Example 14 - Interest Only Payments

This example applies to our online demo Time Value of Money Calculator. The C-Value! program for Windows works in a similar way and has a few more features. Note, our online demo TVM calculator is limited to calculations using interest rates between 2.0% and 8.9%

A "Special Series", 5 year loan with first year's payments paying only the accrued interest.

For greater detail about how values are entered into the TVM calculator, please see Example 1 - conventional mortgage or loan.

To create a loan schedule with a series of initial interest only payments, follow these steps:

1. Click the [New] button to clear any previous entries.
2. Set "Rounding" to "Ignore" by clicking on the "Rounding" button.

3. Set "Compounding" to "Monthly"
4. Enter 5.625% for the "Nominal Annual Rate".
5. Create a "Loan" event in row one of the cash flow input area.

1. Set the "Date" to November 1, 2012 (mm/dd/yyyy)
2. Set the "Amount" to $94,000.00
3. Set the "# Periods" to 1.

6. Move to the second row of the cash flow input area. Select "Payment" for the "Event" type. Initially, the regular payment amount is unknown.

1. Set the "Date" to December 1, 2012
2. Set the "Amount" to "Unknown"
3. Set the "# Periods" to 12.

7. Display the "Special Series Window" by clicking in the second row's right most column under "Special Series...".

1. Select the "Interest Only" tab at the top of the window.
2. Be sure "Activate Interest Only series for the currently highlighted event" is checked.
3. Click [OK]. Notice that the "Amount" column will now say "Interest Only".

The "Special Series" window will look like this.

8. Move to the third row of the cash flow input area. Select "Payment" for the "Event" type. Initially, the regular payment amount is unknown.

1. Set the "Date" to December 1, 2013
2. Set the "Amount" to "Unknown"
3. Set the "# Periods" to 48.

Your screen will look like this:

9. Calculate the unknown. The result is $2,191.47
10. If you want to see a detailed amortization schedule showing the monthly payment allocated between principal and interest click on the "Schedule" tab above the input area.

Back to the online Time Value of Money Calculator.