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 capital: What it is and how to calculate it

Whether you are a business owner, an investor, or an analyst, many financial metrics can help you assess a company’s value and determine the viability of different projects. However, there is a particular metric that is popular with all stakeholders: cost of capital. The cost of capital is the minimum return that the company needs to generate to start generating profits.

By calculating the Weighted Average Cost of Capital (WACC), you’ll have a good idea of how much money new projects or investments need to make to cover the cost of funding. This makes the cost of capital a key metric for investors and owners alike, and the value of WACC is used for different purposes, like budgeting and Discounted Cash Flow Analysis.

In this post, you will learn about the cost of capital and why it’s an important concept to understand. You will also learn how to calculate WACC by first calculating the cost of debt and the cost of equity. Finally, you will learn how it relates to other financial metrics, such as the discount rate used in discounted cash flow analysis.

What is cost of capital?

The cost of capital refers to the minimum return a company must earn before it starts generating value. The business needs to generate enough income to cover the cost of the capital it uses to fund its operations, considering debt and equity.

The calculation of the Weighted Average Cost of Capital (WACC) accounts for the company’s capital structure. In other words, you need to specify what proportion of debt and equity are being used for financing. In some cases, the company or project may be funded purely by equity or purely by debt, but it’s common to use a combination of both.

Why is the cost of capital important?

The cost of capital is an important metric. For the company, it facilitates decisions related to budgeting and planning. It can also help you decide on the best mix of debt and equity to fund your operations. For investors, it provides a comparable metric to assess different investment opportunities.

As always, this type of decision is not made based on a single metric or analytical method, and it’s very important to consider the context. However, regardless of how much weight you place on the calculation of the cost of capital, you can be sure that potential investors and other external stakeholders will be very interested in this metric.

How to calculate cost of capital?

A company’s cost of capital is usually calculated using the Weighted Average Cost of Capital Formula (WACC), which considers both the cost of debt and equity capital. It’s common for companies to use both debt and equity for funding in varying proportions.

Let’s have a look at the formulas you can use to calculate the cost of debt, the cost of equity, and finally, the weighted average cost of capital (WACC).

Cost of debt

The cost of debt can be calculated in various ways, including before and after tax. To calculate WACC, you would usually use the after-tax cost of debt, as interest expenses are tax deductible, giving you a lower value for the cost of debt.

To calculate the after-tax cost of debt, use the following formula:

cost of debt = (interest expense / total debt) * (1 – tax rate)

To learn more about the cost of debt and how to calculate it, take a look at this post on How to Calculate Cost of Debt.

Cost of equity

If your company is partly or totally financed by equity, you’ll need to determine the cost associated with this, too. The cost of equity refers to the return that the company must pay out to equity investors. This is more difficult to pin down, however, as it relies on multiple factors, many of which are estimations.

The company’s estimates, cash flows, and historical information are evaluated and compared to those of similar companies. The Capital Asset Pricing Model (CAPM) is used to calculate the cost of equity, as it evaluates the risk relative to the current market. Use the formula below to calculate the cost of equity.

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

The value for β – stock’s beta – is specific to each company and represents the return risk. For publicly held companies, this value is calculated and published by investment services. To learn more about the cost of equity and how to calculate it, have a look at this post on Cost of equity: formula & how to calculate it.

Weighted average cost of capital (WACC)

Finally, you can calculate the value of WACC by using the formula below.

WACC = ((equity / (equity + debt)) * cost of equity) + ((debt / (equity + debt)) * pre-tax cost of debt * (1 – tax rate))

The formula considers the relative weight of debt and equity and applies the respective cost of each to get an average and weighted value of the cost of capital.

Use the pre-tax cost of debt here, because the formula applies the tax rate itself. If you already calculated the after-tax cost of debt with the formula above, leave out the (1 – tax rate) term so the tax saving is not counted twice.

How to calculate total capital

Total capital is the money a company uses to fund itself: its debt plus its equity. It is the denominator of the WACC weights, so you need it before you can weight the cost of debt and the cost of equity.

total capital = debt + equity

For debt, add up interest-bearing borrowings such as bank loans and bonds. Leave out operating liabilities like accounts payable. For equity, use the market value (share price times shares outstanding) when the company is listed. For a private company, use the book value of equity from the balance sheet.

Each weight is that source’s share of the total. The weight of equity is equity / total capital, and the weight of debt is debt / total capital. The two weights always add up to 100%.

Cost of capital formula: a worked example

Say a company is funded with $600,000 of equity and $400,000 of debt, pays $28,000 a year in interest, and has a 25% tax rate.

  • Total capital = $600,000 + $400,000 = $1,000,000. The weights are 60% equity and 40% debt.
  • Pre-tax cost of debt = $28,000 / $400,000 = 7%. After tax, it is 7% * (1 – 0.25) = 5.25%.
  • Cost of equity with CAPM, using a 4% risk-free rate, a beta of 1.2, and a 9% expected market return: 4% + 1.2 * (9% – 4%) = 10%.
  • WACC = (60% * 10%) + (40% * 5.25%) = 6% + 2.1% = 8.1%.

The company’s cost of capital is 8.1%. A project funded with this same mix of debt and equity needs to return more than 8.1% a year to add value.

What’s the difference between cost of capital and discount rate?

Though similar and often used interchangeably, the discount rate and WACC are different metrics. The confusion probably arises from the fact that the value of WACC is often used as the discount rate in discounted cash flow analysis.

WACC represents the average cost of financing debt and equity. On the other hand, the discount rate is the desired rate of return on investment. In other words, it’s common for investors to use WACC as the discount rate since it represents the minimum rate of return required by investors.

Conclusion

As you have seen, the cost of capital is a key financial metric. It provides you with valuable information to help you assess whether or not to embark on a project or make an investment. The cost of capital tells you how much money the project or investment needs to make to cover the cost of financing. In other words, how much money it must generate before it becomes profitable.

You now know what the cost of capital is and why it’s an important metric in the financial valuation of companies and projects. You also know how to calculate the Weighted Average Cost of Capital (WACC) by finding the cost of debt and the cost of equity. Finally, you know that although the WACC is often used as the discount rate in Discounted Cash Flow Analysis, they are not the same metric.

To learn more about related financial formulas and analyses, take a look at the posts below.

If you use WACC as a discount rate, see how to apply it with the NPV formula in Google Sheets, and compare a project’s return with the IRR formula in Google Sheets. The cash flows you discount usually start from operating cash flow. To keep the debt, equity, and interest figures behind these calculations current, Sheetgo’s AI finance virtual employee can pull them from your spreadsheets into one up-to-date file.

● 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...