Financial Modeling and Evaluation

Day 1:

Introduction to Financial Modeling

• Understanding the purpose and benefits of financial modeling.

• Overview of Excel functions and shortcuts for modeling.

• Best practices for structuring and organizing a financial model.

• Introduction to modeling principles and assumptions.

Day 2:

Building Basic Financial Models

• Building a basic income statement model.

• Constructing a balance sheet and cash flow statement model.

• Linking the financial statements and understanding circular references.

• Incorporating growth rates and historical data in models.

Day 3:

Advanced Financial Modeling Techniques

• Incorporating sensitivity analysis and scenario planning.

• Creating dynamic scenarios for different assumptions.

• Using data tables and goal seek for analysis.

• Introduction to Monte Carlo simulation for risk assessment.

Day 4:

Valuation Modeling

• Overview of different valuation methods (DCF, comparables, etc.).

• Building a discounted cash flow (DCF) valuation model.

• Valuing companies and investment projects.

• Interpreting valuation results and making investment decisions.

Day 5:

Advanced Topics and Practical Application

• Incorporating financing and debt schedules in models.

• Modeling mergers and acquisitions (M&A) scenarios.

• Real estate and project finance modeling.

• Presenting and communicating results effectively.