Financial Model Fundamentals-Learn the Essential Skills

Learn to create full financial models including cash flow, working capital, debt and equity calculations.

This course is for business owners, managers, finance professionals or business students who want to learn to build financial models.

If you have basic Excel skills and a basic understanding of financial concepts, you will be able to follow the course.

I teach step-by-step, from simple steps like creating our input sheet to advanced calculations like cost of capital and share buy backs.

Only essential skills are taught; I don't waste time on skills you don't need.

The course is great value for money and it's far easier to learn to build financial models with my video course than trying to learn from a book.

Debt Equity Model Introduction
Input Sheet for Debt Equity Model
Name Ranges
Input Sheet Name Ranges for Debt Equity Model
Calculation Sheet for Debt Equity Model
Debt Calculations
Capital Expenditure and Depreciation
Equity Calculations Introduction
Equity Calculations for Debt Equity Model
Balance Sheets Introduction
Working Capital Introduction
Balance Sheet for Debt Equity Model
Cash Flow Introduction
Cash Flow for Debt Equity Model
Auditing and Fixing Formulas
Challenge - Balance the Balance Sheet
Output Sheet for Debt Equity Model
Challenge - Summary Balance Sheet & Cash Flow
Financial Ratios and Debt Covenants
Adding Ratios to the Financial Model
Dividends
Weighted Average Cost of Capital
Introduction to Share Buy Backs
Adding Share Buy Backs to the Financial Model
Challenge - WACC Table
Conclusion

What's included

  • 27 Video Lessons

  • Works on all devices
  • Certificate of completion

Andrew de Bruyn

Instructor