Smith Company borrows cash by issuing a bond payable with the following terms: $8,000,000, 8% bond Issued on 1/1/21 Matures in 12 years Semi-annual interest payments on 6/30 and 12/31 of each year Market rate for bonds of this type was 7% at the time of their issue Required a. Compute the cash proceeds from the issuance of the bond. b. Create an effective interest amortization table in Excel for the entire life of the bond payable using the following columns: payment number, payment date, beginning carrying value, effective interest rate, interest expense, cash (interest paid), discount/premium on bond payable (amortization amount), and ending carrying value. The goal of any bond amortization spreadsheet it to prove that, at the maturity date of the bond, the premium or discount has been reduced to zero and the remaining carrying value of the bond is its face value (the amount to be paid in full at maturity). These spreadsheets are important in practice because they serve as the basis for journal entries for every interest payment date and for adjusting journal entries at each year-end. NOTE: You should use normal Excel calculations and formulas for the completion of this assignment. However, you are NOT allowed to use a pre-built Excel template c. Once your table is complete, tell me: What is the journal entry on 1/1/21 to issue this bond? What is the journal entry on 6/30/21, the first interest payment date? What is the journal entry on 12/31/21, the second interest payment date?