FREE Google Sheet Templates
- 1. Pick a template to open
- 2. Click File > Make a copy
- 3. Rename it and edit as you please!
0% Interest Payment Tracker
- Only edit cells in blue
- Read notes by hovering over cells with triangle in upper right corner
- If you try to edit cells that shouldn't be edited, you will receive a warning. I suggest you don't turn this warning off
- If you need more than 60 payments, extend the contents of the range A65:D65 down.
- Amount remaining cell will turn green when when the amount ≤ $0.00
Customizable Amortization Schedule
- Only edit cells in blue
- Read notes by hovering over cells with triangle in upper right corner
- If you try to edit cells that shouldn't be edited, you will receive a warning. I suggest you don't turn this warning off
- When a cell is edited, the script takes a little time to run. A loading dialog will show while the script is running and will close when it's finished.
- Check the box to set the monthly payment amount entered in cell D3