# EXPLANATION

Document Sample

```					EC100

AMORTIZATION TABLE FOR MORTGAGES: EXPLANATORY NOT

This program calculates the monthly mortgage payment PMT that is required to pay off a mortgage loan of \$L with
Click on the worksheet named "TABLE" at the bottom of this worksheet to go to the sheet with the required calculations and the
to enter numerical values for L, Y and rate, the latter being the annual interest rate (in decimal form) the bank charges on the lo
monthly compound rate simply by dividing RATE by 12. The monthly rate is calculated by the program, as shown. The number
The number in black are calculated by the program.
To calculate the monthly mortgage payment PMT, the program uses the equation I had used in class, to wit:

PMT = (iL) / [1 - 1/(1+i)(12Y)]

The program will, first, draw a graph showing you what the monthly mortgage payment PMT would be at different values for the
given the values for L (the loan) and Y (the years over which it is to be paid back) that you have submitted to the program. Bena
the amortization table for the particular payment PMT implied by the values of L, Y and RATE that you have submitted.

This amortization table assumes N to be 30 years. Therefore it has 360 rows. If you submit a value of, say, Y =15, then the prog
for 360 rows, but the entires for any row beyond the 180th payment will be meaningless. The row for the 180th payment should

Usually mortgages do not exceed 30 years. If you submitted Y = 40, the program would still calculate the correct payment and d
amortization table would go only to the 360th payment, not all the way to the 480th payment.

If you ever take out a mortgage loan, you should insist that the banker extending the loan print out for you an amoritzation table
still owe after having made the nth payment. In the table shown here, that amount is in the right-most column of the row for the
provide the table, prepare one yourself and have them sign off on it. It is the best protection against unpleasant surprises. As w
decade, the world of finance appears to be run on sometimes dubious ethical standards. (I personally have had the experience
after paying N payments than I knew I did. ) Knowing something about the technical aspects of finance is the best protection ag
of finance. It has helped me on more than one occasion.
: EXPLANATORY NOTES

ay off a mortgage loan of \$L with equal monthly payments over Y years.
with the required calculations and the amortization table. You are required
mal form) the bank charges on the loan. The bank will convert it to a
he program, as shown. The number si red are those you must submit.

ed in class, to wit:

T would be at different values for the annual borrowing rate (RATE).
have submitted to the program. Benath the graph you will then see
TE that you have submitted.

t a value of, say, Y =15, then the program will still calculate values
he row for the 180th payment should have a 0 in the right-most cell.

l calculate the correct payment and draw the proper graph, but the

print out for you an amoritzation table that shows exactly how much you
right-most column of the row for the nth payment. If the banker won't
n against unpleasant surprises. As we have learned in the past half
personally have had the experience of being told that I owed more
ts of finance is the best protection against being fleeced in the world
You need to specify only the numbers shown in red. The machine will do the rest.
SEE THE MORTIZATION TABLE FOR THIS DEAL BELOW

L         \$300,000        Mortgage loan
Y             20          Years (can be up to 30 years in this program)
M            240          Months (calculated by program)
RATE         5.00%         Annual borrowing rate (A.P.R.)
i          0.42%         Monthly borrowing rate (calculated by program)
PMT       \$1,979.87        Monthly mortgage payment (calculated by pgm.)

AMORTIZATION TABLE FOR A MORTGAGE LOAN (SCROLL DOWN)
Disregard any row row past the number of months for this deal
DEBT STILL OWED      INTEREST DUE       PAYMENT DUE      REPAYMENT OF DEBT
MONTH    AT BEGINNING OF     AT THE END OF     AT THE END OF     WITH THIS PERIOD'S
THE PERIOD         THE PERIOD        THE PERIOD            PAYMENT
(1)           (2)             (3) = i x (2)        (4)              (5) = (4) - (3)
1        \$300,000.00         \$1,250.00         \$1,979.87             \$729.87
2        \$299,270.13         \$1,246.96         \$1,979.87             \$732.91
3        \$298,537.22         \$1,243.91         \$1,979.87             \$735.96
4        \$297,801.26         \$1,240.84         \$1,979.87             \$739.03
5        \$297,062.23         \$1,237.76         \$1,979.87             \$742.11
6        \$296,320.13         \$1,234.67         \$1,979.87             \$745.20
7    \$295,574.93   \$1,231.56   \$1,979.87   \$748.31
8    \$294,826.62   \$1,228.44   \$1,979.87   \$751.42
9    \$294,075.20   \$1,225.31   \$1,979.87   \$754.55
10   \$293,320.64   \$1,222.17   \$1,979.87   \$757.70
11   \$292,562.95   \$1,219.01   \$1,979.87   \$760.85
12   \$291,802.09   \$1,215.84   \$1,979.87   \$764.03
13   \$291,038.07   \$1,212.66   \$1,979.87   \$767.21
14   \$290,270.86   \$1,209.46   \$1,979.87   \$770.41
15   \$289,500.45   \$1,206.25   \$1,979.87   \$773.62
16   \$288,726.84   \$1,203.03   \$1,979.87   \$776.84
17   \$287,950.00   \$1,199.79   \$1,979.87   \$780.08
18   \$287,169.92   \$1,196.54   \$1,979.87   \$783.33
19   \$286,386.60   \$1,193.28   \$1,979.87   \$786.59
20   \$285,600.01   \$1,190.00   \$1,979.87   \$789.87
21   \$284,810.14   \$1,186.71   \$1,979.87   \$793.16
22   \$284,016.98   \$1,183.40   \$1,979.87   \$796.46
23   \$283,220.52   \$1,180.09   \$1,979.87   \$799.78
24   \$282,420.74   \$1,176.75   \$1,979.87   \$803.11
25   \$281,617.62   \$1,173.41   \$1,979.87   \$806.46
26   \$280,811.16   \$1,170.05   \$1,979.87   \$809.82
27   \$280,001.34   \$1,166.67   \$1,979.87   \$813.19
28   \$279,188.15   \$1,163.28   \$1,979.87   \$816.58
29   \$278,371.56   \$1,159.88   \$1,979.87   \$819.99
30   \$277,551.58   \$1,156.46   \$1,979.87   \$823.40
31   \$276,728.17   \$1,153.03   \$1,979.87   \$826.83
32   \$275,901.34   \$1,149.59   \$1,979.87   \$830.28
33   \$275,071.06   \$1,146.13   \$1,979.87   \$833.74
34   \$274,237.33   \$1,142.66   \$1,979.87   \$837.21
35   \$273,400.11   \$1,139.17   \$1,979.87   \$840.70
36   \$272,559.41   \$1,135.66   \$1,979.87   \$844.20
37   \$271,715.21   \$1,132.15   \$1,979.87   \$847.72
38   \$270,867.49   \$1,128.61   \$1,979.87   \$851.25
39   \$270,016.24   \$1,125.07   \$1,979.87   \$854.80
40   \$269,161.44   \$1,121.51   \$1,979.87   \$858.36
41   \$268,303.08   \$1,117.93   \$1,979.87   \$861.94
42   \$267,441.14   \$1,114.34   \$1,979.87   \$865.53
43   \$266,575.61   \$1,110.73   \$1,979.87   \$869.14
44   \$265,706.47   \$1,107.11   \$1,979.87   \$872.76
45   \$264,833.72   \$1,103.47   \$1,979.87   \$876.39
46   \$263,957.32   \$1,099.82   \$1,979.87   \$880.05
47   \$263,077.28   \$1,096.16   \$1,979.87   \$883.71
48   \$262,193.57   \$1,092.47   \$1,979.87   \$887.39
49   \$261,306.17   \$1,088.78   \$1,979.87   \$891.09
50   \$260,415.08   \$1,085.06   \$1,979.87   \$894.80
51   \$259,520.28   \$1,081.33   \$1,979.87   \$898.53
52   \$258,621.74   \$1,077.59   \$1,979.87   \$902.28
53   \$257,719.47   \$1,073.83   \$1,979.87   \$906.04
54   \$256,813.43   \$1,070.06   \$1,979.87   \$909.81
55   \$255,903.62   \$1,066.27   \$1,979.87   \$913.60
56   \$254,990.02   \$1,062.46   \$1,979.87   \$917.41
57   \$254,072.61   \$1,058.64   \$1,979.87   \$921.23
58   \$253,151.38   \$1,054.80   \$1,979.87   \$925.07
59   \$252,226.31   \$1,050.94   \$1,979.87   \$928.92
60   \$251,297.38   \$1,047.07   \$1,979.87   \$932.79
61   \$250,364.59   \$1,043.19   \$1,979.87   \$936.68
62   \$249,427.91   \$1,039.28   \$1,979.87   \$940.58
63   \$248,487.32   \$1,035.36   \$1,979.87   \$944.50
64   \$247,542.82   \$1,031.43   \$1,979.87   \$948.44
65   \$246,594.38   \$1,027.48   \$1,979.87   \$952.39
66   \$245,641.99   \$1,023.51   \$1,979.87   \$956.36
67   \$244,685.63   \$1,019.52   \$1,979.87   \$960.34
68   \$243,725.29   \$1,015.52   \$1,979.87   \$964.35
69   \$242,760.94   \$1,011.50   \$1,979.87   \$968.36
70   \$241,792.58   \$1,007.47   \$1,979.87   \$972.40
71   \$240,820.18   \$1,003.42   \$1,979.87   \$976.45
72   \$239,843.73   \$999.35     \$1,979.87   \$980.52
73   \$238,863.21   \$995.26     \$1,979.87   \$984.60
74   \$237,878.61   \$991.16     \$1,979.87   \$988.71
75   \$236,889.90   \$987.04     \$1,979.87   \$992.83
76   \$235,897.08   \$982.90     \$1,979.87   \$996.96
77   \$234,900.11   \$978.75     \$1,979.87   \$1,001.12
78   \$233,899.00   \$974.58     \$1,979.87   \$1,005.29
79   \$232,893.71   \$970.39     \$1,979.87   \$1,009.48
80   \$231,884.23   \$966.18     \$1,979.87   \$1,013.68
81   \$230,870.55   \$961.96     \$1,979.87   \$1,017.91
82   \$229,852.64   \$957.72     \$1,979.87   \$1,022.15
83   \$228,830.50   \$953.46     \$1,979.87   \$1,026.41
84   \$227,804.09   \$949.18     \$1,979.87   \$1,030.68
85   \$226,773.41   \$944.89     \$1,979.87   \$1,034.98
86   \$225,738.43   \$940.58     \$1,979.87   \$1,039.29
87   \$224,699.14   \$936.25     \$1,979.87   \$1,043.62
88   \$223,655.52   \$931.90     \$1,979.87   \$1,047.97
89   \$222,607.55   \$927.53     \$1,979.87   \$1,052.34
90   \$221,555.21   \$923.15     \$1,979.87   \$1,056.72
91   \$220,498.49   \$918.74     \$1,979.87   \$1,061.12
92   \$219,437.37   \$914.32     \$1,979.87   \$1,065.54
93   \$218,371.82   \$909.88     \$1,979.87   \$1,069.98
94    \$217,301.84   \$905.42   \$1,979.87   \$1,074.44
95    \$216,227.39   \$900.95   \$1,979.87   \$1,078.92
96    \$215,148.48   \$896.45   \$1,979.87   \$1,083.42
97    \$214,065.06   \$891.94   \$1,979.87   \$1,087.93
98    \$212,977.13   \$887.40   \$1,979.87   \$1,092.46
99    \$211,884.67   \$882.85   \$1,979.87   \$1,097.01
100   \$210,787.65   \$878.28   \$1,979.87   \$1,101.59
101   \$209,686.07   \$873.69   \$1,979.87   \$1,106.18
102   \$208,579.89   \$869.08   \$1,979.87   \$1,110.78
103   \$207,469.11   \$864.45   \$1,979.87   \$1,115.41
104   \$206,353.70   \$859.81   \$1,979.87   \$1,120.06
105   \$205,233.64   \$855.14   \$1,979.87   \$1,124.73
106   \$204,108.91   \$850.45   \$1,979.87   \$1,129.41
107   \$202,979.50   \$845.75   \$1,979.87   \$1,134.12
108   \$201,845.38   \$841.02   \$1,979.87   \$1,138.84
109   \$200,706.53   \$836.28   \$1,979.87   \$1,143.59
110   \$199,562.94   \$831.51   \$1,979.87   \$1,148.35
111   \$198,414.59   \$826.73   \$1,979.87   \$1,153.14
112   \$197,261.45   \$821.92   \$1,979.87   \$1,157.94
113   \$196,103.50   \$817.10   \$1,979.87   \$1,162.77
114   \$194,940.73   \$812.25   \$1,979.87   \$1,167.61
115   \$193,773.12   \$807.39   \$1,979.87   \$1,172.48
116   \$192,600.64   \$802.50   \$1,979.87   \$1,177.36
117   \$191,423.27   \$797.60   \$1,979.87   \$1,182.27
118   \$190,241.00   \$792.67   \$1,979.87   \$1,187.20
119   \$189,053.81   \$787.72   \$1,979.87   \$1,192.14
120   \$187,861.67   \$782.76   \$1,979.87   \$1,197.11
121   \$186,664.55   \$777.77   \$1,979.87   \$1,202.10
122   \$185,462.46   \$772.76   \$1,979.87   \$1,207.11
123   \$184,255.35   \$767.73   \$1,979.87   \$1,212.14
124   \$183,043.21   \$762.68   \$1,979.87   \$1,217.19
125   \$181,826.03   \$757.61   \$1,979.87   \$1,222.26
126   \$180,603.77   \$752.52   \$1,979.87   \$1,227.35
127   \$179,376.42   \$747.40   \$1,979.87   \$1,232.47
128   \$178,143.95   \$742.27   \$1,979.87   \$1,237.60
129   \$176,906.35   \$737.11   \$1,979.87   \$1,242.76
130   \$175,663.59   \$731.93   \$1,979.87   \$1,247.94
131   \$174,415.66   \$726.73   \$1,979.87   \$1,253.14
132   \$173,162.52   \$721.51   \$1,979.87   \$1,258.36
133   \$171,904.16   \$716.27   \$1,979.87   \$1,263.60
134   \$170,640.56   \$711.00   \$1,979.87   \$1,268.86
135   \$169,371.70   \$705.72   \$1,979.87   \$1,274.15
136   \$168,097.55   \$700.41   \$1,979.87   \$1,279.46
137   \$166,818.09   \$695.08   \$1,979.87   \$1,284.79
138   \$165,533.30   \$689.72   \$1,979.87   \$1,290.15
139   \$164,243.15   \$684.35   \$1,979.87   \$1,295.52
140   \$162,947.63   \$678.95   \$1,979.87   \$1,300.92
141   \$161,646.71   \$673.53   \$1,979.87   \$1,306.34
142   \$160,340.37   \$668.08   \$1,979.87   \$1,311.78
143   \$159,028.59   \$662.62   \$1,979.87   \$1,317.25
144   \$157,711.34   \$657.13   \$1,979.87   \$1,322.74
145   \$156,388.60   \$651.62   \$1,979.87   \$1,328.25
146   \$155,060.36   \$646.08   \$1,979.87   \$1,333.78
147   \$153,726.57   \$640.53   \$1,979.87   \$1,339.34
148   \$152,387.23   \$634.95   \$1,979.87   \$1,344.92
149   \$151,042.31   \$629.34   \$1,979.87   \$1,350.52
150   \$149,691.79   \$623.72   \$1,979.87   \$1,356.15
151   \$148,335.64   \$618.07   \$1,979.87   \$1,361.80
152   \$146,973.84   \$612.39   \$1,979.87   \$1,367.48
153   \$145,606.36   \$606.69   \$1,979.87   \$1,373.17
154   \$144,233.19   \$600.97   \$1,979.87   \$1,378.90
155   \$142,854.29   \$595.23   \$1,979.87   \$1,384.64
156   \$141,469.65   \$589.46   \$1,979.87   \$1,390.41
157   \$140,079.24   \$583.66   \$1,979.87   \$1,396.20
158   \$138,683.03   \$577.85   \$1,979.87   \$1,402.02
159   \$137,281.01   \$572.00   \$1,979.87   \$1,407.86
160   \$135,873.15   \$566.14   \$1,979.87   \$1,413.73
161   \$134,459.42   \$560.25   \$1,979.87   \$1,419.62
162   \$133,039.80   \$554.33   \$1,979.87   \$1,425.53
163   \$131,614.27   \$548.39   \$1,979.87   \$1,431.47
164   \$130,182.79   \$542.43   \$1,979.87   \$1,437.44
165   \$128,745.35   \$536.44   \$1,979.87   \$1,443.43
166   \$127,301.93   \$530.42   \$1,979.87   \$1,449.44
167   \$125,852.48   \$524.39   \$1,979.87   \$1,455.48
168   \$124,397.00   \$518.32   \$1,979.87   \$1,461.55
169   \$122,935.45   \$512.23   \$1,979.87   \$1,467.64
170   \$121,467.82   \$506.12   \$1,979.87   \$1,473.75
171   \$119,994.07   \$499.98   \$1,979.87   \$1,479.89
172   \$118,514.18   \$493.81   \$1,979.87   \$1,486.06
173   \$117,028.12   \$487.62   \$1,979.87   \$1,492.25
174   \$115,535.87   \$481.40   \$1,979.87   \$1,498.47
175   \$114,037.40   \$475.16   \$1,979.87   \$1,504.71
176   \$112,532.69   \$468.89   \$1,979.87   \$1,510.98
177   \$111,021.71   \$462.59   \$1,979.87   \$1,517.28
178   \$109,504.43   \$456.27   \$1,979.87   \$1,523.60
179   \$107,980.83   \$449.92   \$1,979.87   \$1,529.95
180   \$106,450.88   \$443.55   \$1,979.87   \$1,536.32
181   \$104,914.56   \$437.14   \$1,979.87   \$1,542.72
182   \$103,371.84   \$430.72   \$1,979.87   \$1,549.15
183   \$101,822.69   \$424.26   \$1,979.87   \$1,555.61
184   \$100,267.08   \$417.78   \$1,979.87   \$1,562.09
185   \$98,704.99    \$411.27   \$1,979.87   \$1,568.60
186   \$97,136.40    \$404.73   \$1,979.87   \$1,575.13
187   \$95,561.27    \$398.17   \$1,979.87   \$1,581.70
188   \$93,979.57    \$391.58   \$1,979.87   \$1,588.29
189   \$92,391.28    \$384.96   \$1,979.87   \$1,594.90
190   \$90,796.38    \$378.32   \$1,979.87   \$1,601.55
191   \$89,194.83    \$371.65   \$1,979.87   \$1,608.22
192   \$87,586.61    \$364.94   \$1,979.87   \$1,614.92
193   \$85,971.69    \$358.22   \$1,979.87   \$1,621.65
194   \$84,350.04    \$351.46   \$1,979.87   \$1,628.41
195   \$82,721.63    \$344.67   \$1,979.87   \$1,635.19
196   \$81,086.43    \$337.86   \$1,979.87   \$1,642.01
197   \$79,444.43    \$331.02   \$1,979.87   \$1,648.85
198   \$77,795.58    \$324.15   \$1,979.87   \$1,655.72
199   \$76,139.86    \$317.25   \$1,979.87   \$1,662.62
200   \$74,477.24    \$310.32   \$1,979.87   \$1,669.55
201   \$72,807.69    \$303.37   \$1,979.87   \$1,676.50
202   \$71,131.19    \$296.38   \$1,979.87   \$1,683.49
203   \$69,447.71    \$289.37   \$1,979.87   \$1,690.50
204   \$67,757.20    \$282.32   \$1,979.87   \$1,697.55
205   \$66,059.66    \$275.25   \$1,979.87   \$1,704.62
206   \$64,355.04    \$268.15   \$1,979.87   \$1,711.72
207   \$62,643.32    \$261.01   \$1,979.87   \$1,718.85
208   \$60,924.46    \$253.85   \$1,979.87   \$1,726.02
209   \$59,198.45    \$246.66   \$1,979.87   \$1,733.21
210   \$57,465.24   \$239.44   \$1,979.87   \$1,740.43
211   \$55,724.81   \$232.19   \$1,979.87   \$1,747.68
212   \$53,977.13   \$224.90   \$1,979.87   \$1,754.96
213   \$52,222.17   \$217.59   \$1,979.87   \$1,762.27
214   \$50,459.90   \$210.25   \$1,979.87   \$1,769.62
215   \$48,690.28   \$202.88   \$1,979.87   \$1,776.99
216   \$46,913.29   \$195.47   \$1,979.87   \$1,784.40
217   \$45,128.89   \$188.04   \$1,979.87   \$1,791.83
218   \$43,337.06   \$180.57   \$1,979.87   \$1,799.30
219   \$41,537.77   \$173.07   \$1,979.87   \$1,806.79
220   \$39,730.97   \$165.55   \$1,979.87   \$1,814.32
221   \$37,916.65   \$157.99   \$1,979.87   \$1,821.88
222   \$36,094.77   \$150.39   \$1,979.87   \$1,829.47
223   \$34,265.30   \$142.77   \$1,979.87   \$1,837.10
224   \$32,428.20   \$135.12   \$1,979.87   \$1,844.75
225   \$30,583.45   \$127.43   \$1,979.87   \$1,852.44
226   \$28,731.02   \$119.71   \$1,979.87   \$1,860.15
227   \$26,870.86   \$111.96   \$1,979.87   \$1,867.91
228   \$25,002.96   \$104.18   \$1,979.87   \$1,875.69
229   \$23,127.27   \$96.36    \$1,979.87   \$1,883.50
230   \$21,243.76   \$88.52    \$1,979.87   \$1,891.35
231   \$19,352.41   \$80.64    \$1,979.87   \$1,899.23
232   \$17,453.18   \$72.72    \$1,979.87   \$1,907.15
233   \$15,546.04   \$64.78    \$1,979.87   \$1,915.09
234   \$13,630.94   \$56.80    \$1,979.87   \$1,923.07
235   \$11,707.87   \$48.78    \$1,979.87   \$1,931.08
236   \$9,776.79    \$40.74    \$1,979.87   \$1,939.13
237   \$7,837.66    \$32.66    \$1,979.87   \$1,947.21
238   \$5,890.45    \$24.54    \$1,979.87   \$1,955.32
239   \$3,935.12     \$16.40     \$1,979.87   \$1,963.47
240   \$1,971.65      \$8.22     \$1,979.87   \$1,971.65
241     \$0.00        \$0.00     \$1,979.87   \$1,979.87
242   -\$1,979.87     -\$8.25    \$1,979.87   \$1,988.12
243   -\$3,967.98    -\$16.53    \$1,979.87   \$1,996.40
244   -\$5,964.38    -\$24.85    \$1,979.87   \$2,004.72
245   -\$7,969.10    -\$33.20    \$1,979.87   \$2,013.07
246   -\$9,982.17    -\$41.59    \$1,979.87   \$2,021.46
247   -\$12,003.63   -\$50.02    \$1,979.87   \$2,029.88
248   -\$14,033.52   -\$58.47    \$1,979.87   \$2,038.34
249   -\$16,071.86   -\$66.97    \$1,979.87   \$2,046.83
250   -\$18,118.69   -\$75.49    \$1,979.87   \$2,055.36
251   -\$20,174.05   -\$84.06    \$1,979.87   \$2,063.93
252   -\$22,237.98   -\$92.66    \$1,979.87   \$2,072.53
253   -\$24,310.50   -\$101.29   \$1,979.87   \$2,081.16
254   -\$26,391.66   -\$109.97   \$1,979.87   \$2,089.83
255   -\$28,481.50   -\$118.67   \$1,979.87   \$2,098.54
256   -\$30,580.04   -\$127.42   \$1,979.87   \$2,107.28
257   -\$32,687.32   -\$136.20   \$1,979.87   \$2,116.06
258   -\$34,803.39   -\$145.01   \$1,979.87   \$2,124.88
259   -\$36,928.27   -\$153.87   \$1,979.87   \$2,133.73
260   -\$39,062.00   -\$162.76   \$1,979.87   \$2,142.63
261   -\$41,204.63   -\$171.69   \$1,979.87   \$2,151.55
262   -\$43,356.18   -\$180.65   \$1,979.87   \$2,160.52
263   -\$45,516.70   -\$189.65   \$1,979.87   \$2,169.52
264   -\$47,686.22   -\$198.69   \$1,979.87   \$2,178.56
265   -\$49,864.78   -\$207.77   \$1,979.87   \$2,187.64
266   -\$52,052.42   -\$216.89   \$1,979.87   \$2,196.75
267   -\$54,249.17    -\$226.04   \$1,979.87   \$2,205.91
268   -\$56,455.07    -\$235.23   \$1,979.87   \$2,215.10
269   -\$58,670.17    -\$244.46   \$1,979.87   \$2,224.33
270   -\$60,894.50    -\$253.73   \$1,979.87   \$2,233.59
271   -\$63,128.09    -\$263.03   \$1,979.87   \$2,242.90
272   -\$65,370.99    -\$272.38   \$1,979.87   \$2,252.25
273   -\$67,623.24    -\$281.76   \$1,979.87   \$2,261.63
274   -\$69,884.87    -\$291.19   \$1,979.87   \$2,271.05
275   -\$72,155.92    -\$300.65   \$1,979.87   \$2,280.52
276   -\$74,436.44    -\$310.15   \$1,979.87   \$2,290.02
277   -\$76,726.46    -\$319.69   \$1,979.87   \$2,299.56
278   -\$79,026.02    -\$329.28   \$1,979.87   \$2,309.14
279   -\$81,335.16    -\$338.90   \$1,979.87   \$2,318.76
280   -\$83,653.93    -\$348.56   \$1,979.87   \$2,328.43
281   -\$85,982.35    -\$358.26   \$1,979.87   \$2,338.13
282   -\$88,320.48    -\$368.00   \$1,979.87   \$2,347.87
283   -\$90,668.35    -\$377.78   \$1,979.87   \$2,357.65
284   -\$93,026.00    -\$387.61   \$1,979.87   \$2,367.48
285   -\$95,393.47    -\$397.47   \$1,979.87   \$2,377.34
286   -\$97,770.81    -\$407.38   \$1,979.87   \$2,387.25
287   -\$100,158.06   -\$417.33   \$1,979.87   \$2,397.19
288   -\$102,555.25   -\$427.31   \$1,979.87   \$2,407.18
289   -\$104,962.43   -\$437.34   \$1,979.87   \$2,417.21
290   -\$107,379.64   -\$447.42   \$1,979.87   \$2,427.28
291   -\$109,806.93   -\$457.53   \$1,979.87   \$2,437.40
292   -\$112,244.32   -\$467.68   \$1,979.87   \$2,447.55
293   -\$114,691.87   -\$477.88   \$1,979.87   \$2,457.75
294   -\$117,149.62   -\$488.12   \$1,979.87   \$2,467.99
295   -\$119,617.62   -\$498.41   \$1,979.87   \$2,478.27
296   -\$122,095.89   -\$508.73   \$1,979.87   \$2,488.60
297   -\$124,584.49   -\$519.10   \$1,979.87   \$2,498.97
298   -\$127,083.46   -\$529.51   \$1,979.87   \$2,509.38
299   -\$129,592.84   -\$539.97   \$1,979.87   \$2,519.84
300   -\$132,112.68   -\$550.47   \$1,979.87   \$2,530.34
301   -\$134,643.01   -\$561.01   \$1,979.87   \$2,540.88
302   -\$137,183.89   -\$571.60   \$1,979.87   \$2,551.47
303   -\$139,735.36   -\$582.23   \$1,979.87   \$2,562.10
304   -\$142,297.46   -\$592.91   \$1,979.87   \$2,572.77
305   -\$144,870.23   -\$603.63   \$1,979.87   \$2,583.49
306   -\$147,453.72   -\$614.39   \$1,979.87   \$2,594.26
307   -\$150,047.98   -\$625.20   \$1,979.87   \$2,605.07
308   -\$152,653.05   -\$636.05   \$1,979.87   \$2,615.92
309   -\$155,268.97   -\$646.95   \$1,979.87   \$2,626.82
310   -\$157,895.79   -\$657.90   \$1,979.87   \$2,637.77
311   -\$160,533.56   -\$668.89   \$1,979.87   \$2,648.76
312   -\$163,182.32   -\$679.93   \$1,979.87   \$2,659.79
313   -\$165,842.11   -\$691.01   \$1,979.87   \$2,670.88
314   -\$168,512.99   -\$702.14   \$1,979.87   \$2,682.00
315   -\$171,194.99   -\$713.31   \$1,979.87   \$2,693.18
316   -\$173,888.17   -\$724.53   \$1,979.87   \$2,704.40
317   -\$176,592.57   -\$735.80   \$1,979.87   \$2,715.67
318   -\$179,308.24   -\$747.12   \$1,979.87   \$2,726.98
319   -\$182,035.23   -\$758.48   \$1,979.87   \$2,738.35
320   -\$184,773.57   -\$769.89   \$1,979.87   \$2,749.76
321   -\$187,523.33   -\$781.35   \$1,979.87   \$2,761.21
322   -\$190,284.54   -\$792.85   \$1,979.87   \$2,772.72
323   -\$193,057.26   -\$804.41   \$1,979.87   \$2,784.27
324   -\$195,841.54   -\$816.01   \$1,979.87   \$2,795.87
325   -\$198,637.41   -\$827.66     \$1,979.87   \$2,807.52
326   -\$201,444.93   -\$839.35     \$1,979.87   \$2,819.22
327   -\$204,264.15   -\$851.10     \$1,979.87   \$2,830.97
328   -\$207,095.12   -\$862.90     \$1,979.87   \$2,842.76
329   -\$209,937.89   -\$874.74     \$1,979.87   \$2,854.61
330   -\$212,792.49   -\$886.64     \$1,979.87   \$2,866.50
331   -\$215,659.00   -\$898.58     \$1,979.87   \$2,878.45
332   -\$218,537.44   -\$910.57     \$1,979.87   \$2,890.44
333   -\$221,427.88   -\$922.62     \$1,979.87   \$2,902.48
334   -\$224,330.37   -\$934.71     \$1,979.87   \$2,914.58
335   -\$227,244.94   -\$946.85     \$1,979.87   \$2,926.72
336   -\$230,171.66   -\$959.05     \$1,979.87   \$2,938.92
337   -\$233,110.58   -\$971.29     \$1,979.87   \$2,951.16
338   -\$236,061.74   -\$983.59     \$1,979.87   \$2,963.46
339   -\$239,025.20   -\$995.94     \$1,979.87   \$2,975.81
340   -\$242,001.01   -\$1,008.34   \$1,979.87   \$2,988.20
341   -\$244,989.21   -\$1,020.79   \$1,979.87   \$3,000.66
342   -\$247,989.87   -\$1,033.29   \$1,979.87   \$3,013.16
343   -\$251,003.02   -\$1,045.85   \$1,979.87   \$3,025.71
344   -\$254,028.74   -\$1,058.45   \$1,979.87   \$3,038.32
345   -\$257,067.06   -\$1,071.11   \$1,979.87   \$3,050.98
346   -\$260,118.04   -\$1,083.83   \$1,979.87   \$3,063.69
347   -\$263,181.73   -\$1,096.59   \$1,979.87   \$3,076.46
348   -\$266,258.19   -\$1,109.41   \$1,979.87   \$3,089.28
349   -\$269,347.46   -\$1,122.28   \$1,979.87   \$3,102.15
350   -\$272,449.61   -\$1,135.21   \$1,979.87   \$3,115.07
351   -\$275,564.69   -\$1,148.19   \$1,979.87   \$3,128.05
352   -\$278,692.74   -\$1,161.22   \$1,979.87   \$3,141.09
353   -\$281,833.83   -\$1,174.31   \$1,979.87   \$3,154.17
354   -\$284,988.00   -\$1,187.45   \$1,979.87   \$3,167.32
355   -\$288,155.32   -\$1,200.65   \$1,979.87   \$3,180.51
356   -\$291,335.83   -\$1,213.90   \$1,979.87   \$3,193.77
357   -\$294,529.60   -\$1,227.21   \$1,979.87   \$3,207.07
358   -\$297,736.67   -\$1,240.57   \$1,979.87   \$3,220.44
359   -\$300,957.11   -\$1,253.99   \$1,979.87   \$3,233.86
360   -\$304,190.96   -\$1,267.46   \$1,979.87   \$3,247.33
LOANS
l do the rest.

CROLL DOWN)
r this deal
DEBT STILL OWNED
AT THE END OF
THE PERIOD
(6) = (2) - (5)
\$299,270.13
\$298,537.22
\$297,801.26
\$297,062.23
\$296,320.13
\$295,574.93
\$294,826.62
\$294,075.20
\$293,320.64
\$292,562.95
\$291,802.09
\$291,038.07
\$290,270.86
\$289,500.45
\$288,726.84
\$287,950.00
\$287,169.92
\$286,386.60
\$285,600.01
\$284,810.14
\$284,016.98
\$283,220.52
\$282,420.74
\$281,617.62
\$280,811.16
\$280,001.34
\$279,188.15
\$278,371.56
\$277,551.58
\$276,728.17
\$275,901.34
\$275,071.06
\$274,237.33
\$273,400.11
\$272,559.41
\$271,715.21
\$270,867.49
\$270,016.24
\$269,161.44
\$268,303.08
\$267,441.14
\$266,575.61
\$265,706.47
\$264,833.72
\$263,957.32
\$263,077.28
\$262,193.57
\$261,306.17
\$260,415.08
\$259,520.28
\$258,621.74
\$257,719.47
\$256,813.43
\$255,903.62
\$254,990.02
\$254,072.61
\$253,151.38
\$252,226.31
\$251,297.38
\$250,364.59
\$249,427.91
\$248,487.32
\$247,542.82
\$246,594.38
\$245,641.99
\$244,685.63
\$243,725.29
\$242,760.94
\$241,792.58
\$240,820.18
\$239,843.73
\$238,863.21
\$237,878.61
\$236,889.90
\$235,897.08
\$234,900.11
\$233,899.00
\$232,893.71
\$231,884.23
\$230,870.55
\$229,852.64
\$228,830.50
\$227,804.09
\$226,773.41
\$225,738.43
\$224,699.14
\$223,655.52
\$222,607.55
\$221,555.21
\$220,498.49
\$219,437.37
\$218,371.82
\$217,301.84
\$216,227.39
\$215,148.48
\$214,065.06
\$212,977.13
\$211,884.67
\$210,787.65
\$209,686.07
\$208,579.89
\$207,469.11
\$206,353.70
\$205,233.64
\$204,108.91
\$202,979.50
\$201,845.38
\$200,706.53
\$199,562.94
\$198,414.59
\$197,261.45
\$196,103.50
\$194,940.73
\$193,773.12
\$192,600.64
\$191,423.27
\$190,241.00
\$189,053.81
\$187,861.67
\$186,664.55
\$185,462.46
\$184,255.35
\$183,043.21
\$181,826.03
\$180,603.77
\$179,376.42
\$178,143.95
\$176,906.35
\$175,663.59
\$174,415.66
\$173,162.52
\$171,904.16
\$170,640.56
\$169,371.70
\$168,097.55
\$166,818.09
\$165,533.30
\$164,243.15
\$162,947.63
\$161,646.71
\$160,340.37
\$159,028.59
\$157,711.34
\$156,388.60
\$155,060.36
\$153,726.57
\$152,387.23
\$151,042.31
\$149,691.79
\$148,335.64
\$146,973.84
\$145,606.36
\$144,233.19
\$142,854.29
\$141,469.65
\$140,079.24
\$138,683.03
\$137,281.01
\$135,873.15
\$134,459.42
\$133,039.80
\$131,614.27
\$130,182.79
\$128,745.35
\$127,301.93
\$125,852.48
\$124,397.00
\$122,935.45
\$121,467.82
\$119,994.07
\$118,514.18
\$117,028.12
\$115,535.87
\$114,037.40
\$112,532.69
\$111,021.71
\$109,504.43
\$107,980.83
\$106,450.88
\$104,914.56
\$103,371.84
\$101,822.69
\$100,267.08
\$98,704.99
\$97,136.40
\$95,561.27
\$93,979.57
\$92,391.28
\$90,796.38
\$89,194.83
\$87,586.61
\$85,971.69
\$84,350.04
\$82,721.63
\$81,086.43
\$79,444.43
\$77,795.58
\$76,139.86
\$74,477.24
\$72,807.69
\$71,131.19
\$69,447.71
\$67,757.20
\$66,059.66
\$64,355.04
\$62,643.32
\$60,924.46
\$59,198.45
\$57,465.24
\$55,724.81
\$53,977.13
\$52,222.17
\$50,459.90
\$48,690.28
\$46,913.29
\$45,128.89
\$43,337.06
\$41,537.77
\$39,730.97
\$37,916.65
\$36,094.77
\$34,265.30
\$32,428.20
\$30,583.45
\$28,731.02
\$26,870.86
\$25,002.96
\$23,127.27
\$21,243.76
\$19,352.41
\$17,453.18
\$15,546.04
\$13,630.94
\$11,707.87
\$9,776.79
\$7,837.66
\$5,890.45
\$3,935.12
\$1,971.65
\$0.00
-\$1,979.87
-\$3,967.98
-\$5,964.38
-\$7,969.10
-\$9,982.17
-\$12,003.63
-\$14,033.52
-\$16,071.86
-\$18,118.69
-\$20,174.05
-\$22,237.98
-\$24,310.50
-\$26,391.66
-\$28,481.50
-\$30,580.04
-\$32,687.32
-\$34,803.39
-\$36,928.27
-\$39,062.00
-\$41,204.63
-\$43,356.18
-\$45,516.70
-\$47,686.22
-\$49,864.78
-\$52,052.42
-\$54,249.17
-\$56,455.07
-\$58,670.17
-\$60,894.50
-\$63,128.09
-\$65,370.99
-\$67,623.24
-\$69,884.87
-\$72,155.92
-\$74,436.44
-\$76,726.46
-\$79,026.02
-\$81,335.16
-\$83,653.93
-\$85,982.35
-\$88,320.48
-\$90,668.35
-\$93,026.00
-\$95,393.47
-\$97,770.81
-\$100,158.06
-\$102,555.25
-\$104,962.43
-\$107,379.64
-\$109,806.93
-\$112,244.32
-\$114,691.87
-\$117,149.62
-\$119,617.62
-\$122,095.89
-\$124,584.49
-\$127,083.46
-\$129,592.84
-\$132,112.68
-\$134,643.01
-\$137,183.89
-\$139,735.36
-\$142,297.46
-\$144,870.23
-\$147,453.72
-\$150,047.98
-\$152,653.05
-\$155,268.97
-\$157,895.79
-\$160,533.56
-\$163,182.32
-\$165,842.11
-\$168,512.99
-\$171,194.99
-\$173,888.17
-\$176,592.57
-\$179,308.24
-\$182,035.23
-\$184,773.57
-\$187,523.33
-\$190,284.54
-\$193,057.26
-\$195,841.54
-\$198,637.41
-\$201,444.93
-\$204,264.15
-\$207,095.12
-\$209,937.89
-\$212,792.49
-\$215,659.00
-\$218,537.44
-\$221,427.88
-\$224,330.37
-\$227,244.94
-\$230,171.66
-\$233,110.58
-\$236,061.74
-\$239,025.20
-\$242,001.01
-\$244,989.21
-\$247,989.87
-\$251,003.02
-\$254,028.74
-\$257,067.06
-\$260,118.04
-\$263,181.73
-\$266,258.19
-\$269,347.46
-\$272,449.61
-\$275,564.69
-\$278,692.74
-\$281,833.83
-\$284,988.00
-\$288,155.32
-\$291,335.83
-\$294,529.60
-\$297,736.67
-\$300,957.11
-\$304,190.96
-\$307,438.29

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 19 posted: 4/27/2010 language: English pages: 30