Financial Modelling, Financial Planning and 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
**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
Instructor
- 4.4 Instructor Rating
- 3,147 Reviews
- 41,796 Students
- 3 Courses
Michael is a 9x Microsoft MVP (Most Valuable Professional), certified Advanced Financial Modeler (AFM), Chartered Stockbroker (NG), UK CISI member, Microsoft Certified Trainer and founder of UrBizEdge, a business data analysis solutions firm. He began his professional career as a Radio Access (RA) Engineer for Nokia Siemens Networks, then as a Business Analyst and MIS Analyst for Comviva -- Airtel Africa CRBT operations in 10 countries, and finally as a Service Delivery Lead and Performance Analyst for 21st Century Technologies before resigning to build his own company.
He has done several financial modeling, business intelligence and data analysis projects/training for Telecommunications companies, FMCG companies, FinTech companies and other industries across the globe.
He is addicted to Microsoft Excel, Power BI, Python, business intelligence and Financial Modeling.