TVM - Time Value of Money
Time value of money calculations relate the following quantities:
- future value
- present value
- number of periods
- discount rate
tvm computes one of these values (other than discount rate) given the others.
The number of periods is split between two values, the number of years and the number of periods per year (the frequency).
pip3 install --user tvm
This installs tvm to ~/.local/bin; make sure this directory is on your path.
tvm [options] [fv|pv|pmt|years]
-f <val>, --fv <val> future value -p <val>, --pv <val> present value -P <val>, --pmt <val> payment per period -y <val>, --years <val> total number of years -n <val>, --freq <val> number of payments per year -r <val>, --rate <val> annual discount rate -i, --ignore ignore any previously specified values
If a value is not given it is recalled from the previous invocation. Specify --ignore to use the default values for all unspecified options, which are: pv=0, fv=0, pmt=0, years=30, freq=12.
When the program runs, it always prints the computed value first, and then prints the remaining values to make it easy for you to confirm that you used the right values.
Consider case where you have a interest bearing account that pays 5% per annum compounded monthly. If you start with $10,000, you can compute the amount you will have after 5 years with:
tvm --pv=10000 --rate=5 --freq=12 --years=5 fv
The amount in 5 years is referred to as the future value (fv). The current amount is the present value (pv). The frequency is the number of periods per year. The program responds with:
fv = $12,833.59 pv = $10,000.00 pmt = $0.00 r = 5% N = 60
N is the total number of periods and equals the product of the years and the number of periods per year.
You can specify values with SI scale factors, units, and commas. The units and commas are ignored. So you can do the same thing with either:
tvm --pv='$10,000' --rate=5% --freq=12 --years=5 fv
tvm --pv=10k --rate=5% --freq=12 --years=5 fv
The quotes are needed in the first case to prevent $ from being interpreted by the shell.
tvm remembers the values specified on the previous invocation and uses them if they are not specified. This allows you to rapidly run what-if experiments without having to re-specify values that do not change. So, once you have run the first command, you can now quickly determine how much you will have in 10 years using:
tvm -y 10 fv = $16,470.09 pv = $10,000.00 pmt = $0.00 r = 5% N = 120
Without changing anything else, you can determine what happens if you make an additional $100 contribution each month:
tvm --pmt 100 fv = $31,998.32 pv = $10,000.00 pmt = $100.00 r = 5% N = 120
You can also use tvm to explore loans. For example, you can compute the payment for a mortgage given the principal, interest rate, and length:
tvm --ignore --pv=-250k --rate=4.375 --years=30 pmt pmt = $1,248.21 pv = -$250,000.00 fv = $0.00 r = 4.38% N = 360
The --ignore option was added so that we start from scratch; any values that were previously specified are ignored.
You can now understand how paying a little extra affects how long it takes to pay off the loan using:
tvm --pmt=1.5k years years = 21.42 pv = -$250,000.00 pmt = $1,500.00 fv = $0.00 r = 4.38% N = 257.08
To compute the payments for a 5-year interest only balloon mortgage, use:
tvm -y 5 -f -250k pmt pmt = $911.46 pv = -$250,000.00 fv = -$250,000.00 r = 4.38% N = 60