The formula for a present value calculation using Excel is:
A) PV (rate, nper, pmt, pv).
B) PV (nper, pmt, fv).
C) PV (rate, pmt, pv, fv).
D) PV (rate, nper, pmt, fv).
E) PV (rate, nper, pmt).

Question

Quizplus · Accepted Answer

The correct formula for calculating present value in Excel is PV(rate, nper, pmt, fv), where "rate" is the interest rate per period, "nper" is the total number of payment periods, "pmt" is the payment made each period, and "fv" is the future value.

The Formula for a Present Value Calculation Using Excel Is