Google Sheets Loan Calculator and Interactive Amortization Table

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.