Financial Modelling Financial Planning And Dcf Valuation
Tags: Financial Modeling
How to create a startup or existing company financial model from scratch and carry out the DCF Valuation
Last updated 2022-01-10 | 4.3
- How to build financial models from scratch- Build financial models for startups
- Build financial models for existing companies
What you'll learn
* Requirements
* Good grasp of Microsoft Excel* Accounting and Finance knowledge
Description
**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
Who this course is for:
- Financial Analysts
- Financial Planning and Analysis Professionals
- Chartered Accountants
- Finance Directors
- CFO
- Entrepreneurs
- Investment Bankers
- Corporate Finance Analysts
Course content
15 sections • 42 lectures
Introduction: Financial Modelling, Financial Planning and DCF Valuation Preview 06:07
Important Information on Extensive Support and Live Virtual Sessions Preview 01:01
Creating the Financial Model template from scratch - part 1 Preview 10:00
Creating the Financial Model template from scratch - part 2 Preview 10:00
Creating the Financial Model template from scratch - part 3 Preview 11:58
Model Inputs and Financial Plans - part 1 Preview 10:00
Model Inputs and Financial Plans - part 2 Preview 10:00
Model Inputs and Financial Plans - part 3 Preview 10:00
Model Inputs and Financial Plans - part 4 Preview 10:00
Model Inputs and Financial Plans - part 5 Preview 10:28
Progress Check: Model Inputs
This quiz is to help establish that you thoroughly understand the importance of having a dedicated input sheet and ensuring all plans are captured there.
Model Scenarios - part 1 Preview 10:00
Model Scenarios - part 2 Preview 10:00
Model Scenarios - part 3 Preview 10:00
Model Scenarios - part 4 Preview 07:04
Essence of the Scenarios Sheet
Helping you remember the need for the Scenarios sheet