Excel Spreadsheet

Mortgage Interest Calculator

You must be logged in to download this document
Mortgages Free Repayment Calculator How to use our detailed Mortgage calculator : Firstly, decide which type of Mortgage suits you best and then just input the loan amo the interest rate and the number of years the loan is to be repaid over, into the highlighted blue boxes below. For Repayment mortgage (Capital + Interest) Loan Amount Interest Rate % Number Of Years Payment Amount Per Month approx Repayment Schedule Payment Payment Made 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 0 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 100,000.00 5% 10 1060.66 Interest 0 416.67 413.98 411.29 408.58 405.87 403.14 400.40 397.65 394.88 392.11 389.33 386.53 383.72 380.90 378.07 375.22 372.37 369.50 366.62 363.73 360.82 357.91 354.98 352.04 349.09 346.12 343.14 340.15 337.15 334.14 331.11 328.07 Reduction Outstanding 0 100,000.00 643.99 646.67 649.37 652.07 654.79 657.52 660.26 663.01 665.77 668.54 671.33 674.13 676.94 679.76 682.59 685.43 688.29 691.16 694.04 696.93 699.83 702.75 705.68 708.62 711.57 714.53 717.51 720.50 723.50 726.52 729.55 732.58 99356.01 98709.34 98059.97 97407.90 96753.11 96095.60 95435.34 94772.33 94106.56 93438.02 92766.69 92092.56 91415.62 90735.87 90053.28 89367.84 88679.55 87988.40 87294.36 86597.43 85897.60 85194.85 84489.17 83780.56 83068.99 82354.45 81636.94 80916.44 80192.94 79466.42 78736.87 78004.29 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 325.02 321.95 318.87 315.78 312.68 309.56 306.43 303.29 300.14 296.97 293.79 290.59 287.38 284.16 280.92 277.68 274.41 271.14 267.85 264.54 261.23 257.90 254.55 251.19 247.82 244.43 241.03 237.62 234.19 230.74 227.29 223.81 220.33 216.82 213.31 209.78 206.23 202.67 199.10 195.51 191.90 188.28 184.65 181.00 177.33 173.65 169.96 166.25 162.52 158.78 155.02 151.25 147.46 143.65 139.83 135.99 735.64 738.70 741.78 744.87 747.97 751.09 754.22 757.36 760.52 763.69 766.87 770.07 773.27 776.50 779.73 782.98 786.24 789.52 792.81 796.11 799.43 802.76 806.10 809.46 812.84 816.22 819.62 823.04 826.47 829.91 833.37 836.84 840.33 843.83 847.35 850.88 854.42 857.98 861.56 865.15 868.75 872.37 876.01 879.66 883.32 887.00 890.70 894.41 898.14 901.88 905.64 909.41 913.20 917.00 920.82 924.66 77268.65 76529.95 75788.17 75043.30 74295.32 73544.23 72790.01 72032.65 71272.13 70508.44 69741.57 68971.51 68198.23 67421.74 66642.00 65859.02 65072.78 64283.26 63490.46 62694.34 61894.91 61092.16 60286.05 59476.59 58663.75 57847.53 57027.90 56204.87 55378.40 54548.49 53715.12 52878.27 52037.94 51194.11 50346.77 49495.89 48641.47 47783.49 46921.93 46056.78 45188.03 44315.66 43439.65 42560.00 41676.67 40789.67 39898.97 39004.56 38106.43 37204.55 36298.91 35389.50 34476.30 33559.30 32638.48 31713.81 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 1060.66 132.14 128.27 124.39 120.49 116.57 112.63 108.68 104.72 100.74 96.74 92.72 88.69 84.64 80.57 76.49 72.39 68.27 64.13 59.98 55.81 51.62 47.42 43.20 38.96 34.70 30.43 26.13 21.82 17.49 13.15 8.78 4.40 928.51 932.38 936.27 940.17 944.09 948.02 951.97 955.94 959.92 963.92 967.94 971.97 976.02 980.09 984.17 988.27 992.39 996.52 1000.67 1004.84 1009.03 1013.24 1017.46 1021.70 1025.95 1030.23 1034.52 1038.83 1043.16 1047.51 1051.87 1056.25 30785.30 29852.92 28916.65 27976.48 27032.39 26084.37 25132.40 24176.47 23216.55 22252.63 21284.69 20312.72 19336.70 18356.62 17372.45 16384.18 15391.79 14395.27 13394.59 12389.75 11380.72 10367.48 9350.02 8328.33 7302.37 6272.15 5237.62 4198.79 3155.63 2108.13 1056.25 0.00 e which type of Mortgage suits you best and then just input the loan amount, epaid over, into the highlighted blue boxes below. For Interest only mortgage Loan Amount Interest Rate % Number Of Years Annual Interest Payment Amount Per Month approx 100,000.00 5.00% 10 5000 416.67 Important - At the end of the 'Interest Only' loan period you will still have the full amount of the original loan outstanding !!

Related docs
Mortgage Calculator
Views: 49  |  Downloads: 0
Mortgage Interest Rates Calculator
Views: 353  |  Downloads: 20
Mortgage Calculator On Interest
Views: 1  |  Downloads: 0
Mortgage Calculator And Interest
Views: 2  |  Downloads: 0
Mortgage Calculator For Interest
Views: 1  |  Downloads: 0
Mortgage Calculator
Views: 14  |  Downloads: 0
Mortgage Calculator
Views: 427  |  Downloads: 2
Mortgage Calculator
Views: 91  |  Downloads: 16
A mortgage calculator
Views: 49  |  Downloads: 0
A mortgage calculator
Views: 25  |  Downloads: 0
Mortgage Calculator
Views: 473  |  Downloads: 26
Calculator Interest
Views: 12  |  Downloads: 0
Interest Mortgage Payment Calculator
Views: 22  |  Downloads: 0
A mortgage calculator
Views: 0  |  Downloads: 0
premium docs
Other docs by crisologa lapu...
Free Prenuptial Agreements
Views: 378  |  Downloads: 10
Alaska Gas Prices
Views: 530  |  Downloads: 5
Resume Writting
Views: 1767  |  Downloads: 86
Printable Virtual Marriage Certificate
Views: 3139  |  Downloads: 85
Printable Fill in Resumes
Views: 2651  |  Downloads: 98
Plymouth County Registry of Deeds
Views: 800  |  Downloads: 1
PA Career Links
Views: 490  |  Downloads: 0
Order Business Cards
Views: 219  |  Downloads: 0
New York Burn Accident Claims
Views: 210  |  Downloads: 0
Legal Agreements
Views: 446  |  Downloads: 10
Hawaii Birth Certificate
Views: 3190  |  Downloads: 4
Grant Resource Center
Views: 173  |  Downloads: 2
Grant Applications Dental
Views: 173  |  Downloads: 3
Government Business Grants
Views: 348  |  Downloads: 5
Ge Careers
Views: 200  |  Downloads: 1