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

Thanks -- and Fool on! The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

B2 focuses on the present value, while the data in B7 contains what amounts to the future value. 3] Choose the cell where you want to calculate the CAGR data.

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

When planning for retirement, you need to account for the value of any annuities that you own. Trouble is, there’s not just one value of an annuity—there are two: present value and future ...

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.

Sum all present values to find the total value of projected cash flows, which in this example is $326.

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

How to delete rows with Find in Excel It might have occurred to you at this point, that this feature might provide a quick way to delete cell values and even records.

Now, let’s discuss how you can find the present value of an annuity. After all, calculating the present value lets you know how much your annuity is worth.