80b8ddfa-8365-471e-a7c5-08caa3f2c147.xls
Amortization Table
The amortization table at the end of this worksheet calculates the principal and interest payments, ending balance,
and cumulative interest for any 84 consecutive payment periods of a loan.
u To use the table, change the values in the Inital Data section of the worksheet.
u If you increase the term of the loan or the number of payments, you will need to add more payment periods
to the table. Select cells A75:G77, then drag the Fill handle (+) into the cells below the table.
u Most formulas on this worksheet are contained in defined names. To see the names and formulas,
choose Name from the Insert menu, and then choose Define. Select a name from the list
('Amortization Table'!Interest, for example).
Initial Data
LOAN DATA TABLE DATA
Loan amount: $310,850.00 Table starts at date: 7/1/2003
Annual interest rate: 6.625% or at payment number: 1
Term in years: 30
Payments per year: 12
First payment due: 7/1/2003
PERIODIC PAYMENT
Entered payment: The table uses the calculated periodic payment amount,
Calculated payment: $1,990.41 unless you enter a value for "Entered payment."
CALCULATIONS
Use payment of: $1,990.41 Beginning balance at payment 1: $310,850.00
1st payment in table: 1 Cumulative interest prior to payment 1: $0.00
Table
Payment Beginning Ending Cumulative
No. Date Balance Interest Principal Balance Interest
1 7/1/2003 310,850.00 1,716.15 274.26 310,575.74 1,716.15
2 8/1/2003 310,575.74 1,714.64 275.77 310,299.97 3,430.79
3 9/1/2003 310,299.97 1,713.11 277.29 310,022.68 5,143.90
4 10/1/2003 310,022.68 1,711.58 278.82 309,743.86 6,855.49
5 11/1/2003 309,743.86 1,710.04 280.36 309,463.50 8,565.53
6 12/1/2003 309,463.50 1,708.50 281.91 309,181.59 10,274.03
7 1/1/2004 309,181.59 1,706.94 283.47 308,898.12 11,980.97
8 2/1/2004 308,898.12 1,705.38 285.03 308,613.09 13,686.34
9 3/1/2004 308,613.09 1,703.80 286.61 308,326.48 15,390.14
10 4/1/2004 308,326.48 1,702.22 288.19 308,038.30 17,092.36
11 5/1/2004 308,038.30 1,700.63 289.78 307,748.52 18,792.99
12 6/1/2004 307,748.52 1,699.03 291.38 307,457.14 20,492.02
13 7/1/2004 307,457.14 1,697.42 292.99 307,164.15 22,189.44
14 8/1/2004 307,164.15 1,695.80 294.60 306,869.55 23,885.24
15 9/1/2004 306,869.55 1,694.18 296.23 306,573.32 25,579.42
16 10/1/2004 306,573.32 1,692.54 297.87 306,275.45 27,271.96
17 11/1/2004 306,275.45 1,690.90 299.51 305,975.94 28,962.85
18 12/1/2004 305,975.94 1,689.24 301.16 305,674.77 30,652.09
19 1/1/2005 305,674.77 1,687.58 302.83 305,371.95 32,339.67
20 2/1/2005 305,371.95 1,685.91 304.50 305,067.45 34,025.58
21 3/1/2005 305,067.45 1,684.23 306.18 304,761.27 35,709.81
22 4/1/2005 304,761.27 1,682.54 307.87 304,453.40 37,392.34
23 5/1/2005 304,453.40 1,680.84 309.57 304,143.83 39,073.18
24 6/1/2005 304,143.83 1,679.13 311.28 303,832.55 40,752.31
Page 1
80b8ddfa-8365-471e-a7c5-08caa3f2c147.xls
Payment Beginning Ending Cumulative
No. Date Balance Interest Principal Balance Interest
25 7/1/2005 303,832.55 1,677.41 313.00 303,519.55 42,429.72
26 8/1/2005 303,519.55 1,675.68 314.73 303,204.83 44,105.40
27 9/1/2005 303,204.83 1,673.94 316.46 302,888.36 45,779.34
28 10/1/2005 302,888.36 1,672.20 318.21 302,570.15 47,451.54
29 11/1/2005 302,570.15 1,670.44 319.97 302,250.18 49,121.98
30 12/1/2005 302,250.18 1,668.67 321.73 301,928.45 50,790.65
31 1/1/2006 301,928.45 1,666.90 323.51 301,604.94 52,457.55
32 2/1/2006 301,604.94 1,665.11 325.30 301,279.64 54,122.66
33 3/1/2006 301,279.64 1,663.31 327.09 300,952.55 55,785.97
34 4/1/2006 300,952.55 1,661.51 328.90 300,623.65 57,447.48
35 5/1/2006 300,623.65 1,659.69 330.71 300,292.94 59,107.17
36 6/1/2006 300,292.94 1,657.87 332.54 299,960.40 60,765.04
37 7/1/2006 299,960.40 1,656.03 334.38 299,626.03 62,421.07
38 8/1/2006 299,626.03 1,654.19 336.22 299,289.81 64,075.26
39 9/1/2006 299,289.81 1,652.33 338.08 298,951.73 65,727.59
40 10/1/2006 298,951.73 1,650.46 339.94 298,611.78 67,378.05
41 11/1/2006 298,611.78 1,648.59 341.82 298,269.96 69,026.63
42 12/1/2006 298,269.96 1,646.70 343.71 297,926.26 70,673.33
43 1/1/2007 297,926.26 1,644.80 345.61 297,580.65 72,318.13
44 2/1/2007 297,580.65 1,642.89 347.51 297,233.14 73,961.03
45 3/1/2007 297,233.14 1,640.97 349.43 296,883.70 75,602.00
46 4/1/2007 296,883.70 1,639.05 351.36 296,532.34 77,241.05
47 5/1/2007 296,532.34 1,637.11 353.30 296,179.04 78,878.15
48 6/1/2007 296,179.04 1,635.16 355.25 295,823.79 80,513.31
Page 2