Description Usage Arguments Value Examples
Creates an amortization schedule of a loan
1 |
r |
Rate |
n |
Number of Periods |
pv |
Present Value |
fv |
Future Value, set = 0 |
end |
If FALSE, payments are made at the beginning of the period |
Returns the Amortization Schedule in a dataframe
1 |
Period Payment Cum.Pmt Interest Cum.Int Principal Cum.Prin Rem.Bal
1 0 0.00 0.00 0.00 0.00 0.00 0.00 -5000.00
2 1 -55.51 -55.51 -25.00 -25.00 -30.51 -30.51 -4969.49
3 2 -55.51 -111.02 -24.85 -49.85 -30.66 -61.17 -4938.83
4 3 -55.51 -166.53 -24.69 -74.54 -30.82 -91.99 -4908.01
5 4 -55.51 -222.04 -24.54 -99.08 -30.97 -122.96 -4877.04
6 5 -55.51 -277.55 -24.39 -123.47 -31.13 -154.09 -4845.91
7 6 -55.51 -333.06 -24.23 -147.70 -31.28 -185.37 -4814.63
8 7 -55.51 -388.57 -24.07 -171.77 -31.44 -216.81 -4783.19
9 8 -55.51 -444.08 -23.92 -195.69 -31.59 -248.40 -4751.60
10 9 -55.51 -499.59 -23.76 -219.45 -31.75 -280.15 -4719.85
11 10 -55.51 -555.10 -23.60 -243.05 -31.91 -312.06 -4687.94
12 11 -55.51 -610.61 -23.44 -266.49 -32.07 -344.13 -4655.87
13 12 -55.51 -666.12 -23.28 -289.77 -32.23 -376.36 -4623.64
14 13 -55.51 -721.63 -23.12 -312.89 -32.39 -408.75 -4591.25
15 14 -55.51 -777.14 -22.96 -335.85 -32.55 -441.30 -4558.70
16 15 -55.51 -832.65 -22.79 -358.64 -32.72 -474.02 -4525.98
17 16 -55.51 -888.16 -22.63 -381.27 -32.88 -506.90 -4493.10
18 17 -55.51 -943.67 -22.47 -403.74 -33.04 -539.94 -4460.06
19 18 -55.51 -999.18 -22.30 -426.04 -33.21 -573.15 -4426.85
20 19 -55.51 -1054.69 -22.13 -448.17 -33.38 -606.53 -4393.47
21 20 -55.51 -1110.20 -21.97 -470.14 -33.54 -640.07 -4359.93
22 21 -55.51 -1165.71 -21.80 -491.94 -33.71 -673.78 -4326.22
23 22 -55.51 -1221.22 -21.63 -513.57 -33.88 -707.66 -4292.34
24 23 -55.51 -1276.73 -21.46 -535.03 -34.05 -741.71 -4258.29
25 24 -55.51 -1332.24 -21.29 -556.32 -34.22 -775.93 -4224.07
26 25 -55.51 -1387.75 -21.12 -577.44 -34.39 -810.32 -4189.68
27 26 -55.51 -1443.26 -20.95 -598.39 -34.56 -844.88 -4155.12
28 27 -55.51 -1498.77 -20.78 -619.17 -34.73 -879.61 -4120.39
29 28 -55.51 -1554.28 -20.60 -639.77 -34.91 -914.52 -4085.48
30 29 -55.51 -1609.79 -20.43 -660.20 -35.08 -949.60 -4050.40
31 30 -55.51 -1665.30 -20.25 -680.45 -35.26 -984.86 -4015.14
32 31 -55.51 -1720.81 -20.08 -700.53 -35.43 -1020.29 -3979.71
33 32 -55.51 -1776.32 -19.90 -720.43 -35.61 -1055.90 -3944.10
34 33 -55.51 -1831.83 -19.72 -740.15 -35.79 -1091.69 -3908.31
35 34 -55.51 -1887.34 -19.54 -759.69 -35.97 -1127.66 -3872.34
36 35 -55.51 -1942.85 -19.36 -779.05 -36.15 -1163.81 -3836.19
37 36 -55.51 -1998.36 -19.18 -798.23 -36.33 -1200.14 -3799.86
38 37 -55.51 -2053.87 -19.00 -817.23 -36.51 -1236.65 -3763.35
39 38 -55.51 -2109.38 -18.82 -836.05 -36.69 -1273.34 -3726.66
40 39 -55.51 -2164.89 -18.63 -854.68 -36.88 -1310.22 -3689.78
41 40 -55.51 -2220.40 -18.45 -873.13 -37.06 -1347.28 -3652.72
42 41 -55.51 -2275.91 -18.26 -891.39 -37.25 -1384.53 -3615.47
43 42 -55.51 -2331.42 -18.08 -909.47 -37.43 -1421.96 -3578.04
44 43 -55.51 -2386.93 -17.89 -927.36 -37.62 -1459.58 -3540.42
45 44 -55.51 -2442.44 -17.70 -945.06 -37.81 -1497.39 -3502.61
46 45 -55.51 -2497.95 -17.51 -962.57 -38.00 -1535.39 -3464.61
47 46 -55.51 -2553.46 -17.32 -979.89 -38.19 -1573.58 -3426.42
48 47 -55.51 -2608.97 -17.13 -997.02 -38.38 -1611.96 -3388.04
49 48 -55.51 -2664.48 -16.94 -1013.96 -38.57 -1650.53 -3349.47
50 49 -55.51 -2719.99 -16.75 -1030.71 -38.76 -1689.29 -3310.71
51 50 -55.51 -2775.50 -16.55 -1047.26 -38.96 -1728.25 -3271.75
52 51 -55.51 -2831.01 -16.36 -1063.62 -39.15 -1767.40 -3232.60
53 52 -55.51 -2886.52 -16.16 -1079.78 -39.35 -1806.75 -3193.25
54 53 -55.51 -2942.03 -15.97 -1095.75 -39.54 -1846.29 -3153.71
55 54 -55.51 -2997.54 -15.77 -1111.52 -39.74 -1886.03 -3113.97
56 55 -55.51 -3053.05 -15.57 -1127.09 -39.94 -1925.97 -3074.03
57 56 -55.51 -3108.56 -15.37 -1142.46 -40.14 -1966.11 -3033.89
58 57 -55.51 -3164.07 -15.17 -1157.63 -40.34 -2006.45 -2993.55
59 58 -55.51 -3219.58 -14.97 -1172.60 -40.54 -2046.99 -2953.01
60 59 -55.51 -3275.09 -14.76 -1187.36 -40.75 -2087.74 -2912.26
61 60 -55.51 -3330.60 -14.56 -1201.92 -40.95 -2128.69 -2871.31
62 61 -55.51 -3386.11 -14.36 -1216.28 -41.15 -2169.84 -2830.16
63 62 -55.51 -3441.62 -14.15 -1230.43 -41.36 -2211.20 -2788.80
64 63 -55.51 -3497.13 -13.94 -1244.37 -41.57 -2252.77 -2747.23
65 64 -55.51 -3552.64 -13.74 -1258.11 -41.77 -2294.54 -2705.46
66 65 -55.51 -3608.15 -13.53 -1271.64 -41.98 -2336.52 -2663.48
67 66 -55.51 -3663.66 -13.32 -1284.96 -42.19 -2378.71 -2621.29
68 67 -55.51 -3719.17 -13.11 -1298.07 -42.40 -2421.11 -2578.89
69 68 -55.51 -3774.68 -12.89 -1310.96 -42.62 -2463.73 -2536.27
70 69 -55.51 -3830.19 -12.68 -1323.64 -42.83 -2506.56 -2493.44
71 70 -55.51 -3885.70 -12.47 -1336.11 -43.04 -2549.60 -2450.40
72 71 -55.51 -3941.21 -12.25 -1348.36 -43.26 -2592.86 -2407.14
73 72 -55.51 -3996.72 -12.04 -1360.40 -43.47 -2636.33 -2363.67
74 73 -55.51 -4052.23 -11.82 -1372.22 -43.69 -2680.02 -2319.98
75 74 -55.51 -4107.74 -11.60 -1383.82 -43.91 -2723.93 -2276.07
76 75 -55.51 -4163.25 -11.38 -1395.20 -44.13 -2768.06 -2231.94
77 76 -55.51 -4218.76 -11.16 -1406.36 -44.35 -2812.41 -2187.59
78 77 -55.51 -4274.27 -10.94 -1417.30 -44.57 -2856.98 -2143.02
79 78 -55.51 -4329.78 -10.71 -1428.01 -44.80 -2901.78 -2098.22
80 79 -55.51 -4385.29 -10.49 -1438.50 -45.02 -2946.80 -2053.20
81 80 -55.51 -4440.80 -10.27 -1448.77 -45.24 -2992.04 -2007.96
82 81 -55.51 -4496.31 -10.04 -1458.81 -45.47 -3037.51 -1962.49
83 82 -55.51 -4551.82 -9.81 -1468.62 -45.70 -3083.21 -1916.79
84 83 -55.51 -4607.33 -9.58 -1478.20 -45.93 -3129.14 -1870.86
85 84 -55.51 -4662.84 -9.35 -1487.55 -46.16 -3175.30 -1824.70
86 85 -55.51 -4718.35 -9.12 -1496.67 -46.39 -3221.69 -1778.31
87 86 -55.51 -4773.86 -8.89 -1505.56 -46.62 -3268.31 -1731.69
88 87 -55.51 -4829.37 -8.66 -1514.22 -46.85 -3315.16 -1684.84
89 88 -55.51 -4884.88 -8.42 -1522.64 -47.09 -3362.25 -1637.75
90 89 -55.51 -4940.39 -8.19 -1530.83 -47.32 -3409.57 -1590.43
91 90 -55.51 -4995.90 -7.95 -1538.78 -47.56 -3457.13 -1542.87
92 91 -55.51 -5051.41 -7.71 -1546.49 -47.80 -3504.93 -1495.07
93 92 -55.51 -5106.92 -7.48 -1553.97 -48.03 -3552.96 -1447.04
94 93 -55.51 -5162.43 -7.24 -1561.21 -48.28 -3601.24 -1398.76
95 94 -55.51 -5217.94 -6.99 -1568.20 -48.52 -3649.76 -1350.24
96 95 -55.51 -5273.45 -6.75 -1574.95 -48.76 -3698.52 -1301.48
97 96 -55.51 -5328.96 -6.51 -1581.46 -49.00 -3747.52 -1252.48
98 97 -55.51 -5384.47 -6.26 -1587.72 -49.25 -3796.77 -1203.23
99 98 -55.51 -5439.98 -6.02 -1593.74 -49.49 -3846.26 -1153.74
100 99 -55.51 -5495.49 -5.77 -1599.51 -49.74 -3896.00 -1104.00
101 100 -55.51 -5551.00 -5.52 -1605.03 -49.99 -3945.99 -1054.01
102 101 -55.51 -5606.51 -5.27 -1610.30 -50.24 -3996.23 -1003.77
103 102 -55.51 -5662.02 -5.02 -1615.32 -50.49 -4046.72 -953.28
104 103 -55.51 -5717.53 -4.77 -1620.09 -50.74 -4097.46 -902.54
105 104 -55.51 -5773.04 -4.51 -1624.60 -51.00 -4148.46 -851.54
106 105 -55.51 -5828.55 -4.26 -1628.86 -51.25 -4199.71 -800.29
107 106 -55.51 -5884.06 -4.00 -1632.86 -51.51 -4251.22 -748.78
108 107 -55.51 -5939.57 -3.74 -1636.60 -51.77 -4302.99 -697.01
109 108 -55.51 -5995.08 -3.48 -1640.08 -52.03 -4355.02 -644.98
110 109 -55.51 -6050.59 -3.22 -1643.30 -52.29 -4407.31 -592.69
111 110 -55.51 -6106.10 -2.96 -1646.26 -52.55 -4459.86 -540.14
112 111 -55.51 -6161.61 -2.70 -1648.96 -52.81 -4512.67 -487.33
113 112 -55.51 -6217.12 -2.44 -1651.40 -53.07 -4565.74 -434.26
114 113 -55.51 -6272.63 -2.17 -1653.57 -53.34 -4619.08 -380.92
115 114 -55.51 -6328.14 -1.90 -1655.47 -53.61 -4672.69 -327.31
116 115 -55.51 -6383.65 -1.64 -1657.11 -53.87 -4726.56 -273.44
117 116 -55.51 -6439.16 -1.37 -1658.48 -54.14 -4780.70 -219.30
118 117 -55.51 -6494.67 -1.10 -1659.58 -54.41 -4835.11 -164.89
119 118 -55.51 -6550.18 -0.82 -1660.40 -54.69 -4889.80 -110.20
120 119 -55.51 -6605.69 -0.55 -1660.95 -54.96 -4944.76 -55.24
121 120 -55.51 -6661.20 -0.28 -1661.23 -55.23 -4999.99 -0.01
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.