this is my last attempt for this question please make sure the answer is correct and clear thank you

Score: 0 of 3 pts 7 of 7 complete HW Score: 51.94% 7.79 of 15 X EF-4B (similar to) Question Help Barwel Corp. purchased five $1,000 8% bonds of Simplex Corporation when the market rate of interest was 14%. Interest is paid semiannually, and the bonds will mature in four years. Using the PV function in Excel.compute the price Barnwell paid (the present value) for the bond investment. Assume that all payments of trust and principal end of the period. Round your wiwer the newest cert) on the bond investment Enter any number in the ed elds and then clickCheck Answer All parts showing Final Check MacBook Air