Open calculator ↗

Property renovation draw and interest reserve · Calculation guide

Calculate interest reserve required.

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.

reserve = (opening*months+budget*(months+1)/2)*rate/1200; draw = budget/months; closing = opening+budget

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

InputValue
Opening principal100,000
Renovation draw budget120,000
Draw months12
Annual nominal interest rate12%
ResultValue
Interest reserve required19,800
Monthly draw10,000
Closing principal220,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening principal100,000110,000Interest reserve required19,80021,000
Renovation draw budget120,000132,000Interest reserve required19,80020,580
Draw months1213Interest reserve required19,80021,400
Annual nominal interest rate12%13%Interest reserve required19,80021,450
Property renovation draw and interest reserve →