Comparison of Mortgage Monthly Payments
How TOTAL colouring & ranking works
Lowest
2nd (in groups of 4)
Middle
Highest
- Grouping by equal Prod. term.
- Only positive Totals take part; ties share a colour.
- 3 distinct totals → also highlight Middle; 4 distinct → add 2nd.
- Copy to Word preserves current colours as inline styles.
Repayment
| Term (years) | Term (months) | Value | Loan | LTV | Prod. term | Rate | Prod. fee | Fee added | Monthly | Total (incl fee) |
|---|
Interest-Only
| Term (years) | Term (months) | Value | Loan | LTV | Prod. term | Rate | Prod. fee | Fee added | Monthly | Total (incl fee) |
|---|
Note: Repayment = annuity; Interest-Only = interest only. “Total over product term” = sum of monthly payments over the fixed period plus product fee.