PV can be calculated in Excel with the formula =PV(rate, nper, pmt, [fv], [type]). If FV is omitted, PMT must be included, or vice versa, but both can also be included.

Present Value Formula and Calculation . This is how to calculate the present value of a future sum of money: Present Value = FV (1 + r) n where: ...