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 .

Enter the present value in an Excel spreadsheet cell in place of "PV," which is your starting amount before compounding. Enter the interest rate in place of "R." ...

The discount rate is the interest rate used to calculate net present value (NPV). It represents the time value of money. NPV can help companies determine whether a proposed project may be profitable.

Calculating the future value of a present single sum with multiple interest rates This example shows how to use the ­FVSCHEDULE function in Excel to calculate the future value of a present single sum ...

In Excel, there is an NPV function that can be used to easily calculate the net present value of a series of cash flows. This is a common tool in financial modeling.

The Pmt box is the next assumption. Since we are working with one lump sum of salaries, rather than periodic payments, the Pmt box is left blank. Present value is the next assumption for this ...

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.

We calculate that the present value of the free cash flows is $326. Thus, if you were to sell this business based on its expected cash flows and a 10% discount rate, $326.00 would be a very fair ...

Imagine you plan to invest a fixed amount, say $1,000, every year for the next five years at a 5 percent interest rate. The time value of money comes into play here. The first $1,000 you invest ...

Present Value of Annuity Defined Before explaining how to find the present value of an annuity, we should first define the present value of an annuity. In simplest terms, this is the cash value of ...