Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Financial Modelling, Financial Planning and DCF Valuation

via Udemy

Overview

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

What you'll 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

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

  • Computing the Financial Ratios

Taught by

Michael Olafusi

Related Courses

Reviews

Start your review of Financial Modelling, Financial Planning and DCF Valuation

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free