Solved

Calculating APR - effect of an upfront fee

Posted on 2013-12-30
4
335 Views
Last Modified: 2014-01-06
Hello
I'm looking at this online apr calculator and I'm a bit confused as to why adding an upfront fee to a loan increases the apr so much

http://www.financecalcs.co.uk/smartcalcs/LoanCalculatorquote.php

For example, if i add a fee of £250 to a 10k loan over at 5% interest over a year the apr changes from 9.5%, the apr changes to 14% give or take depending on whether the fee is upfront or spread. I dont understand why this is so much higher than if i simply borrowed 10250 (where the apr stays at 9.5%). I know that doing this approximation isn't quite the same as having an upfront fee because an upfront fee would affect the value of the first monthly payment whereas all the payments are the same in my quick workaround , but even so i wouldnt expect this. In fact i would expect an upfront fee which is paid off in the first month and hence accrues hardly any interest would have negligible affect on APR?

Thanks in advance for any light you can shed
0
Comment
Question by:andieje
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 25

Expert Comment

by:nickg5
ID: 39751487
In that calculator what number are you entering in the space for "flat rate of interest"
Are you entering 0
0
 

Author Comment

by:andieje
ID: 39752444
5%
0
 
LVL 25

Accepted Solution

by:
nickg5 earned 500 total points
ID: 39752506
Leave the $10,000 as $10,000. Then change the "upfront" to "spread" and you see that the 14.4% goes to 14.8%.

The actual interest is $500 or 5% of $10,000.
That same $500 is the "total charge for credit"

If you add the 250 as an arrangement fee then you see the "total charge for credit" is $749.96 which is accurate.

Now, change the $10,000 to $10,250 and leave the arrangement fee zero.
Now the "total charge for credit" is $512.56 which is also correct.

Why? Because you are "financing" the extra $250 at 5%. 5% x 250 = $12.50.

It's more simple to not use such calculators.
The 14.5 or the 14.8 or the 9.5 does not change the numbers.

If the 250 is part of the loan you pay 5% on that 250.
If 250 is not part of the loan but an arrangement fee then the entire 250 is added to the $500 interest and is excluded from the A.P.R. which is calculated on the loan amount of $10,000 at 5%. That is why you only see 9.5%

By adding the 250 as part of the total cost of credit you are increasing the "total" extra from $500 to $750.

So, since you are increasing the 5% or $500 by 50% by adding another $250 here is where
the 9.5% must also go up by 50%.

What is 50% of 9.5? It's 4.75
4.75 + 9.5 = 14.25 and basically completes the math on how the 9.5% gets to 14.4 or thereabouts.
0
 

Author Closing Comment

by:andieje
ID: 39760753
Brilliant explanation - thank you
0

Featured Post

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Guide to the PMT, FV, IPMT and PPMT Functions In MS Excel we have the PMT, FV, IPMT and PPMT functions, which do a fantastic job for interest rate calculations.  But what if you don't have Excel ? This article is for programmers looking to re…
Introduction On a scale of 1 to 10, how would you rate our Product? Many of us have answered that question time and time again. But only a few of us have had the pleasure of receiving a stack of the filled out surveys and being asked to do somethi…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Suggested Courses
Course of the Month6 days, 15 hours left to enroll

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question