Financial Modelling with Excel Training in Pune

$312.00 $265.00

Course Overview:

Financial modeling is the task of building an abstract representation (a model) of a real world financial situation. This is a mathematical model designed to represent (a simplified version of) the performance of a financial asset or portfolio of a business, project, or any other investment.

Financial modeling is a general term that means different things to different users; the reference usually relates either to accounting and corporate finance applications, or to quantitative finance applications. While there has been some debate in the industry as to the nature of financial modeling.

Workshop Details

Date Course Type City Standard Price
Nov 16 – Nov 18
3 Days
9.00 AM – 5.00 PM
Classroom Pune INR 19990 Reg. Closed
Date Course Type City Standard Price Earlybird Price
Apr 13 – Apr 15
3 Days
9.00 AM – 5.00 PM
Classroom Pune INR 19990 INR 16990
till 20 Mar 18
  • Overview of financial modeling
  • Understanding projections
  • Excel best practices foundation and exercises
  • Useful Excel shortcuts and functions
  • Gathering historical documents / information
  • Preparation of Income and Cash Flow statements and Balance Sheet
  • Ratio Analysis
  • Du Pont Analysis
  • Financial Statement Analysis
  • Valuation of Companies
  • Valuation of IPOs
  • Valuation of Merger & Acquisitions
  • Valuation of Bonds
  • Valuation of Equity
  • Leverage Buyout Analysis (LBOs)
  • Sensitivity/Scenario Analysis
  • Monte Carlo Simulation
  • Case Study

Anyone can attend this course with basic excel knowledge.

•    Hard copy of course material
•    24 PDU’s (8*3 days) hours training led by industry expert
•    150 days online access
•    End to end support via phone, mail and chat