LiveOak Posted July 2, 2001 Share Posted July 2, 2001 WHY ARE YOU SHOUTING? You'll need to refresh our memory on exactly the structure of your file an what you wish the calculation to accomplish. Also throw in the calculation you are currently using. -bd Link to comment Share on other sites More sharing options...
DUNDON Posted July 3, 2001 Share Posted July 3, 2001 I RECENTLY SUBMITTED A QUESTION REGARDING CALCULATION OF FINANCE CHARGES... HOWEVER I HAVE SEVERAL INVOICES GOING OUT TO A YEAR. STATE LAW PROHIBITS FINANCE CHARGES TO GO PAST ONE YEAR. WHAT WOULD BE THE CALCULATION TO SCALE THE ADDITIONAL FINANCE CHARGE EACH THIRTY DAYS 30,60,90,120,150,180,210,240,270,300,330, AND 360. I ORIGINALY THOUGHT AN IF WITHIN AN IF, AND SO ON, IT DOESN'T SEEM TO WORK OUT. ANY HELP WOULD BE APPRECIATED. Link to comment Share on other sites More sharing options...
BobWeaver Posted July 7, 2001 Share Posted July 7, 2001 Given: IntRate = monthly interest rate in percent InvDate = Date of invoice InvCharge = Amount of original invoice Then the compound interest charge will be: ((IntRate/100+1)^Min(Int((Status(CurrentDate)-InvDate)/30),12)-1)*InvCharge Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8351 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now