Advanced Financial Modeling and Valuation
Learn how to build your first financial models in Excel from scratch.
What you will learn
Financial Modeling & Valuation,Understanding business, Preparing financial statements - Income Statement, Balance Sheet and Cash Flows
Discounted Cash Flow (DCF), Scenario and Sensitivity Analysis, Financial Modeling for M & A , Private Equity and Startup Valuation
Case Studies for Uber, Facebook, Hotel Valuation, Manufacturing Company, Covid19 Tracker,
Practical Insights on Valuation
Why take this course?
In this course, you will learn
1.Introduction
2.Approach to Financial Modelling - Bottom-up and Top-Down
3. Deep Dive into the Construction Phase - Forecasting Revenue, Costs, Working Capital, Debt & Interest
4. Guidelines for Creating an Effective Financial Model
5. Scenario Analysis and Sensitivity
6 Financial Modeling—Real Life Case Studies - Alibaba IPO, Facebook IPO, Uber Valuation, Startup Funding, Hotel Project Appraisal, Financial Modeling for Mergers & Acquisitions, Financial Model for Covid 19, Financial Model for Project Financing
After the successful completion of this course, participants should be able to:
Design and build a comprehensive financial model
Create dashboards using those financial models
Use financial models in business valuation
Plan and take decision by analysing models