-
Present Values 3
-
Lecture1.1
-
Lecture1.2
-
Lecture1.3
-
-
NPV vs. IRR 4
-
Lecture2.1
-
Lecture2.2
-
Lecture2.3
-
Lecture2.4
-
-
Other Profit Measures 4
-
Lecture3.1
-
Lecture3.2
-
Lecture3.3
-
Lecture3.4
-
-
Depreciation 4
-
Lecture4.1
-
Lecture4.2
-
Lecture4.3
-
Lecture4.4
-
-
Cash Flow Challenges 9
-
Lecture5.1
-
Lecture5.2
-
Lecture5.3
-
Lecture5.4
-
Lecture5.5
-
Lecture5.6
-
Lecture5.7
-
Lecture5.8
-
Lecture5.9
-
-
Capital Asset Pricing Model 3
-
Lecture6.1
-
Lecture6.2
-
Lecture6.3
-
-
Risky Debt 3
-
Lecture7.1
-
Lecture7.2
-
Lecture7.3
-
-
Unlevering Equity 3
-
Lecture8.1
-
Lecture8.2
-
Lecture8.3
-
-
Weighted Average Cost of Capital 4
-
Lecture9.1
-
Lecture9.2
-
Lecture9.3
-
Lecture9.4
-
-
Debt Effect Analysis 2
-
Lecture10.1
-
Lecture10.2
-
-
WACC Challenge 2
-
Lecture11.1
-
Lecture11.2
-
-
Relative Valuation 4
-
Lecture12.1
-
Lecture12.2
-
Lecture12.3
-
Lecture12.4
-
-
Forward Contract Valuation 3
-
Lecture13.1
-
Lecture13.2
-
Lecture13.3
-
Introduction
First, for this challenge figure out the rate of equity to use based on the below companies. Unlever the equity rates and get the average of them. Here is the unlever function we created.
def unlever(r_a,r_d,E,D):
return r_a + (r_a-r_d)*(D/E)
Now for the data, I will make your life easy and feed you the data as arrays. A, B, C and D are companies are the 4 elements of each array represent return on assets, return on debt, amount of Equity and amount of Debt (net debt so do not worry about cash) respectively.
a = [.08,.03,100,100]
b = [.1,.04,100,0]
c = [.09,.02,200,100]
d = [.08,.03,100,200]
Challenge
Unlever these and get the average, then find the WACC for a company which has rate of debt 4%, a $10.5 stock price, 20 million shares, 300 million of debt, and 200 million in cash. Also the tax rate is 20%.
Next
Solution