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.BondCompany/RatingFace Value (FV)Coupon RateAnnual Payment (PMT)Time-to Maturity (NPER)Yield-to-Maturity (RATE)Market Value (Quote)Discount, Premium, ParA-Rated $1,000 B-Rated $1,000 C-Rated $1,000 Explain the relationship observed between ratings and yield to maturity. Explain why the coupon rate and the yield to maturity determine why the bonds would trade 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 5-year 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 (use the Capital Asset Pricing model). You will need to find the risk-free rate online. It is the 5-year Treasury rate. You will need the market return which is just the return on the S&P 500 Index, and it is available online. You should use an average over 5 years (find the historical yearly returns for the S&P 500 Index and average them). You must research your stocks to find the betas. You should be able to find them at finance.yahoo.com.”Company5-year Risk-Free Rate of ReturnBeta (ß)5-Year Return of S&P 500 Index Required Rate of Return (CAPM) “To complete the next table, you will need the most recent dividends paid over the past year for each stock, next year’s expected dividends, the expected growth rate of the dividends (which you can calculate by taking next year’s dividend subtracting off this year’s dividend and dividing the result by this year’s dividend), 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.
CompanyCurrent DividendProjected Growth Rate of DividendsNext year’s DividendRequired Rate of Return (CAPM)Estimated Stock Price (Gordon Model) = Next year’s dividend / (required rate of return – projected growth rate of dividends)Current Stock PriceOver/under PricedIn 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.CompanyEstimated Earning (next year)P/E RatioEstimated Stock Price (P/E)Current Stock PriceOver/Under Priced 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:Explain the relationship observed between the required rate of return, growth rate and the dividend paid, and the estimated value of the stock using the Gordon Model. Explain the value and weaknesses of the Gordon model. Explain the how the price-to-earnings model is used to estimate the value of the stocks. Note: You can find information about the top 500 stocks at this Web site.ReferencesS&P 500 index chart. (2014). Retrieved from the Yahoo! Finance Web site: http://finance.yahoo.com/echarts?s=%5egspc+interactive#symbol=^gspc;range=1y;compare=;indicator=volume;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=;Be sure to document your paper with in-text citations, credible sources, and a list of references used in proper APA format.
We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.
Over the years, our Written Assignments has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keeps up with the rising Academic Trends.
Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.
We pay strict attention to deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.
At Written Assignments, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.
Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email: email@example.com.
Try it now!
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Written Assignments has stood as the world’s leading custom essay writing paper services provider. Once you enter all the details in the order form under the place order button, the rest is up to us.
At Written Assignments, we prioritize all aspects that bring about a good grade such as impeccable grammar, proper structure, zero plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.
Be assured that you’ll get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.
Our skilled editing and writing team will help you restructure your paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.
We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as many details as possible in the place order section.