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