Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Checking monthly payment figure from an online calculator

Posted on 2014-01-06
7
Medium Priority
?
325 Views
Last Modified: 2014-01-14
Hi

I am looking at this online calculator and I confused where it gets its monthly repayment figure from.

Take 10,000 loan over 24 months with excellent credit (interest rate 2.64) and using flat rate of interest i get a montly repayment of 438.66 by doing this

((10,000 * 0.0264 * 2) + 10, 000 ) / 24

They get a repayment of £441. In fact their figures are always a few pounds higher. Please could you advise how they get a figure this high

Thanks a lot
0
Comment
Question by:andieje
7 Comments
 
LVL 54

Expert Comment

by:Scott Fell, EE MVE
ID: 39759021
Maybe they are not using simple interest and that will increase your payments.  Or the formula is wrong.
0
 

Author Comment

by:andieje
ID: 39759078
What do you mean by simple interest?
0
 
LVL 85

Expert Comment

by:ozo
ID: 39759148
Since the principle should decease as you pay it off, I would expect that the payments at 2.64% interest would be closer to 429.
24 monthly payments of 441 seems to imply about double that interest rate, or an extra fee of almost 300
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 54

Expert Comment

by:Scott Fell, EE MVE
ID: 39759163
It's been a long time for this but....

Simple interest is compounded 1 time per year.  

I = p× r × t

10,000 * 0.0264 * 2(years) =528  
10,000+528=10,528
10,528 / 24 months = 438.66

Compounded interest takes calculates the interest at each period based on the balance.
FV = PV × (1+r)n
where FV = Future Value
PV = Present Value
r = annual interest rate
n = number of periods

Compounded annually
10,000 * (1+.0264)^2=10,534.97
10,534.97 / 24 = 438.96

Compounded monthly
10,000 * (1+.0022)^24=10,541.58
10,541.58/24=439.23

Compounded daily
10,000 * (1+.00007232876)^730 =10,542.17
10,542.17/24=439.28
0
 

Author Comment

by:andieje
ID: 39760762
But thats what I mean...even with interest compounded daily you can't get a repayment of £441?? I dont know how they are getting it that high and the few pounds matter as the monthly payments feed into subsequent calculations. I dont want to assume it is erroneous but to me it implies a hidden fee like ozo said
0
 
LVL 54

Expert Comment

by:Scott Fell, EE MVE
ID: 39760812
Do you want to let us know the site where you are seeing this?   Maybe we can look to see if it is done via js and the formula will be available.  Or they must have fine print someplace.

<<edit>>
I wouldn't rule out my math
0
 
LVL 24

Accepted Solution

by:
Steve earned 2000 total points
ID: 39765113
I would most likely put this down to a staggered first payment...

For example taking the loan on the 1st of Jan and not then making first payment until the 16th of Feb.
This partial month at the start is common to arrive at a first payment on a desiable date (such as a payday).

The attached workbook may help explain with a week of month one paid in month 2.

This is just what I think may explain it... but it could be dreaded PPI hidden in there!!!
interest-calculator.xlsx
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

We are taking giant steps in technological advances in the field of wireless telephony. At just 10 years since the advent of smartphones, it is crucial to examine the benefits and disadvantages that have been report to us.
Lithium-ion batteries area cornerstone of today's portable electronic devices, and even though they are relied upon heavily, their chemistry and origin are not of common knowledge. This article is about a device on which every smartphone, laptop, an…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
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…

916 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