Note Recrivable asing Excel to amortize the note

Os fanary $1,2024,$ The Oaken llarrel Company was selling a building, The

company received two offers and wants you to run an amortization schedule for

each offer. The bullding originally cost $$950,000$ and had accumulated depreciation

ofstersoot on the date of cale:

offer a$1$: Non Interest bearing note for $750,009\_$ with a current market interest

rate of $4$ the full amount of the note due in $8$ yara

offer a$2$: Intereat$-$bearing note for $600,000$ with a current market interest rate

of $4\%$ with payments of principal and interest due annually en lanuary $1$

beginning in the following year, due in $12$ yearn.

Prepare an amortization schedule for the note receivable for each one of the

offers

Prepare two journal entries for EACH NOTE:

Note $1$:

A$)$ January $1,2024,$ for the proposed initial sale

aB$)$ December $31,2024,$ the end of the first ycar

Note $2$:

A$)$ Jancary $1,2024,$ for the proposed initial sale

B$)$ January $1,2025,$ for the first payment