| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | PROFIT & LOSS FORECAST | To use this file go to "file" Make A copy. Then edit the copy as much as you wish | |||||||
2 | Simply enter the values for each of the items below. This will then populate the spreadsheet Tab P&L Yr 1. The cash flow will be generate automatically from the values entered. You should only change the items in the GREY fields. Note: This spreadsheet is indicative only and you should consult a professional accountant if you require more advice or to use this for any other purpose than indicative. | ||||||||
3 | |||||||||
4 | |||||||||
5 | |||||||||
6 | |||||||||
7 | ACME Corp | ||||||||
8 | Enter Values Revenue and Cost of product (per month) Including VAT | Sales Revenue (per month) | Cost of Sales (product cost) | Enter above the values for total sales revenue (Excluding VAT) for each month, and the cost of the products, these will be reflected in the P&L Sheet and cash flow forecast. If you change the name of the product, it will be reflected through out the sheet. Note this does not allow for VAT you can reclaim from the costs you incur in producing your product or running your business. | |||||
9 | Revenue Stream 1 | £20,000.00 | £5,000.00 | ||||||
10 | Revenue Stream 2 | £67,500.00 | £15,000.00 | ||||||
11 | Revenue Stream 3 | £4,500.00 | £2,000.00 | ||||||
12 | Revenue Stream 4 | ||||||||
13 | |||||||||
14 | |||||||||
15 | IS VAT Applicable? | Yes | Note, this will calculate the VAT Element. | ||||||
16 | |||||||||
17 | OVERHEADS | ||||||||
18 | Rent | £2,000.00 | Enter the amount you pay each month of each of the items here. If you have others that are not listed add them in the 'Others' at the bottom. | ||||||
19 | Wages | £2,700.00 | |||||||
20 | Director Remuneration | £2,000.00 | |||||||
21 | Motoring costs | £3,500.00 | |||||||
22 | Subsistence | £866.00 | |||||||
23 | Insurance | £250.00 | |||||||
24 | Printing & Stationery | £5,200.00 | |||||||
25 | Advertising & Marketing | £50.00 | |||||||
26 | Website Costs | £3,000.00 | |||||||
27 | Telephone | £135.00 | |||||||
28 | Accountancy Proff fees | £70.00 | |||||||
29 | Entertaining | £250.00 | |||||||
30 | IT & Software Costs | £100.00 | |||||||
31 | PAYE /NI | £250.00 | |||||||
32 | Other Overhead cost | ||||||||
33 | |||||||||
34 | OTHER COSTS | ||||||||
35 | Depreciation | ||||||||
36 | OTHER INCOME | Not from sales | |||||||
37 | Loan Interest | Note Don't include the principle only the amount of interest paid | |||||||
38 | Opening Bank Balance (Year 0) | £0.00 | This sets the starting balance on the cashflow forecast (it's not on the P&L Sheet). | ||||||
39 | |||||||||
40 | |||||||||
41 | |||||||||
42 | |||||||||
43 | |||||||||
44 | |||||||||
45 | |||||||||
46 | |||||||||
47 | |||||||||
48 | |||||||||
49 | |||||||||
50 | |||||||||
51 | |||||||||
52 | |||||||||
53 | |||||||||
54 | |||||||||
55 | |||||||||
56 | |||||||||
57 | |||||||||
58 | |||||||||
59 | |||||||||
60 | |||||||||
61 | |||||||||
62 | |||||||||
63 | |||||||||
64 | |||||||||
65 | |||||||||
66 | |||||||||
67 | |||||||||
68 | |||||||||
69 | |||||||||
70 | |||||||||
71 | |||||||||
72 | |||||||||
73 | |||||||||
74 | |||||||||
75 | |||||||||
76 | |||||||||
77 | |||||||||
78 | |||||||||
79 | |||||||||
80 | |||||||||
81 | |||||||||
82 | |||||||||
83 | |||||||||
84 | |||||||||
85 | |||||||||
86 | |||||||||
87 | |||||||||
88 | |||||||||
89 | |||||||||
90 | |||||||||
91 | |||||||||
92 | |||||||||
93 | |||||||||
94 | |||||||||
95 | |||||||||
96 | |||||||||
97 | |||||||||
98 | |||||||||
99 | |||||||||
100 | |||||||||