Interest-Only Loan Calculator
The Vertex42™ Interest-Only Loan Calculator is a very powerful spreadsheet based on our popular Loan Amortization Schedule. It helps you calculate your interest only loan payment for a fixed-rate loan or mortgage and allows you to easily specify the length of the interest-only (IO) period as well as include extra payments.
What is an Interest-Only Mortgage Loan?
Both fixed-rate and variable-rate loans and mortgages often give you an interest-only payment option. This option allows you to make payments, for a certain number of years, that include interest only (no principal). The result is a lower initial payment.
During the interest-only period, you are usually allowed to make extra payments on the principal if you want to, without paying any penalty fees.
At the end of the IO period, the payment is calculated based on the number of years you have remaining on your loan and your current balance.
Interest Only Loan Calculator
for Excel
This spreadsheet creates an amortization schedule for a fixed-rate loan, with optional extra payments and an optional interest-only period. It will work for an interest-only loan or interest-only mortgage.
A commercial use version of this Interest-Only Loan calculator is included as a bonus spreadsheet when you purchase the Loan Amortization Schedule.
"No Installation, No Macros - Just a simple spreadsheet - An original creation by Dr. Jon Wittwer of Vertex42.com"
Rate this Interest Only Loan Calculator
Is an Interest-Only Loan Good for Me?
I can't answer that for you, but I would strongly recommend reading through the material listed in the references below. A fixed-rate loan with an interest-only option is fairly simple to understand and predict, but interest-only mortgages with adjustable rates seem much more risky.
How to use the Interest-Only Calculator
Our spreadsheet should be pretty intuitive to use. Simply enter your loan information in the cells with the white background and everything else is calculated automatically. If you want to include extra payments, you enter them in the amortization table.
Be sure to read the comments within the file (marked with a little red triangle on some of the cells) if you have questions.
Interest-Only Loan References
- Interest-Only Mortgage Tutorial at mtgprofessor.com - A must-read for anyone looking into interest-only loans or interest-only mortgages.
- Misconceptions About Interest-Only Mortgage Loans at mtgprofessor.com - Another must-read.
