TimeValue
Solves a standard time-value-of-money problem: given a per-period rate, a number of periods, and any combination of payment, present value, and future value, it computes the one you ask for. It follows the same conventions as the PV, FV, and PMT functions in a spreadsheet: the rate is a decimal per period (use 0.06/12 thinking for monthly), and cash you pay out comes back negative while cash you receive comes back positive. The optional Type input is 0 for payments at the end of each period (the default) or 1 for the beginning.
Inputs
| Input | Accepts | Required |
|---|---|---|
Rate | Value (a single number) | Yes |
Nper | Value (a single number) | Yes |
Pmt | Value (a single number) | Yes |
PV | Value (a single number) | Optional |
FV | Value (a single number) | Optional |
Type | Value (a single number) | Optional |
Outputs
| Output | Produces |
|---|---|
Result | Value (a single number) |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
Mode | FV | One of FV (future value, the default), PV (present value), or PMT (periodic payment). The mode picks which value gets solved for from the other inputs. |
Example
You deposit $2,000 a month into an account earning 6% a year, compounded monthly, for 10 years. Set Mode to FV, Rate to 0.005 (6% ÷ 12), Nper to 120, and Pmt to -2000 (negative because the deposits leave your pocket). The result is about $327,760, the balance after the final deposit.
Tips
Rate and Nper must describe the same period length: a monthly payment needs a monthly rate and the period count in months. Wire a Slider into Rate to test how sensitive the answer is to the rate assumption.