This is a short video tutorial on how to use this Google Sheets Loan Calculator and Interactive Amortization Table to answer some basic questions about loans like:
How much will my payoff be on a car loan or mortgage?
How much will I owe, or what will my payoff be in 1 year, or 10 years?
How much will the payment change if the interest rate goes up, or down?
How much interest will I save by making additional payments?
Here’s how to copy the file to your own drive:
Open the document and select, File, Make a Copy. Rename the document, and make sure to save it in your own drive. For private use, make sure sharing is turned off for that document.