3:39
0101. Introduction
Yoda Learning Academy
2:24
0201. Introduction of Component & Download Case Study
6:27
0202. Creation of Flags Part 1 Holiday Expense
10:28
0203. Creation of Flags Part 2 Start Date and End Date Final
6:58
0204. Creation of Flags Part 3 Recurring Expense
8:22
0205. Calculation of Escalation Rate
4:22
0206. Building Schedules using BASE Approach
4:26
0207. Constructing a Depreciation Cap
8:17
0208. Building a Circularity Switch
5:54
0209. Creating a Waterfall Structure
5:13
0210. Preparing a Loan Repayment Schedule
5:38
0211. Using VLOOKUP with True
10:57
0212. Calculation of IRR & NPV
4:06
0301. Model Preview & Download Case Study
10:41
0302. Project Details and Assumptions Sheet
6:44
0303. Sheet Preview and Building Dynamic Timeline
5:00
0304. Building the schedule for Revenue Forecast
4:45
0305. Building the schedule for Capital Expenditure
0306. Building the schedule for Capital Expenditure
5:28
0307. Building the schedule for Annual & Accumulated Depreciation
4:00
0308. Building the schedule for Financial Structure
1:02
0309. Building the schedule for Equity
1:00
0310. Building the schedule for Government Grant
13:02
0311. Building the schedule for Debt
2:15
0312. Building the schedule for Other Operational Costs
7:01
0313. Building the schedule for Working Capital
2:53
0314. Building the schedule for Dividend
1:49
0315. Building the schedule for Tax
4:47
0316. Linking the Income Statement
4:07
0317. Linking the Balance Sheet
4:38
0318. Linking the Cash Flow Statement
9:25
0319. Building the schedule for Cash Surplus and Cash Overdraft
7:52
0320. Key Concepts for the Calculation of IRR & NPV & Download Case Study
0321. Calculating Unlevered IRR
8:13
0322. Calculating Unlevered NPV
3:27
0323. Calculating Levered IRR
3:04
0324. Calculating Levered NPV