Goal Ltd. is authorized to issue $2,000,000 of 3%, 10-year bonds payable. On December 31, 2018, when the market interest rate is 5%, the company issues $1,600,000 of the bonds. Goal amortizes bond discount using the effective-interest method. The semiannual interest dates are June 30 and December 31. Read the requirements. Requirement 1. Use the PV function in Excel to calculate the issue price of the bonds. (Round your answer to the nearest whole dollar.) The issue price of the bonds is $ Enter any number in the edit fields and then click Check Answer. ? Goal Ltd. is authorized to issue $2,000,000 of 3%, 10-year bonds payable. On December 31, 2018, when the market interest rate is 5%, the company issues $1,600,000 of the bonds. Goal amortizes bond discount using the effective-interest method. The semiannual interest dates are June 30 and December 31. Read the requirements. Requirement 1 Use the PV function in Excel to calculate the issue price of the hands (Round vour answ X i Requirements The 1. Use the PV function in Excel to calculate the issue price of the bonds. 2. Prepare a bond amortization table for the first year of the bonds. 3. Record the issuance of the bonds payable on December 31, 2018; the first semiannual interest payment on June 30, 2019; and the second payment on December 31, 2019. Print Done ? Enter any number in the edit fields and then click Check