Financial Management Assignment 3 Due by the end of day December 5, 2021 In this assignment, you will choose a company of its and calculate is weighted cost of capital WACC Accipements should be schmined in the formato excel files.ee other formats if you use other programming languages Data: 1) choose an estimation period for the sequired at least going back a 3-year period. 2) download the Monthly adjusted closing price for the company during the estimation period. 3) rinkfreesate (annual for the time period 4 monthly market indexlee S&P 500) "Adj Clase prices for the estate pened 5) the company's most recent 10-K filings with Balance Sheet normative and tax rate. You will practice how to Use the beta of the stock market reum, and risk-free rate te calculate the required rate of return value the stockingstat dividend discount medel Part I calculate required return for the stick te cost ofegang 1) calculate monthly return for the stock and market index The calculate excess returns retum-risk-free rate 2) Regres the excen return of the stock en the exces sets of bemerker index to estimate beta 3) Calculate tisk-free tate using average of the muai 3-Mont Treasury Sill interest rates over the estimation period 4) Calculate the monthly market return - (Ads close at the end of month - Adj close at the end of pervious month Ad close at the end of previous month 5) Calculate anualine market reum=werage monthly 12 ) Use the formal to cakulteroquired to free band market retum-risk-free rane) Part II, the cost of dcbt. 1) Note: For a company with publicly traded det, the cost of the measured as the yield to maturity on the outstanding debt. The comportement in this assignment you can use a recem YTM given in FINRA' Corporate boodata ee yield at offering of the bond from the prospectus SFINRA.Leute 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) WACC - EVR (DV) Roll-T) Financial Management Assignment 3 Due by the end of day December 5, 2021 In this assignment, you will choose a company of its and calculate is weighted cost of capital WACC Accipements should be schmined in the formato excel files.ee other formats if you use other programming languages Data: 1) choose an estimation period for the sequired at least going back a 3-year period. 2) download the Monthly adjusted closing price for the company during the estimation period. 3) rinkfreesate (annual for the time period 4 monthly market indexlee S&P 500) "Adj Clase prices for the estate pened 5) the company's most recent 10-K filings with Balance Sheet normative and tax rate. You will practice how to Use the beta of the stock market reum, and risk-free rate te calculate the required rate of return value the stockingstat dividend discount medel Part I calculate required return for the stick te cost ofegang 1) calculate monthly return for the stock and market index The calculate excess returns retum-risk-free rate 2) Regres the excen return of the stock en the exces sets of bemerker index to estimate beta 3) Calculate tisk-free tate using average of the muai 3-Mont Treasury Sill interest rates over the estimation period 4) Calculate the monthly market return - (Ads close at the end of month - Adj close at the end of pervious month Ad close at the end of previous month 5) Calculate anualine market reum=werage monthly 12 ) Use the formal to cakulteroquired to free band market retum-risk-free rane) Part II, the cost of dcbt. 1) Note: For a company with publicly traded det, the cost of the measured as the yield to maturity on the outstanding debt. The comportement in this assignment you can use a recem YTM given in FINRA' Corporate boodata ee yield at offering of the bond from the prospectus SFINRA.Leute 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) WACC - EVR (DV) Roll-T)