How often is interest compounded? Daily? Monthly? Quarterly? Annually?
How often do you have transactions which affect the balance?

Whether you have many transactions per period (such as a credit card bill),
or many periods per transaction (like a long-term investment), will make a
difference in how you set up the spreadsheet.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Dean" <Dean @discussions.microsoft.com wrote in message
...
Trying to create a spreadsheet that calculates compounding interest and
penalties, where the interest rates change per quarter.