Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.

Find out how to use Microsoft Excel to calculate the present value of a fixed annuity, including a calculation example. The calculation doesn't account for taxes.

Present value is the next assumption for this analysis. The Pv box should be populated with the lump-sum salaries you are analyzing.