Interest-Only Mortgage Calculator Formula
Understand the math behind the interest-only mortgage calculator. Each variable explained with a worked example.
Formulas Used
Interest-Only Monthly Payment
io_monthly = io_paymentAmortizing Monthly Payment
amort_monthly = amort_paymentPayment Increase at Amortization
payment_shock = amort_payment - io_paymentTotal Interest (IO period)
total_io_interest = io_payment * io_period_years * 12Total Interest (amortizing period)
total_amort_interest = amort_payment * amort_months - loan_amountTotal Interest Over Loan Life
grand_total_interest = io_payment * io_period_years * 12 + amort_payment * amort_months - loan_amountVariables
| Variable | Description | Default |
|---|---|---|
loan_amount | Loan Amount(USD) | 500000 |
interest_rate | Interest Rate(%) | 7 |
io_period_years | Interest-Only Period(years) | 10 |
total_term_years | Total Loan Term(years) | 30 |
r | Derived value= interest_rate / 100 / 12 | calculated |
io_payment | Derived value= loan_amount * r | calculated |
amort_months | Derived value= (total_term_years - io_period_years) * 12 | calculated |
amort_payment | Derived value= r > 0 ? loan_amount * r * pow(1 + r, amort_months) / (pow(1 + r, amort_months) - 1) : loan_amount / amort_months | calculated |
How It Works
Interest-Only Mortgages
An interest-only mortgage allows you to pay only the interest for an initial period (typically 5-10 years), after which the loan converts to fully amortizing payments.
How Payments Work
Interest-Only Period: Monthly Payment = Loan Balance x (Annual Rate / 12)
Amortizing Period: Standard P&I payment calculated on the full balance over remaining years
Advantages
Risks
Worked Example
A $500,000 loan at 7% interest, 10-year IO period, 30-year total term.
loan_amount = 500000interest_rate = 7io_period_years = 10total_term_years = 30
- 01Monthly rate: 7% / 12 = 0.5833%
- 02IO payment: $500,000 x 0.005833 = $2,916.67/month
- 03IO period interest: $2,916.67 x 120 = $350,000
- 04Amortizing period: 20 years = 240 months
- 05Amortizing payment: $500,000 over 240 months at 7% = $3,876.83/month
- 06Payment shock: $3,876.83 - $2,916.67 = $960.16 increase
- 07Amortizing period interest: $3,876.83 x 240 - $500,000 = $430,439
- 08Total interest: $350,000 + $430,439 = $780,439
Ready to run the numbers?
Open Interest-Only Mortgage Calculator