$\backslash$table$[[$LOAN AMORTIZATION SCHEDULE,$],[\backslash$table$[[$PMT$],[$Periods$]],\backslash$table$[[$Beginning$],[$Balance$]],$Payments,$\backslash$table$[[$Payment$],[$Interest$]],\backslash$table$[[$Payment$],[$Principal$]],\backslash$table$[[$Ending$],[$Balance$]]],[1,,,,,],[2,,,,,],[3,,,,,],[4,,,,,],[5,,,,,],[6,,,,,],[7,,,,,],[8,,,,,],[9,,,,,],[10,,,,,]]$

Step $1$: Compute the Payments using the PMT formula adjusted for compounding

Step $2$: Compute the Payment Interest: $=$Beginning Balance $*($Interest Rate$/$Compounding Period$)$

Step $3$: Compute the Payment Principal: $=$Payments $-$ Payment Interest

Step $4$: Compute the Ending Balance: $=$Beginning Balance $-$ Principal

$\backslash$table$[[$Beginning Balance,$$250,000$