CourseOnline
Financial Modeling Using Excel
Led by Mahendra Mehta · Financial risk management, Credit and operational risk measurement, Modeling, Risk mathematics, Derivatives Specialist
Upcoming dates
$2,750.00
per seat
- Financial Modeling Using Excel
- Date
- 07 Sept 2026
- Time
- 00:00 – 00:00
- Format
- Online
- Seats
- 20 of 20 left
About this program
This module will introduce the fundamental concepts of financial modeling using Excel.
Overview
This module will introduce the fundamental concepts of financial modeling using Excel.
Learning Outcomes
- Design and construct robust financial modeling applications
- Use excel support tools and techniques for financial forecasting
- Utilize sensitivity and scenario analysis
- Significantly improve efficiency of using shortcuts
- Use financial functions efficiently
Curriculum
Day 1:
Key Contents
- Financial Modelling Functions
- Sensitivity Analysis
- Scenario Analysis
- Implementing a break-even analysis
- Loans
Day 2:
Basics for Financial Modelling
- Breakdown & grouping of accounting elements
- Determine drivers of the model
- Assumptions for projections
Building Models
- Projection of P&L, balance sheet and cash flow
- Balancing numbers
- How to deal with circular references
- How to prevent circular references
- protection, range names, data validation
- Building a model with assumptions
Day 3:
Valuation Concepts
- Company valuation techniques
- Practical application of valuation constituents
- Weighted Average Cost of Capital (WACC)
- Free Cash Flow (FCF) methods
InstructorMahendra MehtaFinancial risk management, Credit and operational risk measurement, Modeling, Risk mathematics, Derivatives Specialist
has been involved in consultancy and teaching on various financial topics focusing primarily on financial risk management, which includes market, credit and operational risk measurement, modeling, Risk mathematics, derivative pricing and valuation mathematics and analytics its management and modeling, Enterprise Risk Management, development and implementation of policies, processes and procedures in the businesses.