Docstoc

Download the profit and loss forecast table in - Business Link

Document Sample
Download the profit and loss forecast table in - Business Link Powered By Docstoc
					Profit and loss forecast - Year one (first six months)
Sheet 1 of 4 - use the tabs at the bottom for           Month 1                Month 2                Month 3                Month 4                Month 5                Month 6               TOTAL
sheets 2, 3 and 4                                  Forecast  Actual       Forecast  Actual       Forecast  Actual       Forecast  Actual       Forecast  Actual       Forecast  Actual     Forecast  Actual
Total sales                                                                                                                                                                                       0         0
Less direct costs                                                                                                                                                                                 0         0
Gross profit (sales less direct costs)                   0            0         0            0         0            0         0            0         0            0         0            0        0         0
Calculate your gross profit margin (gross profit
                                                       0%        0%            0%       0%            0%       0%            0%       0%            0%       0%            0%       0%            0%        0%
divided by total sales x 100) (A)

Salaries/wages (survival income + any staff)                                                                                                                                                        0            0
Premises (including rent, rates, utilities)                                                                                                                                                         0            0
Telephone and broadband                                                                                                                                                                             0            0
Printing, post and stationery                                                                                                                                                                       0            0
Advertising and promotion                                                                                                                                                                           0            0
Bank charges                                                                                                                                                                                        0            0
Professional fees                                                                                                                                                                                   0            0
Insurances                                                                                                                                                                                          0            0
Bank/HP/Interest (payable to your bank)                                                                                                                                                             0            0
Consumables (not direct costs)                                                                                                                                                                      0            0
Equipment and vehicle leasing                                                                                                                                                                       0            0
Depreciation                                                                                                                                                                                        0            0
Other (please specify)                                                                                                                                                                              0            0
Other (please specify)                                                                                                                                                                              0            0
Other (please specify)                                                                                                                                                                              0            0
Other (please specify)                                                                                                                                                                              0            0
Other (please specify)                                                                                                                                                                              0            0
Total overheads                                          0            0         0            0         0            0         0            0         0            0         0            0          0            0

Net profit (gross profit less overheads)                 0            0         0            0         0            0         0            0         0            0         0            0          0            0
Calculate your net profit margin (net profit divided
                                                       0%        0%            0%       0%            0%       0%            0%       0%            0%       0%            0%       0%            0%        0%
by total sales x 100)

Calculate your break even sales                                                                                                                                                              Forecast   Actual
Equals overheads (B) divided by gross margin % (A)                                                                                                                                                  0            0
Profit and loss forecast - Year one (second six months)
Sheet 2 of 4 - use the tabs at the bottom for        Carried over                   Month 7                Month 8                Month 9                Month 10                Month 11                Month 12         TOTAL (12 MONTHS)
sheets 1, 3 and 4                                 Forecast    Actual           Forecast  Actual       Forecast  Actual       Forecast  Actual       Forecast   Actual       Forecast   Actual       Forecast   Actual     Forecast   Actual
Total sales                                                   0            0                                                                                                                                                      0         0
Less direct costs                                             0            0                                                                                                                                                      0         0
Gross profit (sales less direct costs)                        0            0         0            0         0            0         0            0          0            0          0            0          0            0         0         0
Calculate your gross profit margin (gross profit
                                                            0%        0%            0%       0%            0%       0%            0%       0%            0%        0%            0%        0%            0%        0%            0%        0%
divided by total sales x 100) (A)

Salaries/wages (survival income + any staff)                  0            0                                                                                                                                                       0            0
Premises (including rent, rates, utilities)                   0            0                                                                                                                                                       0            0
Telephone and broadband                                       0            0                                                                                                                                                       0            0
Printing, post and stationery                                 0            0                                                                                                                                                       0            0
Advertising and promotion                                     0            0                                                                                                                                                       0            0
Bank charges                                                  0            0                                                                                                                                                       0            0
Professional fees                                             0            0                                                                                                                                                       0            0
Insurances                                                    0            0                                                                                                                                                       0            0
Bank/HP/Interest (payable to your bank)                       0            0                                                                                                                                                       0            0
Consumables (not direct costs)                                0            0                                                                                                                                                       0            0
Equipment and vehicle leasing                                 0            0                                                                                                                                                       0            0
Depreciation                                                  0            0                                                                                                                                                       0            0
Other (please specify)                                        0            0                                                                                                                                                       0            0
Other (please specify)                                        0            0                                                                                                                                                       0            0
Other (please specify)                                        0            0                                                                                                                                                       0            0
Other (please specify)                                        0            0                                                                                                                                                       0            0
Other (please specify)                                        0            0                                                                                                                                                       0            0
Total overheads                                               0            0         0            0         0            0         0            0          0            0          0            0          0            0          0            0

Net profit (gross profit less overheads)                      0            0         0            0         0            0         0            0          0            0          0            0          0            0          0            0
Calculate your net profit margin (net profit divided
                                                            0%        0%            0%       0%            0%       0%            0%       0%            0%        0%            0%        0%            0%        0%            0%        0%
by total sales x 100)

Calculate your break even sales                        Forecast   Actual                                                                                                                                                    Forecast   Actual
Equals overheads (B) divided by gross margin % (A)            0            0                                                                                                                                                       0            0
Profit and loss forecast - Year two
Sheet 3 of 4 - use the tabs at the bottom for           Quarter 1               Quarter 2               Quarter 3               Quarter 4               YEAR
sheets 1, 2 and 4                                  Forecast   Actual       Forecast   Actual       Forecast   Actual       Forecast   Actual     Forecast   Actual
Total sales                                                                                                                                              0         0
Less direct costs                                                                                                                                        0         0
Gross profit (sales less direct costs)                    0            0          0            0          0            0          0            0         0         0
Calculate your gross profit margin (gross profit
                                                        0%        0%            0%        0%            0%        0%            0%        0%            0%        0%
divided by total sales x 100) (A)

Salaries/wages (survival income + any staff)                                                                                                              0            0
Premises (including rent, rates, utilities)                                                                                                               0            0
Telephone and broadband                                                                                                                                   0            0
Printing, post and stationery                                                                                                                             0            0
Advertising and promotion                                                                                                                                 0            0
Bank charges                                                                                                                                              0            0
Professional fees                                                                                                                                         0            0
Insurances                                                                                                                                                0            0
Bank/HP/Interest (payable to your bank)                                                                                                                   0            0
Consumables (not direct costs)                                                                                                                            0            0
Equipment and vehicle leasing                                                                                                                             0            0
Depreciation                                                                                                                                              0            0
Other (please specify)                                                                                                                                    0            0
Other (please specify)                                                                                                                                    0            0
Other (please specify)                                                                                                                                    0            0
Other (please specify)                                                                                                                                    0            0
Other (please specify)                                                                                                                                    0            0
Total overheads                                           0            0          0            0          0            0          0            0          0            0

Net profit (gross profit less overheads)                  0            0          0            0          0            0          0            0          0            0
Calculate your net profit margin (net profit            0%        0%            0%        0%            0%        0%            0%        0%            0%        0%
divided by total sales x 100)

Calculate your break even sales                                                                                                                    Forecast   Actual
Equals overheads (B) divided by gross margin %
                                                                                                                                                          0            0
(A)
Profit and loss forecast - Year three
                                                                                            YEAR
Sheet 4 of 4 - use the tabs at the bottom for sheets 1, 2 and 3
                                                                                     Forecast Actual
Total sales
Less direct costs
Gross profit (sales less direct costs)                                                     0         0
Calculate your gross profit margin (gross profit divided by total sales x 100) (A)        0%        0%

Salaries/wages (survival income + any staff)
Premises (including rent, rates, utilities)
Telephone and broadband
Printing, post and stationery
Advertising and promotion
Bank charges
Professional fees
Insurances
Bank/HP/Interest (payable to your bank)
Consumables (not direct costs)
Equipment and vehicle leasing
Depreciation
Other (please specify)
Other (please specify)
Other (please specify)
Other (please specify)
Other (please specify)
Total overheads                                                                            0             0

Net profit (gross profit less overheads)                                                   0         0
Calculate your net profit margin (net profit divided by total sales x 100)                0%        0%

Calculate your break even sales                                                      Forecast   Actual
Equals overheads (B) divided by gross margin % (A)                                          0            0

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:58
posted:12/14/2011
language:English
pages:6