P4 Coffee Shop Cash Flow Forecast

Cash flow forecast for Booze 'n' Beans Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Opening balance £0.00 £62,373.75 £50,179.50 £42,860.25 £39,891.00 £41,571.75 £43,252.50 £43,783.25 £46,074.00 £51,254.75 £60,435.50 £70,116.25
Cash inflow
Bank loan £100,000.00 £100,000.00
Sales £2,000.00 £6,375.00 £10,875.00 £15,375.00 £15,375.00 £15,375.00 £16,985.00 £19,875.00 £24,375.00 £24,375.00 £28,375.00 £179,360.00
Other £0.00
Total inflows £100,000.00 £2,000.00 £6,375.00 £10,875.00 £15,375.00 £15,375.00 £15,375.00 £16,985.00 £19,875.00 £24,375.00 £24,375.00 £28,375.00 £279,360.00

Outflows
Rent £2,300.00 £2,300.00 £2,300.00 £2,300.00 £2,300.00 £2,300.00 £2,300.00 £2,300.00 £2,300.00 £2,300.00 £2,300.00 £2,300.00 £27,600.00
Rates £800.00 £800.00 £800.00 £800.00 £800.00 £800.00 £800.00 £800.00 £800.00 £800.00 £800.00 £800.00 £9,600.00
Bank loan repayment 5 years £1,666.00 £1,666.00 £1,666.00 £1,666.00 £1,666.00 £1,666.00 £1,666.00 £1,666.00 £1,666.00 £1,666.00 £1,666.00 £1,666.00 £19,992.00
Owners Drawings £800.00 £1,000.00 £1,000.00 £1,000.00 £1,000.00 £1,000.00 £2,000.00 £2,000.00 £2,000.00 £2,000.00 £2,000.00 £2,000.00 £17,800.00
Coffee machine £2,156.00 £2,156.00
Tables and Chairs £1,160.00 £1,160.00
Interior Design theming etc £15,000.00 £15,000.00
Staff training - Barista etc £984.00 £246.00 £246.00 £246.00 £246.00 £246.00 £246.00 £246.00 £246.00 £246.00 £246.00 £246.00 £3,690.00
Utilities £240.00 £240.00 £240.00 £240.00 £240.00 £240.00 £240.00 £240.00 £240.00 £240.00 £240.00 £240.00 £2,880.00
Till £1,500.00 £1,500.00
Crockery £750.00 £750.00
Cutlery £500.00 £500.00
Dishwashers £189.00 £189.00
Fridge £489.00 £489.00
Freezer
Insurance £2,429.00 £2,429.00 £2,429.00 £2,429.00 £2,429.00 £2,429.00 £2,429.00 £2,429.00 £2,429.00 £2,429.00 £2,429.00 £2,429.00 £29,148.00
Accountant £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £2,400.00
Solicitors fees £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
Food hygiene £150.00 £150.00 £150.00 £500.00 £950.00
Marketing £2,000.00 £1,000.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £8,000.00
Variable costs
Coffee £364.00 £364.00 £364.00 £364.00 £364.00 £364.00 £364.00 £364.00 £364.00 £364.00 £364.00 £364.00 £4,368.00
Milk £164.00 £164.00 £164.00 £164.00 £164.00 £164.00 £164.00 £164.00 £164.00 £164.00 £164.00 £164.00 £1,968.00
Alcohol £1,358.00 £1,358.00 £1,358.00 £1,358.00 £1,358.00 £1,358.00 £1,358.00 £1,358.00 £1,358.00 £1,358.00 £1,358.00 £1,358.00 £16,296.00
Fruit £90.00 £90.00 £90.00 £90.00 £90.00 £90.00 £90.00 £90.00 £90.00 £90.00 £90.00 £90.00 £1,080.00
Working capital £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
Other
Food and drinks licence £23.75 £23.75 £23.75 £23.75 £23.75 £23.75 £23.75 £23.75 £23.75 £23.75 £23.75 £23.75 £285.00
Premises licence £63.50 £63.50 £63.50 £63.50 £63.50 £63.50 £63.50 £63.50 £63.50 £63.50 £63.50 £63.50 £762.00




Total outflows £37,626.25 £14,194.25 £13,694.25 £13,844.25 £13,694.25 £13,694.25 £14,844.25 £14,694.25 £14,694.25 £15,194.25 £14,694.25 £14,694.25 £195,563.00

Closing balance £62,373.75 £50,179.50 £42,860.25 £39,891.00 £41,571.75 £43,252.50 £43,783.25 £46,074.00 £51,254.75 £60,435.50 £70,116.25 £83,797.00



Assumptions
Sales Through the means of marketing and promotional efforts we aim to serve an additional 600 consumers each month with the average spend £7.50
Bank loan repayment 5 years £100000 repaid over 5 years at £1666 per month including interest
Owners Drawings £1000 per month for first 6 months to allow the business to get off the ground and £2000 for the last six as revenue and profits provide
Working capital Allowance for day to day expenses to ensure enough cash to run the business