Given that you want to borrow $$8000$ for $2$ years at $8\%$ use a spreadsheet to calculate payment #$20$

$\backslash$table$[[\backslash$table$[[$Payment$],[$Number$]],\backslash$table$[[$Principle$],[$Portion$]],\backslash$table$[[$Interest$],[$Portion$]],$Payment,Balance$],[0,,,,8000],[1,308\mathrm{.}49,53\mathrm{.}33,361\mathrm{.}82,7691\mathrm{.}51]]$

$\backslash$table$[[20,10+10$