Question: what is pv function in excel?
Answer: PV, one of the financial functions, calculates the present value of a loan or an investment, based on a constant interest rate. ... Use the Excel Formula Coach to find the present value (loan amount) you can afford, based on a set monthly payment.