# Cashflow forecast - help needed with formula

#### blue sky

##### New Member
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!

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

#### blue sky

##### New Member
ok, maybe I need to expalin some more:
I take an order in month one for say, £1000. In the month one cash column goes a 20% deposit of £200. In the month 10 column goes the payment balance of 80%, £800.

Whilst this is very simple to do the problem comes when I want to change the spreadsheet to reflect what happens top my cashflow if the balances are not paid until, say month 12.

I would have thought it would be a fairly common problem but how to solve it?

anyone?

Replies
0
Views
35
Replies
2
Views
56
Replies
2
Views
60
Replies
0
Views
41
Replies
1
Views
72