Waidron Corporation inued $500.000 at 6%, 10 year bendu paryable on January 1, 2018. The market interest rate at the date of issuance wa 4%, and the banda pay interest termiannually on June 30 and December 31). Waldron Corporation's year-end is June 30 Read the requirements 1. Using the PV tunellon in Excel", cntculate the inne price of the bonde (Round your answer to the nearest whole dolue) The issun price of the bonds is i 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 Waldron Corporation's issuance of the bonds on January 1, 2019, and payment of the first semiannual interest amount and amortization of the bond premium on June 30, 2019. Explanations are not required. Print Done Premium Bond Semiannual Interest Interest Premium Account Carrying Amount Interest Date Payment Expense Amortization Balance Jan 1, 2019 Jun 30, 2019 Dec 31, 2019 Jun 30, 2020