Estimating a beta (Corporate Finance)

Compute and estimate a beta for a firm's stock/market index

betaestimatingfinancejensen's alphamarket indexperformancerisksensitivitystock

Description
This spreadsheet allows you to input past returns on a stock and a market index to analyse its price performance (Jensen's Alpha), its sensitivity to market movements (Beta) and the proportion of its risk that can be attributed to the market.

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:

to estimate expected returns:
- risk free rate
- historical return premium
- expected return

to forecast prices:
- current price
- annualized DPS

- predicted prices (one to five years from now)

Reviews

  • No review yet!

Any questions on Estimating A Beta (Corporate Finance)?

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

please wait...