Amortization Table

Reviews
Nice Table
Rated 9 out of 10

June 21, 2008 (1 years 5 ago)
The document "Amortization Table" is great. I wish I had this when I was back in Business Math in school. I liked how it was east to read. This could also be helpful when trying to figure out home loans. I could really see myself using this to figure out payment in the future.

Good for simple uses
Rated 5 out of 10

March 10, 2008 (1 years 8 ago)
This is a great amortization form for very simple uses. It doesn't provide a great deal of detail, but could be very useful in many simple applications such as family loan agreements or just to provide a quick overall view of payment comparisons.

Loan Amount $300,000 $300,000 $285,000 $285,000 $250,000 $250,000 $200,000 $200,000 $300,000 $300,000 $285,000 $285,000 $250,000 $250,000 $200,000 $200,000 $300,000 $300,000 $285,000 $285,000 $250,000 $250,000 $200,000 $200,000 $285,000 $285,000 $250,000 $250,000 $200,000 $200,000 $285,000 $285,000 $250,000 $250,000 $200,000 $200,000 $285,000 $285,000 $250,000 $250,000 $200,000 $200,000 $285,000 $285,000 $250,000 $250,000 $200,000 $200,000 Net $215,000 $215,000 $200,000 $200,000 $165,000 $165,000 $115,000 $115,000 $215,000 $215,000 $200,000 $200,000 $165,000 $165,000 $115,000 $115,000 $215,000 $215,000 $200,000 $200,000 $165,000 $165,000 $115,000 $115,000 $200,000 $200,000 $165,000 $165,000 $115,000 $115,000 $200,000 $200,000 $165,000 $165,000 $115,000 $115,000 $200,000 $200,000 $165,000 $165,000 $115,000 $115,000 $200,000 $200,000 $165,000 $165,000 $115,000 $115,000 Term (Years) 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 15 30 Interest 4.9% 4.9% 4.9% 4.9% 4.9% 4.9% 4.9% 4.9% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.1% 5.1% 5.1% 5.1% 5.1% 5.1% 5.1% 5.1% 5.375% 5.375% 5.375% 5.375% 5.375% 5.375% 5.250% 5.250% 5.250% 5.250% 5.250% 5.250% 5.500% 5.500% 5.500% 5.500% 5.500% 5.500% 5.750% 5.750% 5.750% 5.750% 5.750% 5.750% Payment $2,356.78 $1,592.18 $2,238.94 $1,512.57 $1,963.99 $1,326.82 $1,571.19 $1,061.45 $2,372.38 $1,610.46 $2,253.76 $1,529.94 $1,976.98 $1,342.05 $1,581.59 $1,073.64 $2,388.04 $1,628.85 $2,268.64 $1,547.41 $1,990.03 $1,357.37 $1,592.03 $1,085.90 $2,309.83 $1,595.92 $2,026.16 $1,399.93 $1,620.93 $1,119.94 $2,291.05 $1,573.78 $2,009.69 $1,380.51 $1,607.76 $1,104.41 $2,328.69 $1,618.20 $2,042.71 $1,419.47 $1,634.17 $1,135.58 $2,366.67 $1,663.18 $2,076.03 $1,458.93 $1,660.82 $1,167.15 0.004083 0.004083 0.004083 0.004083 0.004083 0.004083 0.004083 0.004083 0.004167 0.004167 0.004167 0.004167 0.004167 0.004167 0.004167 0.004167 0.00425 0.00425 0.00425 0.00425 0.00425 0.00425 0.00425 0.00425 0.004479 0.004479 0.004479 0.004479 0.004479 0.004479 0.004375 0.004375 0.004375 0.004375 0.004375 0.004375 0.004583 0.004583 0.004583 0.004583 0.004583 0.004583 0.004792 0.004792 0.004792 0.004792 0.004792 0.004792 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 180 360 $500,000 $375,000 $250,000 $250,000 $200,000 $200,000 $415,000 $290,000 $165,000 $165,000 $115,000 $115,000 15 30 15 30 15 30 6.000% 6.000% 6.000% 6.000% 6.000% 6.000% $4,219.28 $2,248.31 $2,109.64 $1,498.88 $1,687.71 $1,199.10 0.005 0.005 0.005 0.005 0.005 0.005 180 360 180 360 180 360 30y 45 days 5.38% 250000 20y 5.38% b41d52da-16df-4852-8403-6c42b8a2080d.xls Amortization Table A simple amortization table covering 360 payment periods of a loan. 1) To use the table, simply change any of the values in the "inital data" area of the worksheet. 2) To print the table, just choose "Print" from the "File" menu. The print area is already defined. Initial Data LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: PERIODIC PAYMENT Entered payment: Calculated payment: CALCULATIONS Use payment of: 1st payment in table: $300,000.00 5.50% 30 12 8/1/2005 TABLE DATA Table starts at date: or at payment number: 1 $1,703.37 $1,703.37 1 The table uses the calculated periodic payment amount unless you enter a value for "Entered payment". Beginning balance at payment 1: Cumulative interest prior to payment 1: 300,000.00 0.00 Table No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Payment Date 8/1/2005 9/1/2005 10/1/2005 11/1/2005 12/1/2005 1/1/2006 2/1/2006 3/1/2006 4/1/2006 5/1/2006 6/1/2006 7/1/2006 8/1/2006 9/1/2006 10/1/2006 11/1/2006 12/1/2006 1/1/2007 2/1/2007 3/1/2007 4/1/2007 5/1/2007 6/1/2007 7/1/2007 Beginning Balance 300,000.00 299,671.63 299,341.76 299,010.38 298,677.47 298,343.05 298,007.08 297,669.58 297,330.54 296,989.93 296,647.77 296,304.04 295,958.73 295,611.84 295,263.36 294,913.29 294,561.61 294,208.31 293,853.40 293,496.86 293,138.69 292,778.87 292,417.41 292,054.29 Interest 1,375.00 1,373.49 1,371.98 1,370.46 1,368.94 1,367.41 1,365.87 1,364.32 1,362.76 1,361.20 1,359.64 1,358.06 1,356.48 1,354.89 1,353.29 1,351.69 1,350.07 1,348.45 1,346.83 1,345.19 1,343.55 1,341.90 1,340.25 1,338.58 Principal 328.37 329.87 331.38 332.90 334.43 335.96 337.50 339.05 340.60 342.16 343.73 345.31 346.89 348.48 350.08 351.68 353.29 354.91 356.54 358.17 359.81 361.46 363.12 364.78 Ending Balance 299,671.63 299,341.76 299,010.38 298,677.47 298,343.05 298,007.08 297,669.58 297,330.54 296,989.93 296,647.77 296,304.04 295,958.73 295,611.84 295,263.36 294,913.29 294,561.61 294,208.31 293,853.40 293,496.86 293,138.69 292,778.87 292,417.41 292,054.29 291,689.50 Cumulative Interest 1,375.00 2,748.49 4,120.48 5,490.94 6,859.88 8,227.29 9,593.15 10,957.47 12,320.24 13,681.44 15,041.08 16,399.14 17,755.61 19,110.50 20,463.79 21,815.48 23,165.55 24,514.01 25,860.83 27,206.03 28,549.58 29,891.48 31,231.73 32,570.31 Page 5

Related docs
Amortization Table
Views: 586  |  Downloads: 14
The Amortization Table
Views: 4  |  Downloads: 0
Loan Amortization Table
Views: 578  |  Downloads: 10
Amortization Table And
Views: 89  |  Downloads: 2
Amortization Table
Views: 405  |  Downloads: 62
Is An Amortization Table
Views: 13  |  Downloads: 0
Amortization Table Calculator
Views: 163  |  Downloads: 8
Mortgage Amortization Table
Views: 280  |  Downloads: 35
A Amortization Table
Views: 48  |  Downloads: 2
Amortization Table
Views: 0  |  Downloads: 0
Mortgage Amortization Table
Views: 674  |  Downloads: 11
Amortization Table
Views: 1  |  Downloads: 0
Monthly Amortization Table
Views: 10  |  Downloads: 0
premium docs