I need help filling in the information in the excel spreadsheets, please show the formulas used to obtain the answers in a excel spreadsheet and set up the spreadsheet as the attached spreadsheets are set up, the initial question is below, leave a comment if you have any questions,thank you

4. Consider a semi-annual bond with an annual coupon = 3.0%, maturity = 5 years, par value = $1,000, and a market price today = $700:

a. What is its yield to maturity (YTM)?

b. Suppose the bond can be called at $900 at the end of year 3, what is itsyield to call?