Advanced Financial Modeling and Valuation
What you'll 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
Requirements
- Basic MS-Excel
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
Who this course is for:
- 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
Instructor
![Anurag Singal](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.9 Instructor Rating
- 297 Reviews
- 3,343 Students
- 6 Courses
Anurag secured All India Rank 22 in CA Final exams-Nov'07 . He completed PGPX - 1 year full-time MBA from IIM Ahmedabad 's in the year 2015. He has worked for 15+ years across corporate houses like Deloitte, ITC, Tata Steel and ABG. His core areas of expertise are M&A,Financial Modelling and Valuation. He was awarded CA Young Achiever-Manufacturing Sector at 6th ICAI Awards'13. He has been a TEDx speaker and has a popular YouTube channel ''Anurag Singal" YouTube to guide youngsters on Careers, Financial Planning and Latest Updates. He is Mentor at CAJobPortal . com is India's first recruitment website exclusively for finance professionals.