- compare our

PRODUCTS- Credit & Identity Monitoring
- ›1 Bureau FICO Score and Credit Monitoring
- ›3 Bureau FICO Scores, Credit and Identity Monitoring
- One-Time Reports and Scores
- ›1 Bureau Credit Report and FICO Scores
- ›3 Bureau Credit Report and FICO Scores
- COMPARE ALL PRODUCTS

- achieve my

GOALS - learn about

SCORES - find my savings &

CREDIT CARDS - connect with the

COMMUNITY

Credit cards from our partners

- myFICO® Forums
- Welcome to the myFICO® Forums
- User Guidelines & General Information
- Community Feature FAQ's
- Take the myFICO Fitness Challenge!
- FICO Scoring and Other Credit Topics
- Understanding FICO® Scoring
- General Credit Topics
- Credit in the News
- Relationships and Money
- Personal Finance
- Types of Credit
- Credit Cards
- Credit Card Applications
- Credit Card Approvals
- Mortgage Loans
- Auto Loans
- Student Loans
- Business Credit
- Bouncing Back from Credit Problems
- Rebuilding Your Credit
- Bankruptcy
- This 'n' That
- SmorgasBoard
- myFICO® Product Feedback
- myFICO® Forums Technical Help
- Credit CARD Act and New FHA Rules Download
- What you should know about the Dodd-Frank Act

turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- myFICO® Forums
- >
- Types of Credit
- >
- Auto Loans
- >
- How is Auto Interest calculated?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

0

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

10-23-2014 01:09 PM

mikemsceo wrote:Hmmmm

Is it compound interest or simply interest off the principal loan ?

Inactually made a spreadsheet on excel with the formula you gave me

If anybody needs I can upload it ...

It's simple interest. I meant to say computed instead of compounded.

0

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

10-23-2014 03:04 PM

Hoya08 wrote:

mikemsceo wrote:Hmmmm

Is it compound interest or simply interest off the principal loan ?

Inactually made a spreadsheet on excel with the formula you gave me

If anybody needs I can upload it ...

It's simple interest. I meant to say computed instead of compounded.

Since it is simple interest

Every months Payment will be off of the initial** Cost of the Car ? **

Rather than the new balance...

Is that right?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

10-23-2014 06:02 PM

The payment is the same every month.

It's the allocation of the payment toward the interest and toward the principal.

As you make more payments the principal portion increases and the interest portion decreases.

In any given month the amount you pay over the minimum payment should go toward your principal balance so that the following month there will be less interest due and more paid toward the principal. If you do this every month (make on time payments and pay more than the minimum) you will save a bunch of interest. You can figure out how much interest by going to the link posted upthread earlier at bankrate.com

0

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

10-23-2014 06:26 PM

Thanks guys been great help..

I went on bankrate and also did the math on my own.. diference is a few bucks..Just arming myself for when i go to the dealer

This one inquiry costed me 20 points

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

10-23-2014 06:39 PM - edited 10-24-2014 06:26 AM

It's simple interest as in: the interest charged is the CURRENT balance times the interest rate.

Although the Annual Rate is 3%, the monthly rate is 0.25%. The monthly rate (0.25%) is the significant rate since payments are remitted monthly. In this situation, simple interest is the loan balance times 0.0025. If payments were made Annually, then the significant rate is the Annual Rate (3%). In this situation, simple interest is the loan balance times 0.03.

This is where we start getting into the nuts and bolts of "the time value of money" , which is the basis of the equation presented earlier as well as the Excel formula, and it can get confusing.

If you are interested in the nuts and bolts of "the time value of money", I recommend obtaining an Introduction to Finance book from your local library, or googling for youtube videos and other web resources to help explain it.

To recap how auto loan interest is calculated:

Price: $4,500

APR: 3%

Term: 36 months

The Excel formula is =PMT(0.03/12, 36, $4,500)

The Excel formula returns your monthly payment: $130.87

The monthly payments are fixed and do not change. The monthly payment is a combination of interest and principal payments. As the interest payments decreases each month, the principal payments increases in the excat amount of the interest decrease.

Thie interest payment for the 1st month is the current balance (aka principal) times the monthly interest rate: $4,500 x 0.0025 = $11.25 (simple interest)

The amount applied to the loan balance (the principal) is: $130.87 - $11.25 = $119.62

The new loan balance is $4,500 - $119.62 = $4,380.38

The 2nd months interest charge is the adjusted loan balance times the monthly interest rate: $4,380.38 x 0.0025 = $10.95 (simple interest)

The amount applied to the loan balance is: $130.87 - $10.95 = $119.91

As you can see, the interest payment decreased from $11.25 to $10.95, a $0.30 difference. Since the monthly payment does not change, the $0.30 decrease in interest payments was added to the principal payment. Don't fret over the $0.01 difference as it will be made up in subsequent months due to rounding.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

10-24-2014 05:27 AM

Excel also has an amortization table feature where you can see the portion of principal and interest each month. There are also numerous amortization calculators:

http://www.bankrate.com/calculators/auto/auto-loan-calculator.aspx

Enter your loan data and scroll down to click on the amortization schedule. It will also show you how much you will save by making extra payments over the life of the loan.

And now a plug for savings/investing. If you make the monthly deposits to YOUR savings account. You become the bank and get the BENEFIT of the interest.

Understanding the power of the time value of money is the best lesson anyone can learn.

Now with the power of computers and the internet anyone can do it. Back in the old days, we did all these calcs by hand. When I was taking tests as a Finance undergrad, we couldn't even use calculators. We did all the math by hand and had to be able to do a lot of it in our heads as the tests were all timed.

Hoya08 wrote:It's simple interest as in: the interest charged is the CURRENT balance times the interest rate.

Although the Annual Rate is 3%, the monthly rate is 0.25%. The monthly rate (0.25%) is the significant rate since payments are remitted monthly. In this situation, simple interest is the loan balance times 0.0025. If payments were made Annually, then the significant rate is the Annual Rate (3%). In this situation, simple interest is the loan balance times 0.03.

This is where we start getting into the nuts and bolts of "the present value of money" , which is the basis of the equation presented earlier as well as the Excel formula, and it can get confusing.

If you are interested in the nuts and bolts of "the present value of money", I recommend obtaining an Introduction to Finance book from your local library, or googling for youtube videos and other web resources to help explain it.

To recap how auto loan interest is calculated:

Price: $4,500

APR: 3%

Term: 36 months

Your monthly payments are $130.87

The monthly payments are fixed and do not change. The monthly payment is a combination of interest and principal payments. As the interest payments decreases each month, the principal payments increases in the excat amount of the interest decrease.

Thie interest payment for the 1st month is the current balance (aka principal) times the monthly interest rate: $4,500 x 0.0025 = $11.25 (simple interest)

The amount applied to the loan balance (the principal) is: $130.87 - $11.25 = $119.62

The new loan balance is $4,500 - $119.62 = $4,380.38

The 2nd months interest charge is the adjusted loan balance times the monthly interest rate: $4,380.38 x 0.0025 = $10.95 (simple interest)

The amount applied to the loan balance is: $130.87 - $10.95 = $119.91

As you can see, the interest payment decreased from $11.25 to $10.95, a $0.30 difference. Since the monthly payment does not change, the $0.30 decrease in interest payments was added to the principal payment. Don't fret over the $0.01 difference as it will be made up in subsequent months due to rounding.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

10-24-2014 06:22 AM

coterotie wrote:Excel also has an amortization table feature where you can see the portion of principal and interest each month. There are also numerous amortization calculators:

http://www.bankrate.com/calculators/auto/auto-loan-calculator.aspx

Enter your loan data and scroll down to click on the amortization schedule. It will also show you how much you will save by making extra payments over the life of the loan.

And now a plug for savings/investing. If you make the monthly deposits to YOUR savings account. You become the bank and get the BENEFIT of the interest.

Understanding the power of the time value of money is the best lesson anyone can learn.

Now with the power of computers and the internet anyone can do it. Back in the old days, we did all these calcs by hand. When I was taking tests as a Finance undergrad, we couldn't even use calculators. We did all the math by hand and had to be able to do a lot of it in our heads as the tests were all timed.

I completely agree that everyone should attempt to learn the power of the time value of money. Learning the time value of money has been one of the most beneficial courses I've taken. And thank goodness for spreadsheets and financial calculators!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

10-24-2014 06:38 AM - edited 10-24-2014 06:40 AM

An amortization table can be created to see how much of the monthly payments are applied towards interest charges.

I tend to avoid amortization tables for auto loans. Instead, I use them for tracking mortgage payments.

I assume the question about monthly interest charges on an auto loan is to determine how much interest you will pay over the life of the loan. This is easy to figure out without an amortization table. *[see note below]

Loan: $4,500

APR: 3%

Term: 36 months

With the Excel formula =PMT(0.03/12, 36, $4,500)

The Excel formula returns a $130.87 monthly payment.

Since the payments are fixed for 36 months, your total payment is: monthly payment times term -> $130.87 * 36 = $4,711.16

The difference between the total payments and the original loan balance is the total interest paid: $4,711.16 - $4,500 = $211.16

Keep in mind the $211.16 in interest is the MOST interest you will pay (assuming you do not re-finance). In other words, you're paying about $70 per year in interest, or $6 per month to borrow $4,500.

* [note] Any additional payments to the principal will decrease the total interest paid. However, including additional payments ontop of the monthly payment requires an amortization table or further knowledge of the time value of money to manipulate the Excel formula to determine the total interest paid.

0

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

10-24-2014 08:16 AM - edited 10-24-2014 08:18 AM

The posts have helped a lot.

Here is a pic of the calculations I got for a car @ $5000 and an apr of 30% ( I like to calculate the highest possible )

Monthly fpr 36 months at 170 assuming I never pay anything towards the principal. ...

0

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

10-24-2014 10:55 AM

Unfortunately, the minimum payment for $5000 @ 30% for 36 months is $212.26. Lenders will not allow you to make less than minimum payments without incurring a fee.

In your scenario of only making $170 instead of $212.26, the loan will be paid off in 54 months.

Forums posts are not provided or commissioned by FICO. Forums posts have not been reviewed, approved or otherwise endorsed by FICO. It is not FICO's responsibility to ensure all posts and/or questions are answered.

*** For complete information, see the terms and conditions on the credit card issuer’s website.** Once you click apply for this card, you will be directed to the issuer’s website where you may review the terms and conditions of the card before applying. While myFICO always strives to present the most accurate information, we show a summary to help you choose a product, not the full legal terms - and before applying you should understand the full terms of products as stated by the issuer itself.

Copyright ©2001-2015 Fair Isaac Corporation. All rights reserved. | Terms of Use | Privacy Policy | Sitemap

**IMPORTANT INFORMATION:** All FICO^{®} Score products made available on myFICO.com include a FICO^{®} Score 8, along with additional FICO^{®} Score versions. Your lender or insurer may use a different FICO^{®} Score than the versions you receive from myFICO, or another type of credit score altogether. Learn more

FICO, myFICO, Score Watch, The score lenders use, and The Score That Matters are trademarks or registered trademarks of Fair Isaac Corporation. Equifax Credit Report is a trademark of Equifax, Inc. and its affiliated companies. Many factors affect your FICO Score and the interest rates you may receive. Fair Isaac is not a credit repair organization as defined under federal or state law, including the Credit Repair Organizations Act. Fair Isaac does not provide "credit repair" services or advice or assistance regarding "rebuilding" or "improving" your credit record, credit history or credit rating. FTC's website on credit.