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.
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.
The required inputs for the sheet to work are the following:
For our example, here are the inputs:
The base monthly payment will be automatically calculated as you input the values.
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.
Once you are done adding the inputs, click the button labeled Generate Amortization Schedule.
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.
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.
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).
Next, a list of permissions needed by the template will be listed.
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?
Wanna try it yourself? Link’s below!
Google Sheets Amortization Schedule Template by Lido.app
