Docstoc

Mortgage

Document Sample
Mortgage Powered By Docstoc
					Loan Amount                 $400,000.00
Number of Payments                  360
Interest (APR)                    6.50%

Intermediate Values
effective interest         0.067152849
periodic interest          0.005430878

Payments                       $2,532.76
Payments (excel)             ($2,532.76)

Total Principle Paid by monthly payments                    $400,000.00            Total Interest without extra payments
Total Princible Paid by extra payments                            $0.00            Total interest with extra Payments
Total Princible Paid                                        $400,000.00
Total Interest Paid                                         $511,793.61            Interest Saved

Total Paid                                                  $911,793.61

                       Monthly             Interest       Principal       Extra
     End of Period     Payment             Payment        Payment         Payment Balance
           0                                                                         $400,000.00
           1                 $2,532.76        $2,172.35         $360.41              $399,639.59
           2                 $2,532.76        $2,170.39         $362.37              $399,277.23
           3                 $2,532.76        $2,168.43         $364.33              $398,912.89
           4                 $2,532.76        $2,166.45         $366.31              $398,546.58
           5                 $2,532.76        $2,164.46         $368.30              $398,178.28
           6                 $2,532.76        $2,162.46         $370.30              $397,807.97
           7                 $2,532.76        $2,160.45         $372.31              $397,435.66
           8                 $2,532.76        $2,158.42         $374.34              $397,061.33
           9                 $2,532.76        $2,156.39         $376.37              $396,684.96
          10                 $2,532.76        $2,154.35         $378.41              $396,306.55
          11                 $2,532.76        $2,152.29         $380.47              $395,926.08
          12                 $2,532.76        $2,150.23         $382.53              $395,543.54
          13                 $2,532.76        $2,148.15         $384.61              $395,158.93
          14                 $2,532.76        $2,146.06         $386.70              $394,772.23
          15                 $2,532.76        $2,143.96         $388.80              $394,383.43
          16                 $2,532.76        $2,141.85         $390.91              $393,992.52
          17                 $2,532.76        $2,139.73         $393.03              $393,599.49
          18                 $2,532.76        $2,137.59         $395.17              $393,204.32
          19                 $2,532.76        $2,135.44         $397.32              $392,807.00
          20                 $2,532.76        $2,133.29         $399.47              $392,407.53
          21                 $2,532.76        $2,131.12         $401.64              $392,005.89
          22                 $2,532.76        $2,128.94         $403.82              $391,602.06
          23                 $2,532.76        $2,126.74         $406.02              $391,196.05
          24                 $2,532.76        $2,124.54         $408.22              $390,787.83
          25                 $2,532.76        $2,122.32         $410.44              $390,377.39
26   $2,532.76   $2,120.09   $412.67   $389,964.72
27   $2,532.76   $2,117.85   $414.91   $389,549.81
28   $2,532.76   $2,115.60   $417.16   $389,132.65
29   $2,532.76   $2,113.33   $419.43   $388,713.22
30   $2,532.76   $2,111.05   $421.71   $388,291.51
31   $2,532.76   $2,108.76   $424.00   $387,867.52
32   $2,532.76   $2,106.46   $426.30   $387,441.22
33   $2,532.76   $2,104.15   $428.61   $387,012.61
34   $2,532.76   $2,101.82   $430.94   $386,581.66
35   $2,532.76   $2,099.48   $433.28   $386,148.38
36   $2,532.76   $2,097.12   $435.64   $385,712.75
37   $2,532.76   $2,094.76   $438.00   $385,274.75
38   $2,532.76   $2,092.38   $440.38   $384,834.37
39   $2,532.76   $2,089.99   $442.77   $384,391.59
40   $2,532.76   $2,087.58   $445.18   $383,946.42
41   $2,532.76   $2,085.17   $447.59   $383,498.82
42   $2,532.76   $2,082.74   $450.02   $383,048.80
43   $2,532.76   $2,080.29   $452.47   $382,596.33
44   $2,532.76   $2,077.83   $454.93   $382,141.41
45   $2,532.76   $2,075.36   $457.40   $381,684.01
46   $2,532.76   $2,072.88   $459.88   $381,224.13
47   $2,532.76   $2,070.38   $462.38   $380,761.75
48   $2,532.76   $2,067.87   $464.89   $380,296.86
49   $2,532.76   $2,065.35   $467.41   $379,829.45
50   $2,532.76   $2,062.81   $469.95   $379,359.49
51   $2,532.76   $2,060.26   $472.50   $378,886.99
52   $2,532.76   $2,057.69   $475.07   $378,411.92
53   $2,532.76   $2,055.11   $477.65   $377,934.27
54   $2,532.76   $2,052.52   $480.24   $377,454.02
55   $2,532.76   $2,049.91   $482.85   $376,971.17
56   $2,532.76   $2,047.28   $485.48   $376,485.70
57   $2,532.76   $2,044.65   $488.11   $375,997.58
58   $2,532.76   $2,042.00   $490.76   $375,506.82
59   $2,532.76   $2,039.33   $493.43   $375,013.39
60   $2,532.76   $2,036.65   $496.11   $374,517.28
61   $2,532.76   $2,033.96   $498.80   $374,018.48
62   $2,532.76   $2,031.25   $501.51   $373,516.97
63   $2,532.76   $2,028.53   $504.23   $373,012.74
64   $2,532.76   $2,025.79   $506.97   $372,505.76
65   $2,532.76   $2,023.03   $509.73   $371,996.04
66   $2,532.76   $2,020.27   $512.49   $371,483.54
67   $2,532.76   $2,017.48   $515.28   $370,968.26
68   $2,532.76   $2,014.68   $518.08   $370,450.19
69   $2,532.76   $2,011.87   $520.89   $369,929.30
70   $2,532.76   $2,009.04   $523.72   $369,405.58
71   $2,532.76   $2,006.20   $526.56   $368,879.01
72   $2,532.76   $2,003.34   $529.42   $368,349.59
 73   $2,532.76   $2,000.46   $532.30   $367,817.29
 74   $2,532.76   $1,997.57   $535.19   $367,282.10
 75   $2,532.76   $1,994.66   $538.10   $366,744.01
 76   $2,532.76   $1,991.74   $541.02   $366,202.99
 77   $2,532.76   $1,988.80   $543.96   $365,659.04
 78   $2,532.76   $1,985.85   $546.91   $365,112.12
 79   $2,532.76   $1,982.88   $549.88   $364,562.24
 80   $2,532.76   $1,979.89   $552.87   $364,009.38
 81   $2,532.76   $1,976.89   $555.87   $363,453.51
 82   $2,532.76   $1,973.87   $558.89   $362,894.62
 83   $2,532.76   $1,970.84   $561.92   $362,332.70
 84   $2,532.76   $1,967.78   $564.98   $361,767.72
 85   $2,532.76   $1,964.72   $568.04   $361,199.68
 86   $2,532.76   $1,961.63   $571.13   $360,628.55
 87   $2,532.76   $1,958.53   $574.23   $360,054.32
 88   $2,532.76   $1,955.41   $577.35   $359,476.97
 89   $2,532.76   $1,952.28   $580.48   $358,896.49
 90   $2,532.76   $1,949.12   $583.64   $358,312.85
 91   $2,532.76   $1,945.95   $586.81   $357,726.04
 92   $2,532.76   $1,942.77   $589.99   $357,136.05
 93   $2,532.76   $1,939.56   $593.20   $356,542.85
 94   $2,532.76   $1,936.34   $596.42   $355,946.43
 95   $2,532.76   $1,933.10   $599.66   $355,346.77
 96   $2,532.76   $1,929.85   $602.91   $354,743.86
 97   $2,532.76   $1,926.57   $606.19   $354,137.67
 98   $2,532.76   $1,923.28   $609.48   $353,528.19
 99   $2,532.76   $1,919.97   $612.79   $352,915.40
100   $2,532.76   $1,916.64   $616.12   $352,299.28
101   $2,532.76   $1,913.29   $619.47   $351,679.81
102   $2,532.76   $1,909.93   $622.83   $351,056.98
103   $2,532.76   $1,906.55   $626.21   $350,430.77
104   $2,532.76   $1,903.15   $629.61   $349,801.16
105   $2,532.76   $1,899.73   $633.03   $349,168.13
106   $2,532.76   $1,896.29   $636.47   $348,531.65
107   $2,532.76   $1,892.83   $639.93   $347,891.73
108   $2,532.76   $1,889.36   $643.40   $347,248.33
109   $2,532.76   $1,885.86   $646.90   $346,601.43
110   $2,532.76   $1,882.35   $650.41   $345,951.02
111   $2,532.76   $1,878.82   $653.94   $345,297.08
112   $2,532.76   $1,875.27   $657.49   $344,639.58
113   $2,532.76   $1,871.70   $661.06   $343,978.52
114   $2,532.76   $1,868.11   $664.65   $343,313.86
115   $2,532.76   $1,864.50   $668.26   $342,645.60
116   $2,532.76   $1,860.87   $671.89   $341,973.71
117   $2,532.76   $1,857.22   $675.54   $341,298.16
118   $2,532.76   $1,853.55   $679.21   $340,618.95
119   $2,532.76   $1,849.86   $682.90   $339,936.05
120   $2,532.76   $1,846.15   $686.61   $339,249.45
121   $2,532.76   $1,842.42   $690.34   $338,559.11
122   $2,532.76   $1,838.67   $694.09   $337,865.02
123   $2,532.76   $1,834.90   $697.86   $337,167.16
124   $2,532.76   $1,831.11   $701.65   $336,465.52
125   $2,532.76   $1,827.30   $705.46   $335,760.06
126   $2,532.76   $1,823.47   $709.29   $335,050.77
127   $2,532.76   $1,819.62   $713.14   $334,337.63
128   $2,532.76   $1,815.75   $717.01   $333,620.62
129   $2,532.76   $1,811.85   $720.91   $332,899.71
130   $2,532.76   $1,807.94   $724.82   $332,174.89
131   $2,532.76   $1,804.00   $728.76   $331,446.13
132   $2,532.76   $1,800.04   $732.72   $330,713.42
133   $2,532.76   $1,796.06   $736.70   $329,976.72
134   $2,532.76   $1,792.06   $740.70   $329,236.02
135   $2,532.76   $1,788.04   $744.72   $328,491.31
136   $2,532.76   $1,784.00   $748.76   $327,742.54
137   $2,532.76   $1,779.93   $752.83   $326,989.71
138   $2,532.76   $1,775.84   $756.92   $326,232.79
139   $2,532.76   $1,771.73   $761.03   $325,471.76
140   $2,532.76   $1,767.60   $765.16   $324,706.60
141   $2,532.76   $1,763.44   $769.32   $323,937.28
142   $2,532.76   $1,759.26   $773.50   $323,163.79
143   $2,532.76   $1,755.06   $777.70   $322,386.09
144   $2,532.76   $1,750.84   $781.92   $321,604.17
145   $2,532.76   $1,746.59   $786.17   $320,818.00
146   $2,532.76   $1,742.32   $790.44   $320,027.57
147   $2,532.76   $1,738.03   $794.73   $319,232.84
148   $2,532.76   $1,733.71   $799.05   $318,433.79
149   $2,532.76   $1,729.38   $803.38   $317,630.41
150   $2,532.76   $1,725.01   $807.75   $316,822.66
151   $2,532.76   $1,720.63   $812.13   $316,010.52
152   $2,532.76   $1,716.21   $816.55   $315,193.98
153   $2,532.76   $1,711.78   $820.98   $314,373.00
154   $2,532.76   $1,707.32   $825.44   $313,547.56
155   $2,532.76   $1,702.84   $829.92   $312,717.64
156   $2,532.76   $1,698.33   $834.43   $311,883.21
157   $2,532.76   $1,693.80   $838.96   $311,044.25
158   $2,532.76   $1,689.24   $843.52   $310,200.73
159   $2,532.76   $1,684.66   $848.10   $309,352.64
160   $2,532.76   $1,680.06   $852.70   $308,499.93
161   $2,532.76   $1,675.43   $857.33   $307,642.60
162   $2,532.76   $1,670.77   $861.99   $306,780.61
163   $2,532.76   $1,666.09   $866.67   $305,913.94
164   $2,532.76   $1,661.38   $871.38   $305,042.56
165   $2,532.76   $1,656.65   $876.11   $304,166.45
166   $2,532.76   $1,651.89   $880.87   $303,285.58
167   $2,532.76   $1,647.11    $885.65    $302,399.93
168   $2,532.76   $1,642.30    $890.46    $301,509.46
169   $2,532.76   $1,637.46    $895.30    $300,614.16
170   $2,532.76   $1,632.60    $900.16    $299,714.00
171   $2,532.76   $1,627.71    $905.05    $298,808.95
172   $2,532.76   $1,622.80    $909.96    $297,898.99
173   $2,532.76   $1,617.85    $914.91    $296,984.08
174   $2,532.76   $1,612.88    $919.88    $296,064.21
175   $2,532.76   $1,607.89    $924.87    $295,139.33
176   $2,532.76   $1,602.87    $929.89    $294,209.44
177   $2,532.76   $1,597.82    $934.94    $293,274.50
178   $2,532.76   $1,592.74    $940.02    $292,334.47
179   $2,532.76   $1,587.63    $945.13    $291,389.35
180   $2,532.76   $1,582.50    $950.26    $290,439.09
181   $2,532.76   $1,577.34    $955.42    $289,483.67
182   $2,532.76   $1,572.15    $960.61    $288,523.06
183   $2,532.76   $1,566.93    $965.83    $287,557.23
184   $2,532.76   $1,561.69    $971.07    $286,586.16
185   $2,532.76   $1,556.41    $976.35    $285,609.81
186   $2,532.76   $1,551.11    $981.65    $284,628.17
187   $2,532.76   $1,545.78    $986.98    $283,641.19
188   $2,532.76   $1,540.42    $992.34    $282,648.85
189   $2,532.76   $1,535.03    $997.73    $281,651.12
190   $2,532.76   $1,529.61   $1,003.15   $280,647.97
191   $2,532.76   $1,524.17   $1,008.60   $279,639.38
192   $2,532.76   $1,518.69   $1,014.07   $278,625.30
193   $2,532.76   $1,513.18   $1,019.58   $277,605.72
194   $2,532.76   $1,507.64   $1,025.12   $276,580.61
195   $2,532.76   $1,502.08   $1,030.68   $275,549.92
196   $2,532.76   $1,496.48   $1,036.28   $274,513.64
197   $2,532.76   $1,490.85   $1,041.91   $273,471.73
198   $2,532.76   $1,485.19   $1,047.57   $272,424.16
199   $2,532.76   $1,479.50   $1,053.26   $271,370.91
200   $2,532.76   $1,473.78   $1,058.98   $270,311.93
201   $2,532.76   $1,468.03   $1,064.73   $269,247.20
202   $2,532.76   $1,462.25   $1,070.51   $268,176.69
203   $2,532.76   $1,456.43   $1,076.33   $267,100.36
204   $2,532.76   $1,450.59   $1,082.17   $266,018.19
205   $2,532.76   $1,444.71   $1,088.05   $264,930.14
206   $2,532.76   $1,438.80   $1,093.96   $263,836.19
207   $2,532.76   $1,432.86   $1,099.90   $262,736.29
208   $2,532.76   $1,426.89   $1,105.87   $261,630.42
209   $2,532.76   $1,420.88   $1,111.88   $260,518.54
210   $2,532.76   $1,414.84   $1,117.92   $259,400.63
211   $2,532.76   $1,408.77   $1,123.99   $258,276.64
212   $2,532.76   $1,402.67   $1,130.09   $257,146.55
213   $2,532.76   $1,396.53   $1,136.23   $256,010.32
214   $2,532.76   $1,390.36   $1,142.40   $254,867.92
215   $2,532.76   $1,384.16   $1,148.60   $253,719.32
216   $2,532.76   $1,377.92   $1,154.84   $252,564.48
217   $2,532.76   $1,371.65   $1,161.11   $251,403.36
218   $2,532.76   $1,365.34   $1,167.42   $250,235.95
219   $2,532.76   $1,359.00   $1,173.76   $249,062.19
220   $2,532.76   $1,352.63   $1,180.13   $247,882.05
221   $2,532.76   $1,346.22   $1,186.54   $246,695.51
222   $2,532.76   $1,339.77   $1,192.99   $245,502.52
223   $2,532.76   $1,333.29   $1,199.47   $244,303.06
224   $2,532.76   $1,326.78   $1,205.98   $243,097.08
225   $2,532.76   $1,320.23   $1,212.53   $241,884.55
226   $2,532.76   $1,313.65   $1,219.11   $240,665.43
227   $2,532.76   $1,307.02   $1,225.74   $239,439.70
228   $2,532.76   $1,300.37   $1,232.39   $238,207.31
229   $2,532.76   $1,293.67   $1,239.09   $236,968.22
230   $2,532.76   $1,286.95   $1,245.81   $235,722.41
231   $2,532.76   $1,280.18   $1,252.58   $234,469.83
232   $2,532.76   $1,273.38   $1,259.38   $233,210.44
233   $2,532.76   $1,266.54   $1,266.22   $231,944.22
234   $2,532.76   $1,259.66   $1,273.10   $230,671.12
235   $2,532.76   $1,252.75   $1,280.01   $229,391.11
236   $2,532.76   $1,245.80   $1,286.96   $228,104.14
237   $2,532.76   $1,238.81   $1,293.95   $226,810.19
238   $2,532.76   $1,231.78   $1,300.98   $225,509.21
239   $2,532.76   $1,224.71   $1,308.05   $224,201.16
240   $2,532.76   $1,217.61   $1,315.15   $222,886.01
241   $2,532.76   $1,210.47   $1,322.29   $221,563.72
242   $2,532.76   $1,203.29   $1,329.47   $220,234.24
243   $2,532.76   $1,196.07   $1,336.69   $218,897.55
244   $2,532.76   $1,188.81   $1,343.95   $217,553.59
245   $2,532.76   $1,181.51   $1,351.25   $216,202.34
246   $2,532.76   $1,174.17   $1,358.59   $214,843.75
247   $2,532.76   $1,166.79   $1,365.97   $213,477.78
248   $2,532.76   $1,159.37   $1,373.39   $212,104.39
249   $2,532.76   $1,151.91   $1,380.85   $210,723.55
250   $2,532.76   $1,144.41   $1,388.35   $209,335.20
251   $2,532.76   $1,136.87   $1,395.89   $207,939.31
252   $2,532.76   $1,129.29   $1,403.47   $206,535.85
253   $2,532.76   $1,121.67   $1,411.09   $205,124.76
254   $2,532.76   $1,114.01   $1,418.75   $203,706.01
255   $2,532.76   $1,106.30   $1,426.46   $202,279.55
256   $2,532.76   $1,098.56   $1,434.20   $200,845.34
257   $2,532.76   $1,090.77   $1,441.99   $199,403.35
258   $2,532.76   $1,082.94   $1,449.82   $197,953.53
259   $2,532.76   $1,075.06   $1,457.70   $196,495.83
260   $2,532.76   $1,067.14   $1,465.62   $195,030.21
261   $2,532.76   $1,059.19   $1,473.57   $193,556.64
262   $2,532.76   $1,051.18   $1,481.58   $192,075.06
263   $2,532.76   $1,043.14   $1,489.62   $190,585.44
264   $2,532.76   $1,035.05   $1,497.71   $189,087.72
265   $2,532.76   $1,026.91   $1,505.85   $187,581.87
266   $2,532.76   $1,018.73   $1,514.03   $186,067.85
267   $2,532.76   $1,010.51   $1,522.25   $184,545.60
268   $2,532.76   $1,002.24   $1,530.52   $183,015.09
269   $2,532.76    $993.93    $1,538.83   $181,476.26
270   $2,532.76    $985.58    $1,547.18   $179,929.07
271   $2,532.76    $977.17    $1,555.59   $178,373.49
272   $2,532.76    $968.72    $1,564.04   $176,809.45
273   $2,532.76    $960.23    $1,572.53   $175,236.92
274   $2,532.76    $951.69    $1,581.07   $173,655.85
275   $2,532.76    $943.10    $1,589.66   $172,066.20
276   $2,532.76    $934.47    $1,598.29   $170,467.91
277   $2,532.76    $925.79    $1,606.97   $168,860.94
278   $2,532.76    $917.06    $1,615.70   $167,245.24
279   $2,532.76    $908.29    $1,624.47   $165,620.77
280   $2,532.76    $899.47    $1,633.29   $163,987.47
281   $2,532.76    $890.60    $1,642.16   $162,345.31
282   $2,532.76    $881.68    $1,651.08   $160,694.23
283   $2,532.76    $872.71    $1,660.05   $159,034.18
284   $2,532.76    $863.70    $1,669.06   $157,365.11
285   $2,532.76    $854.63    $1,678.13   $155,686.99
286   $2,532.76    $845.52    $1,687.24   $153,999.74
287   $2,532.76    $836.35    $1,696.41   $152,303.34
288   $2,532.76    $827.14    $1,705.62   $150,597.72
289   $2,532.76    $817.88    $1,714.88   $148,882.83
290   $2,532.76    $808.56    $1,724.20   $147,158.64
291   $2,532.76    $799.20    $1,733.56   $145,425.08
292   $2,532.76    $789.79    $1,742.97   $143,682.11
293   $2,532.76    $780.32    $1,752.44   $141,929.67
294   $2,532.76    $770.80    $1,761.96   $140,167.71
295   $2,532.76    $761.23    $1,771.53   $138,396.18
296   $2,532.76    $751.61    $1,781.15   $136,615.04
297   $2,532.76    $741.94    $1,790.82   $134,824.21
298   $2,532.76    $732.21    $1,800.55   $133,023.67
299   $2,532.76    $722.44    $1,810.32   $131,213.34
300   $2,532.76    $712.60    $1,820.16   $129,393.19
301   $2,532.76    $702.72    $1,830.04   $127,563.15
302   $2,532.76    $692.78    $1,839.98   $125,723.17
303   $2,532.76    $682.79    $1,849.97   $123,873.19
304   $2,532.76    $672.74    $1,860.02   $122,013.17
305   $2,532.76    $662.64    $1,870.12   $120,143.05
306   $2,532.76    $652.48    $1,880.28   $118,262.77
307   $2,532.76    $642.27    $1,890.49   $116,372.29
308   $2,532.76   $632.00   $1,900.76   $114,471.53
309   $2,532.76   $621.68   $1,911.08   $112,560.45
310   $2,532.76   $611.30   $1,921.46   $110,638.99
311   $2,532.76   $600.87   $1,931.89   $108,707.10
312   $2,532.76   $590.38   $1,942.38   $106,764.71
313   $2,532.76   $579.83   $1,952.93   $104,811.78
314   $2,532.76   $569.22   $1,963.54   $102,848.24
315   $2,532.76   $558.56   $1,974.20   $100,874.04
316   $2,532.76   $547.83   $1,984.93    $98,889.11
317   $2,532.76   $537.05   $1,995.71    $96,893.41
318   $2,532.76   $526.22   $2,006.54    $94,886.86
319   $2,532.76   $515.32   $2,017.44    $92,869.42
320   $2,532.76   $504.36   $2,028.40    $90,841.02
321   $2,532.76   $493.35   $2,039.41    $88,801.61
322   $2,532.76   $482.27   $2,050.49    $86,751.12
323   $2,532.76   $471.13   $2,061.63    $84,689.50
324   $2,532.76   $459.94   $2,072.82    $82,616.67
325   $2,532.76   $448.68   $2,084.08    $80,532.60
326   $2,532.76   $437.36   $2,095.40    $78,437.20
327   $2,532.76   $425.98   $2,106.78    $76,330.42
328   $2,532.76   $414.54   $2,118.22    $74,212.20
329   $2,532.76   $403.04   $2,129.72    $72,082.48
330   $2,532.76   $391.47   $2,141.29    $69,941.19
331   $2,532.76   $379.84   $2,152.92    $67,788.27
332   $2,532.76   $368.15   $2,164.61    $65,623.66
333   $2,532.76   $356.39   $2,176.37    $63,447.30
334   $2,532.76   $344.57   $2,188.19    $61,259.11
335   $2,532.76   $332.69   $2,200.07    $59,059.04
336   $2,532.76   $320.74   $2,212.02    $56,847.02
337   $2,532.76   $308.73   $2,224.03    $54,622.99
338   $2,532.76   $296.65   $2,236.11    $52,386.88
339   $2,532.76   $284.51   $2,248.25    $50,138.63
340   $2,532.76   $272.30   $2,260.46    $47,878.17
341   $2,532.76   $260.02   $2,272.74    $45,605.43
342   $2,532.76   $247.68   $2,285.08    $43,320.35
343   $2,532.76   $235.27   $2,297.49    $41,022.85
344   $2,532.76   $222.79   $2,309.97    $38,712.88
345   $2,532.76   $210.24   $2,322.52    $36,390.37
346   $2,532.76   $197.63   $2,335.13    $34,055.24
347   $2,532.76   $184.95   $2,347.81    $31,707.43
348   $2,532.76   $172.20   $2,360.56    $29,346.87
349   $2,532.76   $159.38   $2,373.38    $26,973.49
350   $2,532.76   $146.49   $2,386.27    $24,587.22
351   $2,532.76   $133.53   $2,399.23    $22,187.99
352   $2,532.76   $120.50   $2,412.26    $19,775.73
353   $2,532.76   $107.40   $2,425.36    $17,350.37
354   $2,532.76    $94.23   $2,438.53    $14,911.84
355     $2,532.76        $80.98     $2,451.78       $12,460.06
356     $2,532.76        $67.67     $2,465.09        $9,994.97
357     $2,532.76        $54.28     $2,478.48        $7,516.49
358     $2,532.76        $40.82     $2,491.94        $5,024.55
359     $2,532.76        $27.29     $2,505.47        $2,519.08
360     $2,532.76        $13.68     $2,519.08            $0.00
      $911,793.61   $511,793.61   $400,000.00   0
l Interest without extra payments   $511,793.61
l interest with extra Payments      $511,793.61

                                         $0.00




           Year




                      1




                      2
3




4




5




6
7




8




9
10




11




12




13
14




15




16




17
18




19




20




21
22




23




24




25
26




27




28




29
30
Intertactical

Period        Payout            Eff Annual Int Present Value
          0      $10,590,843.42              8%   $10,590,843.42
          1       $1,700,000.00              8%    $1,574,074.07
          2       $1,921,000.00              8%    $1,646,947.87
          3       $2,170,730.00              8%    $1,723,195.46
          4       $2,452,924.90              8%    $1,802,973.03
          5       $2,771,805.14              8%    $1,886,444.00

                  $21,607,303.46                        $19,224,477.86




TacLine

Period        Payout            Eff Annual Int Present Value
          0       $4,000,000.00              9%    $4,000,000.00
          1       $3,000,000.00              9%    $2,752,293.58
          2       $3,500,000.00              9%    $2,945,879.98
          3       $4,000,000.00              9%    $3,088,733.92
          4       $4,500,000.00              9%    $3,187,913.45
          5       $5,000,000.00              9%    $3,249,656.93

                  $24,000,000.00                        $19,224,477.86




                Even though the interest and total payout of the TacLine venture is higher than
                Intertactical, the net present value of the two is equivalent. Intertactical has a
                very high initial payout, almost half of the total payout, up front so less of
                intertactical's payout is effected by the interest rate.
Loan Amount                $12,500.00
Number of Payments                 60
Interest (APR)                  7.50%

Intermediate Values
effective interest        0.077875846
periodic interest         0.006268926


Payments (excel)             ($250.47)


                      Payment Number
                                    12           24           36          60
Interest Portion               (66.10)      (51.74)      (36.25)      (1.56)
Principle Portion             (184.50)     (198.87)     (214.36)    (249.05)
Cum Interest Paid             (867.56)   (1,568.49)   (2,089.80) (2,536.56)
Cum Principle Paid          (2,139.75)   (4,446.14)   (6,932.13) (12,500.00)

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:1
posted:10/25/2011
language:English
pages:21
xiaohuicaicai xiaohuicaicai
About