Advanced Financial Modeling and Valuation
Learn how to build your first financial models in Excel from scratch.
Description
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
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
Who Should Attend!
- Finance Students, keen to build a career in Corporate Finance, M&A, Investment Banking, Equity Research
- Financial Analysts Business Analysts Venture Capitalists Private Equity Professionals Entrepreneurs Equity Analysts Finance Managers Investment Bankers