STEP $8$: Payments, Total Amount Paid, and Total Interest Paid $($can copy from spreadsheet$)$

$($Do not use the interest rates below. Use the ones you found in Step $6$ above.$)$

$\backslash$table$[[$Months$,$Interest Rates and Payments,$],[48,6\mathrm{.}00\%,7\mathrm{.}00\%,8\mathrm{.}00\%,9\mathrm{.}00\%$

$3511/$instructionsproj$2.$pdf

STEP $5$: List

CarsDirect.com Price $($or price from similar source$)$

STEP $6$: List Current Interest Rates: $48$ months $-6\mathrm{.}00\%$;$60$ months $-6\mathrm{.}25\%$;$72$ months $-6\mathrm{.}75\%($List the most current interest rates you found, not the ones listed here as examples.$)$

STEP $7$: Amount to be Financed Calculation $($can be copied from spreadsheet$)$

New Car Price

Registration

Document Prep and Related Fees Total New Car Price Before Taxes Trade$-$In Credit for Current Car Net Cost of New Car after Trade$-$In Taxes

Tag, Title, and Related Charges & Fees Total Before Payoff of Trade$-$In Vehicle Plus Payoff on Trade$-$In Vehicle Balance Due $("$amount to be financed"$)$

$$25,499$

$99$

$699$

$$26,297$

$5,400$

$$20,897$

$1,463$

$46$

$$22,406$

Assumes the payoff on the trade$-$in vehicle is $50\%$ of its trade$-$in value.

STEP $8$: Payments, Total Amount Paid, and Total Interest Paid $($can copy from spreadsheet$)($Do not use the interest rates below. Use the ones you found in Step $6$ above.$)$ Months Interest Rates and Payments

$48$

$60$

$72$

$6\mathrm{.}00\%$

$$589\mathrm{.}62$

$6\mathrm{.}25\%$

$$488\mathrm{.}29$

$6\mathrm{.}75\%$

$$425\mathrm{.}02$

$7\mathrm{.}00\%$

$$601\mathrm{.}19$

$7\mathrm{.}25\%$

$$500\mathrm{.}10$

$7\mathrm{.}75\%$

$$437\mathrm{.}13$

$8\mathrm{.}00\%$

$$612\mathrm{.}91$

$8\mathrm{.}25\%$

$$512\mathrm{.}07$

$8\mathrm{.}75\%$

$9\mathrm{.}00\%$

$$624\mathrm{.}76$

$9\mathrm{.}25\%$

$$524\mathrm{.}21$

$9\mathrm{.}75\%$

$$461\mathrm{.}95$

STEP $9$: Answer Interest Questions

Total Interest Paid months at $6\%$

Total Interest Paid months at $6\mathrm{.}75\%$

Total Interest Paid months at $9\%$

$$2,299\mathrm{.}68$ more

$$1,686\mathrm{.}72$ more

MacBook Air