Complete the work outlined below in excel.$$

$$

A company has the following debt issues and uses the effective interest method to amortize discounts$/$premiums$.$ Information for each is below:

$$ There was a bond issue with a par value of $$800,000($Bond #$1)$ on July $1,2021$ when the market rate of interest was $10\%.$ The bonds have a coupon rate of $9\mathrm{.}25\%$ and interest is paid semiannually on January $1$ and July $1.$ The bonds have a nine$-$year life when issued. This bond issue is convertible into common stock at the rate of $15$ shares for every $$1,000$ of face value $($note $-$ common stock has a par value of $$2$ per share$).$ On January $2,2026,$ $$100,000$ of face value was converted into common stock.$$ The company uses the book value method to record conversions. The market price of the stock was $$100$ per share when the bonds were converted.

$$ On February $1,2019,$ the company had a bond issue with principal of $$300,000($Bond #$2).$ The bond issue has a ten$-$year life.$$ Interest is payable semi$-$annually on February $1$ and August $1.$ The coupon rate is $8\mathrm{.}5\%.$ The market rate of interest at issue was $8\%.$ On August $2,2024,$ the company called the entire bond issue at $110.$

$$ On November $1,2020,$ the company issued serial bonds at par.$$ The face value of the issue was $$500,000,$ and the coupon interest rate is $6\%.$ Interest is paid semi$-$annually on May $1$st November $1$st$.$ The principal will be paid with ten annual equal payments of $$50,000$ on November $1$ from $2021$ through $2030.$

$$ On April $1,2021,$ the company purchased a building for $$450,000$ financed by a mortgage.$$ The mortgage has an $8\%$ annual rate of interest, a ten$-$year life, and requires equal quarterly payments on March $30$th$,$ June $30$th$,$ September $30$th$,$ and December $31$st$.$

$$ On March $1,2021,$ the company issued a zero$-$coupon bond with a face value of $$250,000$ that matures on March $1,2025.$ The market rate of interest for this bond is $8\%.$

$$

Required: $($Create a separate tab in excel for each of the following$)$

$1.$ For Bond #$1$:

a$.$ Compute the bond price.

b$.$ Prepare an amortization table for the life of the bond.

c$.$ Prepare all required journal entries for $2021$ and $2022.$

d$.$ Record the bond conversion on January $2,2026.$

e$.$ Prepare a new amortization table effective after the bond conversion.

f$.$ Prepare a journal entry for the interest payment on July $1,2026$

$$

$2.$ For Bond #$2$:

a$.$ Compute the bond price.

b$.$ Prepare an amortization table for the life of the bond.

c$.$ Prepare the entry required on $12/31/20$ for the accrual of interest.

d$.$ Prepare all required journal entries for $2021$ and $2022.$

e$.$ Record the bond call on August $2,2024.$

$3.$ For the serial bond, prepare all required journal entries for $2020,2021,$ and $2022.$

$4.$ For the mortgage:

a$.$ Compute the required quarterly payment.

b$.$ Prepare an amortization table for the life of the mortgage.

c$.$ Prepare all required journal entries for $2021$ and $2022.$

$5.$ For the zero$-$coupon bond:

a$.$ Compute the bond price.

b$.$ Prepare all required journal entries for $2021$ and $2022.$

$6.$ The company is preparing its balance sheet at December $31,2022.$ Create and complete the following table in excel to show how each debt issue would be presented:

$$

$$ Current$$ Noncurrent

$$ Liability$$ Liability

$$

Bond #$1$

Bond #$2$

Serial Bond

Mortgage

Zero$-$coupon bond