Course Content
Introduction
0/5
Course Outline
02:34
Course Objective
01:21
Course Prerequisite
01:23
What is a Financial Model
00:39
Uses of Financial Model
00:30
Understanding the Start Model
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/3
Review of Start Model
07:14
Review of Case Study
03:48
Review of Input Sheets
04:10
Setting up Macros (Bonus Module)
0/2
Formatting & Productivity Macros
07:33
Setting Up Macros
04:42
How to Link the Financial Statement
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/2
Overview of Equity
05:37
Modeling Retained Cash & Retained Earnings
08:25
Revenue & Operating Costs
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/5
Escalation
13:27
Revenue Volume
08:12
Operating Revenue
06:37
Operating Cost
07:53
Operating Cost Summary
03:12
Financial Statement Modeling – Tax
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/3
Tax Expenses and Tax paid
08:16
Tax Losses Carried Forward
06:53
Deferred Tax
06:24
Non-Current Assets & Working Capital
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/7
NCA Initial Balance
04:44
Depreciation of NCA
07:56
Capital Expenditure
06:08
Depreciation of Capex
13:38
Tax Depreciation
07:48
Account Receivables
09:46
Account Payables
04:49
Financial Statement Modeling – Equity & Debt Finance
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/5
Share Capital
05:56
Share Capital Redemption
04:13
Dividend
06:29
Senior Debt Principal Repayment
07:46
Senior Debt Interest Repayment
05:28
Key Outputs / Analysis
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/4
Valuation
17:08
Payback Period – (Bonus Lesson)
07:17
Ratios
17:15
Sensitivity & Scenarios
09:56
Model Guide & Review
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/3
Track Sheet
11:58
Checks & Alerts
11:20
Modeling Guide
11:03
CAPSTONE PROJECT
0/1
AeroLtd - Financial Modeling
Building Model from Scratch & Time Flags (Bonus Module)
0/4
Model Structure and Time Ruler
15:22
Time Flags
12:44
Timeline Label
09:52
Replicating the Timeline to Other Sheet
04:49
Financial Modeling for Projects
Previous
Next
0% Complete