Write a Review

Please login to submit your review
Crash Course On Financial Modelling

Crash Course On Financial Modelling

4 day course Day 1: Excel Tips Understanding And Creating A Financial Model Template Learning referencing (usage of $)Frame work in Excel Learning Custom formatting in Excel Excel Skills - Shortcuts, Formulas, Array Function and Pivot Tables Implementing simple business modeling case in Excel Simple exercise/models in excel       Advance Function Named Ranges Index Match Array Functions Building Scenarios using Offset Functions Creating growing models & Index functions Usage of Indirect Functions Usage of Goal Seek and Solver Functions  Day 2: Charting Building Primary & Secondary Axis in a Chart Radar Charts - Showing the progress of Commercial Property Development Waterfall Charts - Showing Funding Breakup for Renewable Energy project Football Field - Showing Valuation Summary using Different Parameters Gantt Chart - Tracking the status of an Ongoing Project Day 3,4 : Business Modelling and Valuation Data Collection and Data Structuring Preliminary Scrutiny of the Data and Information Understand the Business Model and Operating Model Modeling the Historical Statement Business Drivers Identification and Modeling Modeling Assumptions for Future Action Modeling Revenue Build-up - projecting the future revenues Modeling Cost Build-up - projecting the future cost Modeling the Asset Schedule Modeling the Depreciation Schedule - Book and Income Tax Depreciation Working Capital & Term Loan Modeling - Debt Infusion Tax Modeling Modeling MAT and MAT credit Modeling Impact of Accumulated Losses, Current Tax and Deferred Tax on Tax Payble Equity Modeling - Equity Infusion Modeling Paid Up Capital and Share Premium Account Modeling Retained Earning Schedule Modeling the projected P/L and BS Modeling the projected Cash Flow Statement Conducting Covenant Testing Performing Ratio Analysis WACC and Cost of Equity Analysis Performing Valuation using DCF (FCFF & Enterprise Value) and Comparable analysis (Relative Valuation) Performing sensitivity/scenario analysis

City: Dubai