Hello, I need help with an accounting assigment, using an excel spread sheet is fine. You have been so much help to me this semster thank you so much! I have attached the file with questions below.

ACCT2060 Ch 7/8 Exam J. Adkins Name __________________________ Part I. Valuing Bonds/Finding YTM (7 points each) 1. Linus Inc. has a 9 percent coupon bonds on the market that have 8 years left to maturity. The bonds make annual payments. If the YTM on these bonds is 7 percent, what is the current bond price? 2. Lucy Co. has 12% coupon bonds on the market with 10 years left to maturity. The bonds make semi-annual payments. If the bonds currently sell for $894.06, what is the YTM? 3. Snoopy Co. issued 12 year bonds two years ago at a coupon rate of 14%. The bonds make semiannual interest payments. If the YTM on these bonds is 10%, what is the current bond price? 4. Sally Co. issued 15 year bonds two years ago at a coupon rate of 4% which is paid semiannually. If these bonds currently are priced at $592.78, what is the YTM? Part II. Valuing Stock/Finding Required Rates of Return (7 points each) 1. The Bridge Co. has just paid a cash dividend of $4.00 per share. Investors require a 10% return from investments such as this. If the dividend is expected to grow at a steady 4% per year, what is the current value of the stock? What will the stock be worth in 5 years? 2. Suppose you observe a stock selling for $50 per share. The next dividend will be $2.00 per share, and you think the dividend will grow at 12% per year forever. What is the dividend yield in this case? The capital gains yield? The total required return? 3. Moss Inc. has an issue of preferred stock outstanding that pays $5 dividend every year, in perpetuity. If this issue currently sells for $82.50, what is the required return? 4. ToySrWee's stock is currently selling for $50.00. The expected dividend in one period is $1.50 per share, and the required return is 10%. What is the firm's dividend growth rate assuming constant growth? 5. A stock that pays a constant dividend of $1.50 forever currently sells for $10.71. What is the required rate of return? 6. What would you pay today for a stock that just paid a $2.00 dividend if the expected dividend growth rate is 5% and you require a 15% return on your investment