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 *	$94,000			8%	135 days
b.	February 15 *	19,000			6	30 days
c.	May 19	62,000			5	45 days
d.	August 20	32,300			8	75 days
e.	October 19	50,000			5	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.

Round your answers to the nearest dollar.

Note	Due Date	Interest
a.	Jan. 17Mar. 16May 19July 3Nov. 3	$ fill in the blank 3
b.	Jan. 17Mar. 16May 19July 3Nov. 3	fill in the blank 5
c.	Jan. 17Mar. 16May 19July 3Nov. 3	fill in the blank 7
d.	Jan. 17Mar. 16May 19July 3Nov. 3	fill in the blank 9
e.	Jan. 17Mar. 16May 19July 3Nov. 3	fill in the blank 11

Determine due date and interest on notes Determine the due date and the amount of interest due at maturity on the following notes: * Assume a leap year in which February has 29 days. Days in a year 360 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 appropriate fields in CNOWv2 for grading