Company chosen is Pfizer inc.

Suppose you are about to start your job in your favourite S&P 500 company as a manager corporate finance and treasury department and have just been assigned to the team estimating it's WACC. You must estimate this WACC in preparation for a team meeting later today. You quickly realize that the information you need is readily available online.

1.Go to http://finance.yahoo.com. Under "Market Summary," you will find the yield to maturity for ten-year Treasury bonds listed as "10 Yr Bond(%)." Collect this number as your risk-free rate.

2.In the box next to the "Get Quotes" button, type the company's ticker symbol which you are working on, and click Search. Once you see the basic information for your company, find and click "Key Statistics" on the left side of the screen. From the key statistics, collect your company's market capitalization (its market value of equity), enterprise value (market value equity + net debt2) cash, and beta.

3.To get your company's cost of debt and the market value of its long-term debt, you will need the price and yield to maturity on the firm's existing long-term bonds. Go to http://www.finra.org, click on Investors and then under "Market Data," click on Bonds. Under "Quick Bond Search," click "Corporate," type the company's ticker symbol, and click Search. A list of company's outstanding bond issues will appear.

Assume that your company's policy is to use the yield to maturity on non-callable ten-year obligations as its cost of debt. Find the non-callable bond issue that is as close to ten years from maturity as possible. (Hint: You will see a column titled "Callable"; make sure the issue you choose has "No" in this column.) You may have to choose a bond issued by one of its subsidiaries. Find the yield to maturity for your chosen bond issue (it is in the column titled "Yield") and enter that yield as your pre-tax cost of debt into your spreadsheet. Next, copy and paste the data in the entire table into Excel.

4.You now have the price for each bond issue, but you need to know the size of the issue. Returning to the Web page, go to the row of the bond you chose and click the Issuer Name in the first column (this will either be your Company or its another subsidiary). This brings up a Web page with all of the information about the bond issue. Scroll down until you find "Amount Outstanding" on the right side. Noting that this amount is quoted in thousands of dollars (e.g., $60,000 means ), record the issue amount in the appropriate row of your spreadsheet. Repeat this step for all of the bond issues.

5.The price for each bond issue in your spreadsheet is reported as a percentage of the bond's par value. For example, 104.50 means that the bond issue is trading at 104.5% of its par value. You can calculate the market value of each bond issue by multiplying the amount outstanding by (Price/100). Do so for each issue and then calculate the total of all the bond issues. This is the market value of your company's debt.

6.Compute the weights for your company's equity and debt based on the market value of equity and company's market value of debt, computed in step 5.

7.Calculate company's cost of equity capital using the CAPM, the risk-free rate you collected in step 1, and a market risk premium of 5%.

8.Assuming that company has a tax rate of 35%, calculate its effective cost of debt capital.

9.Calculate company's WACC.

10.Calculate company's net debt by subtracting its cash (collected in step 2) from its debt. Recalculate the weights for the WACC using the market value of equity, net debt, and enterprise value. Recalculate firm's WACC using the weights based on the net debt. How much does it change?

11.How confident are you of your estimate? Which implicit assumptions did you make during your data collection efforts?