can someone please help me work these problems? i think there might be an excel formula for them? preferrably if there is an excel formula if there is one?

thank you

Bond valuation-Semiannual interest Find the value of a bond maturing in 5 years, with a $1,000 par value and a coupon interest rate of 9% (4.5% paid semiannually) if the required retum on similar-risk bonds is 13% annual interest (6.5% paid semiannually) The present value of the bond is 5 (Round to the nearest cent.) Future value of an annuity Using the values below, answer the questions that follow. (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Amount of annuity $7,000 Interest rate 11% Deposit period (years) 8 a. Calculate the future value of the annuity, assuming that it is (1) An ordinary annuity. (2) An annuity due b. Compare your findings in parts a(1) and a(2). All else being identical, which type of annuity-ordinary or annuity dueis preferable as an investment? Explain why. a. (1) The future value of the ordinary annuity is $ (Round to the nearest cent.) Present value of an annuity Consider the following case. (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Amount of annuity $10,000 Interest rate 7% Period (years) 15 a. Calculate the present value of the annuity assuming that it is (1) An ordinary annuity. (2) An annuity due. b. Compare your findings in parts a(1) and a(2). All else being identical, which type of annuity-ordinary or annuity dueis preferable? Explain why. The present value of the ordinary annuity is $. (Round to the nearest cent.)