adspace


What is pv function in excel?

Answer Posted / Manoj Kumar Prasad

The PV (Present Value) function in Excel calculates the present value of a series of cash flows. The syntax is PV(rate, nper, pmt, [fv], [type]) where 'rate' is the interest rate per payment period, 'nper' is the total number of payments, 'pmt' is the constant payment amount, 'fv' (optional) is the future value of the investment or loan, and 'type' (optional) determines when the cash flows are made.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is latest version of excel?

722


What is wrap text in excel?

721


Why can't I see the tabs on my excel spreadsheet?

724


Image result for how do I compare two columns in excel

668


How much is excel for ipad?

714


What is left formula in excel?

685