Financial Modelling, Financial Planning and DCF Valuation
-
How to build financial models from scratch -
Build financial models for startups -
Build financial models for existing companies -
Do DCF Valuation -
Create beautiful, robust, scalable and real-world financial model templates
- Good grasp of Microsoft Excel
- Accounting and Finance knowledge
This is a fully hands-on course that will take you from a blank Excel file to creating a robust, dynamic and fully automated financial model that can be used for a startup or an existing company. It also prepares you for the Advanced Financial Modeler (AFM) certification.
It covers the following sections:
-
Financial Model template creation and Excel tips
-
Fleshing out a dedicated Model Input sheet to aggregate all the client’s plans
-
Creating scenarios — Optimistic, Conservative, Pessimistic — that will flow dynamically into the entire financial statements forecast
-
Creating the Revenue Schedule
-
Creating the Cost of Sales Schedule
-
Creating the Working Capital Schedule
-
Creating the Depreciation Schedule
-
Creating the Debt Schedule
-
Creating the Equity Schedule
-
Creating the Tax Schedule
-
Creating the Income Statement dynamically
-
Creating the Balance Sheet dynamically
-
Creating the Cashflow Sheet dynamically
-
Carrying out the DCF Valuation
-
Computing the Financial Ratios
- Financial Analysts
- Financial Planning and Analysis Professionals
- Chartered Accountants
- Finance Directors
- CFO
- Entrepreneurs
- Investment Bankers
- Corporate Finance Analysts
