Betas and Leverage

Obtain a table of betas at different debt ratios

betasdebt equity ratiodebt ratiosfinanceleveragestock

Description
This spreadsheet allows you to enter the current beta, tax rate and the debt equity ratio for your stock, and obtain a table of betas at different debt ratios.

Note: this model is being shared with the authorization of Professor Aswath Damodaran from NYU Stern Business School (www.damodaran.com)

This business tool includes
1 Excel Model File

Prof. Aswath Damodaran offers you this business tool for free!

Download for free

Ask a question

Further information

The objective of this model is to get the following output values:
- Unlevered Beta for the firm (based upon average debt/equity ratio)
- Current Beta for the firm (based upon current debt/equity ratio)
- Levered Beta based upon this debt/equity ratio

Reviews

  • No review yet!

Any questions on Betas And Leverage?

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

please wait...