# Loan Interest Calculator in Excel

Document Sample

```					                                                                    160,000
Cumulative Interest
140,000
Principal Paid
Loan Amount (pv)                 ##########                  120,000

Interest Rate (rate)               ##########
100,000

Total # of Periods (Nper)
80,000
##########
60,000

40,000
Payment per Period                 \$ 1 ,3 4 8 .2 4              20,000
Total Interest Paid                #########                       0
0          50               100        150         200

Paymen
t                            Cumulativ                             Principal
Period   Amount        Interest            e Interest          Principal             Paid                Balance
\$     150,000.00
1     1,348.24           875.00             875.00            473.24                 473.24         149,526.76
2     1,348.24           872.24           1,747.24            476.00                 949.25         149,050.75
3     1,348.24           869.46           2,616.70            478.78               1,428.03         148,571.97
4     1,348.24           866.67           3,483.37            481.57               1,909.60         148,090.40
5     1,348.24           863.86           4,347.23            484.38               2,393.98         147,606.02
6     1,348.24           861.04           5,208.27            487.21               2,881.19         147,118.81
7     1,348.24           858.19           6,066.46            490.05               3,371.24         146,628.76
8     1,348.24           855.33           6,921.80            492.91               3,864.14         146,135.86
9     1,348.24           852.46           7,774.25            495.78               4,359.93         145,640.07
10     1,348.24           849.57           8,623.82            498.68               4,858.60         145,141.40
11     1,348.24           846.66           9,470.48            501.58               5,360.19         144,639.81
12     1,348.24           843.73          10,314.21            504.51               5,864.70         144,135.30
13     1,348.24           840.79          11,155.00            507.45               6,372.15         143,627.85
14     1,348.24           837.83          11,992.83            510.41               6,882.56         143,117.44
15     1,348.24           834.85          12,827.68            513.39               7,395.95         142,604.05
16     1,348.24           831.86          13,659.54            516.39               7,912.34         142,087.66
17     1,348.24           828.84          14,488.38            519.40               8,431.74         141,568.26
18     1,348.24           825.81          15,314.20            522.43               8,954.16         141,045.84
19     1,348.24           822.77          16,136.97            525.48               9,479.64         140,520.36
20     1,348.24           819.70          16,956.67            528.54           10,008.18            139,991.82
21     1,348.24           816.62          17,773.29            531.62           10,539.80            139,460.20
22     1,348.24           813.52          18,586.80            534.72           11,074.53            138,925.47
23     1,348.24           810.40          19,397.20            537.84           11,612.37            138,387.63
24     1,348.24           807.26          20,204.46            540.98           12,153.35            137,846.65
25     1,348.24           804.11          21,008.57            544.14           12,697.49            137,302.51
26     1,348.24           800.93          21,809.50            547.31           13,244.80            136,755.20
27     1,348.24           797.74          22,607.24            550.50           13,795.30            136,204.70
28     1,348.24           794.53          23,401.77            553.72           14,349.02            135,650.98
29     1,348.24           791.30          24,193.06            556.95           14,905.97            135,094.03
30     1,348.24           788.05          24,981.11            560.19           15,466.16            134,533.84
31     1,348.24           784.78          25,765.89            563.46           16,029.62            133,970.38
32     1,348.24           781.49          26,547.39            566.75           16,596.37            133,403.63
33     1,348.24           778.19          27,325.58            570.05           17,166.42            132,833.58
34     1,348.24           774.86          28,100.44            573.38           17,739.80            132,260.20
35     1,348.24           771.52          28,871.96            576.72           18,316.53            131,683.47
36     1,348.24           768.15          29,640.11            580.09           18,896.62            131,103.38
37     1,348.24           764.77          30,404.88            583.47           19,480.09            130,519.91
38     1,348.24           761.37          31,166.25            586.88           20,066.97            129,933.03
39     1,348.24           757.94          31,924.19            590.30           20,657.27            129,342.73
40     1,348.24           754.50          32,678.69            593.74           21,251.01            128,748.99
41     1,348.24           751.04          33,429.72            597.21           21,848.22            128,151.78
42     1,348.24           747.55          34,177.28            600.69           22,448.91            127,551.09
43     1,348.24           744.05          34,921.32            604.19           23,053.10            126,946.90
44     1,348.24           740.52          35,661.85            607.72           23,660.82            126,339.18
45     1,348.24           736.98          36,398.83            611.26           24,272.08            125,727.92
46     1,348.24           733.41          37,132.24            614.83           24,886.91            125,113.09
47     1,348.24           729.83          37,862.06            618.42           25,505.33            124,494.67
48     1,348.24           726.22          38,588.28            622.02           26,127.35            123,872.65
49     1,348.24           722.59          39,310.87            625.65           26,753.00            123,247.00
50     1,348.24           718.94          40,029.81            629.30           27,382.31            122,617.69
51     1,348.24           715.27          40,745.08            632.97           28,015.28            121,984.72
52     1,348.24           711.58          41,456.66            636.66           28,651.94            121,348.06
53     1,348.24           707.86          42,164.53            640.38           29,292.32            120,707.68
54     1,348.24           704.13          42,868.65            644.11           29,936.44            120,063.56
55     1,348.24           700.37          43,569.02            647.87           30,584.31            119,415.69
56     1,348.24           696.59          44,265.62            651.65           31,235.96            118,764.04
57     1,348.24           692.79          44,958.41            655.45           31,891.41            118,108.59
58     1,348.24           688.97          45,647.37            659.28           32,550.69            117,449.31
59     1,348.24           685.12          46,332.49            663.12           33,213.81            116,786.19
60     1,348.24           681.25          47,013.75            666.99           33,880.80            116,119.20
61     1,348.24           677.36          47,691.11            670.88           34,551.68            115,448.32
62     1,348.24           673.45          48,364.56            674.79           35,226.47            114,773.53
63     1,348.24           669.51          49,034.07            678.73           35,905.20            114,094.80
64     1,348.24           665.55          49,699.62            682.69           36,587.89            113,412.11
65     1,348.24           661.57          50,361.19            686.67           37,274.56            112,725.44
66     1,348.24           657.57          51,018.76            690.68           37,965.24            112,034.76
67     1,348.24           653.54          51,672.29            694.71           38,659.95            111,340.05
68     1,348.24           649.48          52,321.78            698.76           39,358.71            110,641.29
69     1,348.24           645.41          52,967.19            702.83           40,061.54            109,938.46
70     1,348.24           641.31          53,608.49            706.93           40,768.47            109,231.53
71     1,348.24           637.18          54,245.68            711.06           41,479.53            108,520.47
72     1,348.24           633.04          54,878.71            715.21           42,194.74            107,805.26
73     1,348.24           628.86          55,507.58            719.38           42,914.12            107,085.88
74     1,348.24           624.67          56,132.25            723.57           43,637.69            106,362.31
75     1,348.24           620.45          56,752.69            727.80           44,365.49            105,634.51
76     1,348.24           616.20          57,368.89            732.04           45,097.53            104,902.47
77     1,348.24           611.93          57,980.82            736.31           45,833.84            104,166.16
78     1,348.24           607.64          58,588.46            740.61           46,574.45            103,425.55
79     1,348.24           603.32          59,191.78            744.93           47,319.37            102,680.63
80     1,348.24           598.97          59,790.75            749.27           48,068.65            101,931.35
81     1,348.24           594.60          60,385.35            753.64           48,822.29            101,177.71
82     1,348.24           590.20          60,975.55            758.04           49,580.33            100,419.67
83     1,348.24           585.78          61,561.33            762.46           50,342.79             99,657.21
84     1,348.24           581.33          62,142.66            766.91           51,109.70             98,890.30
85     1,348.24           576.86          62,719.52            771.38           51,881.08             98,118.92
86     1,348.24           572.36          63,291.89            775.88           52,656.96             97,343.04
87     1,348.24           567.83          63,859.72            780.41           53,437.37             96,562.63
88     1,348.24           563.28          64,423.00            784.96           54,222.33             95,777.67
89     1,348.24           558.70          64,981.70            789.54           55,011.87             94,988.13
90     1,348.24           554.10          65,535.80            794.14           55,806.01             94,193.99
91     1,348.24           549.46          66,085.27            798.78           56,604.79             93,395.21
92     1,348.24           544.81          66,630.07            803.44           57,408.23             92,591.77
93     1,348.24           540.12          67,170.19            808.12           58,216.35             91,783.65
94     1,348.24           535.40          67,705.60            812.84           59,029.19             90,970.81
95     1,348.24           530.66          68,236.26            817.58           59,846.77             90,153.23
96     1,348.24           525.89          68,762.15            822.35           60,669.12             89,330.88
97     1,348.24           521.10          69,283.25            827.15           61,496.26             88,503.74
98     1,348.24           516.27          69,799.52            831.97           62,328.23             87,671.77
99     1,348.24           511.42          70,310.94            836.82           63,165.06             86,834.94
100    1,348.24           506.54          70,817.48            841.71           64,006.76             85,993.24
101    1,348.24           501.63          71,319.10            846.62           64,853.38             85,146.62
102    1,348.24           496.69          71,815.79            851.55           65,704.93             84,295.07
103    1,348.24           491.72          72,307.51            856.52           66,561.45             83,438.55
104    1,348.24           486.72          72,794.24            861.52           67,422.97             82,577.03
105    1,348.24           481.70          73,275.94            866.54           68,289.51             81,710.49
106    1,348.24           476.64          73,752.58            871.60           69,161.11             80,838.89
107    1,348.24           471.56          74,224.14            876.68           70,037.79             79,962.21
108    1,348.24           466.45          74,690.59            881.80           70,919.59             79,080.41
109    1,348.24           461.30          75,151.89            886.94           71,806.53             78,193.47
110    1,348.24           456.13          75,608.02            892.11           72,698.64             77,301.36
111    1,348.24           450.92          76,058.94            897.32           73,595.96             76,404.04
112    1,348.24           445.69          76,504.63            902.55           74,498.51             75,501.49
113    1,348.24           440.43          76,945.06            907.82           75,406.33             74,593.67
114    1,348.24           435.13          77,380.19            913.11           76,319.44             73,680.56
115    1,348.24           429.80          77,809.99            918.44           77,237.88             72,762.12
116    1,348.24           424.45          78,234.44            923.80           78,161.68             71,838.32
117    1,348.24           419.06          78,653.50            929.19           79,090.87             70,909.13
118    1,348.24           413.64          79,067.13            934.61           80,025.47             69,974.53
119    1,348.24           408.18          79,475.32            940.06           80,965.53             69,034.47
120    1,348.24           402.70          79,878.02            945.54           81,911.07             68,088.93
121    1,348.24           397.19          80,275.20            951.06           82,862.13             67,137.87
122    1,348.24           391.64          80,666.84            956.60           83,818.73             66,181.27
123    1,348.24           386.06          81,052.90            962.19           84,780.92             65,219.08
124    1,348.24           380.44          81,433.34            967.80           85,748.72             64,251.28
125    1,348.24           374.80          81,808.14            973.44           86,722.16             63,277.84
126    1,348.24           369.12          82,177.26            979.12           87,701.28             62,298.72
127    1,348.24           363.41          82,540.67            984.83           88,686.11             61,313.89
128    1,348.24           357.66          82,898.34            990.58           89,676.69             60,323.31
129    1,348.24           351.89          83,250.22            996.36           90,673.05             59,326.95
130    1,348.24           346.07          83,596.30           1,002.17          91,675.22             58,324.78
131    1,348.24           340.23          83,936.52           1,008.01          92,683.23             57,316.77
132    1,348.24           334.35          84,270.87           1,013.89          93,697.13             56,302.87
133    1,348.24           328.43          84,599.31           1,019.81          94,716.93             55,283.07
134    1,348.24           322.48          84,921.79           1,025.76          95,742.69             54,257.31
135    1,348.24           316.50          85,238.29           1,031.74          96,774.43             53,225.57
136    1,348.24           310.48          85,548.77           1,037.76          97,812.19             52,187.81
137    1,348.24           304.43          85,853.20           1,043.81          98,856.01             51,143.99
138    1,348.24           298.34          86,151.54           1,049.90          99,905.91             50,094.09
139    1,348.24           292.22          86,443.76           1,056.03         100,961.94             49,038.06
140    1,348.24           286.06          86,729.81           1,062.19         102,024.12             47,975.88
141    1,348.24           279.86          87,009.67           1,068.38         103,092.51             46,907.49
142    1,348.24           273.63          87,283.30           1,074.62         104,167.12             45,832.88
143    1,348.24           267.36          87,550.66           1,080.88         105,248.01             44,751.99
144    1,348.24           261.05          87,811.71           1,087.19         106,335.20             43,664.80
145    1,348.24           254.71          88,066.42           1,093.53         107,428.73             42,571.27
146    1,348.24           248.33          88,314.76           1,099.91         108,528.64             41,471.36
147    1,348.24           241.92          88,556.67           1,106.33         109,634.96             40,365.04
148    1,348.24           235.46          88,792.13           1,112.78         110,747.74             39,252.26
149    1,348.24           228.97          89,021.11           1,119.27         111,867.01             38,132.99
150    1,348.24           222.44          89,243.55           1,125.80         112,992.81             37,007.19
151    1,348.24           215.88          89,459.42           1,132.37         114,125.18             35,874.82
152    1,348.24           209.27          89,668.69           1,138.97         115,264.15             34,735.85
153    1,348.24           202.63          89,871.32           1,145.62         116,409.77             33,590.23
154    1,348.24           195.94          90,067.26           1,152.30         117,562.07             32,437.93
155    1,348.24           189.22          90,256.48           1,159.02         118,721.09             31,278.91
156    1,348.24           182.46          90,438.94           1,165.78         119,886.87             30,113.13
157    1,348.24           175.66          90,614.60           1,172.58         121,059.45             28,940.55
158    1,348.24           168.82          90,783.42           1,179.42         122,238.88             27,761.12
159    1,348.24           161.94          90,945.36           1,186.30         123,425.18             26,574.82
160    1,348.24           155.02          91,100.38           1,193.22         124,618.40             25,381.60
161    1,348.24           148.06          91,248.44           1,200.18         125,818.59             24,181.41
162    1,348.24           141.06          91,389.50           1,207.18         127,025.77             22,974.23
163    1,348.24           134.02          91,523.52           1,214.23         128,240.00             21,760.00
164    1,348.24           126.93          91,650.45           1,221.31         129,461.30             20,538.70
165    1,348.24           119.81          91,770.26           1,228.43         130,689.74             19,310.26
166    1,348.24           112.64          91,882.90           1,235.60         131,925.34             18,074.66
167    1,348.24           105.44          91,988.34           1,242.81         133,168.14             16,831.86
168    1,348.24             98.19         92,086.52           1,250.06         134,418.20             15,581.80
169    1,348.24             90.89         92,177.42           1,257.35         135,675.55             14,324.45
170    1,348.24             83.56         92,260.98           1,264.68         136,940.23             13,059.77
171    1,348.24             76.18         92,337.16           1,272.06         138,212.29             11,787.71
172    1,348.24             68.76         92,405.92           1,279.48         139,491.77             10,508.23
173    1,348.24             61.30         92,467.22           1,286.94         140,778.72              9,221.28
174    1,348.24             53.79         92,521.01           1,294.45         142,073.17              7,926.83
175    1,348.24             46.24         92,567.25           1,302.00         143,375.17              6,624.83
176    1,348.24             38.64         92,605.89           1,309.60         144,684.77              5,315.23
177    1,348.24             31.01         92,636.90           1,317.24         146,002.01              3,997.99
178    1,348.24             23.32         92,660.22           1,324.92         147,326.93              2,673.07
179    1,348.24             15.59         92,675.81           1,332.65         148,659.58              1,340.42
180    1,348.24              7.82         92,683.63           1,340.42         150,000.00                  0.00
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -
-                     -              -                 -                     -                      -

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 20 posted: 1/21/2012 language: Latin pages: 1
Description: Loan Interest Calculator in Excel document sample
How are you planning on using Docstoc?