Calculation guide
End-of-month payments and a fixed nominal annual rate divided by twelve. No fees or early settlement charges.
Inputs
Existing principal
Example entry 150000 (in the selected currency). Minimum 0.01.
Existing annual rate
Example entry 3 %. Allowed range 0 to 100.
Remaining months on ported loan
Example entry 180. Allowed range 1 to 600. Use whole numbers.
Additional borrowing
Example entry 50000 (in the selected currency).
New annual rate
Example entry 6 %. Allowed range 0 to 100.
Months on top-up
Example entry 240. Allowed range 1 to 600. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| Existing principal | 150,000 |
| Existing annual rate | 3% |
| Remaining months on ported loan | 180 |
| Additional borrowing | 50,000 |
| New annual rate | 6% |
| Months on top-up | 240 |
| Result | Value |
|---|---|
| Principal-weighted rate | 3.75% |
| Combined monthly payment | 1,394.08799 |
| Combined principal | 200,000 |
Calculation steps
Principal-weighted rate = (((Existing principal × Existing annual rate) + (Additional borrowing × New annual rate)) ÷ (Existing principal + Additional borrowing))
(((150,000 × 3) + (50,000 × 6)) ÷ (150,000 + 50,000)) = 3.75%
Combined monthly payment = (payment(Existing principal, Existing annual rate, Remaining months on ported loan) + payment(Additional borrowing, New annual rate, Months on top-up))
(payment(150,000, 3, 180) + payment(50,000, 6, 240)) = 1,394.08799
Combined principal = (Existing principal + Additional borrowing)
(150,000 + 50,000) = 200,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 |
|---|---|---|---|---|---|
| Existing principal | 150,000 | 165,000 | Principal-weighted rate | 3.75% | 3.697674% |
| Existing annual rate | 3% | 4% | Principal-weighted rate | 3.75% | 4.5% |
| Remaining months on ported loan | 180 | 198 | Combined monthly payment | 1,394.08799 | 1,319.624738 |
| Additional borrowing | 50,000 | 55,000 | Principal-weighted rate | 3.75% | 3.804878% |
| New annual rate | 6% | 7% | Principal-weighted rate | 3.75% | 4% |
| Months on top-up | 240 | 264 | Combined monthly payment | 1,394.08799 | 1,377.409685 |
