I hope my grid below looks OK once it is posted. I need a formula to
solve for cell G3. I need a single cell formula to solve for the
total value of a commercial lease given the initial annual rent, the
rent increase percentage and how often (in years) that the rent is
increased. Any ideas?


A B C D
E F G
1
Total Value
2 Tenant SF $/SF Term (yrs) Increase amount % Every
X years of Lease
3 Ross 30,000 7.00 10 5%
2 ???