login
|
join
professional documents
home
Upload
docsters
Upload
all docs
legal
business
financial
technology
educational
creative
BUZZ
weighted average cost
Categories
financial
Tags
financial templates for business
be first to review
lizzybee27925
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%
Public Domain
views:
221
downloads:
14
rating:
not rated
reviews:
0
posted:
1/21/2008
language:
English
Weighted Average Cost of capital
shared by:
balazon
on:
1/8/2008
|
views:
344
|
downloads:
36
|
comments:
0
|
category:
financial
weighted avg cost
shared by:
lizzybee27925
on:
1/21/2008
|
views:
186
|
downloads:
14
|
comments:
0
|
category:
financial
betawacc Weighted Average Capital Cost
shared by:
cshieyiez
on:
1/21/2008
|
views:
266
|
downloads:
15
|
comments:
0
|
category:
financial
Weighted Average Cost of Capital Template
shared by:
LisaB1982
on:
2/5/2008
|
views:
1150
|
downloads:
65
|
comments:
0
|
category:
financial
Weighted avg cost of cap
shared by:
sammyc2007
on:
3/1/2008
|
views:
124
|
downloads:
1
|
comments:
0
|
category:
financial
Calculation of Weighted Average Cost of Capital using beta's for equity
shared by:
wiccangirl
on:
2/19/2008
|
views:
151
|
downloads:
11
|
comments:
0
|
category:
financial
APPENDIX A DERIVATION OF WEIGHTED AVERAGE COST
shared by:
EPADocs
on:
5/14/2008
|
views:
24
|
downloads:
0
|
comments:
0
|
category:
legal
betawacc Weighted Average Capital Cost
shared by:
anonymous
on:
6/16/2007
|
views:
143
|
downloads:
8
|
comments:
0
|
category:
financial
Calculating Weighted Average Cost of Capital
shared by:
ocak
on:
1/14/2008
|
views:
404
|
downloads:
24
|
comments:
0
|
category:
financial
Cost of Capital
shared by:
BeunaventuraLongjas
on:
8/8/2008
|
views:
153
|
downloads:
7
|
comments:
0
|
category:
financial
Calculating Weighted Average cost of capital[1]
shared by:
Mythri
on:
1/23/2008
|
views:
141
|
downloads:
15
|
comments:
0
|
category:
financial
Calculating Weighted Average cost of capital[2]
shared by:
Mythri
on:
1/23/2008
|
views:
92
|
downloads:
7
|
comments:
0
|
category:
financial
WACC ANALYSIS
shared by:
tlindeman
on:
2/27/2008
|
views:
437
|
downloads:
13
|
comments:
0
|
category:
financial
Calculation of Weighted Average Cost of Capital using beta's for equity[1]
shared by:
anonymous
on:
2/23/2008
|
views:
66
|
downloads:
8
|
comments:
0
|
category:
financial
Free Business Templates - Personal Financial Statement
shared by:
anonymous
on:
12/7/2007
|
views:
2950
|
downloads:
97
|
comments:
0
|
category:
business
YearEndTaxPlan[2]
shared by:
lizzybee27925
on:
1/21/2008
|
views:
45
|
downloads:
2
|
comments:
0
|
category:
financial
workbreakdown
shared by:
lizzybee27925
on:
1/21/2008
|
views:
448
|
downloads:
96
|
comments:
1
|
category:
financial
What-If Analysis Template[1]
shared by:
lizzybee27925
on:
1/21/2008
|
views:
274
|
downloads:
80
|
comments:
1
|
category:
financial
what if model
shared by:
lizzybee27925
on:
1/21/2008
|
views:
230
|
downloads:
40
|
comments:
0
|
category:
financial
weighted avg cost
shared by:
lizzybee27925
on:
1/21/2008
|
views:
186
|
downloads:
14
|
comments:
0
|
category:
financial
vertical analysis
shared by:
lizzybee27925
on:
1/21/2008
|
views:
228
|
downloads:
19
|
comments:
0
|
category:
financial
valuation model
shared by:
lizzybee27925
on:
1/21/2008
|
views:
339
|
downloads:
20
|
comments:
0
|
category:
financial
transport management
shared by:
lizzybee27925
on:
1/21/2008
|
views:
271
|
downloads:
8
|
comments:
1
|
category:
financial
timesheet-template[1]
shared by:
lizzybee27925
on:
1/21/2008
|
views:
390
|
downloads:
24
|
comments:
0
|
category:
financial
timesheet totals
shared by:
lizzybee27925
on:
1/21/2008
|
views:
374
|
downloads:
28
|
comments:
0
|
category:
financial