Personal Finance

Any custom loan amortization template?

  • Last Updated:
  • Jul 7th, 2014 11:52 pm
Tags:
None
Member
Sep 1, 2005
397 posts
45 upvotes
Montreal

Any custom loan amortization template?

Hi,

I would like to buy a well for $5400 with funding plan with a interest rate of 4.25% for 24 months (will pay monthly or will pay a lump sum sometime). I want to know if there is any template out there that can calculate the loan amortization + my customize input? Like I want to see what is the remaining if I pay a different sum every month.
2 replies
Member
Feb 23, 2013
499 posts
51 upvotes
NORTH YORK
Excel's the answer for that.

I've made this template and uploaded it to google docs, see if you can download it.

https://drive.google.com/file/d/0B9pGkc ... sp=sharing

The blue fonts are inputs. It has default payments right now, but you can enter lump sum payments for any month in the column highlighted grey and the remaining months will adjust. Be sure to enter it as a negative number.

Did you drill a well? I just did recently and I'm looking for a well pump and filtration system.
Member
Sep 1, 2005
397 posts
45 upvotes
Montreal
Thanks Oldmaster! Just what I need! :)

Planning to buy a small jet boat...

Top