2011-08-10-loan-amortization-google-docs-template.html

---
layout: post
title: Loan Amortization - Google Docs Template
date: '2011-08-10T15:01:00.002-04:00'
author: Carlo
tags:
- Amortization
- Loan
- Template
- Mortgage
- Finance
- Google Docs
- Schedule
- Interest
modified_time: '2013-03-10T21:25:51.078-04:00'
thumbnail: http://2.bp.blogspot.com/-OZvMOistBrY/TkLU9ojAV9I/AAAAAAAA9kY/4CJILCm8a8M/s72-c/loan+summary.png
blogger_id: tag:blogger.com,1999:blog-1115978604548657664.post-2037500470460719106
blogger_orig_url: https://thewahlstedts.blogspot.com/2011/08/loan-amortization-google-docs-template.html
---

So to veer off the SharePoint theme for a moment I wanted to share something that I borrowed and improved.<br /><br />There's a <a href="https://docs.google.com/previewtemplate?id=0AvSvCh_ArzW2dE9rNFlXdnVScEZlYVpYTVJ4YlU2Ymc&amp;mode=public">Google Doc template</a> that I found to make a loan amortization table. It shows you the progress of your loan on a monthly interval; How much interest and principle you pay each payment and when the loan will end.<br /><br />I took this template and I <a href="https://docs.google.com/previewtemplate?id=0AohqXRtakeaNdGd4LUNHZV9pWTF2Q21PMFBmOWR2MXc&amp;mode=public">made my own template</a> of something that would work for my needs. I wanted something that would also allow me to add additional amounts at different time periods to see how that would affect my loan. This way I could see how much less interest I would pay in the long run. I made two extra columns, one for a regular amount (so if you payed $30 more than your payment for a year) and a second column for one time larger amounts (maybe from a tax return).<br /><div class="separator" style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/-OZvMOistBrY/TkLU9ojAV9I/AAAAAAAA9kY/4CJILCm8a8M/s1600/loan+summary.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-OZvMOistBrY/TkLU9ojAV9I/AAAAAAAA9kY/4CJILCm8a8M/s1600/loan+summary.png" /></a></div><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />I also simplified the amounts at the top that you as &nbsp;the user plug in to make it a little more straight forward.<br /><div class="separator" style="clear: both; text-align: center;"><a href="http://1.bp.blogspot.com/-2mUZeyARTX8/TkLU9xi0iAI/AAAAAAAA9kc/z5fQyCWkRsI/s1600/user+input.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-2mUZeyARTX8/TkLU9xi0iAI/AAAAAAAA9kc/z5fQyCWkRsI/s1600/user+input.png" /></a></div><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Finally I've added a column at the top that shows you the amount of original interest that you would have paid by making all of the regular payments, the new amount based on the extra you've paid on your loan, and the difference in the two. This way you can feel good about putting extra money against your loan!<br /><br />Hope you all enjoy this spreadsheet as much as I did improving and using it!