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