I worked out my total receipts by using an excel friendly formula, this allowed me to quickly and easily and also enabling me to use this formula repeatedly.
To work out the payments I reused this formula and was able to quickly work out each number.
I used the notes and comments to guide myself through how to work out each equation and to know what formula to use.
Total receipts are found by adding together the retained profits from 2013 financial year, and sales revenue.
The total payments is found when the wages, loan payments, electricity, advertising, phone and building materials are added together.
The net cash flow is then found by subtracting the total receipts and total payments from each other.
What to do if you have a cash flow problem?
Cut back unnecessary spending.
Also you could use some internal savings, or use some of the savings from previous profits.
Sell previous stocks with discounts or offers. And rotate stocks.
Reduce staff or reduce the pay you give staff/certain staff.
Cut back on the higher priced costs for products, and find alternatives.