R
RUFUS911
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.
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.
