REQUIRED:

Prepare the amortization table through using the effective interest rate method. $($Note: Rounding

differences may occur in spreadsheet software.$)$

Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells

show in the orange cells. Transfer amounts to CNOWv$2$ for grading. This spreadsheet has been formatted to round numbers

to the nearest cent. For example, $17\mathrm{.}651\mathrm{.}5=26\mathrm{.}475.$ The amount will display and hold $26\mathrm{.}48,$ not $26\mathrm{.}475.$ There is no

need to use Excel's rounding function.