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.

You can calculate this with the RATE function by filling its five fields — Nper (number of periods - 12), Pmt (periodic investment – 5000 with a minus sign), Pv (present value – 0), Fv ...

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .