Get help

Help center

Guides and answers

Contact support

Write to our team

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Finance

Turn manual finance work into reports that update themselves.

What Finance teams automate

  • Track payables and receivables
  • Build cash flow statements
  • Compare budget against actuals

Inventory and manufacturing

See stock levels and automate ordering.

What inventory and manufacturing teams automate

  • Track inventory across multiple sites
  • Connect sales, purchasing, and warehouse data
  • Link a barcode scanner to your sheet

HR

Run recruitment, attendance, and OKR tracking from your sheets.

What HR teams automate

  • Track recruitment and onboarding
  • Record team OKRs and results
  • Track check-ins, check-outs, and leave

Project management

Assign tasks and track hours without manual updates.

What project teams automate

  • Assign tasks and track status changes
  • Estimate effort and log hours worked
  • Track milestones across projects

Sales and CRM

Track leads and sales performance with automated reports.

What sales teams automate

  • Track and convert leads
  • Set sales goals and track team metrics
  • Monitor sales KPIs on dashboards

Education

Automate attendance, grades, and school purchasing.

What schools automate

  • Track attendance and notify parents
  • Record and compare class grades
  • Track inventory lent to students and staff

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Get started

Templates

Ready-made workflows to start from

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Help center

Guides and answers

Contact support

Write to our team

Workflows

Build processes with your team

Automations

Connect files and automate tasks

Cost of equity: formula & how to calculate it

The cost of equity is an important financial concept used in multiple calculations and for various purposes. Companies and investors use it to assess the viability of projects or investments. It represents the rate of return that a company pays equity investors and is one of the components in the calculation of the cost of capital, together with the cost of debt.

In this post, you will learn about the cost of equity, why it is important, and how it relates to the cost of debt and the cost of capital. You will also learn how to calculate the cost of equity using two different methods: the Capital Asset Pricing Model (CAPM) and the dividend capitalization model.

To learn more about the cost of debt and the cost of capital, check out the posts below.

What is the cost of equity?

Cost of equity refers to the return a company pays out to equity investors. The cost of equity allows the company to assess potential investments or projects. Potential investors use this figure as the minimum required return to ensure they are appropriately rewarded for the risk they undertake.

Cost of equity formula

You can calculate the cost of equity using two different models. The Capital Asset Pricing Model (CAPM) considers market-related risk and is usually used when calculating the Weighted Average Cost of Capital (WACC). The dividend capitalization model only applies to companies that pay out dividends and assumes constant dividend growth.

Let’s take a closer look at each of these methods.

Capital asset pricing model (CAPM)

The Capital Asset Pricing Model (CAPM) can be used on any stock, including companies that don’t pay dividends. This model is more complex than the dividend capitalization model, and it considers both the level of risk relative to the market and the stock’s volatility.

The CAPM cost of equity formula is the following:

cost of equity = risk-free rate of return + β * (market rate of return – risk-free rate of return)

  • risk-free rate of return: represents the expected return from a risk-free investment.
  • β (beta): represents volatility or systematic risk of the asset. The higher the value, the higher the volatility.
  • market rate of return: represents the average market return over a specified period of time (5-10 years).

Dividend capitalization model

The dividend capitalization model is more straightforward than CAPM but can only be applied to companies that pay dividends. It assumes that dividends grow at a constant rate and it doesn’t account for investment risk in the way that CAPM does.

To calculate the cost of equity using the dividend capitalization model, use the following formula.

cost of equity = (next year's dividends per share / current share price) + dividend growth rate

  • next year’s dividends per share: this information is usually available from the company’s financial reports or press releases, as dividends are announced well before distribution. However, if this information is not available directly, it can be estimated using historical data.
  • current share price: the price of shares is listed under the company name or ticker on the relevant exchange.
  • dividend growth rate: the growth rate for dividends can be calculated in different ways. The simplest way is to calculate growth for each year, then calculate the average. To calculate the growth rate, divide the dividends for year X by the dividends for the year X-1, then subtract one from the result.

Examples: How to calculate cost of equity?

Below are examples of how to calculate the cost of equity using the methods described in the previous section: the Capital Asset Pricing Model (CAPM) and the dividend capitalization model.

Cost of equity using CAPM

In this example, the market rate of return is 9% and the risk-free rate of return is 1%. These are sample figures, so use current rates for your own calculation. Company Z’s beta value (0.9) is slightly lower than the market (1), making it slightly less volatile than average. You can calculate the cost of equity using the formula described in the previous section.

cost of equity = 1% + 0.9 * (9% – 1%) = 8.2%

Cost of equity using dividend capitalization model

The current share price for Company A is $7, and they have announced dividends of $0.60 per share. Using historical data, analysts estimate a 2% dividend growth rate. You can use the formula from the previous section to calculate the cost of equity.

cost of equity = (0.60 / 7) + 2% = 8.6% + 2% = 10.6%

Why is the cost of equity important?

The cost of equity is an important concept in stock valuation, and the value of the cost of equity is often used as the return threshold. Both companies and equity investors can use this metric to assess whether the return on a specific investment is appropriate given the level of risk.

The cost of equity is one of the components in the calculation of the Weighted Average Cost of Capital (WACC), together with the cost of debt. Depending on the company’s capital structure, it will rely on different proportions of equity and debt. The WACC formula considers the weighted cost of equity and of debt to provide the average cost of capital.

What is the difference between cost of capital and cost of equity?

The cost of equity refers to the return that equity investors demand and is one of the components in the calculation of the cost of capital. The Weighted Average Cost of Capital (WACC) considers debt and equity financing, weighted according to the company’s capital structure.

What is the difference between cost of equity and cost of debt?

The cost of equity is usually higher than the cost of debt since investors take on more risk and are rewarded accordingly. However, while equity represents ownership, debt represents obligation, so debtholders are paid before equity investors. The cost of debt and the cost of equity are used to determine the cost of capital. The proportion of each varies by company, but it’s common for initial financing to be mostly in the form of debt.

Conclusion

The cost of equity is an important concept in stock valuation, and together with the cost of debt, it is used to calculate the Weighted Average Cost of Capital (WACC). While you have two methods available to calculate the cost of equity, the dividend capitalization model can only be applied to companies that pay out dividends.

You now know what the cost of equity is and why it is important for both the company and its equity investors. You also know how to calculate the cost of equity in two different ways: using the Capital Asset Pricing Model and using the dividend capitalization model. Finally, you have seen examples using both methods, so you’re ready to calculate the cost of equity to assess potential investments in other companies or projects within your own company.

To put the cost of equity to work, compare it with a project’s return using the IRR formula in Google Sheets, or the XIRR formula when cash flows come at irregular dates. You can also use it as the discount rate for equity cash flows in the NPV formula. If you invest yourself, a stock portfolio spreadsheet helps you check your returns against it. Sheetgo’s AI finance virtual employee can collect the figures behind these calculations from your spreadsheets and keep them up to date.

● Available 24/7

Put Owen on your finance ops

Sheetgo's finance virtual employee keeps your numbers current and your reporting on time. Your data stays in Google Sheets; you work with Owen in Slack, Teams, or Google Chat.

You may also like…

simple finance add on featured image

Build a stock portfolio spreadsheet, track your investments

Staying on top of your investments can be a real challenge, particularly if you manage them through many brokers. In this post we will...
finance

How to use Google Sheets for currency conversion

Staying up to date with the latest conversion rates can be a daunting task. But it doesn’t have to be. Read on to learn how to use Google...
finance processes and templates

8 steps to prepare a bank reconciliation statement

Bank reconciliation is a crucial financial process for businesses to ensure that records match bank statements. In this post, we'll...