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 .

Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.

Net present value (NPV) is used to estimate the profitability of projects or investments. You can calculate NPV in two ways using Microsoft Excel.

I think you misunderstand. I know how to do that. What I'm looking for is a way to calculate the absolute value on the fly.<BR><BR>When entering the range on the series values, I'm currently using ...