have to use pv function in excel

he Sanders Company issued 9.5% bonds, dated January 1 , with a face amount of $8,000,000 on January 1,2023 . The Donds mature on December 31,2032 (10 years). For bonds of similar risk and maturity, the market yield is 11.0%6. nterest is paid semiannually on June 30 and December 31 . Sanders uses the effective interest method. 1. Determine the price of the bonds at January 1, 2023 using Excel's Py function. he Sanders Company issued 9.5% bonds, dated January 1 , with a face amount of $8,000,000 on January 1,2023 . The Donds mature on December 31,2032 (10 years). For bonds of similar risk and maturity, the market yield is 11.0%6. nterest is paid semiannually on June 30 and December 31 . Sanders uses the effective interest method. 1. Determine the price of the bonds at January 1, 2023 using Excel's Py function