SOLUTION: The balance on joe's credit card is 8000. payments are made monthly but interest is compounded daily. The stated APR is 18. Joe has since cut up the credit card and wishes to pay o

Question 662277: The balance on joe's credit card is 8000. payments are made monthly but interest is compounded daily. The stated APR is 18. Joe has since cut up the credit card and wishes to pay off the balance in 5 years. What should his monthly payment be to reach his goal?
(1+.18/365)^(365/12)-1 =1.015% this is the correct rate but I am not sure how to find the actual amount joe will need to pay monthly to answer this question.
Answer by KMST(5328) (Show Source): You can put this solution on YOUR website!
DISCLAIMER: I am not into finance. I am just a math/science-loving old chemist.

I agree that to calculate the interest accrued over 1 day, you would multiply times ,
and that to calculate the balance after 1 day, you would multiply times ,
and that to calculate the balance after 1 month, you would multiply times .
(conveniently rounded) as per my computer.
The monthly interest rate would be 0.01511 (as a decimal), or 1.511% per month.

On my computer, using Excel, the function
PMT(0,01511,60,8000)=$203.72
calculates the monthly payment needed to pay off
$8000, in 60 months, at an interest of 1.511%,
making payments at the end of each month.

Bank people probably have even easier ways to calculate it,
but I like to understand the algebra in it,
and here is what I understand:
One month after starting the loan,
with the interest accrued, the balance would be
$, but at that point Joe pays $,
and the new balance is $
A month later, the same thing happens, and the balance becomes
$
Calling to save ink,
the balance is $ after 2 months,
$ after 3 months,
$ after 4 months, and so on.
After 5 years (60 months), the balance is
$.........=$
So, (.........)
It is not hard to prove that the sum in brackets can be calculated as
.........
So we can write the equation above, using the simpler sum calculation, as

And now we can solve for
-->
The computer calculated for me
(conveniently rounded),
(conveniently rounded),
and we know
So the good enough approximation is
(Using yields , which is less accurate).
RELATED QUESTIONS
Delilah opens a credit card with an APR of 24.38% compounded monthly. How much is charged (answered by jim_thompson5910)

Elaine was charged $288 interest for 1 month on a $1600 credit card balance. What was... (answered by checkley75)

Suppose we have a credit card company that sets the due date every 1st month. If its... (answered by ikleyn)

last month visa credit card charged $42.65 in interest (finance charges) on a balance of... (answered by rfer)

On October 23, you plan to purchase a $1,800 computer by using one of your two credit... (answered by CPhill)

Joe was charged $437 interest for 1 month on a $3800 credit card balance. What was the... (answered by joyofmath)

Joe was charged $66 interest for 1 month on a $1200 credit card balance. what was the... (answered by checkley71)

1.Marina had an accident with her car and the repair bill came to $800. She didn�t have... (answered by ikleyn)

You purchased a laptop computer worth PhP 28,998 by a 30% down payment and agreed to... (answered by Theo)