arrow_back
Module 1
Module1_Intro ppt
Module1_Revision_Guide
1.1 Setting Expectations_ Introduction to the Course
1.2 what is financial modelling
1.3 How model works
1.4_ same Machine, different questions
1.5_ Heart of model - 3 statements
1.6 _ Your Toolkit - Excel, VBA, AI
1.7_ Modeller_s Mindset
Module 2.0 Excel Intro & Setting Expectations
Module 2.0_ excel intro and setting expectations
Module 2.1 Excel Basics (Referencing, copy paste, formula, calculation across sheets)
2.1 Excel core basics
2.1 Excel Core basic Skills Cheatsheet.docx
2.1 Excel interface + how to save
2.2 Cell address, cell value,undo,redo
2.3 adjusting width, selecting multiple columns
2.4 Cell formatting basics
2.5 Basics of formula
2.6 Bodmas
2.7 Fill Handle
2.8 Fill handle & calculation in action
2.9 sum,max,min,average functions
2.10 Cell reference(relative,absolute,mixed)
2.11 Cell Reference+fill handle in action
2.12 copy,paste,paste special,cut
2.13 Copy paste part 2
2.14 CALCULATION ACROSS SHEETS
Module 2.2 Datatypes & Formatting (V.IMP)
2.2 datatypes and formatting
2.2 data types and formatting Cheat sheet_
2.21 why are datatypes and formatting are needed
2.22 Lets talk Datatypes
2.23 Number formatting 1
2.24 Number formatting 2
2.25 Dates 1
2.26 dates 2
2.27 Time
2.28 Custom Format 1
2.29 Custom Format 2
2.210 Merge,Wrap text,Borders,alignment,Shrink to fit
FM Excel files
Asian Paints Solved intrinsic growth + DCF model
Asian Paints Unsloved intrinsic growth + DCF model
Basic Setup FM Excel
Excel FM setup 2
FM Excel DCF WACC -2 Beta
FM Excel DCF WACC 1
FM Excel Tata Steel for forecasting
FM Excel Tata Steel Model for doing Ratio Analysis
FM Basic Excel Setup
1. FM Basic Excel Setup 1
2. Fm Basic Excel Setup 2
3. FM Basic Excel Setup 3 (Conditional Formatting, Date Func, Large, Small)
4. Fm Basic Excel Setup 4(Name Manager,If,Vlookup,What If Analysis,Data Validation, Protect Sheets)
FM Excel 3 statement model
5. Fm Excel 3 Statement Model
Ratio Analysis
6. ratio analysis
Forecasting
7. Forecasting
DCF Model
8. DCF Model 1_ Understanding
9. DCF Model 2 _ WACC
10. DCF Model 3_ Beta part 1
11. DCF Model 4_ Beta part 2
12. DCF Model 5 _ Beta part 3
13. Common size statement
14. DCF Model 6_ Beta part 4
15. DCF Model 7_ Intrinsic Growth part 1
16. DCF Model 8_ Intrinsic Growth part 2
17. DCF Model 9_ FCFF + TV
Relative Pricing
Relative Pricing Model 1
Relative Pricing Model 2
Relative Pricing Model 3
Senstivity Analysis
Sensitivity analysis