Leon Corporation issued $400 000 of 10% 10-year bonds payable on January 1 2019. The market interest rate at the date of issuance was 8%, and the bonds pay interest semiannually on June 30 and December 31). Leon Corporation's year end is June 30 Read the requirements. 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 $ Requirements 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 Leon 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 Pearce Corporation issue 580,000 of 6% 10-year bonds payable on March 31 2019. The market interest rate at the date of ssuance was 10% and the bonds pay interest semiannually Pearce Coporation's year-end is March 31 Read the requirements. 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$435.438 2. Prepare an effective-interest amortization table for the bond through the first three interest payments. Round amounts to the nearest dollar Discount Bond Semiannual Discount Carrying Interest Interest Account Interest Date Payment Expense Amortization Balance Amount Requirements Mar 31, 2019 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 thrce interest payments. Round amounts to the nearest dollar. 3. Record Pearce Corporation's issuance of the bonds on March 31. 2019, and payment of the first semiannual interest amount and amortization of the bond discount on September 30, 2019. Explanations are not required. Print Done