This course is intended to equip the trainees with knowledge, skills and attitudes that will enable them to perform efficiently in this technological ,fast moving information age.
Module 1: Advanced Excel | ||
---|---|---|
TOPIC | DURATION | |
Advanced formatting | 1 Hrs | |
Dynamic Named Ranges | 1 Hrs | |
SUMPRODUCT() calculations | 0.5 Hrs | |
Combo Box for interactive scenarios | 1 Hrs | |
Choose function as a lookup technique | 0.5 Hrs | |
Modeling Loans | ||
Calculating instalments | 3 Hrs | |
Calculating loan balances | ||
Converting flat rates to reducing balance rates | ||
Converting reducing balance rates to flat rates |
Module 2. Advanced Excel for Financial Modelers | ||
---|---|---|
TOPIC | DURATION | |
Conditional Formatting | 1 Hrs | |
Data Analysis and Charting | 1 Hrs | |
Manipulating Pivot Charts | 0.5 Hrs | |
Data Validation | 0.5 Hrs | |
Advanced Formulas | ||
Financial Formulas | ||
PV and FV | 1 Hrs | |
NPV and IRR | ||
Logical Formulas | ||
IF Statements | ||
Nested Ifs | 3 Hrs | |
Error handling using IFERROR | ||
AND & OR Statements | ||
Text Formulas | ||
CONCATENATE | ||
FIND v/s SEARCH | 1 Hrs | |
LEFT, RIGHT, MID | ||
UPPER, PROPER, LOWER | ||
Lookup Formulas | ||
VLOOKUP & HLOOKUP | 2 Hrs | |
INDEX & MATCH |
Module 3. Financial Modeling in Excel | |
---|---|
Topic | DURATION |
Dynamic & Integrated Financial Model design | 0.5 Hrs |
Financial Modeling GAAPs | 0.5 Hrs |
Determining defensible assumptions on business drivers | 0.5 Hrs |
Circular references & iterative calculations | 1 Hrs |
Preparing P&L, Balance Sheet & Cash flow statement from scratch | 3 Hrs |
Equity & Enterprise valuation process | 1 Hrs |
Discounted Cash Flows, Free Cash Flows to the Firm & Free Cash Flows to Equity | 1 Hrs |
Relative valuation techniques | 1 Hrs |
Terminal Value and Terminal Growth Rates | 0.5 Hrs |
CAPM Model and The Discounting Rate | 1 Hrs |
Financial Statement Analysis | 2 Hrs |
Operating Leverage | 0.5 Hrs |
Cash flow for C-Suite performance appraisals | 1 Hrs |
DuPont Analysis | 1 Hrs |
Sensitivity Analysis using Data Tables | 0.5 Hrs |