Excel Case#2:Preparation of Bond and Loan Amortization Tables:

Part 1:

A)Prepare a Premium Bond Amortization Table based on the following Given information:

Soda Corporation issued a 4.0%, 30-year bond, dated January 1, 2022 with a face value of $5 million on January 1, 2022.The market yield for bonds of similar risk and maturity was 3.8%. Interest is paid to investors semiannually on June 30 and December 31.

B)Prepare a Discount Bond Amortization Table with the following Given information:

Forma Corporation issued a 4.1%, 25-year bond, dated January 1, 2022 with a face value of $7 million on January 1, 2022.The market yield for bonds of similar risk and maturity was 4.15%. Interest is paid to investors semiannually on June 30 and December 31.

Part 2:Prepare an Installment Loan (Note) Amortization Table based on the following Given information:

Small Motors Company obtained a 4-year loan from its bank in the amount of $225,000. The loan was dated October 1, 2021 and terms of the loan require Small Motors Company to make monthly payments on the last day of each month beginning October 31, 2021 until the loan is paid in full. The stated annual interest rate for the loan is 4.5%.