Business Finance
teddyoliver
financeAssigment2.docxInstructions:
You are required to use a financial spreadsheet (Excel) to solve 10 problems (provided on page 2) related to the risk and return, stocks and bonds valuation. You are required to show the following 3 steps for each problem (sample questions and solutions are provided for guidance):
(i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem.
Sample Question # 2:
A company just paid a dividend of $1, and the dividends are expected to grow at constant rate of 4% forever. If the required return of the stockholders is 12%, what is the price of this company’s stock?
Solution
(i) The problem assumes the stock will have a constant growth of 4% forever. The constant growth model is appropriate to use for this problem. The accuracy of the solution depends on the correctness of the constant growth assumption.
(ii) The constant growth model is given as: P0 = D1/ (R-g); where P0 is the current price to be calculated, D1 is the next period’s dividend, R is the required return on this stock
(iii) D1= 1x(1+0.04) = 1.04 P0 = 1.04 /(0.12-0.04) = $13; the stock price should be $13 based on the constant growth model. .
Assignment Problems
1. ABC Corporation issues a bond which has a coupon rate of 11.40%, a yield to maturity of 9.75%, a face value of $1,000, and a market price of $1,145. What is the annual interest payment? Round to two decimal places.
2. A shipping company sold an issue of 14-year $1,000 par bonds to build new ships. The bonds pay 6.75% interest, compounded semiannually. Today's required rate of return is 8.7%. How much should these bonds sell for today? Round to two decimal places.
3. Assume a company has an issue of 17-year $1,000 par value bonds that pay 7.5% interest, compounded annually. Further assume that today's required rate of return on these bonds is 6%. How much would these bonds sell for today? Round to two decimal places.
4. ABC Company issued bonds on January 1, 2006. The bonds had a coupon rate of 6.5%, with interest paid semiannually. The face value of the bonds is $1,000 and the bonds mature on January 1, 2021. What is the yield to maturity for these bonds on January 1, 2016 if the market price of the bond on that date is $1,020?
5. A $1,000 par value 14-year bond with a 12 percent coupon rate recently sold for $945. What is the yield to maturity? Assume semiannual payments and submit your answer as a percentage rounded to two decimal places.
6. Consider a 10 year bond with face value $1,000 that pays a 6.5% coupon semi-annually and has a yield-to-maturity of 8.5%. What is the approximate percentage change in the price of bond if interest rates in the economy are expected to decrease by 0.60% per year? Submit your answer as a percentage and round to two decimal places. (Hint: What is the expected price of the bond after the change in interest rates?)
7. ACME, Inc. expects its current annual $4.50 per share common stock dividend to remain the same for the foreseeable future. What is the intrinsic value of the stock to an investor with a required return of 15%? Round to two decimal places.
8. ABC Company's common stock is expected to pay a $2.50 dividend in the coming year. If investors require a 16% return and the growth rate in dividends is expected to be 8%, what should the market price of the stock be? Round to two decimal places.
9. ABC Corporation stock is currently selling for $54.00. The stock is expected to pay a dividend of $4.25 at the end of the year. Dividends are expected to grow at a constant rate of 6.5% indefinitely. Compute the expected rate of return on ABC Corporation stock. Submit your answer as a percentage and round to two decimal places.
