professional documents
home
Upload
docsters
Upload
Excel Spreadsheet

weighted average cost center doc


ESTIMATING THE WEIGHTED AVERAGE COST OF CAPITAL Input cells are in yellow. Comparable Companies Firm 1 Firm 2 Firm 3 Average DATA Amount of equity 200 200 300 Amount of debt 100 200 200 Tax rate 40% 35% 38% Equity beta 1.10 1.25 0.90 RESULT 1+ (1-T)D/E 1.30 1.65 1.41 Unlevered equity beta 0.85 0.76 0.64 0.75 Project or Acquisition DATA % Debt 40% % Equity 60% Tax rate 40% RESULT 1+ (1-T)D/E 1.40 Unlevered project beta 0.75 = average of unlevered equity betas of comparable firms Project equity beta 1.05 DATA Risk-free rate 6.00% = yield on long-term Treasury bonds Market risk premium 7.40% = historical average excess return of S&P 500 RESULT Project equity beta 1.05 Market risk premium 7.40% Equity risk premium 7.74% Plus risk-free rate 6.00% Cost of equity 13.74% Note: The estimate of the market risk premium is the arithmetic average from 1927-1997, based on the Ibbotson Associates "Stocks, Bonds, Bills and Inflation" data. DATA Cost of debt 9.0% RESULT Weighted Weights Cost After-tax cost of debt 5.4% 40.0% 2.2% Cost of equity 13.7% 60.0% 8.2% Weighted average cost of capital 10.4%
flag this doc
221
14
not rated
0
1/21/2008
English
Preview

Weighted Average Cost of capital

balazon 1/8/2008 | 344 | 36 | 0 | financial
Preview

weighted avg cost

lizzybee27925 1/21/2008 | 186 | 14 | 0 | financial
Preview

betawacc Weighted Average Capital Cost

cshieyiez 1/21/2008 | 266 | 15 | 0 | financial
Preview

Weighted Average Cost of Capital Template

LisaB1982 2/5/2008 | 1150 | 65 | 0 | financial
Preview

Weighted avg cost of cap

sammyc2007 3/1/2008 | 124 | 1 | 0 | financial
Preview

Calculation of Weighted Average Cost of Capital using beta's for equity

wiccangirl 2/19/2008 | 151 | 11 | 0 | financial
Preview

APPENDIX A DERIVATION OF WEIGHTED AVERAGE COST

EPADocs 5/14/2008 | 24 | 0 | 0 | legal
Preview

betawacc Weighted Average Capital Cost

anonymous 6/16/2007 | 143 | 8 | 0 | financial
Preview

Calculating Weighted Average Cost of Capital

ocak 1/14/2008 | 404 | 24 | 0 | financial
Preview

Cost of Capital

BeunaventuraLongjas 8/8/2008 | 153 | 7 | 0 | financial
Preview

Calculating Weighted Average cost of capital[1]

Mythri 1/23/2008 | 141 | 15 | 0 | financial
Preview

Calculating Weighted Average cost of capital[2]

Mythri 1/23/2008 | 92 | 7 | 0 | financial
Preview

WACC ANALYSIS

tlindeman 2/27/2008 | 437 | 13 | 0 | financial
Preview

Calculation of Weighted Average Cost of Capital using beta's for equity[1]

anonymous 2/23/2008 | 66 | 8 | 0 | financial
Preview

Free Business Templates - Personal Financial Statement

anonymous 12/7/2007 | 2950 | 97 | 0 | business
Preview

YearEndTaxPlan[2]

lizzybee27925 1/21/2008 | 45 | 2 | 0 | financial
Preview

workbreakdown

lizzybee27925 1/21/2008 | 448 | 96 | 1 | financial
Preview

What-If Analysis Template[1]

lizzybee27925 1/21/2008 | 274 | 80 | 1 | financial
Preview

what if model

lizzybee27925 1/21/2008 | 230 | 40 | 0 | financial
Preview

weighted avg cost

lizzybee27925 1/21/2008 | 186 | 14 | 0 | financial
Preview

vertical analysis

lizzybee27925 1/21/2008 | 228 | 19 | 0 | financial
Preview

valuation model

lizzybee27925 1/21/2008 | 339 | 20 | 0 | financial
Preview

transport management

lizzybee27925 1/21/2008 | 271 | 8 | 1 | financial
Preview

timesheet-template[1]

lizzybee27925 1/21/2008 | 390 | 24 | 0 | financial
Preview

timesheet totals

lizzybee27925 1/21/2008 | 374 | 28 | 0 | financial
 
review this doc