the ultimate guide to budgeting

I'm Not Flipping Burgers when I'm 70

Chapter Nine - Consumer Loans (Amortization)

Consumer loans differ from credit cards in that payments are agreed upon and scheduled for a specific period of time to reach a zero balance. Credit cards can carry balances indefinitely, more so when large balances are maintained and when only minimum payments are made. This also transpires when balances remain stagnant or rise due to additions in principal.

Consumer loans provide the ability for stabilization and predictability as the payments are usually fixed coupled with planned payment schedule. Consumer Loans typically apply to large ticket items such as automobiles, boats, motorcycles, student loans and mortgages.

When speaking in tongue about paying off a loan it is based on amortization which by definition (is the distribution of payment into multiple cash flow installments, as determined by an amortization schedule). If the APR is fixed, each payment consists of principal and interest and the monthly payments are calculated in equal installments (same payment each month throughout the loan term). At the beginning of the loan, a large portion of each payment is devoted to interest (which is more prevalent with large principal balances); however, as the loan matures, larger portions go towards paying down the principal.

If the APR is variable, the number of payments and principal remain the same; however, the interest will increase of decrease affecting the total payment in a given monthly cycle. The formula to calculate amortization is as follows:     

A = payment Amount per period

P = initial Principal (loan amount)

r = interest rate per period

n = total number of payments or periods
 

Amortization in simple form says that each payment goes toward paying interest and reducing principal, which is the outstanding loan amount. Each month, the payment first covers the interest and the remainder goes toward the principal. The interest amount is calculated by multiplying the interest rate by the loan balance.

Producing values in the formula is a time consuming undertaking; however, there are a plethora of amortization calculators on the Internet that will perform the job. For example, say Jasper has a student loan for $12,000 and with 9% interest and a loan term of 72 months. The basic amortization calculator will have these inputs:

From there the calculator will produce a monthly or yearly schedule for the entire loan term with a monthly payment of $216.31. (Some months are $216.30 depending on rounding)       

In the table above, the interest is all but negated and the principal almost equals the actual monthly payment amount. This schedule is 100% predictable as long as the payments are made on time; however, with a variable APR the payment can vary.

 

Variable Interest Rate
In order to pay off a loan with a variable interest rate (a fluctuating rate that can change between payment periods), the increase in the interest has to be added to the normal monthly payment to keep the payment cycle on track. This is calculated by taking the interest accumulated in the variable interest rate schedule and subtracting it from the established interest rate at the beginning of the loan. 

September 2015 variable interest subtracted from September 2015 fixed interest equals $9.90 ($98.95 – 89.05). On the inverse if the interest were to decrease then the calculation would be subtract the variable interest rate from the fixed interest rate schedule. For example, if the interest were to drop to 8% in August, the accumulated interest would be $79.16 which is $9.89 lower than the fixed interest at $89.05. This would decrease the payment to from $226.31 to $216.42 ($226.31 - $9.90).

 

Paying down the Loans  
An amortized loan behaves no differently than credit card does in that interest is calculated the same way by taking the monthly rate and multiplying it by the principal balance. The difference is that credit cards derive the principal from an average daily balance due to the ability to increase the principal. The amortized loan always has a known principal balance by way of the schedule.

When it comes to paying down a loan the same rule applies: decrease the principal and it will decrease the amount of interest levied against it. One of the main reasons people borrow through loans rather than a credit card is that there can be tax advantages. Mortgage and student loan interest can be deducted from taxes and interest (check with your CPA) and an automobile may apply if it is part of a business. Beyond that a fixed payment schedule creates structure whereas a credit card can get people in trouble due to the ability to spend freely. Therefore, if one is going to borrow it should be through a loan and not a credit card. Nevertheless, having a fixed loan doesn’t mean one should just borrow when the desire presents itself. Borrowing is baked into the budget, but the same applies in that whenever possible, pay down the debt quicker than the prescribed schedule.

The loan that is increasing and becoming one of the largest debts in budget is then student loan. The price of tuition typically increases each year and more people in middle age have gone back to school to increase their education and job prospects. These loans tend to rack up more interest as they have terms similar to mortgage payments and in turn last much longer than a car payment.

Making additional payments
Taking the $300 student loan payment from Jasper’s the established budget, it is based on $18,000 for six years, with an interest rate of 6.198%. Just like paying down the credit cards the same exercise can be performed to reduce interest paid to the lender. Taken from the Credit Card Management Chapter 8, money can be taken from one or more of the savings vehicles and applied to the monthly payment which will be set at $250 for the Table below. 

In looking at the schedule the interest reduction is not significant in the first year. The total interest after one year with regular payment is $1,043.84 and $957.13 with the $250 additional payment. This equates to only an $86.71 difference; however, the interest is reduced by 32.1% and in year two 69.6%. If the loan was paid through by regularly scheduled payments, an additional $967.70 would accumulate. In total, making additional prepayments at $250 saves a total of $1,830.91 in interest and the loan is also paid off in in three years which is three years earlier than the beginning schedule. 

 

 


(Note that additional money added to the loan is considered as a prepayment and should always be applied to the principal)

 

9.1 Pay the Credit Card or the Amortized Loan First? 

When carrying multiple sources of debt, normally the credit card debts should be paid off first as they are revolving debt and because balances can fluctuate due to increases in principal and amount of time it takes to reach a zero balance by just paying the minimum payment.

 

Going back to Jasper’s student loan, after six years the total interest accumulated is $3,600 without nothing but the regular monthly payment. Now let’s go back to Jasper when he was paying off his credit cards at the same time and it shows that he will pay $3,056.28 in 33 months.

 

After 33 months of his student loan, his interested paid out would be $2,472.11 with 39 months of payment remaining.

Now that the credit card has been paid off, Jasper can add the $453 to pay off the student loan. At the 33rd month his principal balance would be at $10,572.11 with 39 months of payments remaining. To complete the math go back to the amortization calculator and input the same criteria but add additional payments of $453. You will have to find a amortization calculator that allows for extra payments. (The calculator below is provided by mtgprofessor.com).

 

 

 

 

 

So we can see that the total interest is $431.69 and with the extra payments $695.98 is reduced in interest with a total of 24 months saved. Putting the totals together we see the benefits of paying down the credit card first and then applying it to the student loan. 

 

 

 

 

 

Paying the Amortized Student Loan First
In going back to the budgeted payments for the credit cards, we see that the amounts will change:

 

 

 

The new payment will now be $274.70 rather than the old total between the credit cards which was $453. This means an additional $178.30 will go toward the student loan. (In the calculation, the monthly payment will be the same for the credit cards noting that the minimum payment for these cards would reduce each month)

With the $178.30 added as an additional payment, the loan will be paid off 42 months totaling $2,066.97 interest. 

 

The next step is to see where the credit cards stand at that time. With the student loan paid off there is $478.30 ($300 + $178.30) in additional money to use toward the cards.

The next move is to pay down on the credit card as it accumulating the most interest. So with the current payment of $121.70, adding $478.30 generates a new monthly payment of $600. With that new amount the card will be paid off in the 50th month and with an interest grand total paid of $3,147.83.

At this point the furniture card has principal balance of $985.75 and will receive a one-month payment of $679.33 due to the partial payment from the credit card and will be paid off in the 51st month due to having only having $321.73 remaining. The total interest accumulated comes to $3,147.06.

The answer is clear in the above table that performing an analysis to know which debt to pay off first can save you money over time.   

chp 9.1.png
chp 9.2.PNG
chp 9.3.PNG
chp 9.5.PNG
chp 9.6.PNG
chp 9.7.PNG
chp 9.8.PNG
chp 9.9.PNG
chp 9.10.PNG
chp 9.13.PNG
chp 9 added.PNG
chp 9.12.PNG
chp 9.14.PNG
chp 9.4.PNG