Please show all calculations in MS Excel. No credit will be earned unless you show your calculations.
Problem 1: CAPM:
If the risk-free rate is 0.0200, the return of the market is 0.1350, and the beta is 1.18, what is the required rate of return of the stock using the CAPM equation? Please note that the return of the market is not the same as the market risk premium.
Problem 2: Growth Rate:
If the retention ratio is ((Net Income – Dividends)/Net Income), and the net income amount is $8.98 Billion, the dividends totaled $2.32 Billion, and total equity is $41.315 Billion, what is the retention ratio? What is the return on equity? What is the growth rate for the firm?
Problem 3: DCF:
If the dividend paid last year, D0 (not D^1), was $1.56, and the price per share was $102, utilizing the growth rate previously calculated, what is the required rate of return on stock utilizing the discounted cash-flow approach?
Problem 4: WACC Calculations:
If the long-term debt for the firm is $19.119 Billion, the total equity for the firm is $41.315 Billion, the cost of debt is 0.025, the tax rate is 0.35, there is no preferred equity, what is the WACC utilizing the CAPM rs and then utilizing the DCF rs?
Note that "TWO" separate WACC equations need to be calculated in MS Excel.