Debt & Interest Schedule without Circularity
This lesson is part of the course
In this lesson
You build an amortising term loan and a bullet bond, cap the repayment with MIN and calculate interest on opening balances.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Historicals & Ratios as Forecast Drivers Locked
- Revenue & Cost Forecast with a Scenario Switch Locked
- Working Capital Schedule: DSO, DIO, DPO Locked
- PP&E & Depreciation Schedule (Capex Waterfall) Locked
- Debt & Interest Schedule without Circularity Locked
- Building the Income Statement Locked
- The Balance Sheet: Retained Earnings & the Balance Check Locked
- Cash Flow Statement (Indirect Method) & Cash Tie-Out Locked