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.

One way to use Excel to show how the dividend discount model works is to set up a timeline that reflects the value of each year's dividends, going however far into the future you choose.

Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.

Percentage Formula: Know How to Calculate Percentage in Excel along with Solved questions and examples and Download formula PDF list.