can you work it out by hand rather than excel, so i can understand it better

but if you need to, its fine

Shriver Corp. purchased fifteen $1,000 6 % bonds of Current Power Corporation when the market rate of interest was 8 %. Interest is paid semiannually, and the bonds will mature in seven years. Using the PV function in Excel, compute the price Shriver paid (the present value) for the bond investment. (Assume that all payments of interest a principal occur at the end of the period. Round your answer to the nearest cent.) Shriver paid on the bond investment