please answer requirements 1-3

Crosby Corporation iswed $550.000 of 14%,10 year bonds paryable on January 1,2022 . The market interest rate at the dale of issuance was 12% and the bonds pay interest semiannitally (on June 30 and Decenber 31) Cronby Corporation's year-end is June 30 Read the cemiroments 1. Using the PV function in Excel, calculate the iswee peice of the bends. (Round your answer to the nearest whicle dolat) The issue price of the bonds is Requirements 1. Using the PV function in Excel, calculate the issue price of the bonds. 2. Prepare an effective-interest amortization table for the bonds through the first three interest payments. Round amounts to the nearest dollar. 3. Record Crosby Corporation's issuance of the bonds on January 1, 2022, and payment of the first semiannual interest amount and amortization of the bond premium on June 30, 2022. Explanations are not required