Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, the data to this question can be found online but please answer this question. The company can be any but i'd prefer Fedex. It's

image text in transcribed

Hello, the data to this question can be found online but please answer this question. The company can be any but i'd prefer Fedex. It's one assignment. The class is Financial Management and it's a 300 level course. Please, use excel. There's an example and I have screenshots of potential data but please attempt this problem on your own so I might learn from it. It's supposed to be due by midnight on December 5th. However, I am unaware on how to complete this assignment after several attempts it would seem. So, if you could please show some work then that would be appreciated or the answers itself might be fine too. It's 5 points. I removed the websites that were included in the assignment as per the Chegg policy. In addition, these websites were FINRA, FRED, and the finance section of yahoo. As mentioned, these websites can be used to collect the necessary data to complete the question. I understand the question might be blurry but please answer it anyway.

Word File Edit View Insert Format Tools Table Window Help L2 Sat Dec 4 11:57 PM AutoSave OFF )v_ Design Layout References Assignment3 - Saved Review View Tell me Home Insert Draw Mailings Share Comments Times New... 14 AaBbCcDdEe AaBbccdee O | Aa v A x | A 2A LG || | * E Paste B I U ab Normal No Spacing V Dictate Editor Styles Pane Sensitivity Assignment 3 Due by the end of day December 5, 2021 In this assignment, you will choose a company of interest and calculate its weighted cost of capital WACC. Assignments should be submitted in the format of excel files, or other formats if you use other programming languages. Data: 1) choose an estimation period for the required return R, at least going back a 5-year period. 2) download the Monthly adjusted closing price for the company during the estimation period. 3) risk-free rates a (annual rates) for the estimation period; the rates are available monthly at (need to divide the raw data by 1200). 4) monthly market index (use S&P 500) "Adj Close" prices for the estimation period 5) the company's most recent 10-K filings with Balance Shect information and tax rate. You will practice how to 1) Use the beta of the stock, market return, and risk-free rate to calculate the required rate of retum, 2) cvaluate the stock using constant growth dividend discount model. Part I. calculate required return R for the stock, i.e. cost of equity 1) calculate monthly return for the stock and market index. Then calculate excess returns = retum - risk-free rate. 2) Regress the excess return of the stock on the excess return of the market index to estimate bcta. 3) Calculate risk-free rate using average of the annual 3-Month Treasury Bill interest rates over the estimation period. 4) Calculate the monthly market return = (Adj close at the end of month Adj close at the end of pervious month)/Adj close at the end of previous month 4) = 5) Calculate annualized market return = average monthly return * 12 6) Use the formula to calculate required return R = risk-free rate + beta* (annualized market return risk-free rate). Part II, the cost of debt. 1) Note: For a company with publicly traded debt, the cost of debt can be measured as the yield to maturity on the outstanding debt. The coupon rate is irrelevant. In this assignment you can use a recent YTM given in FINRA corporate bond data or yield at offering of the bond from the prosp Part III. WACC 1) Calculate the company's debt-to-capital ratio from the balance sheet data 2) Calculate the company's weighted average cost of capital (WACC). WAOC = (E/V)RE+ (D/V)RD(I-Tc) 385 words English (United States) Focus EN 110% Ex SHC DO hulu A ty A PE Word File Edit View Insert Format Tools Table Window Help L2 Sat Dec 4 11:57 PM AutoSave OFF )v_ Design Layout References Assignment3 - Saved Review View Tell me Home Insert Draw Mailings Share Comments Times New... 14 AaBbCcDdEe AaBbccdee O | Aa v A x | A 2A LG || | * E Paste B I U ab Normal No Spacing V Dictate Editor Styles Pane Sensitivity Assignment 3 Due by the end of day December 5, 2021 In this assignment, you will choose a company of interest and calculate its weighted cost of capital WACC. Assignments should be submitted in the format of excel files, or other formats if you use other programming languages. Data: 1) choose an estimation period for the required return R, at least going back a 5-year period. 2) download the Monthly adjusted closing price for the company during the estimation period. 3) risk-free rates a (annual rates) for the estimation period; the rates are available monthly at (need to divide the raw data by 1200). 4) monthly market index (use S&P 500) "Adj Close" prices for the estimation period 5) the company's most recent 10-K filings with Balance Shect information and tax rate. You will practice how to 1) Use the beta of the stock, market return, and risk-free rate to calculate the required rate of retum, 2) cvaluate the stock using constant growth dividend discount model. Part I. calculate required return R for the stock, i.e. cost of equity 1) calculate monthly return for the stock and market index. Then calculate excess returns = retum - risk-free rate. 2) Regress the excess return of the stock on the excess return of the market index to estimate bcta. 3) Calculate risk-free rate using average of the annual 3-Month Treasury Bill interest rates over the estimation period. 4) Calculate the monthly market return = (Adj close at the end of month Adj close at the end of pervious month)/Adj close at the end of previous month 4) = 5) Calculate annualized market return = average monthly return * 12 6) Use the formula to calculate required return R = risk-free rate + beta* (annualized market return risk-free rate). Part II, the cost of debt. 1) Note: For a company with publicly traded debt, the cost of debt can be measured as the yield to maturity on the outstanding debt. The coupon rate is irrelevant. In this assignment you can use a recent YTM given in FINRA corporate bond data or yield at offering of the bond from the prosp Part III. WACC 1) Calculate the company's debt-to-capital ratio from the balance sheet data 2) Calculate the company's weighted average cost of capital (WACC). WAOC = (E/V)RE+ (D/V)RD(I-Tc) 385 words English (United States) Focus EN 110% Ex SHC DO hulu A ty A PE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Intelligence An Entrepreneurs Guide Volume 1

Authors: Income Mastery

1st Edition

1647772648, 978-1647772642

More Books

Students also viewed these Finance questions