Chapter 8 Homework b. 4 C. 8 Determine due date and interest on notes Determine the due date and the amount of interest due at maturity on the following notes: Date of Note Face Amount Interest Rate Term of Note a. January 5 $83,000 7% 135 days February 15 20,000 45 days May 19 74,000 45 days d. August 20 37,000 75 days e. October 19 54,000 90 days Assume a leap year in which February has 29 days. Assume 360 days in a year when computing the interest. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. 7 Open spreadsheet Round your answers to the nearest dollar. Note Due Date Interest May 19 Mar. 31 July 3 a. b. c. d. Nov. 3 Jan. 17 template Edit A B D E H J 4 7% 7% 75 days 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 Date of Note Face Amount Interest Rate Term of Note 5 a. January 5 $83,000 135 days 6 b. February 15 20.000 4% 45 days 7 c. May 19 74.000 8% 45 days 8 d. August 20 37.000 9 e. October 19 54,000 90 days 10 Assume a leap year in which February has 29 days. 11 12 Days in a year 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 C17:C21) into the 14 appropriate fields in CNOWV2 for grading 15 16 Due Date Interest Formulas 17 ja 18 b. 360 19 20 d 21 22 23