Math question regarding a car loan

I just got approved for 15k for a car loan with a 3.5% interest.  This will be for 5 years, as far as the loan.  I was told that this loan is based on simple interest.

Here are my questions:

1.  How much will I pay on a daily interest?
2.  How much will my payment be, monthly?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zorvek (Kevin Jones)ConsultantCommented:
Your monthly payment will be 272.88.

Your daily interest will vary month to month as you pay off the principle.

zorvek (Kevin Jones)ConsultantCommented:
The total amount of interest you will pay over the life of the loan is the total amount paid less the financed amount or (272.88 x 12 x 5) - 15,000 = 1,372.80.

Mike TomlinsonHigh School Computer Science, Computer Applications, and Mathematics TeachersCommented:
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Anthony MellorChartered AccountantCommented:
daily interest 0.2876712328767123
days 1825
monthly payment 293.75
Anthony MellorChartered AccountantCommented:
however my own calc is:

Total daily interest 1371.31
Total repayments 16371.00
Monthly Payment 272.85

which makes zorvek right in the first place.
awking00Information Technology SpecialistCommented:
>>Your daily interest will vary month to month as you pay off the principle<<
This is not quite true with simple interest. See the link here -
Which points out the pitfall of simple interest versus an amortized loan.
The calculation of 293.75 as a monthly payment is the more accurate one, although the amount of interest paid will actually depend on what day of the month it's paid and how many days from the time the last payment was made. The monthly payment of 272.88 would be correct if the loan were amotized.
Anthony MellorChartered AccountantCommented:
Ah,  separated by a commin language,  we call that the "flat rate" which resulted in a law change (years ago now)  to require the apr to be disclosed like on your linjed lian agreement.

All it is is a way to make it simple to work with,  while being unrelated to the time cost of money.

Glad to have seen this
zorvek (Kevin Jones)ConsultantCommented:
Which is, although legal, a crime as far as I'm concerned.

vulture71, before you sign anything, I strongly suggest you call the lending institution and ask them what the monthly payment will be. Given that answer - and they most definitely will comply - you will be able to determine if you are getting taken to the cleaners. My guess is that if the lending institution is a bank or credit union, it will be the better deal. But if it's through the car dealer - especially a used car dealer - you may be getting a bad deal. And the dealer is probably getting a bit of a kickback.

awking00Information Technology SpecialistCommented:
I was in the banking business for a number of years and we always had a saying, "Figures don't lie, but liars figure."
Anthony MellorChartered AccountantCommented:
Really we need just a bit more information than was given. Or even the apr which I imagine is legally required there as it is here.

@kevin no argument with that here.
awking00Information Technology SpecialistCommented:
All lenders are required to provide a "truth in lending" statement, which includes the apr.
zorvek (Kevin Jones)ConsultantCommented:
Now the question is: where is vulture71?

simple interest means to me that you pay 3.5% of the 15,000 per year as interest, all added together with the capital then divided by 60 months

15000 x (1 + .035 x 5) / 60 = 293.75
Anthony MellorChartered AccountantCommented:
Same here for "flat rate".
apr = 6.736%
awking00Information Technology SpecialistCommented:
I calculated an apr of 6.537%. Am I missing something?

I made it monthly apr -     i  = 1.06736^(1/12) - 1 = .005447

present value = 293.75 *(1 - (1+i)^-60) / i = 293.75 * 51.06396  = 15000

assuming payments are monthly in arrears

to solve for i, I used IRR function of excel

the present value formula is one I've used in the past that I recalled
awking00Information Technology SpecialistCommented:
The present value for a series of equal payments is the summation of the payments divided by one plus the interest rate per period to the power of the period, where the period ranges from 1 to n and is generally written as:
PV = S   PMT/(1 + i)^n
Applying that to this case where the number of periods is 60 would be:
15,000 = S   293.75/(1 + i)^n
And the present value of 15,000 would determined by:

15,000 = 293.75/(1 + i) 1 + 293.75/(1 + i) 2 + 293.75/(1 + i) 3 + … + 293.75/(1 + i) 60

Unfortunately, there is no direct method for solving i in this equation, so we need to solve for the present value using an iterative process of estimating i until the value of 15,000 is reached. The attached spreadsheet shows the complete calculations.
awking00Information Technology SpecialistCommented:
Note - the S in the equations above was intended to be a sigma (signifying a summation) but didn't convert with the fonts on this site.
Anthony MellorChartered AccountantCommented:
XX% begin
YYY% end

Depending whether payments are at the begin or end of each payment period.

This is calculated the old fashioned way with an HP12C,  Originally the HP38c from the 70s... the financial calculator of choice for finance.There's even an app these days. Anthony
zorvek (Kevin Jones)ConsultantCommented:

The guy is buying a used car and wants to know what the payment and interest is. I really don't think he is all that interested in various percentage calculations to six decimal places. He's not a hedge fund manager working with a few billion dollars.

Speaking of whom, I wonder where the hell he is...

Anthony MellorChartered AccountantCommented:
reckon he's on Easter break.

15000 x 3.5% = 525
 2625.00 = 525.00 x 5 = total interest
17,625.00 / 60 = 293.75 per month. .. 17625 is total paid.

(6.772097% begin)
6.536679% end - this is the one to expect.

Depending whether payments are at the begin or end of each payment period.

This is calculated the old fashioned way with an HP12C,  Originally the HP38c from the 70s... the financial calculator of choice for finance.There's even an app these days.

assuming simple interest method = flat rate method.

pays total 17625 at 293.75 per month.

zorvek (Kevin Jones)ConsultantCommented:
Question: How many Experts does it take to answer a simple used car loan payment/interest question?

Answer: Ask it, go skiing for a week, and then tabulate the fun!

awking00Information Technology SpecialistCommented:
My latest posts were directed at deighton and not vulture71 regarding computation of the apr. Hopefully, vulture71 will receive a truth in lending statement that will include the apr, which will verify or refute the payment of 293.75 that I posted. As far as the interest payment is concerned, the total intest paid over the life of the loan is 2,625.00 (293.50 * 60 - 15,000). How it may be applied is somewhat at the lenders discretion. It might be 43.75 for each monthly payment or it could be calculated at 7.18 per day and applied based on the number of days between payments, or some other method. Whatever it is will be made known upon the receipt of the truth in lending statement.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
zorvek (Kevin Jones)ConsultantCommented:
I realize that. I'm more concerned with the OP getting his question answered. This is his question, not ours. I'm not saying don't - just observing and making sure we don't get too carried away and take the OP's question into areas it really shouldn't go.

awking, in your spread sheet you have calculated monthly interest as i/12
but in uk rules it has to be calculated as (1 + i)^(1/12) - 1

I seem to recall
Anthony MellorChartered AccountantCommented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Math / Science

From novice to tech pro — start learning today.