Current Price	$40.00
Estimated Growth Rate	7.00%
Beta	0.89
Number of Shares Outstanding	4,250,000,000
Next Year's Expected Dividend	$1.60
5-Year Treasury Yield	2.50%
Tax Rate	21.0%
Expected Market Risk Premium	5.50%
Name	Maturity	Par Value (Amount Outstanding)	Price
X 7.375%	7/29/93	95,835,000	140.118%
X 3.150%	11/15/20	1,000,000,000	100.442%
X 3.300%	9/1/21	1,324,080,000	100.448%
X 2.500%	4/1/23	750,000,000	96.558%
X 2.450%	11/1/20	1,250,000,000	98.851%
X 3.200%	11/1/23	1,500,000,000	98.928%
X 1.875%	10/27/20	1,500,000,000	97.841%
X 2.875%	10/27/25	1,750,000,000	95.028%
X 2.550%	6/1/26	500,000,000	91.903%
X 1.550%	9/1/21	1,000,000,000	95.656%
X 2.250%	9/1/26	1,000,000,000	90.007%
X 2.200%	5/25/22	500,000,000	96.424%
X 2.900%	5/25/27	500,000,000	93.606%
	Total Par Value of Debt:	12,669,915,000
Weighted Average Cost of Capital (WACC)
Market Value of Debt
Market Value of Equity
Total Market Value
Weight (%) Debt
Weight (%) Equity
Cost of Equity - CAPM Approach
Cost of Equity - DDM Approach
Cost of Equity - Average
Pre-Tax Cost of Debt
WACC

1. Estimate the weighted average pre-tax cost of debt (using market value weights).

2. Estimate the cost of equity using CAPM.

3. Estimate the cost of equity using DDM.

4. Using the simple average of cost of equity from CAPM and DDM, estimate the WACC for Company X.

After you have finished all the requirements, upload your Excel spreadsheet and enter your answers to questions 1-4 below from your spreadsheet.

note - its an urgent requirement within 40 mins and please send the solution how you solve in excel.