Modeling: what formula do you use to make the proforma years dynamic?
If I wanted to adjust my hold period from 5years to 8years by simply changing the input of one cell, and have the rest of the projections follow (ie gpr, expenses, noi, etc.) What is the formula do I use?
[{"id": "fghsvi3", "text": "Theres not really a formula for that. You could have the years across the top row and have the pro years tied to an if that compares the year to the year in your trigger cell. Something like you set trigger cell A1 to 2028\n\nHave years across row B and every cell in the pro forma could be if(B2 &lt;= A1, whatever would normally be in the cell, else 0) then set formatting so zero does not appear.  Have your aggregation cell such as your sum of income tied to all those cells such that it captures the regular value if triggered and zero if the cell is not triggered.\n\nAlso, try to avoid building complicated spreadsheets. They are annoying af for anyone but the creator to work with.", "replies": [{"id": "fgnujq7", "text": "&gt;Also, try to avoid building complicated spreadsheets. They are annoying af for anyone but the creator to work with.\n\nGuilty.", "replies": [{"id": "fgnult8", "text": "Stop it.", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "fghwgkz", "text": "I use an if statement. Put the years above and have a hold period cell. \n\nSo \n\n=if(sale year=number above, NOI/EXIT CAP, 0)", "replies": [], "depth": 1}]