$018$

$f_x$

A

B

C

D

E

F

G

$H$

$1$

$K$

$4,$ You want to buy a car by taking out a $3$ year loan for $$15,000$ with a $7\%$ interest rate.

A $-$ Create an amortization table of the loan that shows the portion of interest and principal on each payment.

$\backslash$table$[[$Period$,\backslash$table$[[$Beginning$],[$Balance$]],$Payment,Interest,Principal,Ending Balance$],[1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12],[13],[14],[15],[16],[17],[18],[19],[20],[21],[22],[23],[24],[25],[26],[27],[28],[29,,,,,],[30,,,,,],[31,,,,,],[32,,,,,],[33,,,,,],[34,,,,,],[35,,,,,],[36,,,,,]]$

B $-$ Create a stacked column chart that shows interest and principal on each column