Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| a_f:f:af:pv [2022/09/02 02:52] – removed - external edit (Unknown date) 127.0.0.1 | a_f:f:af:pv [2023/05/09 01:17] (current) – sean | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | {{tag> | ||
| + | ====== PV ====== | ||
| + | ===== Description ====== | ||
| + | Calculates present value of an investment. The present value is the total amount that a series of future payments is worth now | ||
| + | ===== Parameters ====== | ||
| + | - Rate – interest rate per period (in percents, 50% is 0.5). | ||
| + | - Nper – total number of payment periods in an annuity | ||
| + | - Payment – payment made each period | ||
| + | - Future value (optional) – future value or the cash balance you want to attain after the last payment is made. If omitted assumed to be 0 | ||
| + | - Type (optional) – indicates when payments are due. 0 or omitted – at the end of the period; 1 – at the start of the period | ||
| + | ===== Example ====== | ||
| + | <code aim>PV (0.08, 12 * 20, 500, 0, 0) </ | ||