Module · Debt Multi-loan Schedule
Download .xlsx
Open in Layerz — Fork
L
Made with Layerz
· Create your own
Debt · Multi-loan Schedule
Base
Debt · Multi-loan Schedule
2026
2027
2028
Assumptions
[Section] Assumptions
Calculations
[Section] Calculations
Loan · Amount outstanding
[List]
350,000
380,000
302,000
Interests
OUTPUT → P&L interest expense (negative).
[Calculation]
-40,500
-29,600
-21,140
Debt · Total Draws
OUTPUT → CF financing inflow (positive).
[Calculation] Debt · Total Draws: $zi62otot + $l2qpqv1q
200,000
100,000
0
Debt · Total Repayment
OUTPUT → CF financing outflow (negative).
[Calculation] Debt · Total Repayment: -$ohfpfo7h
-25,000
-35,000
-39,000
Loan · Amount outstanding
OUTPUT → BS debt liability.
[Calculation]
350,000
380,000
302,000