VARYING RATES OF COMPOUND INTEREST

G

Guest

What's the best way to create the following table:

I have 100 tenants residing in 15 different apartment buildings. I need to calculate the security deposit that each one is due upon move-out based on the following: No security deposit is the same amount. Interest compounded daily must be calculated on each deposit. Each month the interest rate is different. Forfeitures must be taken into consideration. People move in and out all of the time. Using Excel 2000 Pro.
 

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

Similar Threads

VARYING COMPOUND INTEREST 7
determine unknown interest rates 4
Daily compound interest 2
Excel template for daily compound interest varying monthly paymen 1
Need formula to figure compound interest of a deposit for a year 3
Loan Compound Interest Function 4
compound sum interest factor function? 5
Calculate bank interest 2

Top