all has to be done in excel spreadsheet. please help!!!

I only need help with the first problem. You can screenshot work on excel is explain in word document.

FIN 320 Principles offre Chapter 7: Bond Valuation Bonds for ABC Company have the following characteristics Maturity 5 years Face Value $1.000 Coupon Rate Yield te Maturity of Payments per years 1 ( coupon payments of a bond is calculated in the spreadsheet below to be $1,079.85 Timeline Period discount rate 0.08 0 0 0 Coupon payment $0.00 $100.00 $100.00 $100.00 Face value payment Total cash flow $0.00 $100.00 $100.00 $100.00 PV of anal cash flow $0.00 $02.59 $85.73 $29.18 PV of bond $1,079.85 note: $1,079.35 50.00 50. Problem 1 Suppose the coupon payments for the ANC bond are m a instead of t he theme Following the emple who create c readsheet in the space betw e e wa Timeline 0 $100.00 0 $100.00 $1.000.00 $1,100.00 SM 84 $100.00 $ SO 573 .573.50 $74.64 bond Coupon payment Face payment PV of cash flow PV of bond Problem 2 Given the market price of a bond the implied period discount rate set by the market has to found by trial and error For example, finance calculators use an algorithm of trand error to estimate the period discount rate and from that, the YTM In the spreadsheet below, you will use trial and error to find the period discount rate. Instruction to find the period discount , by trial and error, change the number in the green call until PV market price . Both orange ces are the same Period discounter: Coupon payments: 0.08 $0.00 0.08 $0.00 0.08 $000 0.08 $50.00 $0.00 550.00 $1,000.00 $10SO DO $714.61 350.00 $39.63 $0. $36.75 $0.00 $45.30 $42.32 Total cash flow Pof annual cash flow Market Price of fond $762.76 Podband: 880 22 When Market Price PV 5162 , then you have the right awer for HINT: Market Price then make allery Market Price then maker Problem 33 des increase or decrease price of the bond verbond n AjWhen a bond is hype your answer there When bondag type your answer here e does the order th e bond bond that pain why MacBook Air 0 - 2004 + FIN 320 Minciples of Finance Chapter 7: Bond Valuation Bands for AC Company have the following characteristics: coupon payments Yield to Maturity of Payments per year 1 value of a bond is calculated in the spreadsheet below to be $109.85 Producent Coupon payment $0.00 Face value payment 008 0000008 $100.00 $100.00 $100.00 $10000 100.00 PV of annual cash flow PV of bond: $0.00 0.00 59000 Saco.00 $82.598 .7357938 $100.00 $93.50 $1,150 MEGA $1,07985 note: $1,073.850.00 59259585.73.79.38.$3.50 $8.64 Problem 1 Suppose the coupons for the band are a of the me Period discount rate: Coupon payments: Face value payment Totalcanh tow V of annual cash flow Given the market price of a bond, the periodiscount est ly there has to found by trader For example, financial actress or of landemer to the period decorated from In the spreadsheet below, you will strand error to find the period ducuntrate Instruction to find the periodist er, by trial and error change the number in the presencial the YTM market b ranges are the same value 008 Period discontratar Coupon payment Face value mere S000 50.00 50.00 50.00 50.00 50.00 $0.00 $4610 40 53868 $36.95 $714.61 Market Price of Band - S762.76 PV of bond $880.22 When Marie Pie 576276, then you have the rower for : > Manto the maker , PCMarket Price the materice Problem Al When a bond is callable, does this increase or decrease the market price at the bond (versus a bond that is not a ble Explain why When abond has a sinking fund feature, does the Type your aner here) the bond bond that has singular plan why MacBook Air