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.

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.

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.

The following article will show you, step-by-step, how to calculate the historical variance of stock returns with a detailed example.

Reviewed by Thomas Brock Fact checked by Suzanne Kvilhaug CAPM: An Overview Many investors use the capital asset pricing model (CAPM) as a way to estimate the potential return of a stock or other ...

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.