Cashflow forecast - help needed with formula

blue sky

New Member
Joined
Aug 2, 2010
Messages
20
Office Version
  1. 365
Platform
  1. Windows
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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

blue sky

New Member
Joined
Aug 2, 2010
Messages
20
Office Version
  1. 365
Platform
  1. Windows
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?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,029
Messages
5,856,933
Members
431,840
Latest member
simplysoph

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top