Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Learn How to Calculate Cost of Equity (CAPM) | Cash Flow Forecasting and Discount Rate Fundamentals
Mastering Discounted Cash Flow Analysis with Excel
course content

Course Content

Mastering Discounted Cash Flow Analysis with Excel

Mastering Discounted Cash Flow Analysis with Excel

1. Introduction to Business Valuation
2. Understanding Discounted Cash Flow (DCF) Analysis
3. Cash Flow Forecasting and Discount Rate Fundamentals
4. WACC, Terminal Value & Sensitivity Analysis
5. Building a DCF Valuation Model in Excel
6. Practical DCF Case Study – Company Valuation in Action

book
How to Calculate Cost of Equity (CAPM)

The cost of equity represents the return that shareholders expect for investing in a company. It's a cornerstone of valuation, especially when calculating the Weighted Average Cost of Capital (WACC).

One of the most commonly used tools to estimate this return is the Capital Asset Pricing Model (CAPM).

CostΒ ofΒ Equity=Rf+Ξ²Γ—(Rmβˆ’Rf)\text{Cost of Equity} = R_f + \beta \times (R_m - R_f)

Where:

  • RfR_f - risk-free rate (typically government bond yield);

  • Ξ²\beta - beta, a measure of the stock's volatility relative to the market;

  • RmR_m - expected market return;

  • (Rmβˆ’Rf)(R_m - R_f) - market risk premium.

This formula reflects that investors demand a return equal to:

  1. A safe baseline (risk-free rate);

  2. Plus compensation for risk (beta times market risk premium).

  • Risk-Free Rate: based on secure government bonds (e.g., 10-year U.S. Treasury);

  • Beta: indicates how volatile a stock is compared to the broader market;

    • Ξ²>1\beta > 1: more volatile;

    • Ξ²<1\beta < 1: less volatile.

  • Market Risk Premium: the extra return investors expect from the stock market over risk-free assets (usually estimated around 5–7%).

Real-World Example

If:

  • Risk-free rate = 3%;

  • Beta = 1.2;

  • Market return = 8%.

Then:

CostΒ ofΒ Equity=3%+1.2Γ—(8%βˆ’3%)=9%\text{Cost of Equity} = 3\% + 1.2 \times (8\% - 3\%) = 9\%

CAPM provides a structured way to estimate the return investors expect for taking equity risk. It's not perfectβ€”it assumes markets are efficientβ€”but it's the industry standard for a reason.

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 3. ChapterΒ 5

Ask AI

expand
ChatGPT

Ask anything or try one of the suggested questions to begin our chat

course content

Course Content

Mastering Discounted Cash Flow Analysis with Excel

Mastering Discounted Cash Flow Analysis with Excel

1. Introduction to Business Valuation
2. Understanding Discounted Cash Flow (DCF) Analysis
3. Cash Flow Forecasting and Discount Rate Fundamentals
4. WACC, Terminal Value & Sensitivity Analysis
5. Building a DCF Valuation Model in Excel
6. Practical DCF Case Study – Company Valuation in Action

book
How to Calculate Cost of Equity (CAPM)

The cost of equity represents the return that shareholders expect for investing in a company. It's a cornerstone of valuation, especially when calculating the Weighted Average Cost of Capital (WACC).

One of the most commonly used tools to estimate this return is the Capital Asset Pricing Model (CAPM).

CostΒ ofΒ Equity=Rf+Ξ²Γ—(Rmβˆ’Rf)\text{Cost of Equity} = R_f + \beta \times (R_m - R_f)

Where:

  • RfR_f - risk-free rate (typically government bond yield);

  • Ξ²\beta - beta, a measure of the stock's volatility relative to the market;

  • RmR_m - expected market return;

  • (Rmβˆ’Rf)(R_m - R_f) - market risk premium.

This formula reflects that investors demand a return equal to:

  1. A safe baseline (risk-free rate);

  2. Plus compensation for risk (beta times market risk premium).

  • Risk-Free Rate: based on secure government bonds (e.g., 10-year U.S. Treasury);

  • Beta: indicates how volatile a stock is compared to the broader market;

    • Ξ²>1\beta > 1: more volatile;

    • Ξ²<1\beta < 1: less volatile.

  • Market Risk Premium: the extra return investors expect from the stock market over risk-free assets (usually estimated around 5–7%).

Real-World Example

If:

  • Risk-free rate = 3%;

  • Beta = 1.2;

  • Market return = 8%.

Then:

CostΒ ofΒ Equity=3%+1.2Γ—(8%βˆ’3%)=9%\text{Cost of Equity} = 3\% + 1.2 \times (8\% - 3\%) = 9\%

CAPM provides a structured way to estimate the return investors expect for taking equity risk. It's not perfectβ€”it assumes markets are efficientβ€”but it's the industry standard for a reason.

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 3. ChapterΒ 5
We're sorry to hear that something went wrong. What happened?
some-alt