Question

In: Finance

Note This is a guideline and is not meant to show you exactly step-by-step how to...

Note

This is a guideline and is not meant to show you exactly step-by-step how to do the project (although it comes close to doing that). In the “real world”, your boss is not going to show you how to do everything. She is going to ask you to do something and you are going to have to do it to the best of your ability.

Objective

The assignment is to estimate the weighted average cost of capital (WACC) for an actual corporation as of the current time. Actual managers would need to know their company’s WACC as a starting point to estimate the discount rate to use in the net present value analysis of new projects.

The project also develops student skills in using elementary financial management models, in dealing with situations where there are too much or too little data, in employing publicly available data sources with little guidance, and in applying sound judgment when encountering naturally occurring measurement errors.

Please see the detailed instructions in the file attachment: Final Project Instructions.

Solutions

Expert Solution

WACC stand for the wighted average cost of capital, with its major components being cost of debt and cost of equity.

Let's start with the calculation of WACC for Apple Inc.

Risk free rate = US govt 10 year maturity bond = 0.74%

Default spread of Apple = 0.63% (Rated AA1 by Moody's)

Equity market risk premium = 6.1% = (Market return - risk free rate)

Tax rate = 35%

Beta = 1.31

Cost of debt = Risk free rate + default spread = 0.74% + 0.63% = 1.37%

After tax cost of debt = cost of debt * (1 - tax) = 1.37 *(1 - .35) = 0.8905%

Cost of equity = Risk free rate + beta*equity risk premium = 0.73% + 1.31*6.1% = 0.73% + 7.991% = 8.721%

Apple's debt (D)= 122.19 Billion.

Apple's market cap (E)= 2000Billion

D/(D+E) = 122.19/2122.19 = 0.0575

E/(D+E) = 2000/2122.19 = .9424

WACC = (after tax cost of debt * D/(D+E)) + ( cost of equity * E/(D+E))

= 0.8905 * 0.0575 + 8.721 * 0.9424

= 0.0512 + 8.2186

=8.27%

Therefore WACC of Apple Inc is 8.27%

Please see that the above data like beta, debt, market cap of equity etc can be calculated on by own or can be taken from any financials sites.


Related Solutions

vectors physics note: show all the steps and how you reached to the final step Let...
vectors physics note: show all the steps and how you reached to the final step Let A = [-2,-5] and B = [-1,5] Calculate the following algebraically, then illustrate each using the tip to tail method of vector addition. Label all vectors and show clearly how the resultant vectors are constructed. Label the coordinates of the resultant vector. a) A - 2B   b) -A + 3B c) 2A - B d) -B + A
Please solve the below (step by step, show all work): Consider a 10-year note with a...
Please solve the below (step by step, show all work): Consider a 10-year note with a coupon rate of 5%. Calculate its price assuming: 5% yield-to-maturity, annual compounding 5% yield-to-maturity, semi-annual compounding 6% yield-to-maturity, annual compounding 6% yield-to-maturity, semi-annual compounding
What is normalzing a wavefunction and how do you do it step by step? Please show...
What is normalzing a wavefunction and how do you do it step by step? Please show TWO different examples (one for SHO question, an IPW question, etc) Thanks!
And please show me the step by step process of how you solved the question. I...
And please show me the step by step process of how you solved the question. I have a learning disability and I need to know the steps to solve the question If it takes 17.5 mL of 0.085 M NaOH to titrate a 15 mL sample of sauerkraut juice, what is the acidity of that juice, expressed as % lactic acid (wt/vol)?
How can I solve this problem? Can you please show step by step how to solve...
How can I solve this problem? Can you please show step by step how to solve this? Qd = 2,000 − 10P MC = 0.1Q
Please solve all answers on Excel and show step by step how you get the WACC...
Please solve all answers on Excel and show step by step how you get the WACC answer.   Tornado Motors is a major producer of sport and utility trucks. It is a family owned company, started by Jane Biscayne in 1935, at the height of the Great Depression. Today the firm produces 3 lines of trucks. These include a standard, no-frills short bed pickup truck (Model A), a mid-size version (Model B ) and a larger, heavy-duty work truck (Model C)....
Can you please show how you would solve the following using excel? Step by Step? Kaelea,...
Can you please show how you would solve the following using excel? Step by Step? Kaelea, Inc., has no debt outstanding and a total market value of $117,000. Earnings before interest and taxes, EBIT, are projected to be $8,300 if economic conditions are normal. If there is strong expansion in the economy, then EBIT will be 23 percent higher. If there is a recession, then EBIT will be 32 percent lower. The company is considering a $41,700 debt issue with...
assuming that your t-statistic is 1.17. show how you compute the p-value step by step.
assuming that your t-statistic is 1.17. show how you compute the p-value step by step.
Note: I need a step by step answer to the following problem to better understand how...
Note: I need a step by step answer to the following problem to better understand how this works. Hot Coffee Manufacturing produces and sells oak tables. The budgeted   manufacturing costs per table are as follows: Direct costs                 Oak top                48 square feet at $10 per sq. ft.                 Table legs                 4 legs at $5 per leg Direct labor is 3 hours and 24 minutes per table at $15 per hour. The variable overhead rate is $6 per...
Could you please show step by step how I can get IRR after computing Present value...
Could you please show step by step how I can get IRR after computing Present value of cash flows and NPV Exercise 11-13A Internal rate of return LO P4 Following is information on two alternative investments being considered by Tiger Co. The company requires a 4% return from its investments. Project X1 Project X2 Initial investment $ (80,000 ) $ (120,000 ) Expected net cash flows in year: 1 25,000 60,000 2 35,500 50,000 3 60,500 40,000
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT