Financial ModelingLive Class
Our financial and valuation modeling training is a 2-day accelerated workshop specially designed to help you master spreadsheet financial models and business valuation techniques. By attending this 2-day workshop, you will be able to effectively build financial models, prepare and forecast schedules, understand and analyze business drivers, in addition to conducting thorough analysis of financial information. The workshop will also feature real-life case studies and use hands-on application of financial and valuation modeling in Excel.
It includes 5+ daily live classes with over 10 hours of content taught and lifetime access to session recordings.
Includes:
- 85352 ratings
Key Features
Live Online Classes PREFERRED
Overview
Our Financial and Valuation Modeling Live Online Training covers more than 12 hours of comprehensive, interactive, and instructor-led training with real-life case studies, thus imparting working knowledge of crucial financial modeling and business valuation principles.
Live Online Classes Curriculum
- 1 – Introduction to Modeling
- Introduction to financial modeling
- Historical data
- Building the model
- Core statements
- 2 – Projecting Schedules
- Revenues
- Costs
- Fixed asset, capital expenditure, and depreciation schedule
- Capital lease schedule
- Amortization schedule
- Working capital and change in working capital schedule
- Completion of income statement logic
- Shareholders
- Shares outstanding schedule
- Individual schedules of inventory, receivables, and other working capital categories
- Other long-term items schedule
- Shares outstanding schedule
- Debt and debt repayment schedule
- Interest schedule
- Income tax schedule
- Schedules of investments and dividends received
- 3 – Drivers
- Income statement drivers
- Balance sheet drivers - assets
- Balance sheet drivers
- 4 – Balancing Act
- Balancing the balance sheet
- 5 – Valuation Overview
- Valuation overview
- Introduction to discounted cash flow
- Discounted cash flow
- 6 – Discounted Cash Flows
- Free cash flow
- Discounted cash flow projections
- 7 – Terminal Value
- Terminal value overview
- Exit value method
- Exit multiple exercise
- Perpetuity growth method
- Perpetuity growth exercise
- Terminal value spot check
- Terminal value concerns
- 8 – Discount Rate
- Discount rate overview
- Discount rate
- Risks
- 9 – Capital Asset Pricing Model
- Introduction to capital asset pricing model (CAPM)
- Risk-free rate
- Beta
- Market risk premium
- 10 – DCF Synthesis
- DCF
- DCF
- Sensitivity analysis
- 11 – Valuation Multiple
- What is a multiple?
- Why multiples vary
- Advantages and disadvantages of Multiples
- Identifying comparables
- Equity value
- Enterprise value
- Advantages of equity value and enterprise value
- Introduction to equity value multiples
- Introduction to enterprise value multiples
- 12 – Equity and Enterprise Multiple
- Calculation of valuation multiples
- Enterprise value multiples
- Enterprise value multiples
- Let
- 13 – Other Valuation Approaches
- Asset-based valuation
- Sum of parts
- Mergers and acquisitions comparables
- Replacement cost method
- Qualitative factors in valuation - Management Quality
IN : +91-7738666252
