Cashflow
Year One
                               
Weeks
wk1-wk4
wk5-wk8
wk9-wk12
wk13-wk16
wk17-wk20
wk21-wk24
wk25-wk28
wk29-wk32
wk32-wk36
wk37-wk40
wk41-wk44
wk45-wk48
wk49-wk52
Sub-Totals
 
                               
Wages                              
Centre £ 3,190.00 £ 3,190.00 £ 3,190.00 £ 3,190.00 £ 3,190.00 £ 3,190.00 £ 3,190.00 £ 3,190.00 £ 3,190.00 £ 3,190.00 £ 3,190.00 £ 3,190.00 £ 3,190.00 £ 41,470.00  
Production £ 43,320.00 £ 43,320.00 £ 43,320.00 £ 43,320.00 £ 43,320.00 £ 43,320.00 £ 43,320.00 £ 43,320.00 £ 43,320.00 £ 43,320.00 £ 43,320.00 £ 43,320.00 £ 43,320.00 £ 563,160.00  
Flytower £ 13,040.00 £ 13,040.00 £ 13,040.00 £ 13,040.00 £ 13,040.00 £ 13,040.00 £ 13,040.00 £ 13,040.00 £ 13,040.00 £ 13,040.00 £ 13,040.00 £ 13,040.00 £ 13,040.00 £ 169,520.00  
Stage Door £ 6,560.00 £ 6,560.00 £ 6,560.00 £ 6,560.00 £ 6,560.00 £ 6,560.00 £ 6,560.00 £ 6,560.00 £ 6,560.00 £ 6,560.00 £ 6,560.00 £ 6,560.00 £ 6,560.00 £ 85,280.00  
Lautrecs £ 5,080.00 £ 5,080.00 £ 5,080.00 £ 5,080.00 £ 5,080.00 £ 5,080.00 £ 5,080.00 £ 5,080.00 £ 5,080.00 £ 5,080.00 £ 5,080.00 £ 5,080.00 £ 5,080.00 £ 66,040.00  
Greenroom £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 42,120.00  
Bohemia £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 3,240.00 £ 42,120.00  
                               
Show Budgets £ 10,000.00 £ 10,000.00 £ 10,000.00 £ 10,000.00 £ 25,000.00 £ 10,000.00 £ 10,000.00 £ 10,000.00 £ 25,000.00 £ 10,000.00 £ 10,000.00 £ 10,000.00 £ 10,000.00 £ 160,000.00  
Booking Fees etc £ 12,000.00 £ 12,000.00 £ 12,000.00 £ 12,000.00 £ 12,000.00 £ 12,000.00 £ 12,000.00 £ 12,000.00 £ 12,000.00 £ 12,000.00 £ 12,000.00 £ 12,000.00 £ 12,000.00 £ 156,000.00  
                               
Electricity £ 4,000.00 £ 4,000.00 £ 4,000.00 £ 4,000.00 £ 4,000.00 £ 4,000.00 £ 4,000.00 £ 4,000.00 £ 4,000.00 £ 4,000.00 £ 4,000.00 £ 4,000.00 £ 4,000.00 £ 52,000.00  
Gas £ 600.00 £ 600.00 £ 600.00 £ 600.00 £ 600.00 £ 600.00 £ 600.00 £ 600.00 £ 600.00 £ 600.00 £ 600.00 £ 600.00 £ 600.00 £ 7,800.00  
Water £ 400.00 £ 400.00 £ 400.00 £ 400.00 £ 400.00 £ 400.00 £ 400.00 £ 400.00 £ 400.00 £ 400.00 £ 400.00 £ 400.00 £ 400.00 £ 5,200.00  
Public Liabillity £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 6,500.00  
Employer Liabillity £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 500.00 £ 6,500.00  
Motor £ 450.00 £ 450.00 £ 450.00 £ 450.00 £ 450.00 £ 450.00 £ 450.00 £ 450.00 £ 450.00 £ 450.00 £ 450.00 £ 450.00 £ 450.00 £ 5,850.00  
Catering £ 17,000.00 £ 17,000.00 £ 17,000.00 £ 17,000.00 £ 17,000.00 £ 17,000.00 £ 17,000.00 £ 17,000.00 £ 17,000.00 £ 17,000.00 £ 17,000.00 £ 17,000.00 £ 17,000.00 £ 221,000.00  
Bar £ 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 £ 2,300.00 £ 29,900.00  
Printing £ 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 £ 2,000.00 £ 26,000.00  
Advertising £ 6,000.00 £ 6,000.00 £ 6,000.00 £ 6,000.00 £ 6,000.00 £ 6,000.00 £ 6,000.00 £ 6,000.00 £ 6,000.00 £ 6,000.00 £ 6,000.00 £ 6,000.00 £ 6,000.00 £ 78,000.00  
Promotion £ 7,500.00 £ 7,500.00 £ 7,500.00 £ 5,000.00 £ 7,500.00 £ 7,500.00 £ 7,500.00 £ 7,500.00 £ 7,500.00 £ 7,500.00 £ 7,500.00 £ 7,500.00 £ 7,500.00 £ 95,000.00  
Postage £ 150.00 £ 150.00 £ 150.00 £ 150.00 £ 150.00 £ 150.00 £ 150.00 £ 150.00 £ 150.00 £ 150.00 £ 150.00 £ 150.00 £ 150.00 £ 1,950.00  
Merchandise £ 2,500.00     £ 2,500.00     £ 2,500.00     £ 2,500.00       £ 10,000.00  
Stationary £ 150.00     £ 150.00     £ 150.00     £ 150.00       £ 600.00  
Sundries £ 300.00     £ 300.00     £ 300.00     £ 300.00       £ 1,200.00  
Sub Totals £ 144,020.00 £ 141,070.00 £ 141,070.00 £ 141,520.00 £ 156,070.00 £ 141,070.00 £ 144,020.00 £ 141,070.00 £ 156,070.00 £ 144,020.00 £ 141,070.00 £ 141,070.00 £ 141,070.00 £ 1,873,210.00 £ 1,873,210.00
Contingecy 10% £ 14,402.00 £ 14,107.00 £ 14,107.00 £ 14,152.00 £ 15,607.00 £ 14,107.00 £ 14,402.00 £ 14,107.00 £ 15,607.00 £ 14,402.00 £ 14,107.00 £ 14,107.00 £ 14,107.00 £ 187,321.00 £ 187,321.00
Total running costs £ 158,422.00 £ 155,177.00 £ 155,177.00 £ 155,672.00 £ 171,677.00 £ 155,177.00 £ 158,422.00 £ 155,177.00 £ 171,677.00 £ 158,422.00 £ 155,177.00 £ 155,177.00 £ 155,177.00 £ 2,060,531.00 £ 2,060,531.00
                               
                               
                               
Ticket Sales
£ 6,750.00 £ 11,700.00 £ 13,275.00 £ 13,275.00 £ 81,000.00 £ 13,275.00 £ 13,275.00 £ 54,000.00 £ 13,275.00 £ 11,700.00 £ 13,275.00 £ 6,750.00 £ 6,750.00 £ 258,300.00  
Catering
£ 20,000.00 £ 28,500.00 £ 46,000.00 £ 52,250.00 £ 102,500.00 £ 47,750.00 £ 47,750.00 £ 87,000.00 £ 52,250.00 £ 48,500.00 £ 48,500.00 £ 30,500.00 £ 30,500.00 £ 642,000.00  
Bars
£ 4,400.00 £ 6,300.00 £ 6,300.00 £ 9,250.00 £ 18,750.00 £ 5,500.00 £ 6,500.00 £ 12,850.00 £ 4,800.00 £ 4,300.00 £ 4,150.00 £ 3,450.00 £ 3,450.00 £ 90,000.00  
Retail
£ 225.00 £ 2,061.00 £ 2,161.00 £ 2,286.00 £ 8,286.00 £ 2,210.00 £ 2,210.00 £ 6,038.00 £ 2,211.00 £ 2,061.00 £ 2,211.00 £ 1,936.00 £ 1,836.00 £ 35,732.00  
                            £ 1,026,032.00
Turnover
£ 31,375.00 £ 48,561.00 £ 67,736.00 £ 77,061.00 £ 210,536.00 £ 68,735.00 £ 69,735.00 £ 159,888.00 £ 72,536.00 £ 66,561.00 £ 68,136.00 £ 42,636.00 £ 42,536.00 £ 1,026,032.00  
                               
                               
                               
Surplus Deficit (exclusive of funding)   
                     
Balance Brought Forward
  -£ 127,047.00 -£ 233,663.00 -£ 321,104.00 -£ 399,715.00 -£ 360,856.00 -£ 447,298.00 -£ 535,985.00 -£ 531,274.00 -£ 630,415.00 -£ 722,276.00 -£ 809,317.00 -£ 921,858.00    
Expenditure
£ 158,422.00 £ 155,177.00 £ 155,177.00 £ 155,672.00 £ 171,677.00 £ 155,177.00 £ 158,422.00 £ 155,177.00 £ 171,677.00 £ 158,422.00 £ 155,177.00 £ 155,177.00 £ 155,177.00 £ 2,060,531.00  
Income
£ 31,375.00 £ 48,561.00 £ 67,736.00 £ 77,061.00 £ 210,536.00 £ 68,735.00 £ 69,735.00 £ 159,888.00 £ 72,536.00 £ 66,561.00 £ 68,136.00 £ 42,636.00 £ 42,536.00 £ 1,026,032.00  
Total
-£ 127,047.00 -£ 233,663.00 -£ 321,104.00 -£ 399,715.00 -£ 360,856.00 -£ 447,298.00 -£ 535,985.00 -£ 531,274.00 -£ 630,415.00 -£ 722,276.00 -£ 809,317.00 -£ 921,858.00 -£ 1,034,499.00 -£ 1,034,499.00  
                               
                               
Surplus Deficit (inclusive of funding)  
                     
Balance Brought Forward
£ 1,500,000.00 £ 1,372,953.00 £ 1,266,337.00 £ 1,178,896.00 £ 1,100,285.00 £ 1,139,144.00 £ 1,052,702.00 £ 964,015.00 £ 968,726.00 £ 869,585.00 £ 777,724.00 £ 690,683.00 £ 578,142.00    
Expenditure
£ 158,422.00 £ 155,177.00 £ 155,177.00 £ 155,672.00 £ 171,677.00 £ 155,177.00 £ 158,422.00 £ 155,177.00 £ 171,677.00 £ 158,422.00 £ 155,177.00 £ 155,177.00 £ 155,177.00 £ 2,060,531.00  
Income
£ 31,375.00 £ 48,561.00 £ 67,736.00 £ 77,061.00 £ 210,536.00 £ 68,735.00 £ 69,735.00 £ 159,888.00 £ 72,536.00 £ 66,561.00 £ 68,136.00 £ 42,636.00 £ 42,536.00 £ 2,526,032.00  
Total
£ 1,372,953.00 £ 1,266,337.00 £ 1,178,896.00 £ 1,100,285.00 £ 1,139,144.00 £ 1,052,702.00 £ 964,015.00 £ 968,726.00 £ 869,585.00 £ 777,724.00 £ 690,683.00 £ 578,142.00 £ 465,501.00 £ 465,501.00  
Hosted by www.Geocities.ws

1