I'm currently interning at a real estate private equity firm and I have to build a model to analyse the DCF value of potential investments. My model is good, but different types of real estate do have different life spans. For every real estate property with a different life span I have to build a new model. I would like to have one dynamic model which suits all life spans.
How my current model looks:
* On top you input the variables like cost of equity, income through rent, etc
* Horizontally there are years. Now I have 36 years, but for my next model I need 27.
* Vertically there is a profit & loss statement, a balance statement, a cashflow statement and a DCF statement.
What I want to achieve is that on top you have a variable: "life span" where you can put for example "27" and then automatically it adapts the number of forecasted years horizontally.
Is there an Excel formula to achieve such a thing?