Question: what is pv formula in excel?
Answer: Present value is the current value of an expected future stream of cash flow. ... The formula for present value is PV = FV ÷ (1+r)^n; where FV is the future value, r is the interest rate and n is the number of periods. Using information from the above example, PV = 10,000÷(1+.