A month by month cashflow forecast aims to predict the monthly cash movements from a given set of sales and profit assumptions.
It takes into account VAT and credit days given to customers and taken from suppliers as well as accruals and prepayments.
A prepayment arises for example where rent is paid quarterly in advance and expensed to the P&L account monthly.
The sales template in the model allows you to enter debtor days, % Cash and VAT % for each line of sales.
The sales template in the model allows you to enter creditor days , % Cash and VAT % for each line of cost of sales.
The Expenditure template allows you to enter a VAT % for each line of expenditure
E.g. 60 days would mean customers pay you on average 60 days after invoicing
E.g. 50% Cash would mean that 50% of the sales are cash sales
E.g. 100% VAT would mean that 100% of that category of sale attracts VAT at 20%
In the P&L account income and expenditure is expressed as net of VAT in the period to which it was invoiced or to which it relates
In the cashflow forecast income and expenditure is included as the amount paid or received including VAT in the period in which it paid or received.
The model takes account of the above and forecasts income and expenditure in the cashflow on the above basis.
“4CastPro excels in multi-level budgeting and consolidation. The six-digit cost centre coding enables users to create a sophisticated hierarchy of cost centres, from the group consolidated budget at the top down to individual departmental budgets.“
Belleville Rodair International Ltd are a successful International Freight Forwarders based in Shad Thames, London. They operate from various subsidiaries around the world that all run on a bespoke SQL based freight forwarding system with a finance back end...
The Midland Oil Group has grown to 7 companies in related business areas and a package was needed to consolidate monthly management accounts and provide easy budgeting and planning as the task was becoming tricky to perform using spreadsheets...
Michael Abakhan Ltd (MAL) are a successful retail group with a head office based in North Wales. They sell Fabrics, Knitting, Habberdashery, craft goods etc via their retail outlets. Some sites also have coffee shops. MAL have used the 4CastPro product now for 6 years and have been responsible for many of the products upgrades...