Financial Modeling with MS Excel Advanced
4.4 /5- Offered bySimplilearn
- Private Institute
- Estd. 2010
Financial Modeling with MS Excel Advanced at Simplilearn Overview
Duration | 15 hours |
Total fee | ₹8,672 |
Mode of learning | Online |
Credential | Certificate |
Future job roles | Application Security, Audacity, Appraisal, Asp .Net, Asset Allocation |
Financial Modeling with MS Excel Advanced at Simplilearn Highlights
- Earn a certificate of completion
- 1 FM With MS Excel Simulation exam
- Excel Templates for practice, Case study based chapters & Quizzes
Financial Modeling with MS Excel Advanced at Simplilearn Course details
- MBA students
- Commerce graduates
- Investment Bankers
- Business Analysts
- Professionals into Corporate Finance
- Project Finance or any finance and commerce professionals looking forward to strengthen their knowledge of financial modeling techniques and implication
- Financial modeling is the process of creating a complete mathematical model which helps in any financial decision making
- It is a mandatory activity for investment bankers, bankers, project finance persons, equity researchers, Private Equity folks & Venture Capitalists
Financial Modeling with MS Excel Advanced at Simplilearn Curriculum
Valuation Modeling
Welcome
Advanced Financial Modeling Course
Advanced Financial Modeling An Introduction
Advanced FM Course Contents
Valuation Modeling
Agenda
Excel Shortcuts for Financial Modeling 1
Excel Shortcuts for Financial Modeling 2
Excel Formulas for Financial Modeling
Building Historical and Projected Financial Statements
Ratio Analysis 1
Ratio Analysis 2
Ratio Analysis 3
Ratio Analysis 4
Summary
Quiz
Thank You
Merger and Acquisition Analysis
Welcome
Merger and Acquisition Analysis
Agenda
Merger and Acquisition Analysis Basics
Bid Evaluation
Accretion and Dilution Analysis
Accretion and Dilution Analysis Example
Contribution Analysis
Contribution Analysis Example
Summary
Quiz
Thank You
Project Finance Modeling
Welcome
Project Finance Modeling
Agenda
Project Finance An Introduction
Project Finance Modeling An Introduction
Date Functions in Excel
Risk Analysis
Modeling Cash Flow Waterfall
Circular References and Modeling IDC
Summary
Quiz
Thank You
Monte Carlo Simulation
Welcome
Monte Carlo Simulation
Agenda
Monte Carlo Simulation An Introduction
Monte Carlo Simulation Alternative Approaches
Monte Carlo Simulation Using Excel Worksheet
Summary
Quiz
Thank You
Advanced Mapreduce
Welcome
Advanced Excel Functions for FM
Agenda
The INDEX Function
The MATCH Function
Advanced Lookups Using INDEX and MATCH
Summary
Quiz
Thank You
Advanced Charting Techniques
Welcome
Advanced Charting Techniques
Agenda
Creating a Valuation Football Field Chart
Valuation Football Field Godrej Properties Example 1
Valuation Football Field Godrej Properties Example 2
Floating Bar Charts Importance and Uses
Summary
Quiz
Thank You
Other courses offered by Simplilearn
Student Forum
Anything you would want to ask experts?