Financial Modelling, Financial Planning and DCF Valuation

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

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
Requirements
  • Good grasp of Microsoft Excel
  • Accounting and Finance knowledge
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
Tutorial Bar
Logo