Finance & Business

Aug 6 2017

How to Calculate Annual Percentage Rate (APR) #private #student #loan #consolidation

#interest rate on car loan

Why Use APR?

They might include certain costs that you re likely to pay, or they might conveniently omit those costs in advertisements and brochures. You might even get completely transparent quotes from different lenders, but be unsure which one is less expensive (because the interest rates and closing costs are different).

APR helps you (more or less) get an apples-to-apples comparison of loans by accounting for all of the costs related to borrowing.

If you just want an APR calculation without all of the math, use our online APR calculator .

What is APR?

APR allows you to evaluate the cost of the loan in terms of a percentage. If your loan has a 10% rate, you’ll pay $10 per $100 you borrow annually. All other things being equal, you simply want the loan with the lowest APR.

APR Limitations

Unfortunately, all other things are never equal. There are a few important things you should know about using APR.

With credit cards. APR tells you what interest rate you pay, but it doesn’t include the effects of compounding – so in reality you probably pay more than the APR.

Continue Reading Below

If you only make small payments on your credit card, you’ll start paying interest not only on the money you borrowed, but you’ll also pay interest on the interest that was previously charged to you. This compounding effect can raise your cost of borrowing higher than you might think. Instead of looking at the APR, APY would be a more accurate description of how much you pay.

In addition, APR for credit cards only includes interest costs – it doesn’t account for the other fees you pay to your credit card company, so you have to research and compare those costs separately. Annual fees, balance transfer fees. and other charges can add up, so a card with a slightly higher APR might be better in some cases (depending on how you use your card). In addition, your credit card might have several different APRs. so you pay different rates for different types of transactions.

With mortgage loans . APR is complicated because it does include more than just your interest charges. Any quotes you get might or might not include closing costs that you’ll have to pay or other payments required to get your loan approved (such as private mortgage insurance ). Lenders have the ability to choose whether or not certain items are part of the APR calculation, so you have to look closely if you’re comparing loans .

You can’t simply rely on an APR quote to evaluate a loan. You need to look at each and every charge and expense related to your prospective loan in order to judge whether or not you’re getting a good deal. In addition, look at the bigger picture – you need to know how long you’ll be using a loan to make the best decision. For example, one-time charges up-front may drive up your actual cost on a loan – but the APR calculation will assume those charges are spread out over a longer lifetime (and therefore the APR would look lower). If you re going to pay a loan off quickly, APR tends to underestimate the impact of up-front costs.

APR Example With Excel

APR seems really easy, but it’s amazing to watch the numbers (and your costs!) change with different scenarios.

Assume you will borrow $100,000, and the lender tells you you’ve got a 7% interest rate (you ll need to convert that from percentage to decimal format ). You also have $1,000 in closing costs. The APR on a 30 year fixed rate mortgage would be 7.10%.

To test this, try the math yourself. In Microsoft Excel, follow these steps:

Find the monthly payment for loan and closing costs:


The format is: PMT(rate,nper,pv ,fv,type)

  • .07 divided by 12 is the rate (you’re using a monthly rate to find monthly payments)
  • 360 is the number of periods (payments or months – 30 years here)
  • 100,000 is the present value of your loan (including additional costs)

You should have a result of $665.30.

Next, Solve for the APR:


The format is: RATE(nper,pmt,pv ,fv,type,guess)

  • 360 is the number of periods you pay on the loan (360 months or 30 years)
  • – 665.30 is your payment
  • 99,000 is the present value of your loan (how much you’re actually borrowing)

You should have a result of .592%. This is a monthly rate. Multiply by 12 to get 7.0999%.

Why is the loan amount smaller in the third bullet point above? We need to calculate the rate for this step using an decreased loan balance of $99,000 (the $100,000 loan minus the $1,000 in fees required to get that loan).

As you compare loans, you might hear additional terms, such as variable APR and 0% APR. To learn more about different types of loans, see What does APR Mean?

Written by pharma auto insurance apartment car quote rental score loan real estate income travel usa free student credit

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.