# Thread: Interest calculation on theft/repayment amounts (Excel 2003/SP2)

1. ## Interest calculation on theft/repayment amounts (Excel 2003/SP2)

I received the following request from a colleague, and, while I can do a fair amount in Excel, I am by no means an expert. I'd appreciate any suggestions anyone can make as to how to set up a spreadsheet for the following scenario. What formulae can I use to calculate simple interest on each amount based on the date of the theft to today's date taking into account any repayment amounts. Does anyone know of a template or an online example that would help me with this issue? As always, I really appreciate the help from this group.

"We are doing a damages analysis regarding the theft and repayment of funds. The stealing occurred at many different times and the repayments were made in a similar, non patterned way. So, we want a way to calculate the "ongoing" interest that should be paid on the loss.

Claimant A Running Net loss Interest payable to date

Theft of \$100,000 on 1/1/2000 100,000 ______

Theft of \$200,000 on 3/2/2001 300,000 ______

Repayment \$30,000 on 5/2/2002 270,000 ______

Repayment \$25,000 on 3/4/2005 245,000 ______

We need to pay 6% simple interest on the "losses for this person" up to the date of repayment, which we will assume is today, but would
be the date we finally agree to the payment of restitution to the victim."

2. ## Re: Interest calculation on theft/repayment amounts (Excel 2003/SP2)

It is not clear to me how the calculations should be done and what numbers you want.

Could you explain how the numbers are to be calculated and possibly give a couple examples of the situations and the values?

Steve

3. ## Re: Interest calculation on theft/repayment amounts (Excel 2003/SP2)

Do you really mean "simple interest"? Compound interest would make much more sense in this case.

If you do really mean simple interest, on what amount should the interest be calculated on 12/31/2001?

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•