• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Valuation

          • Discounted Cash Flow
          • Dividend Discount Model
          • Terminal Value
        • Valuation
        • Investment Banking Guides

          • Investment Banking
          • What is LBO?
          • What is Pitch Book?
        • Investment Banking Guides
        • Equity Research Guides

          • Equity Research
          • Equity Research Skills
          • Equity Research Q&A
        • Equity-Research-Guides
        • Mergers and Acquisitions

          • What is M&A?
          • Hostile Takeover
          • Golden Parachute
        • Mergers-and-Acquisitions
        • Financial Modeling

          • What is Financial Modeling
          • Financial Modeling Excel
          • Financial Model Types
        • Financial-Modeling
        • Others

          • Resources (A to Z)
          • Accounting
          • Financial Statement Analysis
          • Corporate Finance
          • Private Equity
          • Excel
  • Free Courses
  • All Courses
        • Certification Courses

          Certificate
        • All in One Financial Analyst Bundle

          Financial-Analyst-Bundle
        • Valuation Course

          Business-Valuation-Course
        • Financial Modeling Course

          Financial-Modeling-Course
        • Others

          • Equity Research Course
          • M&A Course
          • Investment Banking Course


          • Private Equity Course
          • Venture Capital Course
          • View All
  • 250+ Courses All in One Bundle
  • Login

Capital Asset Pricing Model Formula

Home » Valuation » Discounted Cash Flow » Capital Asset Pricing Model Formula

By Roshan Waingankar Leave a Comment

Capital Asset Pricing Model FormulaCapital Asset Pricing Model Formula (Table of Contents)

  • Capital Asset Pricing Model Formula
  • CAPM Calculator
  • Capital Asset Pricing Model Template

Capital Asset Pricing Model Formula: What is the Formula?

If you want to know the rate of return of a risky asset or a stock, you can use the capital asset pricing model formula (CAPM) to calculate that.

Here’s the formula for capital asset pricing model –

Capital Asset Pricing Model Formula

Here,

  • Ra = required rate of return of the asset;
  • Rrf = the rate of return of risk-free security;
  • Rm = the broad market’s expected rate of return;
  • Ba = beta of the particular asset.

Recommended Courses

  • Online Certification Training in Financial Analyst
  • Certification Course in Investment Banking
  • Mergers and Acquisitions Modeling Training

Capital Asset Pricing Model Example

Let’s take a simple Capital Asset Pricing Model example to illustrate this.

Ramen wants to know the required rate of return of a stock he wants to invest in. He has gathered all the information –

  • The rate of return of risk-free security – 7%
  • The expected rate of return of the broad market – 12%
  • A beta of the particular stock – 0.80

By using the Capital Asset Pricing Model Formula, Ramen needs to find out the rate of return of that particular stock.

In this example, we have all the information.

All we need to do is to put the information into the Capital Asset Pricing Model formula.

The CAPM formula is as follows.

Formula to Calculate Capital Asset Pricing Model

  • Or, Ra = 0.07 + 0.8 (0.12 – 0.07)
  • Or, Ra = 0.07 + 0.8 * 0.05
  • Or, Ra = 0.07 + 0.04
  • Or, Ra = 0.11 = 11%.

So from the calculation, Ramen finds out that the required rate of return of that particular stock is 11%.

Since the CAPM formula helps one find out the fair value of a stock, you can also compare the market value and decide whether the particular investment is right for you or not.

Popular Course in this category
Cyber Monday Sale
Investment Banking Training (117 Courses, 25+ Projects) 117 Courses | 25+ Projects | 600+ Hours | Full Lifetime Access | Certificate of Completion
4.9 (831 ratings)
Course Price

View Course

Related Courses
Financial Modeling CourseEquity Research CourseM&A Course

 

Starbucks Capital Asset Pricing Model Example

Let us calculate the Cost of Equity using CAPM formula.

Cost of Equity CAPM formula Ke = Rf + (Rm-Rf) x Beta

#1 – RISK-FREE RATE

10-year treasury rate ca

n be a good representative of Risk-free rate.

Cost of Equity Risk Free Rate

source – bankrate.com

EQUITY RISK PREMIUM (RM – RF)

Starbucks listed in the US has an equity risk premium of 6.25%.

Equity Risk Premium - US

source – stern.nyu.edu

BETA

The beta of Starbucks has decreased over the past five years. We note that Beta of Starbucks is at 0.794x

Starbucks Beta Cost of Equity

source: ycharts

With this, we have all the necessary information to calculate CAPM cost of equity.

  • CAPM formula Ke = Rf + (Rm – Rf) x Beta
  • Ke = 2.42% + 5.69% x 0.794
  • Ke =6.93%

Explanation of Capital Asset Pricing Model Formula

To understand the formula, we need to look at each component of the formula.

  • Required rate of return of the asset or the stock: This is what we intend to find out. If we find any risky asset or stock, by using CAPM formula, we can calculate the required rate of return.
  • Rate of return of a risk free security: When you put your money into a fixed deposit, you know that your money is safe and secured. Here we are talking about similar risk free security and its rate of return in normal circumstances.
  • Expected rate of return of the broad market: When the investor invests into the broad market, they take a systematic risk inherent within. And as a reward they get a premium. We call it expected rate of return of the broad market.
  • Beta of the particular asset or stock: Beta represents the systematic risk of the broad market inherent within the asset.

Use of Capital Asset Pricing Model Formula

We use the CAPM formula for finding out the required rate of return of a particular asset or a particular stock. Along with that, if you are calculating WACC (Weighted Average Cost of Capital), you may need to use CAPM formula to find out the cost of capital of equity. On a side note, we calculate WACC to find out how much cost a firm needs to incur to borrow money from the shareholders and the creditors.

CAPM quantifies the relationship between risk and required return in a well-functioning market.

Cost of Equity CAPM

Here’s the Cost of Equity CAPM formula for your reference.

Cost of Equity = Risk-Free Rate of Return + Beta * (Market Rate of Return – Risk-free Rate of Return)

(Capital Asset Pricing Model) CAPM Calculator

You can use the following CAPM Calculator

Rrf  (%)
Ba
Rm  (%)
Ra Formula =
 

Ra Formula = Rrf + Ba (Rm - Rrf)
0 + 0 (0 - 0) = 0

CAPM Formula in Excel (with excel template)

Let us now do the same CAPM Formula in Excel. This is very simple. You just need to put the information into the CAPM formula.

You can easily find the required rate of return of that particular stock.

capital asset pricing model in excel

You can download this CAPM Formula in Excel template here – (Capital Asset Pricing Model Excel) CAPM Formula in Excel Template

Recommended Articles –

This has been a guide to Capital Asset Pricing Model Formula, Capital Asset Pricing Model example, and CAPM calculator along with CAPM Formula in excel templates. You may also have a look at these articles below to learn more about Valuation Analysis –

  • Risk-Free Rate of Return Formula
  • Marginal Cost of Capital | Examples
  • Equity Risk Premium
  • Cost of Equity Formula – Methods
  • Risk-Adjusted Returns
  • Mistakes in DCF
  • Enterprise Value Formula
  • Dividend Discount Model – Complete Beginner’s Guide

Capital Asset Pricing Model (CAPM) Video

1 Shares
Share
Tweet
Share

Filed Under: Discounted Cash Flow, Valuation

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

Free Valuation Course

Learn Discounted Cash Flow Valuation, Comparable Comps, Download Valuation Templates

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Valuation Course

Learn Discounted Cash Flow Valuation, Comparable Comps, Download Valuation Templates

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

CYBER WEEK OFFER - Investment Banking Training (117 Courses, 25+ Projects) View More