Preview Financial Modelling Course

Are you sure you wanna do this ? 😛

Recordings

Introduction to curriculum

Expectation setting

Understanding excel layouts, Navigating in excel

Freezing panes, Hiding cells and rows

Sum, Average, Product, Median, Mode, Round Filters

Sorting, Rank, Min, Max, Remove duplicates

Name ranges, IF, Nested If, Sumif, Sumproduct

Hlookup, Vlookup, Index Paste special

Data validation

conditional formatting

Grouping of rows and columns

Introduction and usage of financial statements

What do you need before starting a model creation?

Financial modelling best practices - 1 & 2

Ratio analysis -1

Ratio analysis -2 and Doubt solving

Time value of money

Building First Financial Model

Summarising the model creation process

Doubt solving

Using charts

Cost of capital

Scenario managers

discounting rate calculation

Sensitivity analysis

Using financial models for valuation -1, 2, & 3

Doubt solviing

Wrap up

Capital budgeting

The magic of time value of money Working session - Case 1

Assessment