Sheet 1: Cash Flow Projection

	
	
	
	
	

		
Cashflow Forecast 2019 - 2020 
		
	

		


		
	

		


		
Jan-19
		
Feb-19
		
Mar-19
		
Apr-19
		
May-19
		
Jun-19
		
Jul-19
		
Aug-19
		
Sep-19
		
Oct-19
		
Nov-19
		
Dec-19
	
	

		
Opening Balance 
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Money In 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Capital
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Sales - Drinks
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Sales - Food
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Other 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Total Money In 
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Money Out 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Operating Expenses:
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Cost of Sales - drinks 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Cost of Sales - food
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Wages
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Licensing
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Sundries / Consumables
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Advertising 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		

		Business Rates

		General Rates
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Postage and Carriage
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Telephone & Internet 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Office Stationary 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Consultancy Fees 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Equipment Hire
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Repairs and Renewals 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Cleaning 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Utilities
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		

		Spotify,
Card Machine 




		Subscriptions 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Insurance
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Rent 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Bank Charges
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Car
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Loan Repayments
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Depreciation
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		

		Would you be taking personal drawings or would there be any shareholders' equity?
		Personal Drawings
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Total Money Out
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Closing Balance 
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Cashflow Forecast 2020 - 2021
		
	

		


		
	

		


		
Jan-20
		
Feb-20
		
Mar-20
		
Apr-20
		
May-20
		
Jun-20
		
Jul-20
		
Aug-20
		
Sep-20
		
Oct-20
		
Nov-20
		
Dec-20
	
	

		
Opening Balance 
		
 £-   
		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Money In 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Drinks
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Food
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Other 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Total Money In 
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Money Out 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Operating Expenses:
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Cost of Sales - drinks 
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
	
	

		
Cost of Sales - food
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
	
	

		
Wages
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Advertising 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Licensing
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Sundries / Consumables
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		

		Business Rates

		General Rates
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Postage and Carriage
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Telephone & Internet 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Office Stationary 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Consultancy Fees 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Equipment Hire
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Repairs and Renewals 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Cleaning 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Utilities
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		

		Spotify,
Card Machine 




		Subscriptions 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Insurance
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Rent 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Bank Charges
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Car
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Loan Repayments 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Depreciation
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Personal Drawings
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Total Money Out
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Closing Balance 
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Cashflow Forecast 2021 - 2022
		
	

		


		
	

		


		
Jan-21
		
Feb-21
		
Mar-21
		
Apr-21
		
May-21
		
Jun-21
		
Jul-21
		
Aug-21
		
Sep-21
		
Oct-21
		
Nov-21
		
Dec-21
	
	

		
Opening Balance 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Money In 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Drinks
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Food
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Other 
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
	
	

		
Total Money In 
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Money Out 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Operating Expenses:
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Cost of Sales - drinks 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Cost of Sales - food
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Wages
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Advertising 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Licensing
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Sundries / Consumables
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		

		Business Rates

		General Rates
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Postage and Carriage
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Telephone & Internet 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Office Stationary 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Consultancy Fees 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Equipment Hire
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Repairs and Renewals 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Cleaning 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Utilities
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		

		Spotify,
Card Machine 




		Subscriptions 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Insurance
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Rent 
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Bank Charges
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Car
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Loan Repayments
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Depreciation
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Personal Drawings
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Total Money Out
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Closing Balance 
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-   
		
 £-