M Pan & Schedule C. WebAdvisor eBook Show Me How Office 365 Calculator 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 $87,000 120 days b. February 15 19,000 45 days May 19 66,000 45 days d. August 20 36,500 75 days e October 19 45,000 75 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 x] Open spreadsheet Round your answers to the nearest della Interest Note Due Date May 4 Previous Next > My Work Submit Assignment for Grading - about blank Aos M Omal YouTube x] Excel Maps M Plan & Schedule C. WebAdvisor template . Saved File Home Insert Data Review View Help Tell me what you want to do 10 A A = 23 Wrap Test Paste Copy Ariel - BIUROA - 3 Format Painter M erge Center $ % 9 % Agent 1 2 A B C D E F G H Determine due date and interest on notes Determine the due date and the amount of interest due at maturity on the following notes: 4 5 6 7 8 9 10 Date of Note Face Amount Interest Rate . January 5 $87 000 b. February 15" 19,000 . May 19 66.000 d. August 20 36.500 . October 19 4 5,000 Assume a leap year in which February has 29 days. Term of Note 120 days 45 days 45 days 75 days 75 days 5% 0% 12 Days in a year 360 Select the corresponding dates in the dropdowns in cells B17-821. Using formulas and cel references, perform the required analysis, and input your answers into the Interest column. Transfer the results for the green entry colls (817 821 and C17.021) into the appropriate fields in CNOWV2 for grading. Due Date interest un RTY A S D F G H J Show Me How Office 365 Calculator 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 Open spreadsheet Round your answers to the nearest dollar. Note Due Date Interest May 4 Mar. 31 July 3 Nov. 3 Jan. 2 Feedback Check my work The due date is the date the note is to be paid Remember the interest rate is stated on an annual basis, while the term is expressed as days. Assume a 30-day year Check My Work Save and Exit Submit Anment for Grading