What is pv function in excel?



What is pv function in excel?..

Answer / 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

More MS Excel Microsoft Interview Questions

How to go to bottom of excel spreadsheet?

1 Answers  


Can I download just excel?

1 Answers  


What is the isna function in excel?

1 Answers  


How do you search for exact words in excel?

1 Answers  


Where is average function in excel?

1 Answers  


How do you describe the correlation of a scatter plot?

1 Answers  


How do you autosum in excel 2010?

1 Answers  


What is the shortcut to insert cells in excel?

1 Answers  


How do I merge cells in excel and keep all data?

1 Answers  


What is an excel file called?

1 Answers  


What is the shortcut to hide entire row?

1 Answers  


How many rows are available in excel?

1 Answers  


Categories