The Gordon growth model, also known as the dividend discount model, is often applied in Microsoft Excel to determine the intrinsic value of a stock.

Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

Learn how to show formulas in cells instead of values or calculated results In Microsoft Excel. You can show or hide formulas in Excel cells.

Learn what Value at Risk is, what it indicates about a portfolio, its pros and cons, and how to calculate the VaR of a portfolio 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 .

Example Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My payroll calculator ...

In this guide, you’ll learn how to stop Excel from calculating blank cells as zeros by creating efficient, reusable solutions that differentiate between actual zeros and blank cells.