Hi
I have this worksheet which column d12 is the monthly rent and which increases at the rent increase rate @d5,at the specified perid@d7. I wanrt to shorten the formula and also eliminate the amounts shown in column c12 and down. pls let me have any suggestions
REgrds
Shamsu
I have this worksheet which column d12 is the monthly rent and which increases at the rent increase rate @d5,at the specified perid@d7. I wanrt to shorten the formula and also eliminate the amounts shown in column c12 and down. pls let me have any suggestions
REgrds
Shamsu
Menu | Lease Term | 96 | |
Rental Rate | ₹ 16,500.00 | ||
Lease Date | 10-09-20 | ||
First Payment Date | 01-10-20 | ||
Current Date | 08-06-21 | Rent Increase % | 10.00% |
Increase @ Period No | 154 | ||
Increase Interval | 12 | ||
Increase Due | 01-10-21 | ||
New Rent | ₹ 19,965.00 | ||
Period No | Month | Rent | Rent Increase |
01-01-09 | Montly Rate | ||
142 | 01-10-20 | ₹ 16,500.00 | ₹ 16,500.00 |
143 | 01-11-20 | ₹ 16,500.00 | ₹ 16,500.00 |
144 | 01-12-20 | ₹ 16,500.00 | ₹ 16,500.00 |
145 | 01-01-21 | ₹ 16,500.00 | ₹ 16,500.00 |
146 | 01-02-21 | ₹ 16,500.00 | ₹ 16,500.00 |
147 | 01-03-21 | ₹ 16,500.00 | ₹ 16,500.00 |
148 | 01-04-21 | ₹ 16,500.00 | ₹ 16,500.00 |
149 | 01-05-21 | ₹ 16,500.00 | ₹ 16,500.00 |
150 | 01-06-21 | ₹ 16,500.00 | ₹ 16,500.00 |
151 | 01-07-21 | ₹ 16,500.00 | ₹ 0.00 |
152 | 01-08-21 | ₹ 16,500.00 | ₹ 0.00 |
153 | 01-09-21 | ₹ 16,500.00 | ₹ 0.00 |
154 | 01-10-21 | ₹ 16,500.00 | ₹ 0.00 |