On June 30, 2018, the market interest rate is 6%. Winner Corporation issues $500,000 of 7%, 10-year bonds payable. The bonds pay interest on June 30 and December 31. The company amortizes bond premium using the effective-interest method. 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 $ - X Requirements 1. Use the PV function in Excel to calculate the issue price of the bonds. 2. Prepare a bond amortization table for the first four semiannual interest periods. 3. Record the issuance of bonds payable on June 30, 2018; the payment of interest on December 31, 2018, and the payment of interest on June 30, 2019 Print Done