financial management 57
Word document of 7001,000 words withattached Excel Spreadsheet showing calculations 

Details: 
SOMEONE PLEASE HELP ME WITH THIS HW…. MY LAST ASSIGNMENT PURCHASED THROUGH HERE GAVE ME A EXTREMELY HIGH SIMILARITY ORIGINLITY VERIFCATION AND RECEIVED A POOR GRADE….. NEED SOMEONE WHO WILL NOT COPY AND PASTE AND ACTUALLY HELPS ME PASS
Weekly tasks or assignments (Individual or Group Projects) will be due by Monday, and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time. After engaging in a dialogue with your colleagues on valuation, you will now be given an opportunity to apply principles that were presented in this phase. Using a Web site that provides current stock and bond pricing and yield information, complete and analyze the tables illustrated below. Your mentor suggests using a Web site similar to this one. To fill out the first table, you will need to select 3 bonds with maturities between 10 and 20 years with bond ratings of “A to AAA,” “B to BBB” and “C to CC” (you may want to use bond screener at the Web site linked above). All of these bonds will have these values (future values) of $1,000. You will need to use a coupon rate of the bond times the face value to calculate the annual coupon payment. You should subtract the maturity date from the current year to determine the time to maturity. The Web site should provide you with the yield to maturity and the current quote for the bond. (Be sure to multiply the bond quote by 10 to get the current market value.) You will then need to indicate whether the bond is currently trading at a discount, premium, or par.
In this step, you have been asked to visit a credible Web site that provides detailed information on publicly traded stocks and select 1 that has at least a 5year history of paying dividends and 2 of its closest competitors. To fill up the first table, you will need to gather information needed to calculate the required rate of return for each of the 3 stocks. You will need the riskfree rate that you used in Phase 3, the market return is calculated in Phase 1, and the beta that you should be able to find on the Web site.
To complete the next table, you will need the most recent dividends paid over the past year for each stock, expected growth rate for the stocks, and the required rate of return you calculated in the previous table. You will also need to compare your results with the current value of each stock and determine whether the model suggests that they are over or underpriced.
In the third table, you will be using the price to earnings ratio (P/E) along with the average expected earnings per share provided by the Web site. You will also need to compare your results with the current value of each stock to determine whether or not the model suggests that the stocks are over or underpriced.
After completing the 3 tables, explain your findings and why your calculations coincide with the principles related to bonds that were presented in the Phase. Be sure to address the following:

Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers 
Our experts write quality original papers using academic databases. 
Free revisions 
We offer our clients multiple free revisions just to ensure you get what you want. 
Discounted prices 
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount 
100% originality 
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity 
Ontime delivery 
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay 