Show pageOld revisionsBacklinksExport to PDFExport Page to HTML/PDFBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. {{tag>Index Function Function_List Financial}} ====== 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) </code> Last modified: 2023/05/09 01:17 Log In