spreadsheet for accruing interest and penalties that vary

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to create a spreadsheet that calculates compounding interest and
penalties, where the interest rates change per quarter.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top