This Loan Payoff Calculator for Google Sheets will help you to:
Create a loan amortization schedule and fully pay off your loan (e.g. mortgage, car loan, student loan or other loan type with a fixed interest rate and regular payment)
Track your payment plan towards your principal and interest
Be able to make extra payments towards your principal!
In addition to payment frequency, you can enter in your interest compound period (e.g. weekly, monthly, semi-annually etc.).
This loan repayment calculator is easy to use and fully automated with a chart, summary and detailed breakdown!
There is also an extensive instructions manual containing how to use this loan tracker template as well as additional tips on how to save and make more money.
This amortization loan tracker will NOT work if you have a variable interest rate or balloon payment structure. It will only work for loans with a fixed interest rate and regular payment.
The payment will break down to show your principal and interest portions. If your payment includes taxes, insurance or other components, these will NOT be shown.
This amortization schedule will NOT work with credit cards. If you're looking for a spreadsheet that will automatically reorder your credit card debts to create an optimal payment plan, here's a debt payoff calculator.
Digital Download: This is a digital file. No physical product will be sent.
Google Sheets: This product has been designed for use in Google Sheets. If you'd like to use it in Excel, here's the Excel version.
Editable: Certain cells are editable. I've locked some cells to prevent accidental changes to formulas and graphs, but all cells can be unlocked. See the instructions for more details.
Support: If you need help with this product or have inquiries, contact us. We will respond as quickly as we can.
Final Sale: All sales are final. Due to the type of product, these digital products are non-refundable.
Copyright: Products are copyrighted. These products are meant for personal and not commercial use. Please do not copy, share, redistribute or resell these products.
We take pride in creating simple, but comprehensive products at an affordable price. If you need something custom made, feel free to reach out. We are always trying to improve our products so any recommendations or thoughts are greatly appreciated.
If you have a question or would just like to say hi, contact me or connect with me on social media.