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

$$,913,954.$

Requirement $2.$ Prepare an amortization table for the first four semiannual interest periods.

Enter the issue date information, then complete the table for each of the following semiannual interest periods. $($Round your answers to the nearest whole dollar.$)$

Jun $30,2021$

Requirements

Use the PV function in Excel to calculate the issue price of the bonds.

Prepare a bond amortization table for the first four semiannual interest

periods.

Record the issuance of bonds payable on June $30,2021$; the payment of

interest on December $31,2021$; and the payment of interest on June $30,$