24 Jun Unit 3 IP Assignment: Deliverable Length 700 wo
Unit 3 IP Assignment: Deliverable Length 700 words in a Word file. Submit an Excel Spreadsheet showing calculations (submit separately). Fill out the 4 Tables completely.
A.
1.Bond Table 1: 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 http://finance.yahoo.com/). 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.
2. Analysis of Bond Table 1:
Organize your work under 3 headings:
•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.
•Based on the material you learn in this Phase, what would you expect to happen to the yield to maturity and market value of the bonds if the time to maturity was increased or decreased by 5 years?
B.
Select a stock that has at least a 5-year history of paying dividends and 2 of its closest competitors.
1. Stock Table 1: You will calculate the required rate of return for each of the 3 stocks. You will need to determine the risk-free rate (see Note below). You will need the market return that was calculated in Phase 2, and the beta that you find on the Web site.
2. Stock Table 2: You will determine whether the model suggests your stocks are over-priced or underpriced. 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. Compare your results with the current value of each stock to determine whether the model suggests that they are over-priced or underpriced.
3. Stock Table 3: You will determine whether the model suggests your stocks are over-priced or underpriced again in a different model. You will need to find the price to earnings ratio (P/E) and the average expected earnings per share. (This should be available on the Web, though P/E can be calculated.) Compare your results with the current value of each stock to determine whether or not the model suggests that the stocks are over-priced or underpriced.
4. Analysis of Stock Tables:
Organize your work under 5 headings:
•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.
•Explain which of the 2 models seemed to be the most accurate in estimating the value of the stocks.
•Based on the material that you learn in this Phase, what would you expect to happen to the value of the stock if the growth rate, dividends, required rate of return, or the estimated earnings per share were to increase or decrease
You can find information about the top 500 stocks at:
http://finance.yahoo.com/echarts?s=%5egspc+interactive#symbol=^gspc;range=1y;compare=;indicator=volume;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=;”
NOTE: You are not asked to find stocks that have a risk free rate of return. You are only asked to list the risk free rate of return, that is the 5 year treasury rate. It is not necessary to actually calculate it. What you have to calculate is the REQUIRED RATE OF RETURN.
The risk free rate will be the same for all stocks and the 5-
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.