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.
Here's an instructional video on the Loan Payoff Schedule o give you an inside look at how it works:
Please note:
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.
Features:
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: 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.
Other Important information:
How to Download: Once payment is complete, the digital file(s) will be available for download and an email will be sent to you. If there are any issues, here's an article about how to download digital items.
Support: If you need help with this product or have inquiries, contact us. We will respond as quickly as we can.
Access: This one-time fee provides you with lifetime access to this product. There are no recurring fees.
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.
I want you to be happy doing business with me so any questions are welcome.
Thanks for stopping by! Your support is appreciated. Jacqueline