- HOT & NEW
- Created by Michael Olafusi
- English [Auto-generated]
Students also bought
- Beginner to Pro in Excel: Financial Modeling and Valuation
- Investment Analysis & Portfolio Management - Core Finance
- The Real Estate Pro Forma Modeling Master Class
- Introduction to Financial Modeling for Beginners
- Financial Budgeting and Forecasting In Excel Complete Course
Preview this Course GET COUPON CODE
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
Who this course is for:
Financial Analysts
Financial Planning and Analysis Professionals
Chartered Accountants
Finance Directors
CFO
Entrepreneurs
Investment Bankers
Corporate Finance Analysts
100% Off Udemy Coupon . Free Udemy Courses . Online Classes