EXCEL Assignment $-$ Chapter $6$: Accounting for Amortization of Discount$/$Premium on a Note Receivable

Assume your company is loaning cash to another entity to be repaid in $3$ years. You will determine the present value of the Note Receivable, record the issuance of the Note, and all accounting entries through the end of the $3$ year period.

Instructions:

Obtain a $$1$ bill and type the serial number into the top cell of your EXCEL spreadsheet. Do not use the same $$1$ bill as another ACCT$313$ student. This is to ensure that every student has a unique problem.

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.

Calculate the Present Value of the note based on the face value 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.$

Prepare a schedule of amortization of the discount$/$premium on the Note Receivable using EXCEL, incorporating appropriate formulas in the various spreadsheet cells. Use the effective interest method of amortization of the discount or premium.

Record all journal and adjusting entries from issuance of the note through receipt of the principal at the end of the $3-$year term.EXCEL Assignment $-$ Chapter $6$: Accounting for Amortization of Discount$/$Premium on a Note Receivable

Assume your company is loaning cash to another entity to be repaid in $3$ years. You will determine the present value of the Note Receivable, record the issuance of the Note, and all accounting entries through the end of the $3$ year period.

Instructions:

Obtain a $$1$ bill and type the serial number into the top cell of your EXCEL spreadsheet. Do not use the same $$1$ bill as another ACCT$313$ student. This is to ensure that every student has a unique problem.

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.

Calculate the Present Value of the note based on the face value 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.$

Prepare a schedule of amortization of the discount$/$premium on the Note Receivable using EXCEL, incorporating appropriate formulas in the various spreadsheet cells. Use the effective interest method of amortization of the discount or premium.

Record all journal and adjusting entries from issuance of the note through receipt of the principal at the end of the $3-$year term.