(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
Printer-friendly version
Send to friend
Mike, you described one of possible approaches to creating cash flow report using spreadsheet.
In Spider Project cash flow management is done automatically if planners enter both expenses and payments. I expect that other packages also can do this and create any reports on discounted cash flows.
Jus did not specify the software that is used. An answer to his question depends on the software capabilities.
Hi Jus
Cash flow is the difference between expenditure and income.
So you need two columns for these two sets of data on a spreadsheet.
Each row will represent either a calendar month or accounting period and in each cell you write the anticipated number for what you will spend and what you will recieve in that period - this takes care of the offset between invoice and payment for both employer and sub-contractor.
The difference for each month will be either a positive or negative cash flow - ie what your bank account should look like at that time.
Estimated figures are replaced with actual figures when the numbers firm up - that way you can generate planned v actual S-Curves.
Best regards
Mike Testro
Email: PPadmin@planningplanet.com
Replies