Formula
Fixed monthly payment = Loan amount × r ÷ (1 − (1 + r)^−m), where r = Fixed rate offered ÷ 12 and m = Term (months); Fixed total of payments = Payment × m
Variable path: in month 1 the rate is the Variable starting rate; at the start of each later year (months 13, 25, …) the rate becomes min(Lifetime cap, previous rate + Expected annual change); each month the payment is re-amortized on the remaining balance over the remaining months at the current rate; Variable total on your path = sum of those payments
Variable highest payment on your path = the largest monthly payment in that sequence; Payment if the rate hits the cap = the payment on the full loan over the full term at the Lifetime cap
Variable must rise more than this to lose = Fixed rate − Variable starting rate; the variable loan costs more only if its average rate over the term exceeds the fixed rate
Worked examples
Example 1: $300,000 over 84 months, 9.5 percent fixed versus 8.25 percent variable rising 0.5 a year, 14 percent cap
Use the defaults: Loan amount $300,000, Term 84 months, Fixed rate 9.5 percent, Variable starting rate 8.25 percent, Expected annual change +0.5 percent, Lifetime cap 14 percent. Fixed: r = 0.095 ÷ 12 = 0.0079167; Payment = $300,000 × 0.0079167 ÷ (1 − 1.0079167^−84) = $4,903.19; total = $4,903.19 × 84 = $411,868. Variable: year-one rate 8.25 percent gives a starting payment on $300,000 over 84 months of $4,713.32. At month 13 the rate becomes 8.75 percent and the payment is re-amortized on the balance then outstanding over the remaining 72 months; at month 25, 9.25 percent over 60 months; then 9.75, 10.25, 10.75 and finally 11.25 percent in year seven, all below the 14 percent cap. The payment rises each year, peaking at $4,954.70 in the final year. The total of all 84 variable payments is $408,268, which is $3,600 less than the fixed total, so the tool reports Variable as cheaper under this path. Payment at the cap = $300,000 at 14 percent over 84 months = $5,622.00. Break-even = 9.5 − 8.25 = 1.25 percent: the variable rate's average over the term must rise more than 1.25 points above its start before the variable loan loses. On this path it averages about 9.75 percent, but because the higher rates arrive when the balance is smaller, the loan still wins narrowly.
Example 2: the same loan with the rate falling 0.5 a year
Keep every default and change Expected annual change to −0.5 percent. The fixed side is unchanged: $4,903.19 a month, $411,868 in total. The variable rate now starts at 8.25 percent and falls to 7.75 at month 13, 7.25 at month 25, then 6.75, 6.25, 5.75 and 5.25 percent in year seven. Each re-amortization lowers the payment, so the highest payment on the path is the first one, $4,713.32, and the total of payments falls to $383,908, which is $27,960 below the fixed total. The cap payment is still $5,622.00 and the break-even is still 1.25 percent, because neither depends on the path. The lesson is the asymmetry: a rising path of the same slope costs the variable borrower $3,600 less than fixed, a falling path saves nearly $28,000 more, because a fixed loan cannot take advantage of falling rates without refinancing and paying whatever prepayment terms apply.
Example 3: $500,000 over 120 months, 8.75 percent fixed versus 7.5 percent rising a full point a year to a 13 percent cap
Enter Loan amount $500,000, Term 120 months, Fixed rate 8.75 percent, Variable starting rate 7.5 percent, Expected annual change +1 percent, Lifetime cap 13 percent. Fixed: r = 0.0072917; Payment = $500,000 × 0.0072917 ÷ (1 − 1.0072917^−120) = $6,266.34; total = $751,961. Variable: starting payment at 7.5 percent = $5,935.09. The rate rises to 8.5 percent at month 13, 9.5 at month 25, 10.5, 11.5, 12.5, and reaches the 13 percent cap at month 73, where it stays for years seven through ten. Re-amortizing on the shrinking balance, the payment climbs to a peak of $7,001.51. The total of payments is $802,022, which is $50,061 more than the fixed total, so the tool reports Fixed as cheaper. Payment at the cap on the full loan over the full term = $7,465.54. Break-even = 1.25 percent, the same gap as before, but a one-point annual rise blows through it by year three. The highest payment on the path, $7,001.51, is $735 a month above the fixed payment; that is the cash-flow stress the borrower would have carried for the last four years.