Use three versions in model
I'm trying to build a rolling forecast model that has actuals, budget, latest estimate and forecast with the following dates:
Current month = jul 2015
Budget = currenlty available for 2015, should be updated every year
Latest estimate = sum of actuals and remaining budget in the current year (2015) according to the current month
Forecast = 2016 - 2020
I'm not sure how this can be best build in the model, either through time ranges or versions. Currently I'm trying to build some versions (see attached image). Here I'm not sure how the rollovers should work and what is the current version. Is there anyone that has some advise on this?
Another question: how can formula's be applied to different versions? For example: forecast = (t - 1) * ( 1 + 1%). Where, in the first column t - 1 should be linked to the budget / actual.