What you’ll learn
- Financial Modeling & Valuation,Understanding the business, Preparing the financial statements – Income Statement, Balance Sheet and Cash Flows Statement,Forecasting the financial statements
- Discounted Cash Flow (DCF), Scenario and Sensitivity Analysis, Financial Modeling for Mergers & Acquisition, Financial Modeling for Private Equity. Financial Modeling for Startup Valuation
- Case Studies for Uber, Facebook, Hotel Valuation, Manufacturing Company, Covid19 Tracker, Valution Practical Insights
Introduction
Introduction
Introduction to Financial Modeling & Career Prospects
The Basics
The Three Financial Statements
Section 2 – Approach to Financial Modeling
Approach to Financial Modeling
Deep Dive into the Construction Phase
WORKING CAPITAL SCHEDULE – (ASSETS)
WORKING CAPITAL SCHEDULE – (LIABILITIES)
Depreciation
Amortisation
Long Term Items
Shareholder’s Equity
Debt and Interest
Guidelines for Creating an Effective Model_Iterative Calculations
Guidelines for Creating an Effective Model_Inputs
Scenario Analysis
Valuation
Business Valuation: Overview & Key Issues from a Practioner’s Perspective
Section 3- Application of Financial Models
Financial Model for Project Appraisal
Preparing 3 Year Business Plan
Discounted Cash Flow Model
Financial Modeling—Investment Banks and Startups
Financial Model for Hotel with M&A Option
Case Study- FInancial Model for Hotel project
Case Study_Facebook IPO
Case Study_Alibaba IPO
Case Study_Uber
Case Study_Manufacturing Startup
Case Study_Covid19 Model
Quiz to test your understanding
Practice Material
Practice Material