Hi, I want to be able to do a simple cashflow forecast using excel. My question is how to treat deposits, taken in say month 1 and the balance in say month 10. The month for the Balance is variable. I may well want to run the cashflow but taking the balances in month 11 or 12 rather than say month 10. Hope this makes sense! I could do this but using extensive If statements but I am thinking there has to be a better way!