# Amortization Table - Excel - Excel

W
Description

This is an example of amortization table. This document is useful for studying amortization table.

Shared by:
Categories
-
Stats
views:
560
posted:
9/15/2008
language:
English
pages:
2
Document Sample

```							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
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

```
Related docs