cranford

Financial Modeling Course

Wishlist Share

About Course

Learn how to build practical financial models in Excel for business analysis, forecasting, budgeting, valuation, and investment decision-making.

What Will You Learn?

  • Build professional financial models in Excel.
  • Link and analyze financial statements.
  • Create forecasts and financial projections.
  • Perform DCF and company valuation.
  • Conduct scenario and sensitivity analysis.
  • Develop practical skills for finance and investment roles.

Course Content

Financial Modeling Fundamentals
Financial modeling concepts and structure Excel fundamentals for financial modeling

Financial Statements
Profit & Loss Statement Balance Sheet Cash Flow Statement Linking financial statements

Financial Forecasting
Revenue and expense forecasting Budgeting and financial projections Working capital forecasting

Financial Analysis
Financial ratios Profitability and performance analysis Cash flow analysis

Valuation
Discounted Cash Flow (DCF) Company valuation Terminal value and valuation assumptions

Scenario & Sensitivity Analysis
Best-case and worst-case scenarios Sensitivity analysis Key financial assumptions

Practical Financial Modeling
Building a complete financial model Real-world case studies Practical modeling assignments