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 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


You can contact us by emailing [email protected] or calling 0700ANALYTICS, +234-1-6311885, +234-808-938-2423, +234-802-118-0874, +234-808-266-9002, +1-941-312-2149 and +234-806-312-5227

Course Curriculum

  Creating the Financial Model template from scratch
Available in days
days after you enroll
  Model Inputs and Financial Plans
Available in days
days after you enroll
  Model Scenarios
Available in days
days after you enroll
  Model Revenue Schedule
Available in days
days after you enroll
  Model Cost of Sales Schedule
Available in days
days after you enroll
  Model Working Capital Schedule
Available in days
days after you enroll
  Model Depreciation Schedule
Available in days
days after you enroll
  Model Debt Schedule
Available in days
days after you enroll
  Model Equity Schedule
Available in days
days after you enroll
  Model Tax Schedule
Available in days
days after you enroll
  Model Income Statement
Available in days
days after you enroll
  Model Balance Sheet
Available in days
days after you enroll
  Model Cashflow Statement
Available in days
days after you enroll
  Model DCF Valuation
Available in days
days after you enroll
  Model Financial Ratios
Available in days
days after you enroll
Michael Olafusi

Meet your instructor: Michael Olafusi

Michael is a 6x Microsoft Excel MVP (Most Valuable Professional), certified Advanced Financial Modeler (AFM), Chartered Stockbroker (NG), UK CISI member, Microsoft Certified Trainer and founder of UrBizEdge, a Microsoft Excel and business data analysis consulting 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 and data analysis projects/training for Telecommunications companies, FMCG companies and other high-profile companies.


He is addicted to Microsoft Excel, Power BI, VBA programming and Financial Modeling.

Select a pricing plan and register

$100

Specially Discounted with lifetime access and updates

Click Enroll Now if you have a coupon/Expand for Naira payment details

You can optionally pay in Naira and via bank transfer to FCMB 2888666014 URBIZEDGE LIMITED the sum of N40,000. Send payment evidence to [email protected] and your registration will be processed.

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 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
$199

Online + 4 hours Live Session Plan

Click Enroll Now if you have a coupon/Expand for Naira payment details

You can optionally pay in Naira and via bank transfer to FCMB 2888666014 URBIZEDGE LIMITED the sum of N80,000. Send payment evidence to [email protected] and your registration will be processed.

This is a bundle of the premium online course with a live 4 hours session with one of our consultants/trainers, and after training support.