Winner Ltd, is authorized to issue $ 2, 000, 000 of 3%, 10-year bonds payable. On December 31, 2014, when the market interest rate is 7%, the company issues $ 1.500, 000 of the bonds. Winner Ltd, another bond discount by the effective-interest method. The semiannual interest dates are June 30 and December 31. Requirements Use the PV function in Excel to calculate the issue price of the bonds. Prepare a bond amortization table for the first year of the bonds. record issuance of bonds payable on December 31, 2014; the first semiannual interest payments on June 30, 2015; and the second payment on December 31, 2015. Requirement Use the PV function in Excel to calculate the issue price at the bonds