With amortization schedule

Original Size

As the name states, with an interest only loan, the periodic payment amount pays only the interest due for the period. This results in smaller periodic payments until the final payment is due The final payment will include the entire principal amount. When a consumer selects an interest only loan, they are not paying down the loan's balance.

Note: Bonds represent debt, that is a loan to the bond's issuer. Frequently bonds pay only coupon interest and thus they are interest only loans.

This calculator will solve for any one of four possible unknowns: "Amount of Loan", "Total Scheduled Periods" (term), "Annual Interest Rate" or the "Periodic Payment".

Enter a '0' (zero) for one unknown value.

The term (duration) of the loan is a function of the "Total Scheduled Periods" and the "Payment Frequency". If the loan is calling for monthly payments and the term is four years, then enter 48 for the "Total Scheduled Periods". If the payments are made quarterly and the term is ten years, then enter 40 for the "Total Scheduled Periods".

Normally you would set the "Payment Method" to "Arrears" for a loan. This means that the monies are lent on one day and the first payment isn't due until one period after the funds are received.

If the first payment is due on the day the funds are available, then set "Payment Method" to "Advance". This is typical for leases.

Is there a way to change the loan date?

Thank you for asking. Not with this calculator. However, with our

amortization tablethere is.Note, you’ll need to select “interest only” using the “amortization method” drop down.

If you ever have a debt which has some interest only payments followed by regular payments, the time value of money calculator will handle those cases.

Hi

I want to make sure that I am using this calculator right, trying to solve for the payment amount. If I have a loan amount of say $100,000, 9 year loan with a 2% interest rate compounded semi-annually, where interest is paid annually, this is what I put in:

Loan amount $100,000

Number of Payments=18

Annual interest rate =2%

Payment frequency = annually

Compounding – semi-annually

Payment method – arrears

Hi, thanks for the question. Your setup is almost right. You said it’s a 9 year loan with annual payments, so you should enter 9 for the number of payments rather than 18. However, that’s not going to make a difference in the calculated payment amount because the payments are for interest only. So assuming that the payments are made as schedule it does not matter if the term of the loan is 1 year, 9 years or 100 years, the payment amount will be the same – $2,010.00. (2% on $100,000 is $2,000 of course. The $10 is due to the semi annual compounding.)

Hi:

We have the potential of investors loaning money for a fixed period at a fixed rate (simple interest). Example: Pay simple interest monthly for 12 months on a loan of $5,000. Is this the right calculator to use? Also, it appears this a very simple thing to do in Excel, right?

Thanks.

If you need to create a schedule of future, interest only payments showing when they are due with a final payment of principal and interest, then yes, this is the calculator to use.

If you want to track the payments as they are made and calculate the actual interest amount due, allowing for payments that are not necessarily made on the date due, then you should use the Ultimate Financial Calculator. Scroll down the page and see tutorial number 25, after you’ve looked at tutorial 1.