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.

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.

Find out the best practices for most financial modeling to price a bond, calculate coupon payments, and calculate a bond's yield to maturity in Microsoft Excel.

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

To calculate the return of a stock index between any two points in time, follow these steps: First, find the price level of the chosen index on the first and last trading days of the period you're ...

Microsoft Excel can perform statistical calculations across a wide set of data. Performing a T-Value Formula is simple so long as each column is set up correctly to accept the mean and standard ...

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

A stock's historical variance measures the difference between the stock's returns for different periods and its average return. A stock with a lower.

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.

Q. I have prepared projections for a proposed project, and I want to calculate the internal rate of return. Instead of using Excel’s IRR function, should I use simple math formulas so others can ...