Assume that the Service company provided services to Smith Company on October 1, 2021,accepting a $500,000, three-year note in payment for the services, assuming a 10% effective interest rate.

Assume that the Service company provided services to Smith Company on October 1, 2021, accepting a $500,000, three-year note in payment for the services, assuming a 10% effective interest rate. Required: 1. Complete the amortization schedule below showing the excel formulas as we did in the demonstration problem. 2. Record all required journal entries for the receipt of the note, amortization of the note and the collection on the note. (See below) Principal on Note Receivable Interest Rate NUMBER OF PERIODS FACE VALUE Principal on Note Receivable PRESENT VALUE OF Note Discount on Note A D AMORTIZATION SCHEDULE E F Present Value Of Note Discount Sales Balance Revenue Principal on Note DATE Debit, Disc. Credit on Notes Interest Receivable Revenue 0 1 2 3 Journal Entries DEBIT CREDIT 10/01/2021 12/31/2021 12/31/2022 12/31/2023 09/30/2024 Assume that the Service company provided services to Smith Company on October 1, 2021, accepting a $500,000, three-year note in payment for the services, assuming a 10% effective interest rate. Required: 1. Complete the amortization schedule below showing the excel formulas as we did in the demonstration problem. 2. Record all required journal entries for the receipt of the note, amortization of the note and the collection on the note. (See below) Principal on Note Receivable Interest Rate NUMBER OF PERIODS FACE VALUE Principal on Note Receivable PRESENT VALUE OF Note Discount on Note A D AMORTIZATION SCHEDULE E F Present Value Of Note Discount Sales Balance Revenue Principal on Note DATE Debit, Disc. Credit on Notes Interest Receivable Revenue 0 1 2 3 Journal Entries DEBIT CREDIT 10/01/2021 12/31/2021 12/31/2022 12/31/2023 09/30/2024