The Balloon, Inc. Company issued 10% bonds, dated January 1, with a face amount of $80 million on January 1, 2021. The bonds mature on December 31, 2030 (10 years). For bonds of similar risk and maturity, the market yield is 12%. Interest is paid semiannually on June 30 and December 31.(FV of $1 (Links to an external site.), PV of $1 (Links to an external site.), FVA of $1 (Links to an external site.), PVA of $1 (Links to an external site.), FVAD of $1 (Links to an external site.) and PVAD of $1 (Links to an external site.))
Required:1.
Determine the price of the bonds at January 1, 2021.
2) Prepare the journal entry to record their issuance by Balloon, Inc. (the bond) issuer on January 1, 2021, interest on June 30, 2021 and interest on December 31, 2021 (at the effective rate).
3) Prepare amortization table IN EXCEL
use the files attached also provide explanation
