This article provides example scenarios and explains various approaches for calculating the time value of money using Microsoft Excel. The Excel tools discussed herein include the FV, FVSCHEDULE, PV, ...

These values total to $19,250. Now let us assume a discount rate of 15 percent. Using a Microsoft Excel spreadsheet, we could calculate the PV as follows, assuming that the current year is 2007.

When teaching financial accounting, faculty often discuss bonds payable and how to calculate the issue price of a bond. Consider teaching students to calculate the issue price by using the net present ...