Using Excel to Compute Interest and Maturity Date

PROBLEM

Compute interest and find the maturity date for the following notes using Excel's DATE function. Base the interest calculation on $360$ days per year.

$\backslash$table$[[$Date of Note,$\backslash$table$[[$Face$],[$Value$]],\backslash$table$[[$Interest$],[$Rate $\%]],\backslash$table$[[$Terms in$],[$Days$]]],[$Month$,$Day,Year$],[0,10,2022,$$$80,000,6\%,60],[7,14,2022,$$$50,000,70,90],[4,27,2022,$$$12,000,8\%,75]]$

Required: Provide input into cells shaded in yellow in this template.

Use mathematical formulas with cell references to the Problem area.

Date of Note Interest

June $10$

July $14$

April $27$