Skip to navigation
Skip to navigation
Skip to search form
Skip to login form
Skip to main content
Skip to accessibility options
Skip to footer
Skip accessibility options
Reset settings
Close
Accessibility profiles
Visual impairment
Seizure and epileptic
Color vision deficiency
ADHD
Dyslexia
Learning
Content adjustments
Readable font
Dyslexia-friendly font
Highlight headings
Highlight links
Highlight buttons
Hide images
Tooltips
Stop animations
Text size
+
+ +
+ + +
Line height
+
+ +
+ + +
Text spacing
+
+ +
+ + +
Color adjustments
Dark contrast
Light contrast
Invert colors
Change colors
High contrast
High saturation
Low saturation
Monochrome
Orientation adjustments
Reading guide
Reading Mask
Big black cursor
Big white cursor
Search
Log in
Login
Blocks
COMPUTER AND ICT COURSES
INTERMEDIATE FINANCIAL MODELLING
30 students
Last updated
Jun 2024
DP
Dineo Pelaelo
Enrol now
Overview
Course content
Instructors
About the course
Show more...
Course content
Sections:
10
•
Activities:
4
•
Resources:
21
Expand all
Section 1
General
Announcements
Section 2
1. BASIC FINANCIAL MODEL CONCEPTS
1.1 Introduction to Financial Modelling
1.2 Financial Model Best Practise
Section 3
2. BASIC FINANCIAL MODELLING (BFA)
2.1 Basic Fin. Analysis Setup
2.2 (a) 10 Essential Formulars
2.2 (b) 10 Basic Formulars Pro
2.2 (b) Worksheet - 10 formulars)
2.3 Awesome Graph Visuals
2.4 IF Function Formulars
2.5 Pivot Tables Development
2.6 Basic FModel Template
Section 4
3. ADVANCED FINANCIAL MODEL CONCEPTS
3.1 Advanced Fin. Analysis
3.2 Formulars and Functions
Section 5
4. THREE STATEMENT FINANCIAL MODELLING
4.1 3 Statement model
4.2 Cashflow Model (Part 1)
4.3 Cashflow Model (Part 2)
Section 6
7. CAPITAL BUDGETING - NPV, IRR, PAYBACK
7.1 (a) Video Explainer - NPV, IRR, Payback Period
7.1 (b) Capital Budgeting workbook
Section 7
8. BUDGET MODELLING
8.1 Budget Modelling
8.2 Worksheet Budgeting
Section 8
9. BASIC PIVOT TABLE CONCEPTS
Pivot Table Design tips
Section 9
10. PIVOT TABLE P&L DASHBOARD
PIVOT TABLE PROFIT & LOSS DASHBOARD
Workbook - Worksheet activity
Section 10
11. FMODELLING FEEBACK
9.1 Feedback - Financial Modelling
9.2 Seedco FModel Template
Instructors
DP
21 courses
445 students
Dineo Pelaelo
Enrolment options
IFM INTERMEDIATE FINANCIAL MODELLING
Course modified date:
19 Jun 2024
Teacher:
Dineo Pelaelo
Enrolled students:
30
Guests cannot access this course. Please log in.
Continue
Enrol now
Skill Level:
Beginner
Skill Level:
Beginner
This course includes
Assignments
Feedback
Forums
Resources
Share this course
Scroll to top
×
Close
×
Close