Personal Loan Amortization Table – Google Docs

Nowadays, Google Docs is one of the biggest Cloud Storage where people stores their data and access them over online at anytime. Here I had a chance to create a loan repayment scheduler(same like Microsoft Excel Amortization Table) in Google Spreadsheet and published it as a template, so anyone can access/use this template and make their repayment schedule as easy as possible.

How to use this template

  • Go to Google Docs, and create new spreadsheet by choosing “From template...” option.
  • Type “personal loan amortisation table” in the search box and click "Search Templates" button.
  • Choose the template named as “Personal Loan Amortization Table” and click “Use this template” button.

Now, you can see the template and save it with a name. Now you have to give valid loan details to produce the repayment schedules. You need to give the following details.

Loan Amount - the actual loan amount you applied, for example 500000.00
Annual Interest Rate - for example 18.10%
Loan Period in Years - for example 5
Number of Payments in Years - usually 12
Start Date of Loan - for example 1/1/2010, after this entry please wait for few seconds, and you can see the loan summary and repayment schedules there.

The standard personal loan calculation formula is used in this template, and this template can be used only for making Personal Loan repayment schedules and not suitable for other type of loans.

Personal Loan Amortization Table

The limitation is, you can calculate the loan up to 290 EMIs only. Please contact me if you want me to customize the template to fulfill your needs.

Feel free to post your queries and rate this template if you like:)

Be Sociable, Share!

9 Responses to “Personal Loan Amortization Table – Google Docs”

  1. Genuinely wonderful desgin of one’s website. It is individual and compares in your posts. Don´t give up and make your individual factor!

  2. I always enjoy reading your blog.

  3. Well written article! I love checking out your blog for the reason that the writers always write great articles. Great work once again. I have already adding to favorites this website. I think I shall subscribe to this feed also. Take Care! ……..

  4. Hi there! I know this is somewhat off topic but I was wondering if you knew where I could get a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having trouble finding one? Thanks a lot!

  5. It’s hard to find knowledgeable people on this topic however you sound like you know what you’re talking about! Thanks

  6. Hi nice article here actualy was looking for a good loan arrange..how do i’m going concerning choosing the rite set up man? some folks say they’ll get loans with interest as low as three%? is that true. Singapore Loans

  7. Caddidon Jabari says:

    My name is Caddidon Jabari,i contacted

    Lin Poh Loan Firm for a business loan amount of $250,000USD,

    to my greatest surprise, the loan was credited to my bank

    account without any stress of getting my requested loan

    amount, i was surprise because i was first a victim of scam,

    so for those of you that maybe in need of loan should contact

    Lin Poh via Email: linpohloanfirm@yahoo.com.sg

  8. I do accept as true with all the concepts you have offered in your post. They are really convincing and will certainly work. Nonetheless, the posts are very short for novices. Could you please lengthen them a little from subsequent time? Thanks for the post.

Leave a Reply


Copyright © 2008-2010 K BalaSubramanian | Credits