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.

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

The future value function capability in Microsoft Excel helps business owners easily assemble data for projects such as budgeting and company or asset valuation exercises. The Excel formula is ...

The present value of an annuity is the current value of future payments from that annuity, given a specified rate of return or discount rate.

The interest rate can also be a discount rate, such as the current rate of inflation; in this case, the annuity formula discounts a series of future payments to calculate their present value.