Financial Modelling, Financial Planning and DCF Valuation

What you'll learn

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

Requirements

Good grasp of Microsoft Excel
Accounting and Finance knowledge

Description

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

Who this course is for:

Financial Analysts
Financial Planning and Analysis Professionals
Chartered Accountants
Finance Directors
CFO
Entrepreneurs
Investment Bankers
Corporate Finance Analysts