I need help with the problems that I have uploaded. It involves bond pricing. The attached file contains the excel problems with the three sheets that needs to be filled. Thanks.

Inputs Number of Years to Maturity (t) Number of Payments per Year Face Value (Par) 8 1 $1,000 Discount Rate / Period (YTM) Coupon Payment (PMT) 3.25% $35.00 Bond Price using a Timeline Year 1 2 3 4 Cash Flows Present Value of Cash Flows Bond Price $0.00 Bond Price using the PV Function Bond Price What three things must be done if payments are semi-annual rather than annual? 5 6 7 8 Calculate the PV of the individual cash flows using the algebraic method. The value in the yellow cell will calculate on its own. BOND PRICING Semi-Annual YTM and Price Sensitivity Inputs Annual Coupon Rate Yield to Maturity (Annualized) Number of Payments / Year Number of Years to Maturity (t) Face Value (Par) Outputs Discount Rate / Payment (k) Coupon Payment (PMT) 4% 1.75% 2 8 $1,000 Bond Price as Time Approaches Maturity Time (t) Bond Price 0 1 2 3 4 5 6 7 8 Bond Price as YTM Changes YTM Bond Price 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% roaches Maturity STOCK VALUATION Dividend Growth Model - Constant Growth Inputs Dividend Growth Rate Required rate of return Dividend Discount Model Year Dividend Growth Rate Dividend Stock Value 3% 11% Finite Horizon 0 1 3.0% 2 3.0% 3 3.0% 4 3.0% 5 3.0% $6.64 Calculate the stock value using the Dividend Growth Model and the data provided in the yellow cells. Hint: notice that the dividend growth does not change. Constant Growth Infin Horiz 3.0% using the Dividend ta provided in the hat the dividend