What I am trying to do is find the total months it would take to pay a card and how much it will be total with interest.

Example

credit card bill

$1000.00

Interest

17.99% apr

Monthly payments

3% or 10 dollars, which ever is greater

I am really trying to figure out how to get two columns, one with the total amount that would be paid paying the minimum payments and one column showing how many months it would take. By just imputting in one column the balance and in another column the interest rate. So four columns total.

It is so hard because of the changing minimum payments every month as the balance changes.

Any super geniuses able to help me out please?

Thanks.