View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
johnsnow johnsnow is offline
external usenet poster
 
Posts: 1
Default Creating a specialized worksheet for my credit cards.


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.


--
johnsnow
------------------------------------------------------------------------
johnsnow's Profile: http://www.excelforum.com/member.php...o&userid=37095
View this thread: http://www.excelforum.com/showthread...hreadid=568217