schedule: Amortization Schedule

Description Usage Arguments Value Examples

View source: R/capitalR.R

Description

Creates an amortization schedule of a loan

Usage

1
schedule(r, n, pv, fv = 0, end = TRUE)

Arguments

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

Value

Returns the Amortization Schedule in a dataframe

Examples

1
schedule(r = 0.06/12, n = 10 * 12, pv = -5000, fv = 0, end = TRUE)

Example output

    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

capitalR documentation built on Dec. 1, 2019, 1:23 a.m.