Question: what is the excel formula for present value?
Answer: 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+.