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.

The T-Value is a common statistical calculation with a very wide range of applications. In the business world, it can help in making educated financial predictions and projections. For example, a ...

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

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 .

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