Capital Asset Pricing Model (CAPM) Excel Template

The Capital Asset Pricing Model (CAPM) provides a way to calculate the expected return of an investment based on the time value of money and the systematic risk of the asset. Put simply, CAPM estimates the price of a high-risk stock by linking the relationship between the risk of the stock and the expected return.

Click here to download the template

CAPM is very commonly used in finance to price risky securities and calculating an expected return on those assets when considering the risk and cost of capital.

For more detailed information about the Capital Asset Pricing Model, including formulas and calculators, you can read our CAPM lesson here.

Link To or Reference This Page

If you found this content useful in your research, please do us a great favor and use the tool below to make sure you properly reference us wherever you use it. We really appreciate your support!

  • "Capital Asset Pricing Model (CAPM) Excel Template". StudyFinance.com. Accessed on September 24, 2021. https://studyfinance.com/capm-excel-template/.

  • "Capital Asset Pricing Model (CAPM) Excel Template". StudyFinance.com, https://studyfinance.com/capm-excel-template/. Accessed 24 September, 2021

  • Capital Asset Pricing Model (CAPM) Excel Template. StudyFinance.com. Retrieved from https://studyfinance.com/capm-excel-template/.