I am an owner in a condo association that is self-managed. I have agreed to help the Board of Directors with a spreadsheet that will track dues, payments, late charges and interest charges. The attorney for the condo association says that a simple interest calculation should be used instead of a compounding calculation.
I am a software developer and have programmed both simple and compound interest for mortgages, etc., but am not sure of how simple interest is calculated on dues and late charges. Can anyone help me with a specific step-by-step procedure?