Please Please complete in SHEET format!!! My friends will all upvote!! thank youuu! Frenza bond Carrying value :Jan

$1$

$,$

$$year

$1$

:

$1$

$0$

$5$

$6$

$0$

$0$

June

$3$

$0$

$,$

$$year

$1$

:

$1$

$0$

$8$

$0$

$0$

$0$

December

$3$

$1$

$,$

$$year

$1$

:

$1$

$1$

$0$

$4$

$0$

$0$

June

$3$

$0$

$$year

$2$

:

$1$

$1$

$2$

$8$

$0$

$0$

December

$3$

$1$

$,$

$$year

$2$

:

$1$

$1$

$5$

$2$

$0$

$0$

June

$3$

$0$

$$year

$3$

:

$1$

$1$

$7$

$6$

$0$

$0$

December

$3$

$1$

$$year

$3$

:

$1$

$2$

$0$

$0$

$0$

$0$

Cash & inventory for competing companies:

Frenza cash:

$6$

$6$

$0$

$0$

$0$

Frenza inventory:

$3$

$6$

$0$

$0$

$0$

Lika cash:

$3$

$8$

$4$

$0$

$0$

Lika inventory:

$5$

$0$

$4$

$0$

$0$

Nelo cash:

$2$

$1$

$6$

$0$

$0$

Nelo inventory:

$8$

$4$

$0$

$0$

Market rate for company bonds:

Frenza:

$9$

$\%$

Lika:

$7$

$\%$

Nelo:

$4$

$\%$

Net income

Frenza :

$1$

$2$

$0$

$0$

$0$

$0$

Lika:

$2$

$2$

$8$

$0$

$0$

$0$

Nelo:

$1$

$0$

$2$

$0$

$0$

$0$

Total equity:

Frenza:

$4$

$8$

$0$

$0$

$0$

$0$

Lika:

$6$

$3$

$6$

$0$

$0$

$0$

Nelo:

$3$

$3$

$0$

$0$

$0$

$0$

The founder of Frenza asks us to help her in accounting and analysis of her corporations bonds, which have an annual contract rate of

$8$

$\%$

$.$

$$

$1$

$.$

$$Record the issuance of the bonds on January

$1$

$,$

$$year

$1$

$2$

$.$

$$Record the semiannual interest payment and amortization on June

$3$

$0$

$,$

$$year

$1$

$3$

$.$

$$Record the semiannual interest payment and amortization on December

$3$

$1$

$,$

$$year

$1$

$4$

$.$

$$Record the payment of bonds at the maturity date,December

$3$

$1$

$,$

$$year

$3$

$$Assume semiannual interest is already recorded