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.

What will you learn in this course?

• 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 cash flow sheet dynamically
• Carrying out the DCF valuation
• Computing the financial ratios

Who should take this course?

• Financial planning and analysis professionals
• Chartered accountants
• Finance directors
• CFO
• Entrepreneurs
• Investment bankers
• Corporate finance analysts