Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

You can calculate Ratio in Excel by using the GCD function and the Substitute function. This article is a step-by-step guide to help you.

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.

The article How to Calculate the Average Return for the Share of Stock in Excel originally appeared on Fool.com. the_motley_fool has no position in any stocks mentioned.