ok Show Me How Office 365 Calculator Entries for discounted note payable A business issued a 60-day note for $51,000 to a bank. The note was discounted at 7%. Assume a 360-day year. This information has been collected in the Microsoft Excel Online fille. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Journalize the entry to record the issuance of the note. Record debits first, then credits. If an amount box does not require an entry, leave it blank. Round your answers to the nearest dollar. Debit Credit Account Cash Interest Expense Notes Payable b. Journalize the entry to record the payment of the note at maturity. Record debits first then credits fan amount box does not require an entry, leave it blank Round your answers to the nearest dollar Debit Credit Account Notes Payable Cash & Check My Work Previous Next > Save and Exit Submit Assignment for Grading NRN WIA X Excel template - Saved File Home Insert Data Review View Help Tell me what you want to do Arial 10 AA EE Wrap Text General format Power R A Merge Center $ % 9 2 Alignment 1 2 Entries for discounted note payable The data for a loan are provided in the table below DATA $51,000 5 6 7 8 Principal amount of note Nobedscount rate Term of not denys Number of days per year Journalize the entry to record the transactions Select the corresponding accounts in the dropdowns in cells A13 A15, A18 A19. Using formulas and correferences, perform the required analysis, and input your answers into the Debitor Credit columns respectively. If an amount box does not require an entry, Inave it blank Transfer the numere results for the green entry cells (C13.015, C16 019) into the appropriate fields in CNOWV2 for grading Account Debit Credit 17 . Account Debit Credit Data