Ok I have been playing with this for a couple of weeks now and have yet to come up with a formula that works.
A1 - Annual Interest Rate of Credit Card
A2 - Total Balance of Card
A3 - Minimum monthly payment
=ROUND(0.5+NPER((a1/12), a3*-1, a2),2)
I thought this would work, but I am getting a NUM error.
Any assistance. I would like to know two things. How many months until paid in full. How much interest would be paid.
Bookmarks