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

Microsoft Excel has dozens of preset formulas for many types of mathematical calculations, but compounding interest isn't one of them. To calculate the future value of a single amount compounded ...

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.

You can calculate the T-Value in Excel with the mean, standard deviation and degrees of freedom. Since the T-Value is a comparison between sample mean and population mean, both values need to be ...

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

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

Learn what Value at Risk is, what it indicates about a portfolio, its pros and cons, and how to calculate the VaR of a portfolio using Microsoft Excel.

Calculate the present value of each year's cash flow by dividing by (1 + discount rate)^number of years. Sum all present values to find the total value of projected cash flows, which in this ...

Here's how to calculate the present value of a perpetual annuity that promises to pay flat or growing annual payments with helpful examples.

To calculate the present value of any cash flow, you need the formula below: Present value = Expected Cash Flow ÷ (1+Discount Rate)^Number of periods Thus, for year one, the math would look like ...