How to calculate average stock returns in Excel In the following example, I'll calculate the returns for Microsoft stock using historical prices and dividends. The first step is to get organized.

Learning to predict stock prices using Excel is a rewarding skill. It offers a hands-on way to explore data analysis without complex tools or programming knowledge.

The purpose of the two-stock regression analysis is to determine the relationship between returns of two stocks. With some pairs of stocks, the two stock prices will tend to move in tandem.

Many active investors model stock price movements in order to better understand how they might move. Here's how to do it, step by step.

Learn how to calculate the cost of equity in Microsoft Excel using the capital asset pricing model, or CAPM, including brief definitions of each component.

"Abnormal returns" is an important concept in academic finance, as well as in the investment management industry.Let's go over how to calculate an abnormal return for a stock using stock prices ...

You can use Stock Quote in Excel to get the real-time prices of stocks. The Stocks data type is connected to an online source that contains more info.

How to Use Excel to Calculate a Bond's Yield to Call. Bonds are investment vehicles that make regular coupon payments until maturity, at which time the bond's face value is paid.