Kim Shaw is considering the purchase of a 18 year bond that pays a coupon rate of 9.75% over the life of the bond (annual payments) and a face value of $1000 that is returned at the bond's maturity. Using a yield to maturity of 9.00%, calculate to the nearest penny the value of the bond today. $ Place your answer in dollar and cents without a dollar sign or comma. For example, an answer of one thousand seventy five dollars and forty five cents would be entered 1075.45. Work your analysis using at least four decimal places of accuracy.

Please show how to do this in excel as well as without software