Vind een opleiding

Financial Modelling, Financial Planning and DCF Valuation - Udemy

Doelgroep: Financial Analysts,Financial Planning and Analysis Professionals,Chartered Accountants,Finance Directors,CFO,Entrepreneurs,Investment Bankers,Corporate Finance Analysts
Duur: 6,5 uur in totaal
Richtprijs: $89.99
Taal: Engels
Aanbieder: Udemy

>> proefles

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


>> Meer info