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 .

You can estimate the expected value of your current venture, compare it to other opportunities and make a sensible decision on what is more beneficial for you.

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

One simple but powerful method investors can use to assess the risk and reward of a stock portfolio is using the Capital Asset Pricing Model, or CAPM, model for expected returns.