Equity Beta and Asset Beta Conversion Excel Model Template
Originally published: 02/10/2018 10:20
Last version published: 16/01/2019 09:09
Publication number: ELQ-82305-2
View all versions & Certificate

Equity Beta and Asset Beta Conversion Excel Model Template

This Excel template and accompanying video provide a concise explanation of how to conduct an unlevered beta analysis.

This Unlevered Beta and Asset Beta Conversion Template is an efficient and practical Excel model from CFI. With the correct data inputs, the template can automatically calculate a company’s Unlevered Beta.

Beta is the measure of a stock’s volatility in the context of the market. The benchmark for the market is 1.0, and so the Beta of a given company tells us how much the stock swings over a given period by way of its deviation from the market’s 1.0 standard.

Unlevered Beta (Asset Beta) is the company’s Beta score without taking into account the debt that it holds. This tells us the risk of investing into a given company in comparison with the market. This is a very useful tool. When researching companies’ betas, the default that we are usually given is the Levered Beta, which takes into account the debt. By removing this, we can see how risky the assets of a company are, without having to consider the debt.

The accompanying video offers a concise explanation of how to calculate the levered and unlevered beta. It also demonstrates how to fill out the table that is included in the Excel model template.

See CFI’s Channel for additional templates and resources.

This Best Practice includes
1 Excel Spreadsheet, 1 Youtube

CFI offers you this Best Practice for free!

download for free

Add to bookmarks



  • Rate this Downloadable Best Practice

    Write a review

  • RUBENS COSTA(last updated: 14/04/2019 23:36)

People using this Best Practice also downloaded


More Best Practices from CFI

See all

Any questions on Equity Beta And Asset Beta Conversion Excel Model Template?

The user community and author are here to help. Go ahead!

3.0 / 5 (1 votes)

please wait...