Financial Modelling, Financial Planning and DCF Valuation

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

Beginner 5(2 Ratings) 3 Students enrolled
Created by Michael Olafusi Last updated Thu, 10-Jun-2021 English
What will i learn?
  • Build financial models for existing companies
  • How to build financial models from scratch
  • Build financial models for startups
  • Create beautiful, robust, scalable and real-world financial model templates
  • Do DCF Valuation

Curriculum for this course
42 Lessons 06:47:09 Hours
Introduction
1 Lessons 00:06:07 Hours
  • Introduction to Financial Modeling 00:06:07
Template Creation
6 Lessons 00:48:56 Hours
  • Creating the Financial Model template from scratch - Part 1 00:10:00
  • Creating the Financial Model template from scratch - Part 2 00:10:00
  • Creating the Financial Model template from scratch - Part 3 00:11:58
  • Creating the Financial Model template from scratch - Part 4 00:05:00
  • Creating the Financial Model template from scratch - Part 5 00:05:00
  • Creating the Financial Model template from scratch - Part 6 00:06:58
Model Input
5 Lessons 00:50:28 Hours
  • Model Inputs and Financial Plans - Part 1 00:10:00
  • Model Inputs and Financial Plans - Part 2 00:10:00
  • Model Inputs and Financial Plans - Part 3 00:10:00
  • Model Inputs and Financial Plans - Part 4 00:10:00
  • Model Inputs and Financial Plans - Part 5 00:10:28
Scenario
4 Lessons 00:37:04 Hours
  • Model Scenarios - Part 1 00:10:00
  • Model Scenarios - Part 2 00:10:00
  • Model Scenarios - Part 3 00:10:00
  • Model Scenarios - Part 4 00:07:04
Revenue Schedule
1 Lessons 00:11:44 Hours
  • Revenue Schedule 00:11:44
Cost of Sales
1 Lessons 00:04:02 Hours
  • Cost of Sales 00:04:02
Working Capital
1 Lessons 00:12:00 Hours
  • Working Capital Schedule 00:12:00
Depreciation Schedule
2 Lessons 00:22:29 Hours
  • Depreciation Schedule - Part 1 00:10:00
  • Depreciation Schedule - Part 2 00:12:29
Debt Schedule
1 Lessons 00:13:38 Hours
  • Debt Schedule 00:13:38
Equity Schedule
1 Lessons 00:10:59 Hours
  • Equity Schedule 00:10:59
Tax Schedule
1 Lessons 00:06:17 Hours
  • Tax Schedule 00:06:17
Income Statement Schedule
3 Lessons 00:32:56 Hours
  • Income Statement - Part 1 00:10:00
  • Income Statement - Part 2 00:10:00
  • Income Statement - Part 3 00:12:56
Balance Sheet
3 Lessons 00:31:35 Hours
  • Balance Sheet - Part 1 00:10:00
  • Balance Sheet - Part 2 00:10:00
  • Balance Sheet - Part 3 00:11:35
Cash-flow Statement
4 Lessons 00:42:22 Hours
  • Cash-flow Statement - Part 1 00:10:00
  • Cash-flow Statement - Part 2 00:10:00
  • Cash-flow Statement - Part 3 00:10:00
  • Cash-flow Statement - Part 4 00:12:22
DCF Valuation
6 Lessons 00:49:57 Hours
  • DCF Valuation - Part 1 00:10:00
  • DCF Valuation - Part 2 00:10:00
  • DCF Valuation - Part 3 00:10:00
  • DCF Valuation - Part 4 00:10:00
  • DCF Valuation - Part 5 00:07:48
  • WACC Calculation Update 00:02:09
Financial Ratio Schedule
2 Lessons 00:26:35 Hours
  • Financial Ratios - Part 1 00:10:00
  • Financial Ratios - Part 2 00:16:35
Requirements
  • Microsoft Excel
  • Accounting and Finance knowledge
+ View more
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
+ View more
Other related courses
00:00:00 Hours
0 1 ₦5,000
00:00:00 Hours
1 34 ₦5,000
02:00:09 Hours
Updated Sat, 10-Oct-2020
0 4 ₦5,000
00:44:30 Hours
Updated Sun, 18-Oct-2020
0 0 ₦5,000
About the instructor
  • 3 Reviews
  • 7 Students
  • 2 Courses
+ View more

Michael is a 6x Microsoft MVP (Most Valuable Professional), certified Advanced Financial Modeler (AFM), Chartered Stockbroker (NG), UK CISI member, Microsoft Certified Trainer and founder of UrBizEdge, a business data analysis solutions firm. He began his professional career as a Radio Access (RA) Engineer for Nokia Siemens Networks, then as a Business Analyst and MIS Analyst for Comviva -- Airtel Africa CRBT operations in 10 countries, and finally as a Service Delivery Lead and Performance Analyst for 21st Century Technologies before resigning to build his own company.


He has done several financial modeling, business intelligence and data analysis projects/training for Telecommunications companies, FMCG companies, FinTech companies and other industries across the globe.


He is addicted to Microsoft Excel, Power BI, business intelligence and Financial Modeling.


Student feedback
5
Average rating
  • 0%
  • 0%
  • 0%
  • 50%
  • 50%
Reviews
  • Mon, 17-Aug-2020
    Fehintola Saiyepe
    The step by step explanation is an intriguing experience. Good Value for money.
  • Tue, 08-Sep-2020
    Tobiloba Williams
₦5,000
Buy now
Includes:
  • 06:47:09 Hours On demand videos
  • 42 Lessons
  • Access on mobile and tv
  • Full lifetime access
  • Certificate of completion
  • Compare this course with another