Education Technology

# Knowledge Base

## Solution 31111: Creating an Amortization Table with the TI-Nspire™ Family Handhelds or TI-Nspire™ Family Software.

### How do I create an amortization table with the TI-Nspire Family Handheld or TI-Nspire Family Software?

To create an amortization table, please follow the command as shown below:

amortTbl(NPmt,N,I,PV, [Pmt], [FV], [PpY], [CpY], [PmtAt],[roundValue])

Example: amortTbl(12,60,10,5000,,,12,12)

You can access the amorTbl( command by selecting the calculator page and pressing the catalog key followed by the letter [A]. Then key in the values above to generate a table.

The amortization function returns a matrix as an amortization table for a set of TVM arguments.

NPmt is the number of payments to be included in the table. The table starts with the first payment.

N, I, PV, Pmt, FV, PpY, CpY, and PmtAt are described in the table of TVM arguments.

PmtAt is the payment due at the end or beginning of each period, default is always = end. PpY and CpY can be changed depending if compounding annually, monthly, or semiannually.

• If you omit Pmt, it defaults to Pmt=tvmPmt(N,I,PV,FV,PpY,CpY,PmtAt).
• If you omit FV, it defaults to FV=0.

roundValue specifies the number of decimal places for rounding. The Default is 2.

The amortization table looks like a matrix with column and rows.

The columns in the result matrix are in this order: Payment number, amount paid to interest, amount paid to principal, and balance.

The balance displayed in row n is the balance after payment n.

Optional: There is a tns file attached and is ready to use. You may load the file into you handheld or open it with your software. You can then edit the TVM solver with your own data and the table will change to reflect your input. To view the default value, open the tns file and follow the instruction on the first page to view the amortization table.

To edit the TVM solver:

• Open the calculator page and press [menu]>8:Finance>1: Finance Solver

• Press enter to key in the data and compute for [PMT]

To view the table, move over to the next page.

Column [A] = Payment
Column [B] = Interest
Column [C] = Principle
Column [D] = Balance