Estimating the Weighted Average Cost of Capital


This spreadsheet shows to estimate the equity beta for a project using the betas of comparable companies and adjusting the for effect of leverage. The equity beta, market risk premium, and risk-free rate determine the cost of equity, according to the Capital Asset Pricing Model. The equity beta is combined with the after-tax cost of debt to compute the weighted average cost of capital.
Subjects: Finance, Spreadsheets
Source: Professor Kerry Back (Washington University in St. Louis) (visit original source)  
This content is for Premium, Lifetime Access members only.
Log In Register