Overview

The CAPM Excel template is a great tool to calculate the required rate of return for investing in a security or portfolio of securities when you have the risk-free return, risk premium, and beta of the portfolio/security. Capital Asset Pricing Model (CAPM) is a model used to price securities returns, it is a great tool to quantify the risk-return relationship of security. It essentially tries to price the systematic risk an investor has for carrying a stock, and quantify the required return for that stock. The CAPM formula is given as:

 

Expected Return on a security = Risk-free Rate + [ Beta x Equity Risk Premium]

Share
Reviews Add a review
No reviews yet

More From Corporate Finance Institute®

Browse our top rated business templates. See All
Financial Institution Dividend Discount Model
423
0
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
277
0
The loan payment calculator allows users to determine the principal and interest payment each month until the full balance of…
DDM - Excel Dividend Discount Model Template
339
28
The dividend discount model template allows investors to value a company base on future dividend payments. This is based on…
Non-directional trading strategy template Non-directional Trading Strategies Template
338
0
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
restructuring financial model template preview 1 Restructuring Financial Model Template
566
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…
TMT Financial Model Template Preview TMT Financial Model Template
743
0
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…