have been gaining ghe weong answer on excel

Canter Corp purchased fifteen $1,000 6% bonds of Simplex Corporation when the market rate of interest was 12%. Interest is paid semiannually, and the bonds wil mature in six years. Using the PV function in Excel.compute the price Canter paid (the present value) for the bond investment. (Assume that all payments of interest and principal occur at the end of the period. Round your answer to the nearest cent) GLEN Canter paid -11,277.27 on the bond investment