Read a loan's repayment schedule
Add the loan's interest rates and repayment phases, and read the period by period schedule the app calculates.
Add the interest rate
Open the project. Click Finance Model, then Loans. Click the loan.
Under Interest rate history, click Add rate. Pick the date and type the rate as % p.a.. Click Add.
Add another rate when the loan reprices. Each rate applies from its own date. To correct one, delete it and add it again.
Add the repayment phases
Under Repayment phases, click Add phase. Pick the type, the start and end dates, and the payment frequency. Click Add.
Add a second phase for a loan that moves from interest only to amortising. Click the pencil on a phase to change it.
Riverside Senior Facility
Senior · Repayment 15 Feb 2028 · First registered mortgage
$18,000,000.00
Interest rate history
Add rateRepayment phases
Add phaseRepayment schedule
Interest over full term: $2,610,000.00
Remaining balance: $18,000,000.00
Interest to 25 Aug 2026: $682,890.41
| Period | Opening | Interest | Principal | Payment | Closing |
|---|---|---|---|---|---|
| 15 Feb 2026 → 15 Mar 2026 | $18,000,000.00 | $100,109.59 | $0.00 | $100,109.59 | $18,000,000.00 |
| 15 Mar 2026 → 15 Apr 2026 | $18,000,000.00 | $110,835.62 | $0.00 | $110,835.62 | $18,000,000.00 |
| 15 Apr 2026 → 15 May 2026 | $18,000,000.00 | $107,260.27 | $0.00 | $107,260.27 | $18,000,000.00 |
| 15 May 2026 → 15 June 2026 | $18,000,000.00 | $110,835.62 | $0.00 | $110,835.62 | $18,000,000.00 |
| 15 June 2026 → 15 July 2026 | $18,000,000.00 | $107,260.27 | $0.00 | $107,260.27 | $18,000,000.00 |
| 15 July 2026 → 15 Aug 2026 | $18,000,000.00 | $110,835.62 | $0.00 | $110,835.62 | $18,000,000.00 |
Riverside Mezzanine
Mezzanine · Repayment 15 Feb 2028 · First registered mortgage
$3,500,000.00
Read the schedule
Repayment schedule lists every period with Opening, Interest, Principal, Payment and Closing.
Interest over full term is the total to maturity. Interest to the Timeline completion date is what the budget carries, since the loan is repaid from settlement.
Click Link interest to budget to write that figure into a Finance Costs budget line. Set a later Costed to date for a settlement tail.