| Mortgage Loan Calculator | From SB Consultancy | |||||
| Download | ||||||
| Loan Variables | ||||||
| Purchase Price | £200,000 | Optional Payment | ||||
| Percent Down | 20% | First Payment Due | 24/12/00 | |||
| Interest Rate | 7.50% | Tax Releif | 20% | |||
| Term - Years | 15 | |||||
| Loan Results | ||||||
| Total Interest | 111,889 | Down Payment | 40,000 | |||
| Total Principal | 160,000 | Loan Amount | 160,000 | |||
| Total Paid | 271,889 | Annual Payment | -18,126 | |||
| Payments | 15 | Tax Releif | 22,378 | |||
| Monthly | -£1,510 | Quarterly | -£4,531 | Half Year | -£9,063 | |
| Payment Schedule | ||||||
| Date | Capital & Interest | Interest | Principal Repaid | Principal Remaining | Tax Releif | |
| 24/12/00 | 160,000 | |||||
| Dec-01 | -18,126 | 12,000 | -6,126 | 153,874 | 2400 | |
| Dec-02 | -18,126 | 11,541 | -6,585 | 147,289 | 2308 | |
| Dec-03 | -18,126 | 11,047 | -7,079 | 140,209 | 2209 | |
| Dec-04 | -18,126 | 10,516 | -7,610 | 132,599 | 2103 | |
| Dec-05 | -18,126 | 9,945 | -8,181 | 124,418 | 1989 | |
| Dec-06 | -18,126 | 9,331 | -8,795 | 115,623 | 1866 | |
| Dec-07 | -18,126 | 8,672 | -9,454 | 106,169 | 1734 | |
| Dec-08 | -18,126 | 7,963 | -10,163 | 96,006 | 1593 | |
| Dec-09 | -18,126 | 7,200 | -10,926 | 85,080 | 1440 | |
| Dec-10 | -18,126 | 6,381 | -11,745 | 73,336 | 1276 | |
| Dec-11 | -18,126 | 5,500 | -12,626 | 60,710 | 1100 | |
| Dec-12 | -18,126 | 4,553 | -13,573 | 47,137 | 911 | |
| Dec-13 | -18,126 | 3,535 | -14,591 | 32,546 | 707 | |
| Dec-14 | -18,126 | 2,441 | -15,685 | 16,861 | 488 | |
| Dec-15 | -18,126 | 1,265 | -16,861 | 0 | 253 | |
| Dec-16 | 0 | 0 | 0 | 0 | 0 | |
| Dec-17 | 0 | 0 | 0 | 0 | 0 | |
| Dec-18 | 0 | 0 | 0 | 0 | 0 | |
| Dec-19 | 0 | 0 | 0 | 0 | 0 | |
| Dec-20 | 0 | 0 | 0 | 0 | 0 | |
| Dec-21 | 0 | 0 | 0 | 0 | 0 | |
| Dec-22 | 0 | 0 | 0 | 0 | 0 | |
| Dec-23 | 0 | 0 | 0 | 0 | 0 | |
| Dec-24 | 0 | 0 | 0 | 0 | 0 | |
| Dec-25 | 0 | 0 | 0 | 0 | 0 | |
| Dec-26 | 0 | 0 | 0 | 0 | 0 | |
| Dec-27 | 0 | 0 | 0 | 0 | 0 | |
| Dec-28 | 0 | 0 | 0 | 0 | 0 | |
| Dec-29 | 0 | 0 | 0 | 0 | 0 | |
| Dec-30 | 0 | 0 | 0 | 0 | 0 | |
| Dec-31 | 0 | 0 | 0 | 0 | 0 | |
| Dec-32 | 0 | 0 | 0 | 0 | 0 | |
| Dec-33 | 0 | 0 | 0 | 0 | 0 | |
| Dec-34 | 0 | 0 | 0 | 0 | 0 | |
| Dec-35 | 0 | 0 | 0 | 0 | 0 | |
| Dec-36 | 0 | 0 | 0 | 0 | 0 | |
| Dec-37 | 0 | 0 | 0 | 0 | 0 | |
| Dec-38 | 0 | 0 | 0 | 0 | 0 | |
| Dec-39 | 0 | 0 | 0 | 0 | 0 | |
| Dec-40 | 0 | 0 | 0 | 0 | 0 | |
| Totals | -271,889 | 111,889 | -160,000 | 22,378 | ||