Question 1:

At the beginning of 2020 Jaja Cor. issued 200,000 bonds for 40 years. The stated rate was 8% and the market rate was 5%.

Instruction:

1- Calculate the carrying value for the bonds at the issuance date using Excel

2- Prepare the amortization schedule using Excel