Financial Terms / cost of capital report

Calculating Cost of Capital Report

The cost of capital report explains the importance of determining a capital budgeting project's minimum return by calculating the weighted average cost of capital formula, which considers a company's cost of both debt and equity.

Formula

Ke = Rf + β(Rm - Rf)

How do I calculate the cost of capital report?

In order to calculate the cost of capital for a project or investment, it is important to understand the concept of the cost of equity. The cost of equity is the return that a company requires for an investment or project and it is used as a capital budgeting threshold. To calculate the cost of equity, the Capital Asset Pricing Model (CAPM) can be used, which takes dividends per share for the next year and the current market value of the stock. The formula for the CAPM cost of equity is Ke = Rf + β(Rm - Rf), where Ke is the cost of equity, Rf is the risk-free rate of return, β is the beta of the security, and Rm is the expected market return. Sourcetable has useful financial functions to help calculate the cost of equity.

What is the cost of capital?

The cost of capital is the minimum required return for a capital budgeting project. It is used to justify a capital budget and is calculated using the weighted average cost of capital (WACC).

What is the difference between the cost of capital and the discount rate?

The cost of capital and the discount rate are similar, but the cost of capital takes into account the weighted average cost of capital whereas the discount rate does not.

Key Points

How do I calculate cost of capital report?
Ke = Rf + β(Rm - Rf)
Calculating the Cost of Capital
The cost of capital is a calculation used to justify capital budgeting projects. It is calculated using the weighted average cost of capital formula, which considers both debt and equity capital. This formula is used to determine the minimum return needed to justify capital expenditure projects.
Financing Projects
The cost of capital is the cost of financing a project. It is important to consider the cost of capital when determining whether or not to pursue a project, as it will affect the rate of return that can be expected.
Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV