Variable Loan Amortization Spreadsheet

Variable Loan Amortization Spreadsheet

Price: Free!
File Type(s): Excel 2007 Spreadsheet (.xlsx); Open Office Calc Spreadsheet (.ods)
File Size: 69kb (ZIP file)
Last Update: February, 2012
Current Version: 1.4
Macros: None.
  • Pinterest

Now that I've had a host of people ask me for some sort of spreadsheet to track loans with variable terms (like a changing interest rate, or perhaps non-equal payments), I've come up with something that I think should work nicely for most cases. I call this my "Variable Loan Amortization" spreadsheet ... or "VLA" for short.

The VLA spreadsheet is pretty simple, really, and shows up like this:

Variable Loan Amortization Worksheet

There's more about the purpose of the VLA spreadsheet later on this page. For now, you can grab a copy below:

Download Spreadsheet!

There's only one worksheet in the spreadsheet itself, and what few instructions there are, are right there.

Spreadsheet Versions

When you extract the ZIP file (tutorial), you'll actually find two separate spreadsheets. One is for Excel 2007 and later (.xlsx). The other version is for OpenOffice Calc (.ods).

Please use the spreadsheet that's appropriate for the program you've got.

Working with Variable Loan Amortizations

I'd like to think that not much about this spreadsheet needs explaining — it ought to be pretty straightforward, after all, if you have a basic knowledge of loan components.

The difference between this spreadsheet and my basic loan amortization worksheet is that the VLA allows for the interest rate, payment, and amount borrowed to change in any month, rather than remaining fixed for the life of the loan.

In my experience, loans between family members and friends often work out this way: Interest rates change, payments change, and sometimes even the amount borrowed changes. Most loan-amortization spreadsheets don't handle this very well, if at all. I'd like to think that the VLA spreadsheet bridges a gap in this area!

Will It Be Exact?

If you're hoping that this spreadsheet will give you the same figures you'd get from your bank's amortization software, well, think again. Whether you make payments at the beginning or the end of the month makes a difference, for instance, in how much interest gets tacked on. But, in most cases, this should track your loan pretty closely.

If you're using it to track a family or personal loan, well, it ought to serve that purpose nicely.

Printable? Yup!

This amortization schedule should print nicely in landscape format. But because printers tend to be a bit testy with these sorts of things, I can't promise that this will work perfectly on everyone's computer.

Looking for a Turbo-Charged Version?

If you're looking for a spreadsheet to build a comprehensive debt-payoff plan, then you'll want to check out ExcelGeek's Rapid Payoff / Debt Snowball Calculator elsewhere on this site!

Questions? Comments? Contact Me!

As always, if you've got a question or issue, don't hesitate to drop me a line. I'll get back to you as soon as possible!

RSS FeedWant to know when I add to and update my spreadsheets? Subscribe to IYM's feed!

Add to My Yahoo!

Make a Donation
If you're a user of my Excel spreadsheets and feel that they're worthy of a small donation ... well, that's extremely cool. And I'm truly honored that you'd think so.

The following button will allow you to make a donation (any amount) via Paypal. I would ask, though, that if you're someone who's in substantial debt, and working like crazy to get out, that you please refrain from making a donation to IYM.

Instead, use your intended donation amount as an extra contribution toward your highest-interest debt ... and then drop me an email to tell about how my site or my spreadsheets have helped in some way.

That, I assure you, is payment enough for me.

As always, I am truly grateful for your kindness and continued support!