Question: what is the pv 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. At the same time, you'll learn how to use the PV function in a formula.