Financial Modelling, Financial Planning and DCF Valuation

About Financial Modelling, Financial Planning and DCF Valuation

We do regular live support sessions to give a more enriching experience and help you align what you are learning with career growth. Enroll now to get this benefit for life!

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