Capital Asset Pricing Model (CAPM) – Excel Template

Ivan Kitov
Ivan Kitov

The Capital Asset Pricing Model (CAPM) describes the relationship between the expected return and risk on any asset or portfolio. It is basically used to calculate the stock’s expected stock return. CAPM suggests that a stock’s expected return is equal to the risk-free rate, plus beta multiplied by the market risk premium.

Some other related topics you might be interested to explore are Risk-free Rate, Beta, and Market Risk Premium.

This is an open-access Excel template in XLSX format that will be useful for anyone who wants to work as a Banker, Investment Professional, Corporate Finance Practitioner, or Portfolio Manager.

You can now download the Excel template for free.

The Capital Asset Pricing Model is among the topics included in the Corporate Finance module of the CFA Level 1 Curriculum.

Top