CREATING FORMULA FOR CALCULATING ENDING BALANCE WITH PMT AND INTRE

[HEIDI]

I AM HOPING TO GET SOME ASSISTANCE IN CREATING EXCEL FORMULA, THAT WILL TAKE
MY BEGINNING CREDIT CARD BALANCE CALCULATE INTEREST ACCRUED ON A MONTHLY
BASIS BASED ON VARIOUS INTEREST RATES MINUS MONTHLY PAYMENT GIVING ME AN
ENDING BALANCE SOMETHING THAT i CAN CARRY ON FROM MONTH TO MONTH OR CALCULATE
LONG TERM I AM KINDA NEW TO EXCEL SO ANY HELP WOUL DBE GREAT

 

[Ron@Buy]

Heidi
First off - DON'T SHOUT !!
Rather than reinvent the wheel why not try an existing template?
Try
http://office.microsoft.com/en-us/templates/TC300016541033.aspx?CategoryID=CT101444811033