determine due date and interest on notes

Demin due date and instantes De the date and many in the Date of NA Face Amount Interest Rate ry 59.000 Porary 15 10.000 May 4.000 20 74,100 . 19 Terms Note 105 days wo days dey 7 days 5.000 Ayer where The contenitore there may be Note Due Date Inter mi G A B F H 1 Determine due date and interest on notes 2 Determine the due date and the amount of interest due at maturity on the following notes: 3 4 Date of Note Face Amount Interest Rate Term of Note 5 a. January 5 $95,000 4% 105 days 6 b. February 15 16,000 6% 45 days 7 C. May 19 66,000 8% 60 days 8 d. August 20 34,500 5% 90 days 9 e. October 19 55,000 7% 75 days 10 Assume a leap year in which February has 29 days. 11 12 Days in a year 360 13 Select the corresponding dates in the dropdowns in cells B17:B21. Using formulas and cell references, perform the required analysis, and input your answers into the Interest column Transfer the results for the green entry cells (B17:B21 and C17C21) into the appropriate 14 fields in CNOWV2 for grading. 15 16 Due Date Interest Formulas 17 18 19 20 d. 21 22 23 GOOD e