Financial Modeling for Projects
5.00 (1 Rating)
Enrolled:154
$100
$126
-
LevelBeginner
-
Duration9 hours 16 minutes
-
Last UpdatedNovember 25, 2024
-
Enrollment validityEnrollment validity: 365 days
-
CertificateCertificate of completion
Hi, Welcome back!
About Course
The Financial Modeling for Project course is designed to equip you with the essential skills and knowledge needed to build and analyze financial models for a project using Microsoft Excel. This course is a prerequisite for the Project Finance Modeling course and covers fundamental topics that will enable you to create accurate and efficient project finance models.
This course is part of the Project Finance School, which includes Accounting Fundamentals of Project Finance, Finance Fundamentals of Project Finance, Legal Fundamentals of Project Finance, Core Modeling Skills, and Project Finance Modeling.
What will I learn?
- How to build and analyze financial models for a project using Microsoft Excel
- Advanced topics such as modeling tax, linking financial statements, and modeling equity and debt finance
- How to calculate the cost of equity and debt, create a debt schedule, and model interest during construction
- Understanding non-current assets and working capital, including modeling depreciation, capital expenditures, and inventory
- How to model the construction period and calculate interest during construction
- Analyzing project finance and making informed business decisions
- Practical skills and knowledge that can be applied to real-world scenarios
Course Curriculum
Introduction
-
02:34
-
01:21
-
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.
-
Review of Start Model
07:14 -
Review of Case Study
03:48 -
Review of Input Sheets
04:10
Setting up Macros (Bonus Module)
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
Track Sheet
11:58 -
Checks & Alerts
11:20 -
Modeling Guide
11:03
CAPSTONE PROJECT
-
AeroLtd – Financial Modeling
Building Model from Scratch & Time Flags (Bonus Module)
-
Model Structure and Time Ruler
15:22 -
Time Flags
12:44 -
Timeline Label
09:52 -
Replicating the Timeline to Other Sheet
04:49
Student Ratings & Reviews
5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
This was a good match for me which is why I am taking the project finance modeling to deepen my understanding of complex cases. Thank you promise and the BFI for this.