complete all requirements, most people don't complete the entire question and if you dont complete it all I will down vote

Gilmartin Corporation issued $600,000 of 6%,10-year bonds payable on January 1,2022 . The market interest rate at the date of issuance was 4%, and the bonds pay interest semiannually (on June 30 and December 31). Gilmartin Corporation's year-end is June 30 . Read the requirements 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 Gilmartin 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. Gilmartin Corporation issued $600,000 of 6%,10-year bonds payable on January 1,2022 . The market interest rate at the date of issuance was 4%, and the bonds pay interest semiannually (on June 30 and December 31). Gilmartin Corporation's year-end is June 30 . Read the equirements. 1. Using the PV function in Excel, calculate the issue price of the bonds. (Round your answer to the nearest whole dollar.) The issue price of the bonds is