For each of the scenario please generate an Excel spreadsheet showing a Notes Receivable with the table similar to the one below. Amortization of Bond Discount/Premium and Carrying Value ntoristx) Note nterest Disct/Premium Carrying Value Amortization of NoteX Date Cash Received Revenue Date of issue: End of year 1 End of year 2 End of year 3 Total $0 $0.00 $0.00 SCENARIO 1: ABC Corp makes a loan to one of the clients, J Jones, Inc, for a three-year, $10,000 note bearing interest at 7% annually. The market rate of interest is 8% for a note of similar risk. (1) Is this a discount loan or a premium loan? How can you tell? (2) Fill in the table about for the 3 years of the loan using Excel. SCENARIO 2: ABC Corp makes a lo bearing interest at 5% annually. The market rate of interest is 4% for a note of similar risk. an to one of the clients,JJ Jones, Inc, for a three-year, $10,000 note (3) Is this a discount loan or a premium loan? How can you tell? (4) Fill in the table about for the 3 years of the loan using Excel