Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Loan Amortization Spreadsheet
Old 01-04-2011, 10:45 AM   #1
Recycles dryer sheets
Join Date: Sep 2008
Posts: 60
Loan Amortization Spreadsheet

I saw a post recently that asked for a loan amortization spreadsheet, so I will post what I use. I found this on the internet years ago, and I haven't been able to find it since. The attached spreadsheet template is in Excel 2003 format and it is what I use to figure out payment amounts and how extra payments will affect the loan balance/life.

You can enter in loan amount, interest rate, start of loan, loan period, etc. The spreadsheet will calculate the scheduled payment, total number of payments, the total amount of early payments and the total amount of interest paid.

If you enter in a extra amount on a particular payment, it will recalculate the amortization table and change the total number of payments and total interest.

There are dummy numbers in the input cells right now.

Uncle Drew
Attached Files
File Type: xls Loan Amortization Template.xls (142.0 KB, 22 views)

Uncle Drew is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 01-04-2011, 06:33 PM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
easysurfer's Avatar
Join Date: Jun 2008
Posts: 8,475
Thanks. It looks really helpful. Nice to have a spreadsheet handy at all times instead of finding a website.
Have you ever seen a headstone with these words
"If only I had spent more time at work" ... from "Busy Man" sung by Billy Ray Cyrus
easysurfer is online now   Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Found 15 acres, loan to buy land, loan to build... how is it done? jIMOh FIRE and Money 17 11-05-2010 12:18 PM
Tracking basis with spreadsheet, how to structure the spreadsheet? bamsphd FIRE and Money 13 08-03-2009 09:31 AM
Random payment loan amortization calculator? calmloki FIRE and Money 5 01-29-2008 10:17 PM
Amortization Rates boont FIRE and Money 8 07-26-2006 11:46 AM
spreadsheet nnkrealtor Other topics 4 09-18-2005 03:01 PM


All times are GMT -6. The time now is 05:00 PM.
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2018, vBulletin Solutions, Inc.