Financial Modeling using Excel (0-30 yrs)

Online program on Financial Modeling using Excel

Course Snapshot
  • FeeINR 14,376
  • Work Experience0 - 30 Years
  • Duration76 Hours
  • Delivery MethodOnline
Course Detail

Manipal ProLearn is offering the course on Financial Modeling using Excel through a comprehensive and modular set of learning content and fascinating videos on a robust learning platform that has been developed in-house.

Financial modelling includes creating a complete structure, which justifies an organisation to come up with the right decision on investment in any project, or entity. Excel is mostly used to perform the calculation of valuation. The benefit of MS Excel over manual calculation is speed and accuracy, and pre-defined formulas.

Program Objectives

Our objective is to create a talent pool with proficient knowledge of financial modelling. We aim to train students through an experiential model that incorporates several strategies, including teaching through reading material and videos featuring an industry expert, and not only some useful slides explaining fundamental concepts but also a lot of demo sessions for hands on practice.
Upon completion of this course, learners will be able to:

- Perform Basic and Advanced Calculations in MS Excel
- Analyse Companies
- Build Financial Projections-Income Statement, Balance Sheet, Cash Flow Statement
- Perform a Discounted Cash Flow (DCF) & Relative Valuation
- Analyse Mergers & Acquisitions (M&A)
- Analyse and Build Projects Finance Models
- Build M&A models and analyse the transaction

Learning Outcomes

- Learn the various Basic & Advanced usage of Excel
- Learn to build various charts in Excel
- Analyze historical Financial Statement and evaluate the current value of an entity
- Efficiently forecast Profit & Loss, Balance Sheet and Cash Flow statements
- Use different methods like Discounted Cash Flow (DCF)/Dividend Discount Model (DDM)/Relative Valuation for arriving at the Fair Value of the companies
- Build a project finance model
- Perform Merger & Acquisition (M&A) Analysis

Key Benefits

You will learn:
- Financial modelling for valuation of a company and determining whether it is undervalued or overvalued
- Sector specific modelling for:
1> Banking
2> Real Estate
- Usage of various tools of MS Excel to facilitate financial modelling
- Analysis of companies to determine their financial health
- Building Financial Projections, which help companies to plan their output and predict their performance

Desired Candidate Profile

- MBAs, CFAs, CAs, FRMs, B-Tech, and Commerce Graduates & Students
- Candidates looking to make career in Equity Research, Valuation, Private Equity Funds, Investment Banking or Commercial Banking, Project Management, Business Planning & Strategy

Course Modules

Module 1 - Excel- Basics & Advanced
Module 2 - Charts
Module 3 - Financial Statement Analysis
Module 4 - Forecasting Financial Statements
Module 5 - DCF Modeling
Module 6 - Project Finance
Module 7 - M&A Analysis
Module 8 - Case Study (Application of everything done so far)