http://dl.dropbox.com/u/59808759/ground%20rent%20p...

here is the link, should work.. ive just put three units in but i have a list of hundreds..

The cell i want to solve is AF3... which is the PV of the lease to termination. i.e. for the top unit with the doubling rent it should be 13 years at 175, 25 years at 350, 25 years at 700, 24 years at 1400.. now i can go that sum manually with ease, but im not sure how to automate it in excel. i may be being stupid and it is easy.. What i dont want to do it have a huge cashflow, i just want a single cell answer.

The rising ones i havent got the details of the effect yet so ignore them, and the fixed ones are fixed so are easy.