Name of Company: Period from: Period to: 1 Month Ending: Receipts Cash Sales From Debtors Term Loans Grants Share Capital Other Sources: A: Total Receipts Payments Cash Purchases To Creditors Wages and Salaries (net) Rent, rates and insurance Light, heat and power Telephone, post, stationery Selling and distribution expenses Motor Travel Advertising Loan repayments Financial charges/interest PAYE, PRSI, NIC, VAT Capital Expenditure Other Payments B. Total Payments C. Net Cash (A-B) Opening Balance Closing Balance (C+D) B € € € € € € Purchase of supplies for which payment is made immediately Payment for goods bought on credit Enter payments net of all deductions € € € € € € Schedule A € € € € € Sales for which payment is received immediately Receipts in respect of credit sales Central, local and European government agencies Owner's investment in business Sale of assets, director's loans, VAT refunds, etc € € € € € € € 2 3
CASHFLOW FORECAST
4 5 6 7 8 9 10 11 12
Commissions, entertainment expenses etc
Check loan conditions for repayment schedules Bank interest, leading/hire purchse charges etc Payments for fixed assets - premises, plant & equipment, motor vehicles etc Audit, legal fees, private health and pension payments
Name of Company: Period from: Period to: Schedule A
RECEIPTS FROM DEBTORS
FUNDS TO BE RECEIVED IN PERIODS
Period Ending
Projected Credit Sales
(Total = )
1 Jan
2 Feb
3 Mar
4 Apr
5 May
6 Jun
7 Jul
8 Aug
9 Sep
10 Oct
11 Nov
12 Dec
Outstanding from previous year 1 2 3 4 5 6 7 8 9 10 11 12 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
RECEIPTS FROM DEBTORS
(TO CASHFLOW FORECAST)
Name of Company: Period from: Period to: Schedule B
PAYMENTS TO CREDITORS
FUNDS TO BE PAID IN PERIODS
Period Ending
Projected Credit Purchases
(Total = )
1 Jan
2 Feb
3 Mar
4 Apr
5 May
6 Jun
7 Jul
8 Aug
9 Sep
10 Oct
11 Nov
12 Dec
Outstanding from previous year 1 2 3 4 5 6 7 8 9 10 11 12 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
PAYMENTS TO CREDITORS
(TO CASHFLOW FORECAST)