Amortization Schedule Calculator V1.0 Excel Template

Document Sample
Amortization Schedule Calculator V1.0 Excel Template Powered By Docstoc
					                     AMORTIZATION SCHEDULE CALCULATOR

Loan Amount                             (PV)             1,000.00
Interest Rate (per Year)                (Rate)              8.00%
Term (Year)                             (Nper)                 15

Monthly Payment                         (PMT)              $9.56

         VISIT EXCELTEMPLATE.NET FOR MORE TEMPLATES AND UPDATES

Month       Balance        Principal      Interest      Payment     Total Interest
             1,000.00
     1         997.11            2.89            6.67        9.56           6.67
     2         994.20            2.91            6.65        9.56          13.31
     3         991.27            2.93            6.63        9.56          19.94
     4         988.32            2.95            6.61        9.56          26.55
     5         985.36            2.97            6.59        9.56          33.14
     6         982.37            2.99            6.57        9.56          39.71
     7         979.36            3.01            6.55        9.56          46.26
     8         976.33            3.03            6.53        9.56          52.79
     9         973.29            3.05            6.51        9.56          59.30
    10         970.22            3.07            6.49        9.56          65.78
    11         967.13            3.09            6.47        9.56          72.25
    12         964.02            3.11            6.45        9.56          78.70
    13         960.89            3.13            6.43        9.56          85.13
    14         957.74            3.15            6.41        9.56          91.53
    15         954.57            3.17            6.38        9.56          97.92
    16         951.38            3.19            6.36        9.56         104.28
    17         948.16            3.21            6.34        9.56         110.62
    18         944.93            3.24            6.32        9.56         116.94
    19         941.67            3.26            6.30        9.56         123.24
    20         938.39            3.28            6.28        9.56         129.52
    21         935.09            3.30            6.26        9.56         135.78
    22         931.77            3.32            6.23        9.56         142.01
    23         928.42            3.34            6.21        9.56         148.22
    24         925.06            3.37            6.19        9.56         154.41
    25         921.67            3.39            6.17        9.56         160.58
    26         918.26            3.41            6.14        9.56         166.72
    27         914.82            3.43            6.12        9.56         172.85
    28         911.36            3.46            6.10        9.56         178.95
    29         907.88            3.48            6.08        9.56         185.02
    30         904.38            3.50            6.05        9.56         191.07
    31         900.85            3.53            6.03        9.56         197.10
    32         897.30            3.55            6.01        9.56         203.11
    33         893.73            3.57            5.98        9.56         209.09
    34         890.13            3.60            5.96        9.56         215.05
    35         886.50            3.62            5.93        9.56         220.98
    36         882.86            3.65            5.91        9.56         226.89
    37         879.19            3.67            5.89        9.56         232.78
    38         875.49            3.70            5.86        9.56         238.64
    39         871.77            3.72            5.84        9.56         244.48
40   868.03   3.74   5.81   9.56   250.29
41   864.26   3.77   5.79   9.56   256.08
42   860.46   3.79   5.76   9.56   261.84
43   856.64   3.82   5.74   9.56   267.57
44   852.80   3.85   5.71   9.56   273.28
45   848.93   3.87   5.69   9.56   278.97
46   845.03   3.90   5.66   9.56   284.63
47   841.11   3.92   5.63   9.56   290.26
48   837.16   3.95   5.61   9.56   295.87
49   833.18   3.98   5.58   9.56   301.45
50   829.18   4.00   5.55   9.56   307.01
51   825.15   4.03   5.53   9.56   312.53
52   821.10   4.06   5.50   9.56   318.03
53   817.01   4.08   5.47   9.56   323.51
54   812.90   4.11   5.45   9.56   328.96
55   808.77   4.14   5.42   9.56   334.37
56   804.60   4.16   5.39   9.56   339.77
57   800.41   4.19   5.36   9.56   345.13
58   796.19   4.22   5.34   9.56   350.47
59   791.94   4.25   5.31   9.56   355.77
60   787.66   4.28   5.28   9.56   361.05
61   783.36   4.31   5.25   9.56   366.30
62   779.02   4.33   5.22   9.56   371.53
63   774.66   4.36   5.19   9.56   376.72
64   770.27   4.39   5.16   9.56   381.89
65   765.85   4.42   5.14   9.56   387.02
66   761.40   4.45   5.11   9.56   392.13
67   756.92   4.48   5.08   9.56   397.20
68   752.40   4.51   5.05   9.56   402.25
69   747.86   4.54   5.02   9.56   407.26
70   743.29   4.57   4.99   9.56   412.25
71   738.69   4.60   4.96   9.56   417.21
72   734.06   4.63   4.92   9.56   422.13
73   729.40   4.66   4.89   9.56   427.02
74   724.70   4.69   4.86   9.56   431.89
75   719.98   4.73   4.83   9.56   436.72
76   715.22   4.76   4.80   9.56   441.52
77   710.43   4.79   4.77   9.56   446.29
78   705.61   4.82   4.74   9.56   451.02
79   700.76   4.85   4.70   9.56   455.73
80   695.88   4.88   4.67   9.56   460.40
81   690.96   4.92   4.64   9.56   465.04
82   686.01   4.95   4.61   9.56   469.64
83   681.03   4.98   4.57   9.56   474.22
84   676.01   5.02   4.54   9.56   478.76
85   670.96   5.05   4.51   9.56   483.26
86   665.88   5.08   4.47   9.56   487.74
87   660.76   5.12   4.44   9.56   492.18
88   655.61   5.15   4.41   9.56   496.58
89   650.42   5.19   4.37   9.56   500.95
90   645.20   5.22   4.34   9.56   505.29
91   639.95   5.26   4.30   9.56   509.59
 92   634.66   5.29   4.27   9.56   513.86
 93   629.33   5.33   4.23   9.56   518.09
 94   623.97   5.36   4.20   9.56   522.28
 95   618.57   5.40   4.16   9.56   526.44
 96   613.14   5.43   4.12   9.56   530.57
 97   607.67   5.47   4.09   9.56   534.65
 98   602.17   5.51   4.05   9.56   538.70
 99   596.62   5.54   4.01   9.56   542.72
100   591.04   5.58   3.98   9.56   546.70
101   585.43   5.62   3.94   9.56   550.64
102   579.77   5.65   3.90   9.56   554.54
103   574.08   5.69   3.87   9.56   558.40
104   568.35   5.73   3.83   9.56   562.23
105   562.59   5.77   3.79   9.56   566.02
106   556.78   5.81   3.75   9.56   569.77
107   550.94   5.84   3.71   9.56   573.48
108   545.05   5.88   3.67   9.56   577.16
109   539.13   5.92   3.63   9.56   580.79
110   533.17   5.96   3.59   9.56   584.38
111   527.16   6.00   3.55   9.56   587.94
112   521.12   6.04   3.51   9.56   591.45
113   515.04   6.08   3.47   9.56   594.93
114   508.92   6.12   3.43   9.56   598.36
115   502.75   6.16   3.39   9.56   601.75
116   496.55   6.20   3.35   9.56   605.10
117   490.30   6.25   3.31   9.56   608.42
118   484.01   6.29   3.27   9.56   611.68
119   477.68   6.33   3.23   9.56   614.91
120   471.31   6.37   3.18   9.56   618.10
121   464.90   6.41   3.14   9.56   621.24
122   458.44   6.46   3.10   9.56   624.34
123   451.94   6.50   3.06   9.56   627.39
124   445.40   6.54   3.01   9.56   630.41
125   438.81   6.59   2.97   9.56   633.38
126   432.18   6.63   2.93   9.56   636.30
127   425.50   6.68   2.88   9.56   639.18
128   418.78   6.72   2.84   9.56   642.02
129   412.02   6.76   2.79   9.56   644.81
130   405.21   6.81   2.75   9.56   647.56
131   398.35   6.86   2.70   9.56   650.26
132   391.45   6.90   2.66   9.56   652.91
133   384.51   6.95   2.61   9.56   655.52
134   377.51   6.99   2.56   9.56   658.09
135   370.47   7.04   2.52   9.56   660.60
136   363.39   7.09   2.47   9.56   663.07
137   356.25   7.13   2.42   9.56   665.50
138   349.07   7.18   2.38   9.56   667.87
139   341.84   7.23   2.33   9.56   670.20
140   334.56   7.28   2.28   9.56   672.48
141   327.24   7.33   2.23   9.56   674.71
142   319.86   7.37   2.18   9.56   676.89
143   312.44   7.42   2.13   9.56   679.02
144   304.97    7.47   2.08   9.56   681.10
145   297.44    7.52   2.03   9.56   683.14
146   289.87    7.57   1.98   9.56   685.12
147   282.24    7.62   1.93   9.56   687.05
148   274.57    7.67   1.88   9.56   688.93
149   266.84    7.73   1.83   9.56   690.77
150   259.07    7.78   1.78   9.56   692.54
151   251.24    7.83   1.73   9.56   694.27
152   243.36    7.88   1.67   9.56   695.95
153   235.42    7.93   1.62   9.56   697.57
154   227.43    7.99   1.57   9.56   699.14
155   219.39    8.04   1.52   9.56   700.65
156   211.30    8.09   1.46   9.56   702.12
157   203.15    8.15   1.41   9.56   703.53
158   194.95    8.20   1.35   9.56   704.88
159   186.69    8.26   1.30   9.56   706.18
160   178.38    8.31   1.24   9.56   707.42
161   170.01    8.37   1.19   9.56   708.61
162   161.59    8.42   1.13   9.56   709.75
163   153.11    8.48   1.08   9.56   710.82
164   144.58    8.54   1.02   9.56   711.85
165   135.98    8.59   0.96   9.56   712.81
166   127.33    8.65   0.91   9.56   713.72
167   118.63    8.71   0.85   9.56   714.56
168   109.86    8.77   0.79   9.56   715.36
169   101.04    8.82   0.73   9.56   716.09
170    92.15    8.88   0.67   9.56   716.76
171    83.21    8.94   0.61   9.56   717.38
172    74.21    9.00   0.55   9.56   717.93
173    65.15    9.06   0.49   9.56   718.42
174    56.02    9.12   0.43   9.56   718.86
175    46.84    9.18   0.37   9.56   719.23
176    37.60    9.24   0.31   9.56   719.55
177    28.29    9.31   0.25   9.56   719.80
178    18.92    9.37   0.19   9.56   719.98
179     9.49    9.43   0.13   9.56   720.11
180    (0.00)   9.49   0.06   9.56   720.17

				
DOCUMENT INFO
Shared By:
Stats:
views:22
posted:12/4/2011
language:English
pages:8