This question has been answered
Question


CAN YOU PLEASE INCLUDE IMAGE OF REGRESSION OUTPUT !!!!

Capture11.PNG



a)    Using Excel, calculate the mean, variance and Standard Deviation for FedEx stock. The Market Index values are given above.

FDX   

Mean               _______%

Variance         _________

Std. Dev           _______%        


b)   Using Excel, calculated the covariance for FedEx stock with the NYSE Index: Covariance  = _________


After using Excel to calculate the covariance of FedEx Corporation stock returns with the Market Index, what is FDX's correlation with the market and its beta (β) using the covariance?

           

Correlation  = ________________ = 0._______


Beta (β)         = _________________ = ________


c)    Using Regression under Data in Excel, the y axis is FDX percentage returns and the x axis is the Market percentage returns. Copy and paste (as a picture) the regression output below. From the Regression output, what is the Beta for FDX Corporation stock?

Beta (β) = __________

 

 




(20 points)

2. You are an intern at FedEx Corporation and the CFO, Mr. Grayson House, has asked you to estimate the growth rate and cost of equity capital (retained earnings) for the firm. Each FDX stock is expected to pay a dividend (D1) of $2.60 a share next year. You estimated the beta above in problem# 1. The risk-free rate is estimated as the yield on nominal 10-year US Treasury bonds is 0.88%. See: https://www.treasury.gov/resource-center/data-chart-center/interest-rates/Pages/TextView.aspx?data=yield and the market risk premium [rM - rrf] is 5.5%. FedEx's dividend is expected to grow at the same constant rate, g, forever. The stock currently sells for $259.47 per share. Assuming the market is in equilibrium, where both the CAPM and DCF model should result in the same expected rate of return.


  1. What is the firm's estimated cost of equity capital for retained earnings (rs) and what is its implied growth rate (g)?

Remember:    rs = rrf +[rM-rrf]β=_0.88% +[5.5%]1.53 = _______% 

and P0 = D1 /(rs - g).


g = rs - D1/P0 =                     = ____________%

 


  1. Given average returns for the previous 14 years, is FedEx Corporation common stock underpriced or overpriced?



(10 Points) 3. As a measure of FDX's current cost of new issue debt, FDX Corp issued new long-term, BBB (S&P) bonds on October 17, 2018 of $850,000,000 par value with a coupon rate of 4.950% (paid semiannually) that will mature on October 17, 2048. At the current price of 111.250 percent of par value, this equals an annual yield of 4.06%. You may use this bond issue to estimate FDX's cost of new issue, 30-year maturity debt. What is FDX's after tax cost of the new debt assuming a 26 percent income tax rate? Remember: After-tax cost = before-tax cost (1-tax rate).

Data obtained from: https://www.investopoli.com/en/bonds/fedex-us31428xbs45/

 

After-tax cost debt =                            = ___________%








(30 Points)

4. Given the after-tax cost of new FDX 30-year bonds calculated in the previous problem and that FDX has $36.120 Billion of Debt and its most recent market value of equity is 68.135 Billion, (total value of debt plus equity of $104.255 Billion) its debt/equity ratio is 0.530, which converts to its current capital structure is 34.7% debt (Debt/Total Asset ratio is 34.7%) and 65.3% equity, what is the weighted average cost of capital (WACC) for FDX given the cost of debt and equity capital calculated above? FDX has no preferred stock. Remember:


WACC = wd *(before-tax cost of debt)*(1-tax rate) + ws *cost of equity

WACC =                                                            = _____________%


     

Answered by Expert Tutors
Step-by-step explanation
2 Attachments
66_Formula Sheet.png
png
66.png
png
Subject: Business, Finance
a)Using Excel, calculate the mean, variance and Standard Deviation for FedEx stock. The Market Index values are given above. FDX Mean _______%...
Get unstuck

292,177 students got unstuck by Course
Hero in the last week

step by step solutions

Our Expert Tutors provide step by step solutions to help you excel in your courses