P&L Template - Google Drive

	A	B	C	D
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?	No	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)		This sets the starting balance on the cashflow forecast (it's not on the P&L Sheet).

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	PROFIT & LOSS FORECAST			ACME Corp
2
3	Revenue	Revenue Stream 1	Revenue Stream 2	Revenue Stream 3	Revenue Stream 4
4	Enter Sales Revenue (per month)	£20,000.00	£67,500.00	£4,500.00
5
6	Enter Cost of Sales	£5,000.00	£15,000.00	£2,000.00
7
8	Vat Applicable	No	This will calculate the VAT element from the Sales Revenue
9
10		Mth 1	Mth 2	Mth 3	Mth 4	Mth 5	Mth 6	Mth 7	Mth 8	Mth 9	Mth 10	Mth 11	Mth 12	Total	Assumptions
11	Sales Revenue
12	Revenue Stream 1	£20,000.00	£20,000.00	£20,000.00	£20,000.00	£20,000.00	£20,000.00	£20,000.00	£20,000.00	£20,000.00	£20,000.00	£20,000.00	£20,000.00	£240,000.00
13	Revenue Stream 2	£67,500.00	£67,500.00	£67,500.00	£67,500.00	£67,500.00	£67,500.00	£67,500.00	£67,500.00	£67,500.00	£67,500.00	£67,500.00	£67,500.00	£810,000.00
14	Revenue Stream 3	£4,500.00	£4,500.00	£4,500.00	£4,500.00	£4,500.00	£4,500.00	£4,500.00	£4,500.00	£4,500.00	£4,500.00	£4,500.00	£4,500.00	£54,000.00
15	Revenue Stream 4													£0.00
16														£0.00
17	VAT Element	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	£0.00
18
19	Total Sales (Minus VAT if Applicable)	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£1,104,000.00
20
21	Cost of sales
22	Revenue Stream 1	£5,000.00	£5,000.00	£5,000.00	£5,000.00	£5,000.00	£5,000.00	£5,000.00	£5,000.00	£5,000.00	£5,000.00	£5,000.00	£5,000.00	£60,000.00
23	Revenue Stream 2	£15,000.00	£15,000.00	£15,000.00	£15,000.00	£15,000.00	£15,000.00	£15,000.00	£15,000.00	£15,000.00	£15,000.00	£15,000.00	£15,000.00	£180,000.00
24	Revenue Stream 3	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£24,000.00
25	Revenue Stream 4													£0.00
26														£0.00
27	Cost of Sales	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£264,000.00
28
29	GROSS PROFIT (Does not include VAT)	£70,000.00	£70,000.00	£70,000.00	£70,000.00	£70,000.00	£70,000.00	£70,000.00	£70,000.00	£70,000.00	£70,000.00	£70,000.00	£70,000.00	£840,000.00
30	Gross Margin	76.09%	76.09%	76.09%	76.09%	76.09%	76.09%	76.09%	76.09%	76.09%	76.09%	76.09%	76.09%	76.09%
31
32	OVERHEADS
33	Rent	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£24,000.00
34	Wages	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£32,400.00
35	Director Remuneration	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£24,000.00
36	Motor & Travel Costs	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£42,000.00
37	Subsistence	£866.00	£866.00	£866.00	£866.00	£866.00	£866.00	£866.00	£866.00	£866.00	£866.00	£866.00	£866.00	£10,392.00
38	Insurance	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£3,000.00
39	Printing & Stationery	£5,200.00	£5,200.00	£5,200.00	£5,200.00	£5,200.00	£5,200.00	£5,200.00	£5,200.00	£5,200.00	£5,200.00	£5,200.00	£5,200.00	£62,400.00
40	Advertising & Marketing	£50.00	£50.00	£50.00	£50.00	£50.00	£50.00	£50.00	£50.00	£50.00	£50.00	£50.00	£50.00	£600.00
41	Website Costs	£3,000.00	£3,000.00	£3,000.00	£3,000.00	£3,000.00	£3,000.00	£3,000.00	£3,000.00	£3,000.00	£3,000.00	£3,000.00	£3,000.00	£36,000.00
42	Telephone	£135.00	£135.00	£135.00	£135.00	£135.00	£135.00	£135.00	£135.00	£135.00	£135.00	£135.00	£135.00	£1,620.00
43	Accountancy Proff fees	£70.00	£70.00	£70.00	£70.00	£70.00	£70.00	£70.00	£70.00	£70.00	£70.00	£70.00	£70.00	£840.00
44	Entertaining	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£3,000.00
45	IT & Software Costs	£100.00	£100.00	£100.00	£100.00	£100.00	£100.00	£100.00	£100.00	£100.00	£100.00	£100.00	£100.00	£1,200.00
46	PAYE/NI	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£3,000.00
47	Other													£0.00
48	Subtotal Overheads	£20,371.00	£20,371.00	£20,371.00	£20,371.00	£20,371.00	£20,371.00	£20,371.00	£20,371.00	£20,371.00	£20,371.00	£20,371.00	£20,371.00	£244,452.00
49
50	OTHER COSTS
51	Depreciation													£0.00
52	OTHER INCOME													£0.00
53	OPERATING PROFIT	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£595,548.00
54
55	INTEREST EXPENSE
56	Loan Interest													£0.00
57
58
59	NET PROFIT	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£595,548.00
60
61	Net Profit Margin %	53.94%	53.94%	53.94%	53.94%	53.94%	53.94%	53.94%	53.94%	53.94%	53.94%	53.94%	53.94%	53.94%
62
63	CORPORATION TAX
64
65	PROFIT AFTER TAX	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£595,548.00
66

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1
2					ACME Corp
3	CASH FLOW FORECAST
4
5		Mth 1	Mth 2	Mth 3	Mth 4	Mth 5	Mth 6	Mth 7	Mth 8	Mth 9	Mth 10	Mth 11	Mth 12	Total
6		£	£	£	£	£	£	£	£	£	£	£	£	£
7	RECEIPTS
8	Invoiced Sales	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£1,104,000.00
9
10	VAT	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	£0.00
11	Cash In	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£92,000.00	£1,104,000.00
12
13	Cost of Sales (goods)	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£22,000.00	£264,000.00
14
15	Invoiced Costs	£11,821.00	£11,821.00	£11,821.00	£11,821.00	£11,821.00	£11,821.00	£11,821.00	£11,821.00	£11,821.00	£11,821.00	£11,821.00	£11,821.00	£141,852.00
16
17	Wages	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£2,700.00	£32,400.00
18	Director Remuneration	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£2,000.00	£24,000.00
19	Motor & Travel Costs	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£3,500.00	£42,000.00
20
21	IT & Software Costs	£100.00	£100.00	£100.00	£100.00	£100.00	£100.00	£100.00	£100.00	£100.00	£100.00	£100.00	£100.00	£1,200.00
22	PAYE/NI	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£250.00	£3,000.00
23	Other													£3,000.00
24
25	VAT	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	£0.00
26	Dividend Paid													£0.00
27	Total Cash Out	£42,371.00	£42,371.00	£42,371.00	£42,371.00	£42,371.00	£42,371.00	£42,371.00	£42,371.00	£42,371.00	£42,371.00	£42,371.00	£42,371.00	£508,452.00
28
29	NET CASH FLOW	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£49,629.00	£595,548.00
30
31	OPENING BANK		£49,629.00	£99,258.00	£148,887.00	£198,516.00	£248,145.00	£297,774.00	£347,403.00	£397,032.00	£446,661.00	£496,290.00	£545,919.00	£595,548.00
32
33	CLOSING BANK	£49,629.00	£99,258.00	£148,887.00	£198,516.00	£248,145.00	£297,774.00	£347,403.00	£397,032.00	£446,661.00	£496,290.00	£545,919.00	£595,548.00
34