Schedule of Amortization of Discount or Premium on a Note Receivable

1. Obtain a $1 bill and type the serial number into the top cell of your EXCEL spreadsheet.

A 60410074C

a. Assume the last 5 digits of the serial number on the $1 bill represents the face value of a Note Receivable. Assume the stated rate is the first digit of the serial number and that the effective rate (market rate) is the 2^nd digit of the serial number. Alternatively, if you would like to work an example of a premium amortization, choose an effective rate that is lower than the stated rate.

b.Calculate the Present Value of the note based on the face values and interest rates determined in step #2, assuming that the note has a 3-year term with interest paid annually on December 31, and that the loan is collateralized by accounts receivable. Record the initial journal entry for the Note Receivable assuming an issue date of January 1.

c. Prepare a schedule of amortization of the discount/premium on the Note Receivable using EXCEL, incorporating appropriate formulas in the various spreadsheet cells.

d. Record all journal entries from issuance of the note through repayment of the note at the end of the 3-year term.