Advanced Financial Modelling

Course overview

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
  • 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