Problems In either a Word document or Excel spreadsheet complete the following problemos. . You may solve the problems algebraically, or you may use a financial calculator or an Excel spreadsheet. If you choose to solve the problems algebraically, be sure to show your computations. . If you use a financial calculator, show your input values If you use an Excel spreadsheet, show your input values and formulas In addition to your solution to each computational problem, you must show the supporting work leading to your solution to receive credit lor your answer Compute the following 1. Assuming semi-annual compounding, what is the price of a zero coupon bond that matures in 3 years it the market interest rate is 5.5 percent? Assume par value is $1000, 2. Using semi-annual compounding, what is the price of a 5 percent coupon bond with 10 years left to maturity and a market interest rate of 7.2 percent? Assume that interest payments we paid semi-annually and that par value is $1000). 3. Using semi-annual compounding, what is the yield to maturity on a 4.65 percent coupon bond with 18 years left to maturity that is offered for sale at $1,025.959 Assume par value is $1000