need some help with this spreadsheet! thank you!!

RATE PER PERIOD PRESENT VALUE OF ORDINARY ANNUITY (annuity in arrears - end of period payments) RATE PER PERIOD A corporation issues $3,000,000 of 8%,10-year bonds, interest payable semiannually. At the time the bonds are issued, the market rate is 12%. Determine the present value of the bonds at issuance using the present value table below. Show computations in good form. REMEMBER TO ADJUST THE RATE AND THE PERIODII Hint: multiple the period by 2 (semiannual payment) and divide the rate by 2 (semiannual payment). PRESENT VALUE OF $1