The present value equals the dividend divided by the discount factor, which in the first row will simply equal the current dividend. For the second row, calculate the year by adding 1 to the ...

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

Since an annuity’s present value depends on how much money you expect to receive in the future, you should keep the time value of money in mind when calculating the present value of your annuity.

Net present value (NPV) represents the difference between the present value of cash inflows and outflows over a set time period. Knowing how to calculate net present value can be useful when ...

Net present value (NPV) represents the difference between the present value of cash inflows and outflows over a set time period. Knowing how to calculate net present value can be useful when ...

The present value equals the dividend divided by the discount factor, which in the first row will simply equal the current dividend. For the second row, calculate the year by adding 1 to the ...