I am working on a small model that calculates cash flows, within the model the cash flows are broken up by month and after 12 months the cash flows automatically increased by CPI. The cash flows do not always start at the same month. I would like to us an if statement to instruct the cash flow to start in the appropriate month however my problem is getting the CPI calculation to automatically start 12 months after the cash flows starts.
(ie cash flow 1 starts in month 6 so on month 18 I would like the cash flow to increase by CPI. And cash flow 2 starts month 3 I would like to start the CPI increase on month 15.) These months will change with every example I put into my model.
Thank you in advance for everyone’s help. Let me know if I need to explain the problem in greater detail.