Mortgage is usually the largest and longest running debt ordinary people like you and me have in their life. But how many of us treat it in a manner: “get the home loan, set up regular automatic payments and forget about it”? This is a big mistake! Let’s say you have a mortgage $400,000 for …
Author Archives: uncle
Classic loan calculators that you can find on most finance or bank websites offer you only limited functions. Basically you can choose loan amount, add interest rate and set loan term and the calculator will tell you how much your weekly, fortnightly or monthly repayment will be. What you cannot do is doing some more …
This calculator will help you model your repayments and find out the date when you become debt free. Simply list all your credit cards or hire purchase details into the entry table, hit the Refresh button. It will tell you straight away your debt free date. Our calculator can also be used for other types …
Have you got an existing Loan or Mortgage, would like to refinance it and are keen to see how the modification may influence your financial situation? In this case we have just the right Calculator in Excel for you. It will show you exactly what impact amending multiple Loan Parameters will have. This Calculator requires …
Payment terms for mortgages are usually the longest of all loans. It makes sense to pay some Extra Principal as often as you can. Making so can dramatically reduce Total Repayment Time of the Loan and also save you lots of money on Interest. For this purpose we have created a great Mortgage Calculator in …
Normally at the end of mortgage when it’s fully repaid the balance is zero. However, in some situations you will need to calculate the outstanding balance of your loan. This happens usually when: You want to refinance your mortgage (pay off first and take another) You inherit, earn or otherwise obtain large amount of money …
Are you thinking about purchasing a new (used) car? Or do you have car already and want to refinance it for whatever reason – be it a lower Interest Rate, lower Repayments or a better Finance Deal? In this case we have a perfect Calculator in Excel just for what you need! To download a …
This advanced Excel calculator is designed to simultaneously manage Amortization Schedules for Multiple Loans. As you know, in most cases people as well as businesses don’t have just one loan. However, if you are looking for a great calculator for only one loan (or mortgage) then instead of this one we recommend using this: Excel …
If you are an Accountant for a small or medium sized company with multiple leases (or loans) then you probably experience problems with generating accounting entries every month. What you need to work out are the principal and interest amounts for each lease and then summarize them. In case of just few loans or leases …
We’ve got some good news for you! Recently we just released a new version of our Compound Interest Loan Calculator in Excel. It’s often called “Amortization Schedule with Principal and Interest Amounts” which is basically the same thing as simply “Loan Calculator”. The enhancements are: Added Compounding Interest Frequency (daily, weekly, fortnightly and monthly) Possibility …