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.

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.

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.

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.

Learn how to approximate the effective convexity of bonds using Microsoft Excel with a modified and simpler version of the standard convexity formula.

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.

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 ...