Cashflow Forecast 2013-16
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNO
1
MONTHJulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneTotal
2
Figures rounded to £'s
3
Income
4
1Cafe Rent £250.00£250.00£250.00£500.00£500.00£500.00£750.00£750.00£750.00£750.00£750.00£750.00£6,750.00
5
2Room Booking Fees£120.00£120.00£120.00£240.00£240.00£240.00£360.00£360.00£360.00£480.00£480.00£480.00£3,600.00
6
3Offices Rent £100.00£100.00£100.00£200.00£200.00£200.00£300.00£300.00£300.00£400.00£400.00£400.00£3,000.00
7
4Events £0.00£0.00£150.00£0.00£0.00£150.00£0.00£0.00£150.00£0.00£0.00£150.00£600.00
8
5Sponsorship / Advertising £10.00£10.00£10.00£20.00£20.00£20.00£30.00£30.00£30.00£40.00£40.00£40.00£300.00
9
6Other Income£0.00
10
aTotal Income£480.00£480.00£630.00£960.00£960.00£1,110.00£1,440.00£1,440.00£1,590.00£1,670.00£1,670.00£1,820.00£14,250.00
11
Expenditure
12
7Centre Manager£128.00£128.00£128.00£256.00£256.00£256.00£384.00£384.00£384.00£512.00£512.00£512.00£3,840.00
13
8Rent and Rates£0.00£0.00£0.00£0.00£0.00£0.00£0.00£0.00£0.00£0.00£0.00£0.00£0.00
14
9Heating, Lighting, Water£100.00£100.00£75.00£75.00£75.00£50.00£50.00£50.00£75.00£75.00£100.00£100.00£925.00
15
10Purchases£10.00£10.00£10.00£15.00£15.00£15.00£20.00£20.00£20.00£25.00£25.00£25.00£210.00
16
11Telephone£10.00£10.00£10.00£15.00£15.00£15.00£20.00£20.00£20.00£25.00£25.00£25.00£210.00
17
12Postage and Stationery£10.00£10.00£10.00£15.00£15.00£15.00£20.00£20.00£20.00£25.00£25.00£25.00£210.00
18
13Repairs and Renewals£0.00£0.00£50.00£0.00£0.00£75.00£0.00£0.00£100.00£0.00£0.00£125.00£350.00
19
14Professional Fees£25.00£25.00£25.00£25.00£25.00£25.00£25.00£25.00£25.00£25.00£25.00£25.00£300.00
20
15Insurance£40.00£40.00£40.00£40.00£40.00£40.00£40.00£40.00£40.00£40.00£40.00£40.00£480.00
21
16Advertising and Promotion£100.00£0.00£0.00£25.00£0.00£0.00£25.00£0.00£0.00£25.00£0.00£0.00£175.00
22
17Cleaning£24.00£24.00£24.00£48.00£48.00£48.00£72.00£72.00£72.00£96.00£96.00£96.00£720.00
23
18 £0.00
24
bTotal Expenditure£447.00£347.00£372.00£514.00£489.00£539.00£656.00£631.00£756.00£848.00£848.00£973.00£7,420.00
25
cNet cashflow (a - b)£33.00£133.00£258.00£446.00£471.00£571.00£784.00£809.00£834.00£822.00£822.00£847.00£6,830.00
26
19Opening bank balance£0.00£33.00£166.00£424.00£870.00£1,341.00£1,912.00£2,696.00£3,505.00£4,339.00£5,161.00£5,983.00£0.00
27
dClosing Bank (C+/- Line 29)£33.00£166.00£424.00£870.00£1,341.00£1,912.00£2,696.00£3,505.00£4,339.00£5,161.00£5,983.00£6,830.00£6,830.00
Loading...
 
 
 
2013-14
2014-15
2015-16