Most analysts use Excel to calculate NPV. You can input the present value formula, apply it to each year's cash flows, and then add together each year's discounted cash flows, minus expenditures ...

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 .