financial modeling course

Financial modeling is the process of creating a mathematical representation of a real-world financial situation. It involves using various financial data and assumptions to create a forecast of potential financial outcomes. Financial models are typically used to evaluate the financial performance of a business or investment opportunity, make projections about future financial performance, and assess risk. At GB training & placement centre, we provide best Financial Modeling Training in Chandigarh.

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

Do you need any help?

Just fill the following form to send a message to us and we will get back to you soon.

Scroll to Top