tvm_present-value
Calculate the present value of a future lump sum or annuity stream using a discount rate and number of periods.
Instructions
Present value of a future lump sum and/or annuity stream.
Use when computing the present value of a future cash flow. Provide future value, discount rate, and number of periods. Returns: present value and discount factor.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rate | Yes | Discount rate per period | |
| payment | No | Periodic payment amount (annuity) | |
| periods | Yes | Number of periods | |
| future_value | No | Future lump sum to discount | |
| payment_timing | No | Payment at end or beginning of period | end |