I'm using the PV function in excel, but the second and third answer does not come out.

% P6-25 (similar to) Question Help Bond valuationSemiannual interest Calculate the value of each of the bonds shown in the following table, all of which pay interest semiannually. (Click on th icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Bond Coupon interest rate 8% Years to maturity Par Value $1,000 500 100 Required stated annual return 11% 10 13 16 The value of bond Ais S 802.72. (Round to the nearest cent.) The value of bond B is $ 542.90 (Round to the nearest cent.) The value of bond C is $ 91.38. (Round to the nearest cent.)