Ad Angels LTD CRF Cashflow Oct 2020-March 2021

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 6

Organisation name: Ad Angels Limited

Cashflow Financial year for 6 month cashflow:

Period No: 1

Original Period 1 Period 2 Period 3 Period 4


Income budget Oct-20 Nov-20 Dec-20 Jan-21
Budget/actual? Budget Budget Budget Budget
DCMS - Cultural Recovery Grants 69,000 69,000 0 0 0
ACE NPO 0 0 0 0 0
Arts Council England - other 0 0 0 0 0
HLF 0 0 0 0 0
Other Lottery Grants 0 0 0 0 0
Local Authority Income 0 0 0 0 0
Other Public Subsidy 0 0 0 0 0
Earned Income - e.g generated incom 8,000 0 4,000 0
Contributed income - e.g sponsorship, 0 0 0 0 0
Investment Income 0 0 0 0 0
Other Income 0 0 0 0 0
Reserves 0 0 0 0 0
TOTAL INCOME 77,000 69,000 0 4,000 0

Original Period 1 Period 2 Period 3 Period 4


Expenditure budget Oct-20 Nov-20 Dec-20 Jan-21
Budget/actual? Budget Budget Budget Budget
Salaries 0 0 0 0 0
National Insurance 0 0 0 0 0
Pension Costs 0 0 0 0 0
Temporary Staff 0 0 2,500 0 2,500
Social Media costs 0 1,165 600 1,165 1,165
Artistic spend 0 4,500 6,500 4,500 4,500
Artists' fees 0 1,140 1,140 1,140 1,140
Volunteers 0 0 1,350 750 0
Venue Rent 0 0 1,800 0 0
Heat/Light/Water 0 0 0 0 0
Insurance 0 0 450 0 0
Telephone & internet 0 0 440 440 440
Cleaning/deep clean 0 0 500 0 0
Print/Post/Stationery 0 0 700 0 0
Advertising & Promotion 0 1,000 1,000 0 1,000
Consultants Fees & Subscriptions 0 0 0 0 0
Legal & Professional 0 0 1,000 0 0
Audit & Accountancy 0 0 0 0 0
Bank Charges 0 0 0 0 0
IT /Website launch/maintenance 0 4,500 0 4,500 0
PPE and social distancing equipment 0 0 0 0 0
TOTAL EXPENDITURE 0 12,305 17,980 12,495 10,745

BALANCE B/F 0 56,695 38,715 30,220


SURPLUS/(DEFICIT) 77,000 56,695 (17,980) (8,495) (10,745)

BALANCE C/F 56,695 38,715 30,220 19,475

Instructions
Do not edit cells with the following
colour:
The information must be kept up to
date in cells marked with the
following colour:
The carry forward figure from the end
of the previous year should be
entered in the cell marked with the
following colour:
All amounts should be entered as a
12,000
positive.
Change budget/actual heading from Budget
budget to actual using dropdown
after each complete month.
ed Financial year end date
31/03/2021 (6 month)
month cashflow: 2020/21

Period 5 Period 6 Period 7 Period 8 Period 9 Period 10 Period 11 Period 12


Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21
Budget Budget Budget Budget Budget Budget Budget Budget
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
4,000 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
4,000 0 0 0 0 0 0 0

Period 5 Period 6 Period 7 Period 8 Period 9 Period 10 Period 11 Period 12


Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21
Budget Budget Budget Budget Budget Budget Budget Budget
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
600 1,165 0 0 0 0 0 0
4,500 6,500 0 0 0 0 0 0
1,140 1,140 0 0 0 0 0 0
750 1,350 0 0 0 0 0 0
0 1,800 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 450 0 0 0 0 0 0
440 440 0 0 0 0 0 0
0 500 0 0 0 0 0 0
0 700 0 0 0 0 0 0
1,000 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 1,000 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
8,430 15,045 0 0 0 0 0 0

19,475 15,045 0 0 0 0 0 0
(4,430) (15,045) 0 0 0 0 0 0

15,045 0 0 0 0 0 0 0
TOTAL Variance

69,000 0
0 0
0 0
0 0
0 0
0 0
0 0
8,000 0
0 0
0 0
0 0
0 0
77,000 0

TOTAL Variance

0 0
0 0
0 0
5,000 (5,000)
5,860 (5,860)
31,000 (31,000)
6,840 (6,840)
4,200 (4,200)
3,600 (3,600)
0 0
900 (900)
2,200 (2,200)
1,000 (1,000)
1,400 (1,400)
4,000 (4,000)
0 0
2,000 (2,000)
0 0
0 0
9,000 (9,000)
0 0
77,000 (77,000)
0 (77,000)

You might also like