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, ...

In order to use the model, you have to make several assumptions. First, you must choose a discount rate to apply to future dividend payments in order to reflect their present value accurately.

Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

If you have a recent pay stub, you can use Microsoft Excel to calculate your annual salary, as well as estimate how much a raise will affect your.