Homework: Chapter 8/Appendix F Graded Homework Save Score: 0 of 3 pts 7 of 7 (5 complete) HW Score: 66.67%, 10 of 15 pts EF-4B (similar to) :3 Question Help 0 Canter Corp. purchased ten $1,000 4% bonds of Solar Corporation when the market rate of interest was 14%. Interest is paid semiannually, and the bonds will mature in ten 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.) Canter paid on the bond investment. Check