CALC 1 Home Documentation Home Contact

# CALC 1 Amortization Examples using the TVM Calculator.

These are examples for calculating interest, principle and balance for any two periods using the Time Value of Money Calculator.

Calculate the interest, principal and balance for a 120,000 loan for 30 years at 6.125% per year with 12 payments per year of \$-729.13 for the first 9 periods.

If you have just used the TVM calculator to calculate the payment amount for the loan, the N, I/YR, PV, PMT and P/YR values have been retained and do not need to be entered.

Value Keystrokes Display Description
shift, C TVM   Clears the financial variables.
shift, B/E   To toggle the BEG / END mode so the BEG indicator is not displayed.
12 STO, P/YR 12.00 Sets the payments per year. This also sets the compounding periods to the same value if using the Focused Calculator.
30 shift, xP/YR 360.00 Sets the total number of payments to the value in x (30) times the payments per year.
6.125 I/YR 6.125 Stores the annual interest rate.
120000 PV 120,000.00 Stores the loan amount, PV.
PMT -729.13 Calculate the monthly payment.
9 STO PER2 9.00 Stores period 2.
AMORT -5,490.80 Calculate the interest paid.
ROLL -1,071.37 Displays the principal paid.
ROLL 118,928.63 Displays the balance

You can view all 3 results by setting the number of rows in options to 3. Or, you can swipe up to increase the number of rows to display. You can also use the INT, PRIN and BAL keys to calculate the individual values.

The History details will also show the calculation results:

Calculates the Interest, Principal and Balance
1.00 : From period 1.
9.00 : To period 2.
6.13 : The annual rate.
120,000.00 : The present value.
-729.13 : The payment.
12.00 : Payments per year.
12.00 : Compounding periods per year.
0.00 : Payments due at end.
-5,490.80 : Interest paid.
-1,071.37 : Principal paid.
118,928.63 : Balance.

Now calculate the values for periods 10 to 21.

Value Keystrokes Display Description
Next P 21.00 Calculates and stores the next values for PER1 and PER2.
AMORT -7,242.53 Calculate the interest paid.
ROLL -1,507.03 Displays the principal paid.
ROLL 117,421.60 Displays the balance

Now calculate the values for periods 22 to 33.

Value Keystrokes Display Description
Next P 33.00 Calculates and stores the next values for PER1 and PER2.
AMORT -7,147.58 Calculate the interest paid.
ROLL -1,601.98 Displays the principal paid.
ROLL 115,819.62 Displays the balance

Now calculate the values for periods 33 to 35.

Value Keystrokes Display Description
33 STO PER1 33.00 Stores the value for PER1.
35 STO PER2 35.00 Stores the value for PER2.
AMORT -1,773.48 Calculate the interest paid.
ROLL -413.91 Displays the principal paid.
ROLL 115,542.98 Displays the balance

Now calculate the values for period 120.

Value Keystrokes Display Description
120 STO PER1 120.00 Stores the value for PER1.
120 STO PER2 120.00 Stores the value for PER2.
AMORT -515.37 Calculate the interest paid.
ROLL -213.76 Displays the principal paid.
ROLL 100,756.46 Displays the balance

Note that the when summing the results that the values are rounded to the number of decimal places set. This is a common practice with calculators, but not spreadsheets.