Course Highlights
  • Create an integrated financial model from scratch
  • Apply leading strategies for model building
  • Analyse financial statements
  • Confidently use advanced Excel functions for financial modeling
  • Translate financial data into Excel
  • Understand and be able to apply DCF, Trading Multiples and Precedent Transactions
  • Know when to use the different valuation methods
  • Understand the difference between Book Value and Market Value
  • Tailor financial models for end users
  • Reduce modeling errors
  • Apply a disciplined and structured model building approach
  • Become a valuation expert
Curriculum

4 Topics
Introduction to Financial Modeling
Overview of Accounting and Financial Statements
Cash Flow Statement and Balance Sheet
Financial Analysis and Ratios

7 Topics
Why Do We Value Companies?
Difference Between book Value and Market Value
Valuation Methods: DCF
Valuation Methods: Trading Multiples
Valuation Methods: Precedent Transactions
Spreading Comps
Summary of Valuation Methods

17 Topics
Uses for Financial Modeling
Debt and Interest Schedule
Revolver Modeling
Sensitivity Analysis
Creating 5 Year Projections: Case Study
Data Backed and Qualitative Assumptions
Market Sizing
Traffic and Demand
Share of Market Matrix
Start-Up Expenses
Capex Schedule
Profit and Loss Statement part 1
Profit and Loss Statement part 2
Profit and Loss Statement part 3
Cash Flow Statement
Balance Sheet
Business Valuation ROI and Conclusion

  Write a Review

Financial Modeling and Valuation: Complete Beginner to Pro

Go to Paid Course