What is answer for the issue price of bond. Formula I need is for excel is =-pmt(rate, Nper,pmt, fv, type)?

The Bridget Rittinghouse Company issues 6%, 4-year bonds with a par value of $410,000 and semiannual interest payments On the issue date, the annual market rate for these bonds is 7%. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cells addresses. Entering a value will be marked as incorrect Par Value Term (years) Annual market 96 Annual contract % Payments per year $410,0 What is the amount of each semiannual interest payment? How many semiannual payments of $12,300 will be made in total? Using the PV function, calculate the issue price of the bond Make sure the formula returns a positive value. See the instructions tab for help on the PV function. $12 300 Complete the amortization schedule for these bonds Semiannual Cash Interest Bond Interest Discount Unamortized Interest Period Paid Carrying Value Expense Amortization Discount Instructions Bond1 Bond 2G dy Type here to search