Course Content
Introduction
0/5
Course Outline
02:05
Course Objectives
01:10
Course Prerequisites
01:08
What is a Financial Model
00:34
Uses of Financial Models
01:05
Understanding the Start Model
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/3
Review of Case Study
06:07
Review of Start Model
02:21
Review of Input Sheets
04:06
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:15
Modeling Retained Cash and Retained Earnings
08:36
FS Modeling – Revenue and Operating costs
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/14
Escalation
20:33
Revenue Volume
04:52
Revenue – Price
06:14
Operating Revenue Summary
13:38
Raw Material Unit Cost
03:12
Raw Materials Volume
09:14
Raw Material Cost Summary
04:25
Packaging Cost
07:38
Packaging Cost Summary
05:25
Labour Cost
05:42
Direct Production Cost Summary
02:14
Staff Cost
09:17
Overhead Cost
10:06
Operating Cost Summary
03:11
FS Modeling – Tax
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/2
Tax Paid and Tax Expense
08:01
Deferred Tax Balance
07:25
FS Modeling – Non-Current Assets and Working Capital
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/11
NCA Initial Balance
03:19
Depreciation of NCA
04:15
Capital Expenditure (CAPEX)
04:31
Depreciation of Capex
14:06
Tax Depreciation
05:57
Accounts Receivables
12:10
Account Payables
06:17
Inventory
03:26
Work-in-progress
03:42
Net Movement in Working Capital
09:06
Net Movement in Working Capital MTD2
05:32
FS Modeling – Equity and Debt Finance
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/6
Share Capital
04:13
Share Premium
02:32
Dividend
05:21
Unsecured Loan Principal Repayment
04:35
Unsecured Loan Interest
08:04
Corporate Bond Interest
10:26
Key Outputs / Analysis
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/2
Ratios
15:43
Sensitivity and Scenarios
11:20
Quality Control and Model Finalization
Locate the accompanying files for the lessons within this module beneath the respective course video.
0/2
Check and Alerts
10:36
Modeling Guide
09:29
Building Model from Scratch & Time Flags (Bonus Module)
0/4
Model Structure and Time Ruler
15:22
Time Flags
00:00
Timeline Label
00:00
Replicating the Timeline to Other Sheet
00:00
CAPSTONE PROJECT
0/1
GoodCare Hospital - Financial Modeling
Financial Modeling for Business (FP&A)
Previous
Next
0% Complete