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:)

22 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. I came across this good from you from pure luck and never believe it is lucky enough to say too as credit you to definitely get a fine.

  5. That seems superior though i am still less than certain that I like it. In any case will look far more into it and decide personally! :)

  6. 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!

  7. I simply want to say I am just new to blogging and actually savored this page. Most likely I’m likely to bookmark your site . You really have amazing well written articles. Thanks for sharing your web page.

  8. I was very pleased to find this website. I wanted to thank you for your time for this wonderful post!! I definitely enjoy reading it and I have you bookmarked to check out new stuff you blog post.

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

  10. Hiya, I loved reading your post. Thanks for the great info. Hoped that we will lengthen our friendship through a mutual hyperlink trade? Let me know, and respectable to see you here!

  11. testing says:

    There are some attention-grabbing deadlines in this article but I don’t know if I see all of them heart to heart. There is some validity but I will take maintain opinion till I look into it further. Good article , thanks and we want extra! Added to FeedBurner as well

  12. testing says:

    I am usually to running a blog and i really appreciate your content. The article has actually peaks my interest. I am going to bookmark your website and preserve checking for brand spanking new information.

  13. Mrs. Caroline Keith says:

    My name is Mrs. Caroline Keith from South California, i am a single mother with just one son. My husband divorce me when my little boy was still 3years old. And ever since then things has not been easy for me and my son. Even to pay my bills is a big problem for me, i can’t pay my son school fees. I continued praying to the lord of heaven to send down my divine helper for me one day, because i have been scam 3times so i am scared, Until one day i decide to take bold step for the last time, so i came across one Mrs. Sandra Bent on yahoo answer who share a testimony about YOUNG LEE LOAN COMPANY grant him a loan of $15,000USD. So i decide to try my faith with this Company. I can’t believe this would happen. Mr Smith just grant me a loan $25,000USD indeed is really a genuine lender, you can contact he via mail(youngleeloanfirm@yahoo.com.sg )I am sure he will help you.

  14. 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

  15. 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

  16. 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.

  17. Andrew Lee says:

    Contact us for unsecured personal or business loan of any amount, we are ready to help you out. Our interest rates are reasonable. Here are some few questions from us: Are you in debts? Do you want to pay of your debts? Do you have plans in expanding your business? Do you want to get your self financially equipped? If yes then contact us and you will be given the best of all financial support.Many are out there that needs financial assistance with no opportunity. But this is an opportunity you can’t afford to miss. We are out in the world to get most people that needs financial assistance financially equipped. For more information contact us via email:andrewleeoriginatorasialoan@live.com.sg

  18. chang seng says:

    Are you tired seeking Funds to finance your Business, has Bank stress be upon you all this years and you cannot get capital to start up your Business, or are you financially embarrassed that you cannot pay up your Debt and Bills, Do you think of getting a Financial Help ? Are you seriously in need of an urgent loan?while don’t you hurry now and Grab your Guaranteed and Secured Loan today at CHANG SENG ASIA BEST LOAN, we give out the best service ever to all our customer, and will are working towards and beyond our customers reach and expectation, as we Render out all kinds of Loans. to Loan seekers, Individuals, Cooperate Organization’s, Companies, and so on Email: changsengloancompany@yahoo.com.sg
    APPLICATION DETAILS
    Your Full Details:
    Full Name:
    Loan Amount Need:
    Loan Duration:
    Phone Number:
    State:
    Monthly Income:
    Country:
    Best Regards,
    Mr Chang Seng

  19. certainly like your web-site however you have to take a look at the spelling on quite a few of your posts. Several of them are rife with spelling problems and I find it very bothersome to tell the reality on the other hand I’ll certainly come back again.

  20. Kenshaw Jeanne says:

    Be careful here.nobody can help you here or even suggest how you can get financial help.any answer of a loan lender to your question or loan request,you MUST ignore,because they are SCAMS…real SCAMS…I was a victim of which i was ripped off hundreds of dollars $….So email me right away on tips of detecting a loan scam and a safer way of getting a cheap legitimate loan help via ” kenshawwjeanne (at) gmail (dot) com “.Replace the content in brackets as usual.I made it so because of those CON IDIOTS..Beware,I can’t diclose anything here cos its a public place, for fear of SCAMMERS,so do as instructed and you shall see the reality of it all..If you don’t mind I can as well narrate my scam experience to you and how I finally got back on my feet through a God Sent from where I Least expected that finally gave my life a financial stability,in my next email to you.Jeanne

  21. STEVE MORGAN says:

    Hello,

    Are you desperately in need of a loan?
    Have you been denied of a loan from your bank or any institution?
    Do you need financial assistance?
    Do you need a loan to pay off your bills or buy a home?
    Do you want to have a business of your own and you need a Loan for your
    financial demands? Contact us today for your loan. We are ready and able to help you out on either Business or Personal Loan. Offer is available at an affordable interest rate of 3%. Interested applicant should contact us via email:cooperativeloans@bluesash.net

    LOAN APPLICATION FORM

    First Name:……………………………..
    Other Name(s):…………………………..
    Gender:…………………………………
    Marital status:………………………….
    Contact Address:…………………………
    City/Zip code:…………………………..
    Country:………………………………..
    Religion:……………………………….
    Date of Birth:…………………………..
    Amount Needed as Loan:……………………
    Loan Duration:…………………………..
    Monthly Income/Yearly Income:……………..
    Occupation:……………………………..
    Purpose for Loan:………………………..
    House Phone:…………………………….
    Cell Phone:……………………………..
    Have you applied for a loan before?………..
    How did you hear about us?………………..

    Contact us via email: cooperativeloans@bluesash.net

    Thanks

    STEVE MORGAN

Leave a Reply


Copyright © 2008-2010 K BalaSubramanian | Credits