Calculation guide
Assume equal start-of-month renovation draws, monthly simple interest on outstanding principal and no repayments. Interest is paid from a separate cash reserve.
Inputs
Opening principal
Example entry 100000 (in the selected currency).
Renovation draw budget
Example entry 120000 (in the selected currency).
Draw months
Example entry 12. Allowed range 1.0 to 600.0. Use whole numbers.
Annual nominal interest rate
Example entry 12 %. Allowed range 0.0 to 100.0.
Worked example
| Input | Value |
|---|---|
| Opening principal | 100,000 |
| Renovation draw budget | 120,000 |
| Draw months | 12 |
| Annual nominal interest rate | 12% |
| Result | Value |
|---|---|
| Interest reserve required | 19,800 |
| Monthly draw | 10,000 |
| Closing principal | 220,000 |
Calculation steps
Interest reserve required = ((((Opening principal × Draw months) + ((Renovation draw budget × (Draw months + 1)) ÷ 2)) × Annual nominal interest rate) ÷ 1,200)
((((100,000 × 12) + ((120,000 × (12 + 1)) ÷ 2)) × 12) ÷ 1,200) = 19,800
Monthly draw = (Renovation draw budget ÷ Draw months)
(120,000 ÷ 12) = 10,000
Closing principal = (Opening principal + Renovation draw budget)
(100,000 + 120,000) = 220,000
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Opening principal | 100,000 | 110,000 | Interest reserve required | 19,800 | 21,000 |
| Renovation draw budget | 120,000 | 132,000 | Interest reserve required | 19,800 | 20,580 |
| Draw months | 12 | 13 | Interest reserve required | 19,800 | 21,400 |
| Annual nominal interest rate | 12% | 13% | Interest reserve required | 19,800 | 21,450 |
