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?

Autosave UP File Home Insert Page Layout Formul Times New Roman ~ 12 A" A Paste BIU~ A . Clipboard Font F15 X V A B C b 2 Coupon 3 Par 4 YTM 5 Start 6 0.5 1.0 8 1.5 2.0 10 2.5 11 3.0 12 3.5 13 4.0 14 4.5 15 5.0 16