CAPM Formula Template
This CAPM formula template will help you calculate the required rate of return for investing in a security given the risk-free return and risk premium.
This is what the CAPM template looks like:
![CAPM Formula Template Screenshot]()
Download the Free Template
Enter your name and email in the form below and download the free template now!
The Capital Asset Pricing Model (CAPM) describes the relationship between expected return and risk of investing in a security. It shows that the expected return on a security is equal to the risk-free return plus a risk premiumEquity Risk PremiumEquity risk premium is the difference between returns on equity/individual stock and the risk-free rate of return. It is the compensation to the investor for taking a higher level of risk and investing in equity rather than risk-free securities., which is based on the betaUnlevered Beta / Asset BetaUnlevered Beta (Asset Beta) is the volatility of returns for a business, without considering its financial leverage. It only takes into account its assets. It compares the risk of an unlevered company to the risk of the market. It is calculated by taking equity beta and dividing it by 1 plus tax adjusted debt to equity of that security.
The formula for calculating CAPM is as follow:
Expected return on a security = Risk-free rate + Beta of the security * (Expected return on market – Risk-free rate)
It is based on the premise that investors have assumptions of systematic riskSystematic RiskSystematic risk is that part of the total risk that is caused by factors beyond the control of a specific company or individual. Systematic risk is caused by factors that are external to the organization. All investments or securities are subject to systematic risk and therefore, it is a non-diversifiable risk. (also known as market risk or non-diversifiable risk) and need to be compensated for it in the form of a risk premiumMarket Risk PremiumThe market risk premium is the additional return an investor expects from holding a risky market portfolio instead of risk-free assets. – an amount of market return greater than the risk-free rate. By investing in a security, investors want a higher return for taking on additional risk.
More Free Templates
For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation, and Word document templates.
- Excel Modeling TemplatesExcel & Financial Model TemplatesDownload free financial model templates - CFI's spreadsheet library includes a 3 statement financial model template, DCF model, debt schedule, depreciation schedule, capital expenditures, interest, budgets, expenses, forecasting, charts, graphs, timetables, valuation, comparable company analysis, more Excel templates
- PowerPoint Presentation Templates
- Transaction Document TemplatesTemplatesFree business templates to use in your personal or professional life. Templates include Excel, Word, and PowerPoint. These can be used for transactions, legal, financial modeling, financial analysis, business planning and business analysis.
