I have posted part A previously but have yet to get an answer. For this, its the question for part b.

A fund manager is required to submit an investment proposal to the Investment Committee on the merits of investing in ABC Corp. As an investment analyst supporting the team, you have been asked to assist in analysing the bonds and common stock of the company. You have found the company to have a target capital structure of 70% equity and 30% debt, and gathered the following information: Current price of bonds Bonds par value Coupon rate Earnings per share- most recent year Expected growth rate of dividends Dividend payout ratio Required rate of return Current price of common stock 97% of par $1000 8% $2.00 5.10% 60% 12.60% $18 (a) The bonds were issued 10 years ago, and mature 15 years from today. Coupon payments are distributed annually. Analyse the YTM of the bonds (including the verification of your answer with an appropriate Excel function), and the circumstances where bonds will be trading at discount, premium or at par. (b) Calculate the company's share price using the Dividend Discount Model, and determine whether it is worth investing at current price