Home | Mathematics |     Share This Page
 Consumer Loan Calculator

An interactive consumer-oriented loan evaluation tool

Most recent update:

Copyright © 2019, P. LutusMessage Page

Loan Calculator | Background | Money Shopping | Payoff Strategies | Credit Cards

(double-click any word to see its definition)

Loan Calculator

Here's an easy-to-use consumer loan calculator that computes loan outcomes for user-entered values. Enter values in the green entry pane and see the results below:

Entries:

Loan Amount (pv)
Payment Amount per period (pmt)
Interest Rate per period, % (ir)

Results:

Number of full-amount payments (np)
Final payment amount (fp)
Total cost (tc = np * pmt + fp)
Duration

Instructions:

  • A result of (infinity) means (a) the balance can never be paid off, or (b) there's an entry error.
  • If you're only provided with an annual interest rate, divide it by 12 for monthly interest rate.
  • For accurate results be sure to add any loan setup fees to the "Loan Amount" and subtract any per-period service fees from the "Payment Amount" above.
  • To make a copy of a result, drag your pointer cursor across the results in the blue display box, then press Ctrl+C.
  • For a more detailed calculator with more theoretical depth and an exposition of the underlying mathematics, visit my Finance Calculator page.
Background

When you buy something in cash, let's say a car, the transaction can be simple — you pay money up front, get a car in return, then you walk away. But when you can't afford the car and must take out a loan, things get complicated, because you're actually buying two things:

  • The car.
  • Some money to buy the car.

Over time the transaction has two phases — you pay for the car with borrowed money, then you pay for the borrowed money, possibly for years.

In a cash purchase, there are two interested parties — you and the owner of the car. But in a consumer loan, there are three — you, the owner of the car, and the owner of the money. All these parties have requirements that must be satisfied:

  • You get the car.
  • The owner of the car gets the money.
  • The owner of the money gets service fees and interest over time.

There are any number of people ready to tell you the cost of a car. In this article, my purpose is to tell you the cost of money.

Money Shopping

It's not an exaggeration to say that Americans (including governments) are drowning in a sea of debt. Apart from narcissism and an infantile unwillingness to defer gratification, an important part of the problem is that people spend too much time considering the cost of consumer goods and too little time considering the cost of money.

There are creative and responsible ways to avoid the debt trap, but they require knowledge of how money works, and this article provides that knowledge.

Compound Interest

The most important thing to understand about consumer loans is that they obey the rules of compound interest — interest amounts that directly add to, or subtract from, the loan's balance. To understand why this is important, consider this loan's terms:

  • Borrowed amount: $10,000.00
  • Annual interest: 12%
  • Monthly payment: $100.00

Doesn't this seem reasonable? Joe consumer wants to buy a used car, the car's price is acceptable, he can meet the monthly payments, the interest rate seems normal, where's the problem? The problem is that this loan never ends — it's an "interest-only loan". The monthly payments only cover the accrued interest, they don't reduce the owed balance at all. So Joe consumer might make payments forever.

  • Wait — is this legal? Yes, perfectly so.
  • Must the bank tell Joe what kind of loan it is? Yes, but in excruciatingly small print, and in language calculated to confuse and mislead, just short of felony prosecution.
  • Can Joe avoid responsibility by claiming to be too stupid to look after his own affairs? No. If that were true, Congress would have to disband.

Don't be Joe consumer — learn how consumer loans work. Learn the cost of money.

Now consider these alternatives, computed using the loan calculator at the top of this page:

  • If Joe pays $125 per month, the loan is paid off in 13 years 6 months and costs $20,218.40.
  • If Joe pays $150 per month, the loan is paid off in 9 years 3 months and costs $16,561.44.
  • If Joe pays $200 per month, the loan is paid off in 5 years 10 months and costs $13,932.14.

Do you notice a pattern? As monthly payment amounts increase, the cost of the loan declines dramatically. A small increase in monthly payment produces a disproportionately large change in the total cost of the loan. This is because compound interest amplifies small differences.

Payoff Strategies

When to pay more

Because of how compound interest works, at the beginning of a typical consumer loan most of your payment is applied to the interest and little to the loan balance. Here's a graph:

Figure 1: Loan History

Figure 1 shows that at the beginning of a typical loan, almost all your payment is applied to interest. So if you have any flexibility in timing the payments you make, the best strategy is to make larger payments near the beginning of a loan, because that reduces the overall cost of the loan more efficiently than other strategies.

Small Print

Many consumer loans have hidden costs and conditions. Here are a few:

  • Setup fees. These are fees charged by the lending institution to set up the loan, and they're added to the initial balance. In the worst case these fees can turn a marginal consumer loan into an interest-only loan (a "forever" loan).
  • Monthly service fees. When they exist, these fees can dramatically increase the cost of a loan over time, because they're subtracted from your monthly payments — they can keep you to the left side of Figure 1 much longer than you would like.
  • Early-payoff penalty. If this condition exists, it can prevent you from applying strategies like the above to reduce the cost and/or duration of a loan.

This is just a short list of the most obvious traps. Many lending institutions do all they can to conceal the true nature of a consumer loan, so it's essential to read everything and if possible, seek counsel from a more experienced consumer before signing on the dotted line.

Credit Cards

Let me say a few words about the worst example of consumer financing — credit cards. At first glance credit cards seem pretty harmless, but I suspect more people have lost more money to credit cards than any other consumer loan scheme. And make no mistake about it — a credit card is a month-to-month consumer loan, but with all the bad parts dialed up to 11. If you fall behind in your payments, the bank will respond by increasing penalties and interest rates in a way that can only make things worse, so that your chance to catch up may simply evaporate.

Young people, college students in particular, often find themselves trapped by credit card debt because of their inexperience with loans and compound interest. Older consumers may keep up with their credit card balances until a financial reversal upsets their plans and forces them into bankruptcy. And guess what happens then? Banks eagerly try to give the victim new credit cards! Why? Because once having declared bankruptcy, Joe consumer can't do it again, so he's a more reliable credit card victim.

Credit cards are everywhere now, and some transactions require a card. To avoid the worst outcomes, consumers should analyze their credit card spending — see how much they actually pay for the luxury of using a card. It's often a much higher percentage than people realize.

Interest Rates

Credit card interest rates vary widely based on circumstances and are confusing — here's an explanatory article. The worst interest rates approach 30% per annum, which I personally think should be illegal, and are very difficult to deal with on limited income.

To see how bad that situation would be, try an example problem in the calculator above — enter an initial balance of $10,000, a 2.5% monthly (30% annual) interest rate and a monthly payment of $300. Such a loan would require over 6 years to zero and would cost $21,768.77, more than twice the borrowed amount.

Suggestions

Here are some common-sense rules for credit card accounts:

  • Don't have too many active cards. This is a practical issue — it's more difficult to track multiple accounts and keep them from getting out of control.
  • Do all you can to avoid an outstanding unpaid month-to-month credit card balance. Credit card accounts charge exorbitant interest rates and penalties, such that nearly any other kind of loan would be less expensive.
  • If you can't zero out a credit card's balance each month, stop buying things. Easy to say, hard to do.

Credit Cards and Social Class

Wealthy people use credit cards with impunity — they experience nothing but advantages. They don't have to carry cash around, they charge things they want, and they pay no fees. Because these people automatically zero out card balances when they come due, the short-term balance on their cards represents a free 30-day no-interest loan.

How is that possible? Why would banks give wealthy people free 30-day loans? Well, they don't — the credit card system is paid for by poor people, people who have month-to-month unpaid balances, people who can't catch up.

Remember this when you read your credit card statement — if you have an unpaid month-to-month balance, if you see interest charges, that means instead of buying something nice for yourself or your family, you're paying for some rich person's yacht.

The remedy is simple — don't buy things you can't afford, but if you do, don't buy them with a credit card.

Thanks for reading! — PL

Home | Mathematics |     Share This Page