Using Financial Modelling For Analysis And Valuation

What Will I Learn:

• Understand Income Statement, Balance Sheet, Cash Flow Statement
• Learn scheduling & techniques
• Learn to put it all together and determining clusters from where to extract value
• Learn important concepts required in valuation
• Understand how to work with balance sheet components

Curriculum:

• Formatting the data, summarizing, and creating a presentable format.
• Manipulating Text and Numerical Data
• Using Pivot Tables to Sumerize Data
• Converting data into tabular format
• Identify high profit sales using conditional formatting
• Excel Best Practices
• Inputs/Assumptions Worksheet
• Preparing the 3 Financial Statements
• Preparing Depreciation & Amortization Schedule
• Preparing Debt Schedule
• Other Working Notes
• Understand the Business Model and Operating Model
• Modeling the Historical Statement
• 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 and Term Loan Modelling – Debt Infusion
• Equity Modelling – Equity Infusion
• WACC and Cost of Equity Analysis
• Performing Valuation using DCF
• Performing Sensitivity/Scenario Analysis
• Comparing the Valuation Summary using Different Parameters