5.00
(1 Rating)
Master Financial modelling
What Will You Learn?
- MS Excel for financial modeling covering functions and features:
- Date, Logic, Text, Cell referencing, Lookup , custom format e.t,c
- Structuring of a Standard Financial Model
- Assumption and Input
- Working and Schedule
- Output: Primary 3 Statement
- Building your own KPI dashboards
- Modeling Revenue, SG&A, PPE, Borrowing and working Capital across sectors such as : Manufacturing, Financial service, Logistics, retail, QSR, Hospitality
- Practical Case Study: FM Built from scracth to Finish
- Building Scenarios into Financial Models
- Scenarios and sensitivity analysis
- Leveraging AI using Prompt
Course Content
Introduction to Financial Modelling Course
-
Course objective and Course overview
09:25 -
Introduction to Financial modelling
04:41 -
Definition and Skills required in building a Financial Model
13:42 -
Question and Answer on skills required in building a Financial Model
23:01 -
Introduction to components of Financial Modelling
03:40 -
Illustration of a Sample Financial Model
14:21 -
Question and Answer on component of a financial model
32:09
MS Excel For Financial Modelling
-
Introduction to MS Excel for financial modelling
04:12 -
MS Excel shortcuts I
14:26 -
Question and Answer on MS Excel Shortcuts I
16:23 -
MS Excel Shortcuts II
07:21 -
Question and Answer on MS Excel shortcuts II
08:40 -
Cell referencing I
10:03 -
Question and Answer on Cell referencing I
23:22 -
Question and Answer on Cell referencing II
02:35 -
Mixed referencing
11:33 -
Question and Answer on MS Excel
22:46 -
Custom Format
20:14 -
Question and Answer on Custom Format
25:29 -
Introduction to Functions
10:12 -
Question and Answer on IF Function
25:19 -
IF Function II
08:07 -
Question and Answer on IF function II
08:23 -
IF Function III
16:23 -
Question and Answer on IF Function III
19:14 -
DATE and EOMONTH Function
25:11 -
Data Validation List
07:05 -
Question and Answer on Data Validation list
12:22 -
Recap on cell referencing
10:35 -
MS Excel feature: Data Validation list
03:21 -
Applying cell referencing in more scenerios
05:06 -
Question and Answer on cell referencing application
14:46 -
Application of cell referencing II
08:18 -
Question and Answer on application of cell referencing
18:55 -
IFERROR Function
02:59 -
Question and Answer on IF ERROR Function
11:23 -
Question and Answer on IFERROR Function II
01:25 -
Applying Data Validation
04:00 -
Scenerio using choose and data validation list
11:04 -
Index and Match Function I
08:12 -
Question and Answer on Index and Match Function I
12:56 -
Index and Match Function II
05:32 -
Question and Answer on Index and Match Function
09:00 -
SUMIF and SUMPRODUCT Functions
09:00 -
Question and Answer on SUMPRODUCT and SUMIF Function
33:32
Modelling Component: Major Financial Statement Line Items
-
Modeling Components: Data sourcing
05:23 -
Question and Answer on Data Sourcing
25:56 -
Understanding the assumption sheet in Financial Modeling
02:34 -
Question and Answer on assumption sheet
02:28 -
Modeling revenue
10:48 -
Question and Answer on modeling revenue
16:14 -
Apllying modelling scenerios in examples
11:20 -
Question and Answer on modeling revenue in examples I
27:07 -
Question and Answer on modelling revenue examples II
02:14 -
Class exercise: Revenue modelling-Glovo and Shuttler
35:41 -
Explaining Revenue for Glovo and Shuttler
22:31 -
Modelling Revenue for Shuttler walkthrough
24:47 -
Modelling revenue for existing manufacturing businesses
06:12 -
Question and Answer on modelling revenue for existing manufacturing businesses
22:00 -
Modeling Revenue for hospitality
12:04 -
Question and Answer on modelling revenue for hospitality sector
11:30 -
Question and Answer on Modelling revenue for hospitality sector II
11:30 -
Introduction to Modelling SG&A
05:43 -
Introduction to Modelling SG&A II
06:07 -
Question and Answer on Modelling SG&A
04:49 -
Practical case modelling SG&A
03:33 -
Practical case modelling SG&A II
02:32 -
Question on revenue modelling exercise
07:43 -
Modeling SG&A Case 3
25:39 -
Question and Answer on modelling SG&A Case 3
17:35 -
Introduction to modelling borrowing
05:50 -
Question and Answer on modelling borrowing (The theory)
21:30 -
Introduction to modeling working capital
12:07 -
Question and Answer on modelling working capital(The theory)
06:32 -
Using Receivable days,Inventory days and Payable days to determine working capital
06:16 -
Modeling Inventory using movement schedule
06:25 -
Question and Answer on modelling Inventory using movement schedule
10:09 -
Question and Answer on modelling Inventory using movement schedule II
03:22 -
Question and Answer on Inventory modelling using movement schedule III
05:26 -
Modelling trade receivables using movement schedule
13:11 -
Question and Answer on modelling trade receivables I
36:47 -
Modeling TR, AP and INV using payables, receivables and Inventory days
10:59 -
Question and Answer on inventory days, payable days and receivable days
21:29 -
Modelling borrowing
14:34 -
Modelling borrowing II
14:20 -
Modelling borrowing recap
12:06 -
Question and Answer on modelling working capital
08:53 -
Question and Answer on Trade receivables and Working capital II
08:07 -
Question and Answer on modelling borrowing
05:19 -
Modelling borrowing II
11:42 -
Question and answer on modelling borrowing II
19:58 -
Class exercise on borrowing
07:39 -
Introduction to modelling PPE
07:16 -
Question and Answer on modelling PPE
06:10 -
Scenerio management in Financial models
09:35 -
Question and Answer on modeling scenerios
12:05 -
Modelling PPE Case 1
05:24 -
Question and Answer on Modelling PPE Case 1
20:28 -
Question and Answer on modelling PPE Case 1 II
13:30 -
Modelling PPE Case 2
26:51 -
Question and Answer on modelling PPE Case 2
12:17 -
Question and Answer on Financial Modeling
01:16 -
Modeling PPE
14:40 -
Question and Answer on modelling PPE
10:13
Introduction to Case study
-
Introduction to FS links
07:13 -
Question and Answer on Intro to FS links
04:20 -
Introduction to case study
05:18 -
Question and Answer on Introduction to Case study
24:09 -
Creating Cover page and Table of content
06:41 -
Question and Answer on creating cover page and table of content
09:00 -
Creating FM structure: Template sheet
11:47 -
Question and Answer on creating template sheet
10:24
Case Study Assumption and Input Section
-
Creating modelling relevant sheets
04:13 -
Assumption: General section
14:22 -
Question and Answer on Assumptions
11:54 -
Creating cell style
01:31 -
Assumption: Revenue section
11:32 -
Question and Answer on assumption- revenue section
23:27 -
Expanding Clipboard in MS Excel
02:57 -
Assumption- cost of sales and SG&A
09:31 -
Question and Answer on cost of sales and SG&A
08:39 -
Assumption- CAPEX and Depreciation
06:12 -
Overview on Case study
08:42 -
Creating the links and maps on assumption
05:37 -
Assumption on working capital
12:28 -
Question and Answer on working capital assumptions
20:18 -
Assumption of Income Tax and Debt
04:12 -
Assumption on debt
05:08 -
Question and Answer on assumption of debt
07:26 -
Assumption on equity
05:13 -
Question and Answer on assumption on Equity
09:32 -
Introduction to scenerio
12:16 -
Question and Answer on creating scenerios
07:59 -
Creating scenerios for prices and growth
10:55 -
Question and Answer on creating scenerios for growth and prices
10:42 -
Question and Answer on creating scenerios for growth and prices II
08:00 -
Introduction to calculation and revenue schedule
14:11 -
Question and Answer on revenue schedule
15:53 -
Workings for Cost of Sales
17:09 -
Question and Answer on workings of cost of sales
16:57 -
Workings for SG&A
05:29 -
Question and Answer on workings on SG&A
09:54 -
Question and Answer on workings on SG&A II
05:04 -
Workings for depreciation
13:18 -
Question and Answer on workings on depreciation
08:30 -
Workings for Fixed asset movement
02:53 -
Question and Answer on workings for Fixed Asset movement
03:27 -
Creating the Income statement structure
05:31 -
Income statement populating for forecast period
03:59 -
Workings for Income tax expense
07:10 -
Question and Answer on Income tax expense
03:59 -
Workings for Income and deferred tax liability movements
08:13 -
Question and Answer on Income tax and deferred tax liability
22:39 -
Workings for working capital
06:16 -
Question and Answer on workings for working capital
04:10
Case study: Schedules and Workings
-
Calculation of working capital
08:13 -
Question and Answer on calculation of working capital
04:19 -
Calculation of Equity movement schedule
13:17 -
Question and Answer on Equity movement schedule
09:08 -
Searching the logics and values in Financial models
07:15 -
Calculation of borrowing
06:05 -
Question and Answer on calculation of borrowing
11:11 -
Creating SOFP for actual numbers
07:58 -
Populating the SOFP for forecast period
08:27 -
Question and Answer on Populating the SOFP for forecast period
09:09 -
Creating the SOCF Template
03:02 -
Using F2 and Ctrl Enter to paste
14:28 -
Creating SOCF II
01:53 -
Preparing operating activities
17:30 -
Question and Answer on operating activity of cash flow
04:56 -
Conpleting Operating, Investing and Investing activities
06:37 -
Question and Answer on Cash flow preparation
02:23 -
Troubleshooting issues with the cashflow statement
02:45 -
Troubleshooting the statement of cash flow II
10:10 -
Summary questions and answers
22:44 -
Introduction to Revolver
10:50 -
Revolver II
02:59 -
Revolver III
03:59 -
Question and Answer on Revolver
01:32 -
Determining the value of revolver balance
09:24 -
Determining the value of revolver balance II
14:53 -
Question and Answer on determining the value of the revolver
22:18 -
Linking revover balance additions and payment to SOFP and SOCF
04:31 -
Question and Answer on linking the revolver
05:02 -
Interest expense treatment on revolver
51:45 -
Calculating financial ratios and populating the summary sheet
08:28 -
Popualting sumnary sherts and creating charts
09:29 -
Question and Answer on populating the summary sheet
19:24 -
Question and Answer on populated summary sheet
02:49
Case study: Scenerios and checks
-
creating a scenerio using developer and combox box
08:09 -
creating a scenerio with developer and combox box II
17:10 -
Creating a scenerio field across multiple sheets
10:07 -
Question and Answer on creating a scenerio field on multiple sheets
06:58 -
Question and Answer on creating Scenerio field on multiple sheets II
01:31 -
Creating checks in a financial model
07:07 -
Creating checks in a financial model II
05:43 -
Question and Answer on creating checks in a financial model
11:09 -
Question and Answer on templates in a financial model
10:28 -
Checks for financial covenant breach or no breach
09:27 -
Question and Answer on checks for financial covenant or no breach
04:12 -
Question and Answer on checks for financial covenant and use of conditional formattimg
17:29
Case study: Business Valuation
-
Introduction to Businesss valuation
12:30 -
Valuation Toolkit and different valuation types
11:16 -
Question and Answer on different valuation types and Business valuation
29:12 -
Recap on Introduction to business valuation
08:48 -
Data sourcing and Introduction to DCF
07:01 -
Determining Free Cash Flow for the firm
04:26 -
Question and Answer on determining free cash flow for the firm
14:16 -
Question and Answer on determining free cash flow for the firm II
03:51 -
Question and Answer on determining free cah flow for the firm III
02:42 -
Computation of WACC
08:15 -
Data Sourcing platform for business valuation
08:20 -
Question and Answer on data sourcing for business valuation
02:04 -
Determing free cash flow for the firm using case study
05:59 -
Calculating Free Cash Flow using case study data
01:04 -
Question and Answer on calculating Free Cash Flow using case study
04:39 -
Calculating weighted Cost of capital
11:32 -
Determining discounting factor and discounting cashflow
03:54 -
Determining the growth rate
08:49 -
Determining terminal value for Free Cash Flow
03:25 -
Determining Free Cash Flow for Equity
07:11 -
Determining Free cash flow for Equity and clarifying outcome
07:47 -
Question and Answer on value of the business
04:09
Practice Files and Materials
-
MS Excel working sheets
-
Case study
-
Practice file
-
Past interview questions
-
Modelling components
Student Ratings & Reviews
5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
What an amazing course, I personally love the idea of taking each modelling component separately and considering different ways to model each component of the financial model. It was greatly insightful