ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Amortization Table
2
A simple amortization table covering 48 payment periods of a loan.
3
4
2) To print the table, just choose "Print" from the "File" menu. The print area is already defined.
5
Initial Data
6
LOAN DATA
TABLE DATA
7
Loan amount:
Table starts at date:
8
Annual interest rate:
or at payment number:
1
9
Term in years:
10
Payments per year:
11
First payment due:3/1/2016
12
PERIODIC PAYMENT
13
Entered payment:
The table uses the calculated periodic payment amount
14
Calculated payment:#NAME?
unless you enter a value for "Entered payment".
15
CALCULATIONS
16
Use payment of:#NAME?
Beginning balance at payment 1:
#DIV/0!
17
1st payment in table:1
Cumulative interest prior to payment 1:
#NAME?
18
Table
19
20
PaymentBeginningEndingCumulative
21
No.DateBalanceInterestPrincipalBalanceInterest
22
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
23
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
24
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
25
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
26
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
27
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
28
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
29
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
30
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
31
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
32
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
33
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
34
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
35
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
36
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
37
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
38
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
39
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
40
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
41
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
42
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
43
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
44
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
45
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
46
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
47
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
48
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
49
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
50
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
51
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
52
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
53
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
54
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
55
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
56
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
57
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
58
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
59
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
60
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
61
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
62
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
63
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
64
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
65
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
66
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
67
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
68
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
69
#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100