On December 31, 2020, Stellar Company signed a $1,284,300 note to Pearl Bank. The market interest rate at that time was 12%. The stated interest rate on the note was 10%, payable annually. The note matures in 5 years. Unfortunately, because of lower sales, Stellars financial situation worsened. On December 31, 2022, Pearl Bank determined that it was probable that the company would pay back only $770,580 of the principal at maturity. However, it was considered likely that interest would continue to be paid, based on the $1,284,300 loan. please show the full answer in excel spreadsheet, thank you

Determine the amount of cash Stellar received from the loan on December 31, 2020. (Round present value factors to 5 decimal places, e.g. 0.52513 and final answer to O decimal places, e.g. 5,275.) Amount of cash Stellar received from the loan $ Prepare a note amortization schedule for Pearl Bank up to December 31, 2022. (Round answers to 0 decimal places, e.g. 5,275.) Note Amortization Schedule (Before Impairment) Cash Received Interest Revenue Increase in Carrying Amount Carrying Amount of Note Date 12/31/20 12/31/21 $ 12/31/22 Determine the loss on impairment that Pearl Bank should recognize on December 31, 2022. (Round present value factors to 5 decimal places, e.g. 0.52500 and final answer to O decimal places, e.g. 5,275.) Loss due to impairment $