Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Project Finance Ninja Course
Introduction
Introduction (3:38)
Component Model
0201 Introduction of Component & Download Case Study (2:23)
0203 Creation of Flags Part 2 (Start Date and End Date) Final (10:27)
0202 Creation of Flags Part 1 (Holiday Expense) (6:26)
0204 Creation of Flags Part 3 (Recurring Expense) (6:57)
0205 Calculation of Escalation Rate (8:21)
0206 Building Schedules using BASE Approach (4:21)
0207 Constructing a Depreciation Cap (4:25)
0208 Building a Circularity Switch (8:16)
0209 Creating a Waterfall Structure (5:53)
0212 Calculation of IRR & NPV (10:56)
0211 Using VLOOKUP with True (5:37)
0210 Preparing a Loan Repayment Schedule (5:12)
Financial Model
0301 Model Preview & Download Case Study (4:05)
0302 Project Details and Assumptions Sheet (10:40)
0305 Building the schedule for Capital Expenditure (4:44)
0303 Sheet Preview and Building Dynamic Timeline (6:43)
0304 Building the schedule for Revenue Forecast (4:59)
0305 Building the schedule for Capital Expenditure (4:44)
0306 Building the schedule for Annual & Accumulated Depreciation (5:27)
0307 Building the schedule for Financial Structure (3:59)
0308 Building the schedule for Equity (1:01)
0309 Building the schedule for Government Grant (0:59)
0310 Building the schedule for Debt (13:01)
0311 Building the schedule for Other Operational Costs (2:14)
0312 Building the schedule for Working Capital (7:00)
0313 Building the schedule for Dividend (2:52)
0314 Building the schedule for Tax (1:48)
0315 Linking the Income Statement (4:46)
0316 Linking the Balance Sheet (4:06)
0317 Linking the Cash Flow Statement (4:37)
0318 Building the schedule for Cash Surplus and Cash Overdraft (9:23)
0319 Key Concepts for the Calculation of IRR & NPV & Download Case Study (7:51)
0320 Calculating Unlevered IRR (3:59)
0321 Calculating Unlevered NPV (8:12)
0322 Calculating Levered IRR (3:25)
0323 Calculating Levered NPV (3:03)
Project Finance Course Feedback
0201 Introduction of Component & Download Case Study
Download
Project Finance Component Model.xlsx
Complete and Continue