week 5 hcs385 financial exercise. please also provide the step by step gudiance/explanation.

Insert Draw hc305_14_wk5_financial_exercises - Pre COTECTED VIEW Design Layout Be careful-Files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protecte References Mailings Review View Hel Week Five Financial Exercises Your task is to determine the WACC for a given firm using what you know about WACC, as well as data you can find through research. Your deliverable is a brief report in which you state your determination of VACC, describe and justify how you determined the number, and provide relevant information as to the sources of your data. Select a publicly traded company that has debt or bonds and common stock to calculate the current WACC. One good source for financial data for companies, as well as data about their equity, is Yahoo! Finance. By looking around this site, you should be able to find the market capitalization (E) as well as the B for any publicly traded company. There are not many places left where data about corporate bonds is still available. One of them is the Fina Bonds website. To find data for a particular company's publicly traded bonds use the Quick Search feature, then be sure to specify corporate bonds and type in the name of the issuing company. This should give you a list of all of the company's outstanding bond issues. Clicking on the symbol for a given bond issue will lead you to the current amount outstanding and the yield to maturity. You are interested in both. The total of all bonds outstanding is in the above formula If you like, you can use the YTM on a bond issue that is not callable as the pre-tax cost of debt for the company Assumptions: As you recall the formula for WACC is WCC = (EE+D) TE+DE+D) D (1-TC) The formula for the required return on a given equity Investment is rje of Bi (RM-) I RMit is the Market Risk Premium. For this project you may assume the Market Risk Premium is 5% unless you can develop a better number of is the risk-free rate. The risk-free rates normally the yield on US Treasury Securities such as 10-year treasury. For this assignment, please use 35% You may assume a corporate tax rate of 40% Submit the following Write a 350-to 700-word report that contains the following elements Your calculated WACC How data was used to calculate WACC provide the formula and the formula with your values Substituted Sources for your data A discussion of how much confidence you have in your answer including what the limiting assumptions you made were any I 424 words ew. Enable Editing Week Five Financial Exercises HCS/385 v4 Page 2 of 2 Include a Microsoft Excel file showing your WACC calculations discussed above. Submit your assignment. Insert Draw hc305_14_wk5_financial_exercises - Pre COTECTED VIEW Design Layout Be careful-Files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protecte References Mailings Review View Hel Week Five Financial Exercises Your task is to determine the WACC for a given firm using what you know about WACC, as well as data you can find through research. Your deliverable is a brief report in which you state your determination of VACC, describe and justify how you determined the number, and provide relevant information as to the sources of your data. Select a publicly traded company that has debt or bonds and common stock to calculate the current WACC. One good source for financial data for companies, as well as data about their equity, is Yahoo! Finance. By looking around this site, you should be able to find the market capitalization (E) as well as the B for any publicly traded company. There are not many places left where data about corporate bonds is still available. One of them is the Fina Bonds website. To find data for a particular company's publicly traded bonds use the Quick Search feature, then be sure to specify corporate bonds and type in the name of the issuing company. This should give you a list of all of the company's outstanding bond issues. Clicking on the symbol for a given bond issue will lead you to the current amount outstanding and the yield to maturity. You are interested in both. The total of all bonds outstanding is in the above formula If you like, you can use the YTM on a bond issue that is not callable as the pre-tax cost of debt for the company Assumptions: As you recall the formula for WACC is WCC = (EE+D) TE+DE+D) D (1-TC) The formula for the required return on a given equity Investment is rje of Bi (RM-) I RMit is the Market Risk Premium. For this project you may assume the Market Risk Premium is 5% unless you can develop a better number of is the risk-free rate. The risk-free rates normally the yield on US Treasury Securities such as 10-year treasury. For this assignment, please use 35% You may assume a corporate tax rate of 40% Submit the following Write a 350-to 700-word report that contains the following elements Your calculated WACC How data was used to calculate WACC provide the formula and the formula with your values Substituted Sources for your data A discussion of how much confidence you have in your answer including what the limiting assumptions you made were any I 424 words ew. Enable Editing Week Five Financial Exercises HCS/385 v4 Page 2 of 2 Include a Microsoft Excel file showing your WACC calculations discussed above. Submit your assignment