In this article:

Free Google Sheets Amortization Schedule Template [2024 Update]

1. Copy the Free Google Sheets Amortization Schedule Template by Lido.app

Copy the free Google Sheets Amortization Schedule Template by Lido.app here.  A new tab or window will open, asking you to copy the template. Click Make a copy.

Amortization schedule google sheets

The Free Google Sheets Amortization Schedule Template has a single sheet, containing cells for the required input and a space below for the amortization table that will be generated. For ease of use, sample values are already added. 

google sheets amortization schedule

2. Add the Inputs such as Principal, Interest Rate, etc.

The required inputs for the sheet to work are the following:

  • Principal - total value of the loan
  • Interest rate per annum - interest rate set
  • Number of years - duration of the mortgage
  • Payments per year - number of payments to be made per annum; for monthly payments it is equal to 12

For our example, here are the inputs:

  • Principal - $250,000.00
  • Interest rate per annum - 3.50%
  • Number of years - 15 years
  • Payments per year - 12

The base monthly payment will be automatically calculated as you input the values. 

amortization schedule in google sheets

Depending on the terms of your loan payments, you may  need to add expenses to the calculation. There are six slots for it, marked Additional Payment per Month and Addtl2 to Addtl6. Feel free to rename them to your convenience and add values to them. 

Additional input to amortization schedule‍

3. Click Generate Amortization Schedule

Once you are done adding the inputs, click the button labeled Generate Amortization Schedule.

Generate amortization schedule google sheets

As it is your first time running the script in the sheet, you will be asked to give permission for the script attached to the template to run. Click Continue.

Authorize amortization schedule script in google sheets

A new window will load. First, you will be asked to choose the Google account that will run the script. Select the account in the list. Most of the time, only the active account will be listed. 

Choose the account to run the amortization schedule template in google sheets‍

You will next get the message that Google hasn’t verified the script. Click the small link labeled Advanced. Another link will appear below it. Click Go to amortsched(unsafe).

Enable the script in the amortization schedule template‍

Next, a list of permissions needed by the template will be listed. 

Permissions needed by the amortization schedule template by lido.app‍

Click Allow. The window will close.

Click the Generate Amortization Schedule button again. The template will now generate the amortization schedule in the table below. Pretty neat, right?

Generate amortization schedule google sheets‍

Wanna try it yourself? Link’s below!

Google Sheets Amortization Schedule Template by Lido.app

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started