Loan Calculator Made with Google Sheets

A loan is a contract between a borrower and a lender in which the borrower receives an amount of money (principal) that they are obligated to pay back in the future.

Amortized Loan: Paying Back a Fixed Amount Periodically

Use this calculator for basic calculations of common loan types such as student loans, car loans, mortgages, and personal loans.

It also contains sections for extra payment and you can see at a glance the interest saved when you make extra payments.

You can use this spreadsheet to track personal, home, and car loans. Any type of loan you can think of and it can be used from any country.