Monmouth Corporation issued 10 year, 10% bonds with a face value of $2,175,000. The bonds were sold to yield 11%. Interest is payable annually on January 1.

The issuance price of the bond is calculated as $2,046,909.

The bond issuance is recorded as

Cash $2,046,909

Discount on Bonds Payable $128,091

Bonds Payable $2,175,000

In EXCEL, form an amortization table for the whole bond term. The table should be properly labeled and neatly presented in one page. The amounts should have commas and should be rounded to the nearest whole dollar. USE THE EFFECTIVE INTEREST METHOD OF AMORTIZATION.