SALES FORECAST TEMPLATE - COMPANY NAME
UNPROTECTED UNRESTRICTED MODEL VIEWABLE BY SUBSCRIPTION MEMBERS ONLY
Summary
Estimated close date by end month 1 by end month 2 by end month 3 by end month 4 by end month 5 by end month 6 by end month 7 by end month 8 by end month 9 by end month 10 by end month 11 by end month 12 TOTAL Weighted forecast £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Monthly analysis
by end month 1 Customer ABC Ltd DEF Ltd GHI plc JLK Partners Forecast total for period Status In progress In progress In progress Early stages
by end month 2
Customer ABC Ltd DEF Ltd GHI plc JLK Partners Forecast total for period
Status In progress In progress In progress Early stages
by end month 3
Customer ABC Ltd DEF Ltd GHI plc JLK Partners Forecast total for period
Status In progress In progress In progress Early stages
by end month 4
Customer ABC Ltd DEF Ltd GHI plc JLK Partners Forecast total for period
Status In progress In progress In progress Early stages
by end month 5
Customer ABC Ltd DEF Ltd GHI plc JLK Partners Forecast total for period
Status In progress In progress In progress Early stages
by end month 6
Customer ABC Ltd DEF Ltd GHI plc JLK Partners Forecast total for period
Status In progress In progress In progress Early stages
by end month 7
Customer ABC Ltd DEF Ltd GHI plc JLK Partners Forecast total for period
Status In progress In progress In progress Early stages
by end month 8
Customer ABC Ltd DEF Ltd GHI plc JLK Partners Forecast total for period
Status In progress In progress In progress Early stages
by end month 9
Customer ABC Ltd DEF Ltd GHI plc JLK Partners Forecast total for period
Status In progress In progress In progress Early stages
by end month 10
Customer ABC Ltd DEF Ltd GHI plc JLK Partners Forecast total for period
Status In progress In progress In progress Early stages
by end month 11
Customer ABC Ltd DEF Ltd GHI plc JLK Partners Forecast total for period
Status In progress In progress In progress Early stages
by end month 12
Customer ABC Ltd DEF Ltd GHI plc JLK Partners Forecast total for period
Status In progress In progress In progress Early stages
BSCRIPTION MEMBERS ONLY
Forecast £0 £0 £0 £0 £0
% 0 0 0 0
Comments
Close date 30.04.04 30.04.04 30.04.04 30.04.04
Weighted estimate £0 £0 £0 £0 £0
Forecast £0 £0 £0 £0 £0
% 0 0 0 0
Comments
Close date 31.05.04 31.05.04 31.05.04 31.05.04
Weighted estimate £0 £0 £0 £0 £0
Forecast £0 £0 £0 £0 £0
% 0 0 0 0
Comments
Close date 30.06.04 30.06.04 30.06.04 30.06.04
Weighted estimate £0 £0 £0 £0 £0
Forecast £0 £0 £0 £0 £0
% 0 0 0 0
Comments
Close date 31.07.04 31.07.04 31.07.04 31.07.04
Weighted estimate £0 £0 £0 £0 £0
Forecast £0 £0 £0 £0 £0
% 0 0 0 0
Comments
Close date 31.08.04 31.08.04 31.08.04 31.08.04
Weighted estimate £0 £0 £0 £0 £0
Forecast £0 £0 £0 £0 £0
% 0 0 0 0
Comments
Close date 31.09.04 31.09.04 31.09.04 31.09.04
Weighted estimate £0 £0 £0 £0 £0
Forecast £0 £0 £0 £0 £0
% 0 0 0 0
Comments
Close date 31.10.04 31.10.04 31.10.04 31.10.04
Weighted estimate £0 £0 £0 £0 £0
Forecast £0 £0 £0 £0 £0
% 0 0 0 0
Comments
Close date 30.11.04 30.11.04 30.11.04 30.11.04
Weighted estimate £0 £0 £0 £0 £0
Forecast £0 £0 £0 £0 £0
% 0 0 0 0
Comments
Close date 31.12.04 31.12.04 31.12.04 31.12.04
Weighted estimate £0 £0 £0 £0 £0
Forecast £0 £0 £0 £0 £0
% 0 0 0 0
Comments
Close date 31.01.05 31.01.05 31.01.05 31.01.05
Weighted estimate £0 £0 £0 £0 £0
Forecast £0 £0 £0 £0 £0
% 0 0 0 0
Comments
Close date 28.02.05 28.02.05 28.02.05 28.02.05
Weighted estimate £0 £0 £0 £0 £0
Forecast £0 £0 £0 £0 £0
% 0 0 0 0
Comments
Close date 31.03.05 31.03.05 31.03.05 31.03.05
Weighted estimate £0 £0 £0 £0 £0
CASHFLOW FORECAST TEMPLATE - COMPANY NAME
CASH IN HAND AT BEGINNING OF PERIOD CASH IN Cash sales excluding VAT VAT invoiced Directors loans Share capital investment Other external finance/loans Other specific cash inflow TOTAL CASH RECEIPTS CASH PAID OUT Premises (rent, rates) Power (light, heat, electricity, gas) Telephone Insurance Postage and carriage Interest and bank charges payable Stationery Drawings, wages, or salary Equipment hire Motor expenses Accountancy fees Legal/professional fees Depreciation Other specific expenses Other specific expenses OPERATING EXPENSES SUBTOTAL Bad-debt provision Plant and other capital expenditure Loan and financing repayments Repayment of directors loans VAT payment due to Customs and Excise Other specific financing payments TOTAL CASH PAID OUT NET CASH FLOW FOR PERIOD CASH BALANCE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 2 0 3 0 4 0
5 0
6 0
7 0
8 0
9 0
10 0
11 0
12 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
PROFIT AND LOSS FORECAST TEMPLATE - COMPANY NAME
Month Revenue Cost of sales Gross profit Gross profit margin (%) Expenses/overheads Premises (rent, rates) Power (light, heat, electricity, gas) Telephone Insurance Postage and carriage Advertising Interest and bank charges payable Stationery Drawings, wages or salaries Equipment hire Motor expenses Accountancy fees Legal/professional fees Depreciation Other specific expenses Other specific expenses Total expenses/overheads Net profit Net profit margin #DIV/0! #DIV/0! 1 0 0 0 #DIV/0! 2 0 0 0 #DIV/0! 3 0 0 0 #DIV/0! 4 0 0 0 #DIV/0! 5 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6 0 0 0 #DIV/0! #DIV/0!
7 0 0 0 #DIV/0!
8 0 0 0 #DIV/0!
9 0 0 0
10 0 0 0 #DIV/0!
11 0 0 0 #DIV/0!
12 0 0 0 #DIV/0!
Total 0 0 0 #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0