| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Jan | Feb | Mar | Apr | May | June | July | Aug | Sep | Oct | Nov | Dec | Totals | |
2 | income | |||||||||||||
3 | sales | 1000000 | 750000 | |||||||||||
4 | additional sales | 100000 | ||||||||||||
5 | loans | |||||||||||||
6 | total income | £1,100,000.00 | £750,000.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £1,850,000.00 |
7 | expenditure | £0.00 | ||||||||||||
8 | utilities | 25000 | 25000 | £50,000.00 | ||||||||||
9 | raw materials | 300000 | 250000 | £550,000.00 | ||||||||||
10 | insurance | 100000 | 100000 | £200,000.00 | ||||||||||
11 | salaries | 250000 | 25000 | £275,000.00 | ||||||||||
12 | premises | £0.00 | ||||||||||||
13 | loan repayment | £0.00 | ||||||||||||
14 | advertising | 125000 | 125000 | £250,000.00 | ||||||||||
15 | cooking equipment | £0.00 | ||||||||||||
16 | fuel | £0.00 | ||||||||||||
17 | total expenditure | £800,000.00 | £525,000.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £1,325,000.00 |
18 | net cash flow | £300,000.00 | £225,000.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £525,000.00 |
19 | opening balance | £300,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £525,000 | £5,550,000.00 | |
20 | closing balance | £300,000.00 | £525,000.00 | £525,000.00 | £525,000.00 | £525,000.00 | £525,000.00 | £525,000.00 | £525,000.00 | £525,000.00 | £525,000.00 | £525,000.00 | £525,000.00 | £6,075,000.00 |
21 | Please add income and expediture details as per the sheet above! |