Simply enter your loan information in the cells with the white background and everything else is calculated automatically. Our spreadsheet should be pretty intuitive to use. We've also made a few cosmetic changes and updated comments and help info.Ī commercial use version of this Interest-Only Loan calculator is included as a bonus spreadsheet when you purchase the Loan Amortization Schedule. Update : The main XLSX version for Excel 2007+ has been updated to allow duplicating the loan worksheet (for comparing different loans within the same workbook). It will work for an interest-only loan or interest-only mortgage.
This spreadsheet creates an amortization schedule for a fixed-rate loan, with optional extra payments and an optional interest-only period.
0 kommentar(er)
