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