Financial Modeling Training in Chandigarh

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 the performance of a financial asset or portfolio of a business, project, or any other investment.

Session and Training Schedule:

Weekdays (30 days) - 5 days/week

2 Hours/day – 1 Hour Theory, 1 Hour Practical

Weekends (8 weeks) - 2 days/week

4 Hours/day – 2 Hours Theory, 2 hours Practical

Our Course Content:-

Chapter 1 :- Excel Basics

Chapter 2 :- Advanced Excel Features

Chapter 3:- Excel’s Built-in Functions and Analysis Tools

  • Financial Functions
  • Logical Functions
  • Statistical Functions
  • Mathematical & Trigonometric Functions
  • Lookup & Reference Functions
  • Date & Time Functions
  • Text Functions
  • Information Functions
  • The Analysis ToolPack

Financial Modeling Using Excel

Chapter 4 :- How to Build Good Excel Models

  • Attributes of good Excel models
  • Documenting Excel models
  • Debugging Excel models
  • Using formula auditing tools for debugging
  • Learning modeling using Excel

Chapter 5 :- Financial Statements Forecasting

Chapter 6 :- Time Value of Money

Chapter 7 :- Financial Planning and Investments

Chapter 8 :- Analyzing Market History

Chapter 9 :- Bond Pricing and Duration

Chapter 10 :- Simulating Stock Prices

Chapter 11 :- Sensitivity Analysis

Chapter 12 :- Merger Model

Chapter 13 :- DCF Model

Chapter 14 :- LBO Model

Chapter 15 :- Financial Planning and Investments

Chapter 16 :- Analyzing Market History

Chapter 17 :- Cost of Capital, Equity Value, Enterprise value

Chapter 18 :- Beta Calculation

Chapter 19 :- Mergers, Acquisitions and Corporate Restructuring

Chapter 20 :- Macros

Chapter 21 :- Charting

Fill Form For Free Classes