Course Details

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