Financial Modelling, Financial Planning and DCF Valuation

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

How to create a startup or existing company financial model from scratch and carry out the DCF Valuation

Url: View Details

What you will learn

• How to build financial models from scratch
• Build financial models for startups
• Build financial models for existing companies

Rating: 4.4

Level: Intermediate Level

Duration: 6.5 hours

Instructor: Michael Olafusi