Compare-Loans

Enter your loan information below. Compare two loans and find out how much you will save. If you know the loan terms you are eligible for, enter them in the calculator and click on the update button. (Note: You must click the update button to make sure your numbers are calculated.) If you don't know what loan types you are eligible for, you can apply on-line for up to four free quotes. APPLY NOW

Compare Loans and Save
Loan #1 Information
Loan
Annual Rate
Years of Loan
Monthly Payment
Total Payments
Loan #2 Information
Loan
Annual Rate
Years of Loan
Monthly Payment
Total Payments
 
Total Savings or Total Loss Using Loan #2

In this example the interest is compounded annually, so in order to find the monthly payment, the annual payment is divided by twelve. If the loan is compounded monthly, the monthly payment will be a bit less. For example, using Excel to calculate the monthly payments we can see the difference in the monthly loan payments, versus when a loan is compounded annually. Check the details of your loan to see how the interest is compounded (see example below).

When comparing loans it is important to check the details of the loan to see what one-time fees are included in the Annual Percentage Rate (APR). Annual Percentage Rate is an expression of the effective interest rate that the borrower will pay on a loan, taking into account one-time fees and standardizing the way the rate is expressed.

The APR of a loan is not usually a good measure of the actual interest you are paying on a loan. The APR is often higher that the actual rate you are paying on a loan. 

The “note rate" or the "headline rate" advertised by the lender is often less than the APR. In many advertisements, the APR appears in the fine print at the bottom of the advertisement, while the “note rate” or the "headline rate" is prominently displayed at the top of the advertisement. Make sure you know all of the one-time fees that are required by lenders, and read all the fine print before you decide which loan is best.

The calculator above compares two loans but should not be relied upon in itself to determine which loan is better for your needs. It is very important to get in writing from your lender exactly how much your monthly payments will be and exactly how many payments you will be required to make. If you are getting an adjustable-rate mortgage, you will not be able to determine exactly what your payments will be, because no one knows how interest rates will change. To find out what type of loan you pre-qualify for, fill out a simple form and you will receive loan quotes from up to four lenders.

Once you have received a loan quote and you want to determine your home-ownership costs, enter your property’s information into the real estate proforma spreadsheet on the Quick Proforma Page. Whether you are buying an investment property or your own home, run your numbers and find out how much ownership will cost you.

Online Loan Applications

With easy access to online quoting services and referral agencies, now has never been a better time to get the lowest rate and best possible terms on a new or existing loan policy. A number of free mortgage quote services allow homeowners and investors to apply for mortgages on-line at no charge and with no obligations. Mortgage-quote services are partnered with hundreds of nationwide lenders. These services are paid for by lenders so no money comes out of your pocket. Let lenders compete for your business! APPLY NOW

On-line Loan Types

Apply for First Mortgages, Refinance Loans, Home Equity Line of Credits, Secondary Financing, FHA/VA Loans, Construction Loans, Debt Consolidation Loans and Personal Loans. Once you have submitted your on-line application you will receive up to four free loan quotes, along with the lenders contact information. The on-line application takes only 5 minutes, and no initial credit check or Social Security number is needed. There is no obligation to purchase and your privacy is protected. APPLY NOW!

Compare Four Mortgages

Compare mortgage quotes with our four calculators Go to Calculator. Each calculator is independent. Enter the loan amount, loan rate, and the loan payoff time (years). You can enter the loan payoff time as a fraction. For instance, if your loan period is only 13 months, then enter 1.0833 (multiply the number of months times 0.0833). For a more comprehensive view of home-ownership costs, go to our Quick Proforma Page.

Download Excel Spreadsheet-Comparing Monthly and Annual Interest

This spreadsheet is a comparison of monthly and annual compounded loans. This spreadsheet is an Excel version of the mortgage examples below. You can change the variables and modify the amortization tables to fit your loans. Download Excel Spreadsheet

Download Excel Spreadsheet with Mortgage Amortization Tables and Formulas

This spreadsheet show you how to create an amortization schedule for a mortgage loan. Download Excel Spreadsheet

Mortgage Amortization Schedule Example with Monthly Compounding

This is the payment schedule if your interest is compounded monthly and you make the mortgage payment at the end of the payment period.

Input Values  
Annual Interest Rate (AIR) 10 %
Mortgage Loan Amount (MLA) $100,000
Number of Periodic Payments (NPP) 120

The Total Mortgage Payments you make is $158,580.88.
Output Values  
Monthly Mortgage Payment (MMP) ($1,321.51)
Annual Mortgage Payment (AMP) ($15,858.09)
Total Mortgage Payments (TMP) $158,580.88

Payment Period (PP)
Monthly Mortgage (MM) $
Mortgage Loan Principal (MLP) $
Monthly Interest (MI)
Interest Payment (IP) $
Ending Mortgage Rate (EMR) %
Equity (E) $
1
 (1,321.51) 100000.00 1/120 833.33 99,511.83 488.17
2
 (1,321.51) 99511.83 1/120 829.27 99,019.58 492.24
3
 (1,321.51) 99019.58 1/120 825.16 98,523.24 496.34
4
 (1,321.51) 98523.24 1/120 821.03 98,022.76 500.48
5
 (1,321.51) 98022.76 1/120 816.86 97,518.11 504.65
6
 (1,321.51) 97518.11 1/120 812.65 97,009.25 508.86
7
 (1,321.51) 97009.25 1/120 808.41 96,496.15 513.10
8
 (1,321.51) 96496.15 1/120 804.13 95,978.78 517.37
9
 (1,321.51) 95978.78 1/120 799.82 95,457.10 521.68
10
 (1,321.51) 95457.10 1/120 795.48 94,931.07 526.03
11
 (1,321.51) 94931.07 1/120 791.09 94,400.65 530.42
12
 (1,321.51) 94400.65 1/120 786.67 93,865.82 534.84
13
 (1,321.51) 93865.82 1/120 782.22
93,326.52
539.29
14
 (1,321.51) 93326.52 1/120 777.72
92,782.74
543.79
15
 (1,321.51) 92782.74 1/120 773.19
92,234.42
548.32
16
 (1,321.51) 92234.42 1/120 768.62
91,681.53
552.89
17
 (1,321.51) 91681.53 1/120 764.01
91,124.04
557.49
18
 (1,321.51) 91124.04 1/120 759.37
90,561.90
562.14
19
 (1,321.51) 90561.90 1/120 754.68
89,995.07
566.82
20
 (1,321.51) 89995.07 1/120 749.96
89,423.52
571.55
21
 (1,321.51) 89423.52 1/120 745.20
88,847.21
576.31
22
 (1,321.51) 88847.21 1/120 740.39
88,266.10
581.11
23
 (1,321.51) 88266.10 1/120 735.55
87,680.14
585.96
24
 (1,321.51) 87680.14 1/120 730.67
87,089.30
590.84
25
 (1,321.51) 87089.30 1/120 725.74
86,493.54
595.76
26
 (1,321.51) 86493.54 1/120 720.78
85,892.81
600.73
27
 (1,321.51) 85892.81 1/120 715.77
85,287.08
605.73
28
 (1,321.51) 85287.08 1/120 710.73
84,676.30
610.78
29
 (1,321.51) 84676.30 1/120 705.64
84,060.42
615.87
30
 (1,321.51) 84060.42 1/120 700.50
83,439.42
621.00
31
 (1,321.51) 83439.42 1/120 695.33
82,813.24
626.18
32
 (1,321.51) 82813.24 1/120 690.11
82,181.84
631.40
33
 (1,321.51) 82181.84 1/120 684.85
81,545.19
636.66
34
 (1,321.51) 81545.19 1/120 679.54
80,903.22
641.96
35
 (1,321.51) 80903.22 1/120 674.19
80,255.91
647.31
36
 (1,321.51) 80255.91 1/120 668.80
79,603.20
652.71
37
 (1,321.51) 79603.20 1/120 663.36
78,945.05
658.15
38
 (1,321.51) 78945.05 1/120 657.88
78,281.42
663.63
39
 (1,321.51) 78281.42 1/120 652.35
77,612.26
669.16
40
 (1,321.51) 77612.26 1/120 646.77
76,937.52
674.74
41
 (1,321.51) 76937.52 1/120 641.15
76,257.16
680.36
42
 (1,321.51) 76257.16 1/120 635.48
75,571.13
686.03
43
 (1,321.51) 75571.13 1/120 629.76
74,879.38
691.75
44
 (1,321.51) 74879.38 1/120 623.99
74,181.87
697.51
45
 (1,321.51) 74181.87 1/120 618.18
73,478.54
703.33
46
 (1,321.51) 73478.54 1/120 612.32
72,769.36
709.19
47
 (1,321.51) 72769.36 1/120 606.41
72,054.26
715.10
48
 (1,321.51) 72054.26 1/120 600.45
71,333.20
721.06
49
 (1,321.51) 71333.20 1/120 594.44
70,606.14
727.06
50
 (1,321.51) 70606.14 1/120 588.38
69,873.02
733.12
51
 (1,321.51) 69873.02 1/120 582.28
69,133.79
739.23
52
 (1,321.51) 69133.79 1/120 576.11
68,388.39
745.39
53
 (1,321.51) 68388.39 1/120 569.90
67,636.79
751.60
54
 (1,321.51) 67636.79 1/120 563.64
66,878.92
757.87
55
 (1,321.51) 66878.92 1/120 557.32
66,114.74
764.18
56
 (1,321.51) 66114.74 1/120 550.96
65,344.19
770.55
57
 (1,321.51) 65344.19 1/120 544.53
64,567.21
776.97
58
 (1,321.51) 64567.21 1/120 538.06
63,783.77
783.45
59
 (1,321.51) 63783.77 1/120 531.53
62,993.79
789.98
60
 (1,321.51) 62993.79 1/120 524.95
62,197.23
796.56
61
 (1,321.51) 62197.23 1/120 518.31
61,394.03
803.20
62
 (1,321.51) 61394.03 1/120 511.62
60,584.14
809.89
63
 (1,321.51) 60584.14 1/120 504.87
59,767.50
816.64
64
 (1,321.51) 59767.50 1/120 498.06
58,944.06
823.44
65
 (1,321.51) 58944.06 1/120 491.20
58,113.75
830.31
66
 (1,321.51) 58113.75 1/120 484.28
57,276.53
837.23
67
 (1,321.51) 57276.53 1/120 477.30
56,432.32
844.20
68
 (1,321.51) 56432.32 1/120 470.27
55,581.09
851.24
69
 (1,321.51) 55581.09 1/120 463.18
54,722.75
858.33
70
 (1,321.51) 54722.75 1/120 456.02
53,857.27
865.48
71
 (1,321.51) 53857.27 1/120 448.81
52,984.57
872.70
72
 (1,321.51) 52984.57 1/120 441.54
52,104.60
879.97
73
 (1,321.51) 52104.60 1/120 434.21
51,217.30
887.30
74
 (1,321.51) 51217.30 1/120 426.81
50,322.61
894.70
75
 (1,321.51) 50322.61 1/120 419.36
49,420.45
902.15
76
 (1,321.51) 49420.45 1/120 411.84
48,510.78
909.67
77
 (1,321.51) 48510.78 1/120 404.26
47,593.53
917.25
78
 (1,321.51) 47593.53 1/120 396.61
46,668.64
924.89
79
 (1,321.51) 46668.64 1/120 388.91
45,736.04
932.60
80
 (1,321.51) 45736.04 1/120 381.13
44,795.66
940.37
81
 (1,321.51) 44795.66 1/120 373.30
43,847.45
948.21
82
 (1,321.51) 43847.45 1/120 365.40
42,891.34
956.11
83
 (1,321.51) 42891.34 1/120 357.43
41,927.26
964.08
84
 (1,321.51) 41927.26 1/120 349.39
40,955.15
972.11
85
 (1,321.51) 40955.15 1/120 341.29
39,974.93
980.21
86
 (1,321.51) 39974.93 1/120 333.12
38,986.55
988.38
87
 (1,321.51) 38986.55 1/120 324.89
37,989.93
996.62
88
 (1,321.51) 37989.93 1/120 316.58
36,985.00
1,004.92
89
 (1,321.51) 36985.00 1/120 308.21
35,971.71
1,013.30
90
 (1,321.51) 35971.71 1/120 299.76
34,949.96
1,021.74
91
 (1,321.51) 34949.96 1/120 291.25
33,919.70
1,030.26
92
 (1,321.51) 33919.70 1/120 282.66
32,880.86
1,038.84
93
 (1,321.51) 32880.86 1/120 274.01
31,833.36
1,047.50
94
 (1,321.51) 31833.36 1/120 265.28
30,777.13
1,056.23
95
 (1,321.51) 30777.13 1/120 256.48
29,712.10
1,065.03
96
 (1,321.51) 29712.10 1/120 247.60
28,638.19
1,073.91
97
 (1,321.51) 28638.19 1/120 238.65
27,555.34
1,082.86
98
 (1,321.51) 27555.34 1/120 229.63
26,463.46
1,091.88
99
 (1,321.51) 26463.46 1/120 220.53
25,362.48
1,100.98
100
 (1,321.51) 25362.48 1/120 211.35
24,252.33
1,110.15
101
 (1,321.51) 24252.33 1/120 202.10
23,132.92
1,119.40
102
 (1,321.51) 23132.92 1/120 192.77
22,004.19
1,128.73
103
 (1,321.51) 22004.19 1/120 183.37
20,866.05
1,138.14
104
 (1,321.51) 20866.05 1/120 173.88 19,718.43 1,147.62
105
 (1,321.51) 19,718.43 1/120 164.32 18,561.24 1,157.19
106
 (1,321.51) 18,561.24 1/120 154.68 17,394.41 1,166.83
107
 (1,321.51) 17,394.41 1/120 144.95 16,217.86 1,176.55
108
 (1,321.51) 16,217.86 1/120 135.15 15,031.50 1,186.36
109
 (1,321.51) 15,031.50 1/120 125.26 13,835.25 1,196.24
110
 (1,321.51) 13,835.25 1/120 115.29 12,629.04 1,206.21
111
 (1,321.51) 12,629.04 1/120 105.24 11,412.77 1,216.27
112
 (1,321.51) 11,412.77 1/120 95.11 10,186.37 1,226.40
113
 (1,321.51) 10,186.37 1/120 84.89 8,949.75 1,236.62
114
 (1,321.51) 8,949.75 1/120 74.58 7,702.82 1,246.93
115
 (1,321.51) 7,702.82 1/120 64.19 6,445.51 1,257.32
116
 (1,321.51) 6,445.51 1/120 53.71 5,177.71 1,267.79
117
 (1,321.51) 5,177.71 1/120 43.15 3,899.35 1,278.36
118
 (1,321.51) 3,899.35 1/120 32.49 2,610.34 1,289.01
119
 (1,321.51) 2,610.34 1/120 21.75 1,310.59 1,299.75
120
 (1,321.51) 1,310.59 1/120 10.92 (0.00) 1,310.59
  ($158,580.88) $58,580.88   $100,000.00

The sum of the Equity column should always equal the Mortgage Loan Amount. If these two numbers do not match, then you have an error in your amortization schedule.

The Total Dollar Value of Mortgage Payment (TDVMP) you make is $158,580.88.

The Total Interest (TI) you pay is $58,580.88. This value is the sum of all the interest portion of the mortgage loan. This value is also equal to the Total Mortgage Payment (TMP) minus the Total Interest Paid (TIP).

TDVMP - (E or MLA) = TIP

$158,580.88 - $100,000 = $ 58,580.88

Ammortization Schedule for a Mortgage Loan with Annual Payments.

Years
Payment
Mortgage Principal
Interest
Ending Principal
Equity
1
($16,274.54)
$100,000.00
$10,000.00
$93,725.46
$6,274.54
2
($16,274.54)
$93,725.46
$9,372.55
$86,823.47
$6,901.99
3
($16,274.54)
$86,823.47
$8,682.35
$79,231.27
$7,592.19
4
($16,274.54)
$79,231.27
$7,923.13
$70,879.86
$8,351.41
5
($16,274.54)
$70,879.86
$7,087.99
$61,693.31
$9,186.55
6
($16,274.54)
$61,693.31
$6,169.33
$51,588.10
$10,105.21
7
($16,274.54)
$51,588.10
$5,158.81
$40,472.37
$11,115.73
8
($16,274.54)
$40,472.37
$4,047.24
$28,245.07
$12,227.30
9
($16,274.54)
$28,245.07
$2,824.51
$14,795.04
$13,450.03
10
($16,274.54)
$14,795.04
$1,479.50
$0.00
$14,795.04
Sum
($162,745.39)
$62,745.39
$100,000.00

 

Mortgage Amortization Schedule Example - Compare Monthly vs. Annual Interest

If you were to pay $1,356.22 a month instead of $1,321.50 then you would finish paying off the loan by the 115th payment, and you would have to pay $206.28 less on your last payment.  It is important to find out from your lender exactly how many payments you will be required to make during the life of a fixed-rate loan and how much those monthly payments will be. Ask the lender for the formula that they use so you can check the lenders calcuations using excel.

A
B
C
E
F
D
G
Payment Period (PP) #
Monthly Mortgage (MM) $
Year Beginning Principal (MLP) $
Monthly Mortgage Rate (MMR) %
Interest Payment (IP) $
Year Ending Principal (YEP) $
Equity (E) $
1
 (1,356.22) 100000.00 1/120 833.33 99477.12 522.88
2
 (1,356.22) 99477.12 1/120 828.98 98949.88 527.24
3
 (1,356.22) 98949.88 1/120 824.58 98418.24 531.63
4
 (1,356.22) 98418.24 1/120 820.15 97882.18 536.06
5
 (1,356.22) 97882.18 1/120 815.68 97341.64 540.53
6
 (1,356.22) 97341.64 1/120 811.18 96796.61 545.04
7
 (1,356.22) 96796.61 1/120 806.64 96247.03 549.58
8
 (1,356.22) 96247.03 1/120 802.06 95692.87 554.16
9
 (1,356.22) 95692.87 1/120 797.44 95134.09 558.78
10
 (1,356.22) 95134.09 1/120 792.78 94570.66 563.43
11
 (1,356.22) 94570.66 1/120 788.09 94002.53 568.13
12
 (1,356.22) 94002.53 1/120 783.35 93429.67 572.86
13
 (1,356.22) 93429.67 1/120 778.58 92852.04 577.64
14
 (1,356.22) 92852.04 1/120 773.77 92269.59 582.45
15
 (1,356.22) 92269.59 1/120 768.91 91682.28 587.30
16
 (1,356.22) 91682.28 1/120 764.02 91090.08 592.20
17
 (1,356.22) 91090.08 1/120 759.08 90492.95 597.13
18
 (1,356.22) 90492.95 1/120 754.11 89890.84 602.11
19
 (1,356.22) 89890.84 1/120 749.09 89283.72 607.13
20
 (1,356.22) 89283.72 1/120 744.03 88671.53 612.19
21
 (1,356.22) 88671.53 1/120 738.93 88054.24 617.29
22
 (1,356.22) 88054.24 1/120 733.79 87431.81 622.43
23
 (1,356.22) 87431.81 1/120 728.60 86804.19 627.62
24
 (1,356.22) 86804.19 1/120 723.37 86171.34 632.85
25
 (1,356.22) 86171.34 1/120 718.09 85533.22 638.12
26
 (1,356.22) 85533.22 1/120 712.78 84889.78 643.44
27
 (1,356.22) 84889.78 1/120 707.41 84240.98 648.80
28
 (1,356.22) 84240.98 1/120 702.01 83586.77 654.21
29
 (1,356.22) 83586.77 1/120 696.56 82927.11 659.66
30
 (1,356.22) 82927.11 1/120 691.06 82261.95 665.16
31
 (1,356.22) 82261.95 1/120 685.52 81591.25 670.70
32
 (1,356.22) 81591.25 1/120 679.93 80914.96 676.29
33
 (1,356.22) 80914.96 1/120 674.29 80233.04 681.93
34
 (1,356.22) 80233.04 1/120 668.61 79545.43 687.61
35
 (1,356.22) 79545.43 1/120 662.88 78852.09 693.34
36
 (1,356.22) 78852.09 1/120 657.10 78152.97 699.12
37
 (1,356.22) 78152.97 1/120 651.27 77448.03 704.94
38
 (1,356.22) 77448.03 1/120 645.40 76737.22 710.82
39
 (1,356.22) 76737.22 1/120 639.48 76020.48 716.74
40
 (1,356.22) 76020.48 1/120 633.50 75297.76 722.71
41
 (1,356.22) 75297.76 1/120 627.48 74569.03 728.74
42
 (1,356.22) 74569.03 1/120 621.41 73834.22 734.81
43
 (1,356.22) 73834.22 1/120 615.29 73093.29 740.93
44
 (1,356.22) 73093.29 1/120 609.11 72346.18 747.11
45
 (1,356.22) 72346.18 1/120 602.88 71592.85 753.33
46
 (1,356.22) 71592.85 1/120 596.61 70833.24 759.61
47
 (1,356.22) 70833.24 1/120 590.28 70067.30 765.94
48
 (1,356.22) 70067.30 1/120 583.89 69294.98 772.32
49
 (1,356.22) 69294.98 1/120 577.46 68516.22 778.76
50
 (1,356.22) 68516.22 1/120 570.97 67730.97 785.25
51
 (1,356.22) 67730.97 1/120 564.42 66939.18 791.79
52
 (1,356.22) 66939.18 1/120 557.83 66140.79 798.39
53
 (1,356.22) 66140.79 1/120 551.17 65335.74 805.04
54
 (1,356.22) 65335.74 1/120 544.46 64523.99 811.75
55
 (1,356.22) 64523.99 1/120 537.70 63705.47 818.52
56
 (1,356.22) 63705.47 1/120 530.88 62880.14 825.34
57
 (1,356.22) 62880.14 1/120 524.00 62047.92 832.22
58
 (1,356.22) 62047.92 1/120 517.07 61208.77 839.15
59
 (1,356.22) 61208.77 1/120 510.07 60362.63 846.14
60
 (1,356.22) 60362.63 1/120 503.02 59509.43 853.19
61
 (1,356.22) 59509.43 1/120 495.91 58649.13 860.30
62
 (1,356.22) 58649.13 1/120 488.74 57781.65 867.47
63
 (1,356.22) 57781.65 1/120 481.51 56906.95 874.70
64
 (1,356.22) 56906.95 1/120 474.22 56024.96 881.99
65
 (1,356.22) 56024.96 1/120 466.87 55135.61 889.34
66
 (1,356.22) 55135.61 1/120 459.46 54238.86 896.75
67
 (1,356.22) 54238.86 1/120 451.99 53334.63 904.23
68
 (1,356.22) 53334.63 1/120 444.46 52422.87 911.76
69
 (1,356.22) 52422.87 1/120 436.86 51503.51 919.36
70
 (1,356.22) 51503.51 1/120 429.20 50576.49 927.02
71
 (1,356.22) 50576.49 1/120 421.47 49641.75 934.75
72
 (1,356.22) 49641.75 1/120 413.68 48699.21 942.54
73
 (1,356.22) 48699.21 1/120 405.83 47748.82 950.39
74
 (1,356.22) 47748.82 1/120 397.91 46790.51 958.31
75
 (1,356.22) 46790.51 1/120 389.92 45824.21 966.30
76
 (1,356.22) 45824.21 1/120 381.87 44849.87 974.35
77
 (1,356.22) 44849.87 1/120 373.75 43867.40 982.47
78
 (1,356.22) 43867.40 1/120 365.56 42876.74 990.66
79
 (1,356.22) 42876.74 1/120 357.31 41877.83 998.91
80
 (1,356.22) 41877.83 1/120 348.98 40870.60 1007.23
81
 (1,356.22) 40870.60 1/120 340.59 39854.97 1015.63
82
 (1,356.22) 39854.97 1/120 332.12 38830.88 1024.09
83
 (1,356.22) 38830.88 1/120 323.59 37798.25 1032.63
84
 (1,356.22) 37798.25 1/120 314.99 36757.02 1041.23
85
 (1,356.22) 36757.02 1/120 306.31 35707.11 1049.91
86
 (1,356.22) 35707.11 1/120 297.56 34648.45 1058.66
87
 (1,356.22) 34648.45 1/120 288.74 33580.97 1067.48
88
 (1,356.22) 33580.97 1/120 279.84 32504.60 1076.38
89
 (1,356.22) 32504.60 1/120 270.87 31419.25 1085.35
90
 (1,356.22) 31419.25 1/120 261.83 30324.86 1094.39
91
 (1,356.22) 30324.86 1/120 252.71 29221.35 1103.51
92
 (1,356.22) 29221.35 1/120 243.51 28108.65 1112.71
93
 (1,356.22) 28108.65 1/120 234.24 26986.67 1121.98
94
 (1,356.22) 26986.67 1/120 224.89 25855.34 1131.33
95
 (1,356.22) 25855.34 1/120 215.46 24714.59 1140.76
96
 (1,356.22) 24714.59 1/120 205.95 23564.32 1150.26
97
 (1,356.22) 23564.32 1/120 196.37 22404.48 1159.85
98
 (1,356.22) 22404.48 1/120 186.70 21234.96 1169.51
99
 (1,356.22) 21234.96 1/120 176.96 20055.71 1179.26
100
 (1,356.22) 20055.71 1/120 167.13 18866.62 1189.09
101
 (1,356.22) 18866.62 1/120 157.22 17667.62 1199.00
102
 (1,356.22) 17667.62 1/120 147.23 16458.64 1208.99
103
 (1,356.22) 16458.64 1/120 137.16 15239.58 1219.06
104
 (1,356.22) 15239.58 1/120 127.00 14010.36 1229.22
105
 (1,356.22) 14010.36 1/120 116.75 12770.89 1239.46
106
 (1,356.22) 12770.89 1/120 106.42 11521.10 1249.79
107
 (1,356.22) 11521.10 1/120 96.01 10260.89 1260.21
108
 (1,356.22) 10260.89 1/120 85.51 8990.18 1270.71
109
 (1,356.22) 8990.18 1/120 74.92 7708.88 1281.30
110
 (1,356.22) 7708.88 1/120 64.24 6416.91 1291.98
111
 (1,356.22) 6416.91 1/120 53.47 5114.16 1302.74
112
 (1,356.22) 5114.16 1/120 42.62 3800.57 1313.60
113
 (1,356.22) 3800.57 1/120 31.67 2476.02 1324.55
114
 (1,356.22) 2476.02 1/120 20.63 1140.44 1335.58
115
 (1,356.22) 1140.44 1/120 9.50 (206.28) 1346.71
Total Payments (141,046.55)   Equity 100,206.28
Total Payment Formula SUM(B1:B115)
Equity Formula  
   SUM(G1:G115)

If you would like to download an Excel file with the table above click here.

Many loans allow you to make extra payments but you will have to check with your loan officer. Some mortgages have pre-payment penalties and an extra fee that you will have to pay if you make extra payments. If you want to see how much you would save by making extra payments on a loan, you can use the sample-online ammortization calculator.

If you would like to download an Excel turorial, showing how to make an amortization schedule click here.

When interest rates drop you are likely to save a significant amount of money on your loan if you refinance at a lower rate.

 

Member Posts

No topics exist.

UPDATE

Contribute to this page

Message Title:

Your Message Text:

Membership

Members receive access to a variety of real estate resources not available to the general public.

As a member you can:
  • Download Excel real estate proformas, construction checklists, construction contracts, real estate development schedules, and sample construction contracts.
  • Upload files such as contracts, schedules, and proformas to share with other members
  • Post discussion topics, write commentary, and reply to posts in the Members Forum
  • Create a member profile, with your photo, your resume, and information on your networking and real estate goals
  • Browse member profiles and find other entrepreneurs in your area
  • Send and receive messages to and from other members on your personalized profile page
  • List or create a real estate investment club(s) with details including your clubs description, contact information, meeting times, event information, and more
  • Browse the database of real estate investment clubs, and find clubs in your area
  • Reply to messages sent to your club from Members

Use our contracts and scopes of work for your renovation, remodeling, home-renovation projects, and new-home construction projects. Become a member and receive access to all of these sample construction contracts free: cabinets, ceramic tile, clean up/ move in, concrete slab, drywall, electrical wiring, flatwork patios, flooring, heating and air conditioning, low voltage, masonry fencing, painting, plumbing, and roofing. These contracts will help you control the quality of the work of your specialty contractors.

Become a member and develop your own customized proformas from our templates. Use your customized proformas to:

  • Help secure competitive loans for your real estate investments
  • Raise capital for your real estate investments
  • Strengthen your bargaining power and persuade the owner and selling broker to accept your offer
  • Keep records and update your proformas over the time span of your real estate projects

The Real-Estate-Proforma.com Members Area will be updated periodically to include more resources and links to online real estate services.

Screenshot of Members Download Area

Copyright © 2006 Real-Estate-Proforma.com ® All Rights Reserved.
about | contact | privacy policy | user agreement