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.