- 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
- Introduction to Financial Modeling 00:06:07
- 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 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
- 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 00:11:44
- Cost of Sales 00:04:02
- Working Capital Schedule 00:12:00
- Depreciation Schedule - Part 1 00:10:00
- Depreciation Schedule - Part 2 00:12:29
- Debt Schedule 00:13:38
- Equity Schedule 00:10:59
- Tax Schedule 00:06:17
- Income Statement - Part 1 00:10:00
- Income Statement - Part 2 00:10:00
- Income Statement - Part 3 00:12:56
- Balance Sheet - Part 1 00:10:00
- Balance Sheet - Part 2 00:10:00
- Balance Sheet - Part 3 00:11:35
- 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 - 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 Ratios - Part 1 00:10:00
- Financial Ratios - Part 2 00:16:35
- Microsoft Excel
- Accounting and Finance knowledge
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
- Financial Analysts
- Financial Planning and Analysis Professionals
- Chartered Accountants
- Finance Directors
- CFO
- Entrepreneurs
- Investment Bankers
- Corporate Finance Analysts
- 3 Reviews
- 7 Students
- 2 Courses
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.
-
Mon, 17-Aug-2020Fehintola SaiyepeThe step by step explanation is an intriguing experience. Good Value for money.
-
Tue, 08-Sep-2020Tobiloba Williams
Write a public review