Skip to content
UdemyFinance & AccountingPaid courseIntermediate levelCertificate

Financial Modelling, Financial Planning and DCF Valuation (Udemy.com)

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

Created by: Michael Olafusi

Last updated July 2020

icon
What you will 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

How it compares

Against the other 376 rated Udemy courses in Finance & Accounting on CourseDuck:

  • Rating4.3 out of 5higher than 17% of them
  • Reviews569#170 of 377 by number of reviews
  • Length6.5 hourslonger than 61% of them
  • Last updatedJuly 2020earlier than 90% of them

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

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Michael Olafusi

Michael is a 9x 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, Python, business intelligence and Financial Modeling.

icon
More courses by Michael Olafusi

$14.99

icon
More Finance & Accounting courses

$10.99

Free

Free

$19.99

$19.99

$11.99

icon
Reviews

4.3

569 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Lisariani Putri on 7/11/2023

Easy to grasp with comfortable pace, improvement advice tho would be more comprehensive if on each lectures the facilitator could explain a bit more detail of the underlying theory

By gowtham kumar on 2/2/2022

This course has helped me to understand more about Financial modeling.

By Oluwarotimi Oseni on 7/19/2020

It has been an exciting and a great learning sojourn. I was able to re-emphasize my knowledge on some financial terms and also gleaned some MS Excel hacks. Most interestingly, I love that their were mistakes and corrections before the final ouput which made the whole learning curve extremely realistic.

By Joy Matwale on 6/8/2020

Thanks Michael! This was very useful. I appreciated that you used an African start-up for the modelling exercise. Also, your step-by-step explanations were easy to follow along. I will continue joining the weekly sessions that you organise, which I have also found to be quite informative.

By Grigoriy Zakharov on 5/27/2020

If you could possibly put more emphsis on excel formulae, speed up lectures, enlarge the screen, make explanations shorter and more to the point.

By Folorunso Adebare Lala on 5/21/2020

This is a superb Financial Modeling from scratch!The instructor did an excellent job by breaking down each of the schedules and building a very robust financial model.Building the model from scratch by practicing along with the instructor has really boosted my confidence to prepare a 3 statement model.

By shivam srivastava on 5/18/2020

Few doubts regarding financial statement has been clear, and the way of presentation is excellent.

By Thompson Akpevweoghene KIKIRI on 4/18/2020

I love this course, it actually taught two skills one in effectively operating the Excel package and also Financial modelling which are essentially skills in the labour market today, am so getting buffed up. I appreciate everyone that Made this course a success. Thank You.

By Omololu Fagbiele on 4/17/2020

It has been very amazing, although I'm not an accountant but the way the teacher explained really helped me to understand as I followed the practical from beginning to the end. I was able to do it also on my own with further research. Thank you very much Mr Michael and Udemy.

By Kazeem Adekunle Adesanya on 4/11/2020

It was something i have been looking forward to learn but the cost is high. The only reason i didn't give a 5 star is because this course assumes the learners are Excel expert too, though i have learnt a lot on the use of Excel from this course so far

Showing all 10 reviews on CourseDuck

Read all 569 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 86 / 100