2023-03-31-accounts - Community Lives Consortium

This text was generated using OCR and may contain errors. Check the original PDF to see the document submitted to the regulator.

		Page
Report ofthe Trustees	1	to	9
Report ofthe Independent Auditors	10 to		12
Statement of Financial Activities		13
Balance Sheet		14
Cash Flow Statement		15
Notes to the Cash Flow Statement		16
Notes to the Financial Statements	17 to		28

				f	or the Year	Ended 31 March	20	23
									2023	2022
						Unrestricted		Restricted	Total	Total
						funds		funds	funds	funds
					Notes	6		6	6	6
Income and endowments			from
Charitable activities
Supported living						14,030,604			14,030,604	12,194,715
Expenditure on
Charitable activities
Supported living						13,846,813			13846 813	11.949080
NET INCOME						183,791			183,791	245,635
Other recognised	gains/(losses)
Gains/(losses) on revaluation			offixed assets			(131,293)			(131,293)
Actuarial gains/(losses) schemes		on defined		benefit		~207 tltltl	3		~207 0007	~50tltltli
Net movement in	funds					(154,502)			(154,502)	195,635
Reconciliation of	funds
Total funds brought	forward					529,402		166,880	696,282	500,647
Total funds carried forward						374 900		166880	541 780	696282

					2023	2022
			Unrestricted	Restricted	Total	Total
		Notes	funds f.	funds E	funds f.	fundsf
Fixed assets
Tangible assets		8	497,235		497,235	639,119
Current assets
Debtors		9	648,001		648,001	1,040,438
Cash at bank			94509	66.880	66 389	9 8
			1,142,510	166,880	1,309,390	1,237,866
Creditors
Amounts falling due within	one year	10	(745,437)		(745,437)	(668,708)
Net current assets			397,073	166,880	563,953	569,158
Total assets less current	liabilities		894,308	166,880	1,061,188	1,208,277
Creditors
Amounts falling due afier	more than one year	11	(31,408)		(31,408)	(52,995)
Provisions for liabilities		14	(488,000)		(488,000)	(459,000)
NET ASSETS/(LIABILITIES)			3 900	66880	80	696 8
Funds		15
Unrestricted funds					374,900	529,402
Restricted funds					166880	166880
Total funds					5412811	696282

				Cash Flow Statement
			for the	Year Ended 31 March	2023
					2023	2022
			Notes		E	8
Cash flows from operating	activities
Cash generated from operations Interest paid Net cash provided by operating activities					500,580 ~6692 493888	46,162 ~4,376) 41 786
Cash flows from investing	activities
Purchase of tangible fixed assets					(5,495)
Sale of tangible fixed assets					6 570
Net cash provided by investing activities					1 075
Cash flows from financing activities Loan repayments in year Net cash used in financing activities					31 002 31 002	~39821) ~39821)
Change In cash and cash	equivalents	in
the reporting period					463,961	1,965
Cash and cash equivalents	at the
beginning ofthe reporting	period				197,428	195,463
Cash and cash equivalents	at the end	of
the reporting period					661,389	197,428

Reconcffiatl	on of n	et Inco	me	to net cash flow from operati	ng activities
						2023	2022
						E	6
Net Income	for the	reporting		period (as per the Statement	of Financial
Activities)						183,791	245,635
Adjustments	for:
Depreciation	charges					14,157	17,374
Profit on disposal of		fixed assets				(4,643)
Interest paid						6,692	4,376
Decrease/(increase)		in debtors				392,437	(150,911)
Increase in creditors Difference between		pension	charge and cash contributions			86,146 ~128,000i	89,688 ~160,~1102
Net cash provided		by operations				500580	46162

Analysis ofchanges	In net funds
		At 1.4.22	Cash flow	At 31.3.23
				6
Net cash
Cash at bank		197428	463 961	661 389
		197428	463 961	661 389
Debt
Debts falling due within Debts falling due after	1 year 1 year	(36,587) ~52995) ~89,582)	9,417 ~21 587 31,004	(27, 170) ~31408) ~58,578)
Total		107846	494 965	602 811

Freehold	property	1.5% on cost
Fixtures	and fittings	15%on cost
Motor vehicles		20% on cost

								2023	2022
					Activity				6
SSDDcharges					Supported	living		619,161	562,573
ILF					Supported	living			(4,380)
Housing benefit					Supported	living		1,994,314	1,821,394
Swansea	Community		Care		Supported	living		5,015,900	4,031,070
NPT Community		Care			Supported	living		4,224,230	3,772,781
Swansea	Bay UHB				Supported	living		1,375,403	1,117,564
Covid-19	grants	and additional
income					Supported	living		613,851	784,548
Sundry income					Supported	living		187745	109165
								140306114	12194715
Charitable activities			costs
								Support
							Direct	costs (see
							Costs	note 4)	Totals
							E
Supported	living						12 165932	1 680 881	13846 813
Support	costs
								Governance
							Management 0	costs f	Totals
Supported	living						1 845358	35 523	1 680881
Net income/(expenditure)
Net income/(expenditure)				is stated	after charging/(crediting):
								2023	2022
Auditors'	remuneration							35,523	13,200
Depreciation —owned			assets					14,159	17,374
Surplus on disposal offixed assets								(4,643)
Loan interest									4 376

Staff costs					for	the	Yea	r Ended	31	March	20	23
															2023		2022
															E		E.
Wages and salaries														10,407,585		8,955,402
Social security costs															865,573		666,323
Other pension costs															127271		283,906
														11400429		9	905631
The average monthly		number		of	employees	during		the year was		as follows:
															2023		2022
Operational staff															391		368
Administrative staff															13		34
															404		402
The number ofemployees			whose		employee	benefits (excluding				employer		pension	costs) exceeded E60,000 was:
															2023		2022
E60,001 —E70,000															1
During the year, Community				Lives Consortium			paid key management				gross salaries			totalling	E138,440	(2022:	f131,586).
Key management	are	considered			to be 2 individuals			during	the	year (2 in		prior year)		who directly impact		upon the strategic
direction ofthe charity.
Tangible fixed assets
												Fixtures
									Freehold			and			Motor
									property			Rttings			vehicles		Totals
										E			E		E		E
Cost or valuation
At 1 April 2022									708,607			9398			43,671		761,676
Additions															5,495		5,495
Disposals Revaluations At 31 March 2023								~186,228) 522,379				9398			(35,147) 14,019	(35,147) ~186228) ~545 796
Depreciation
At 1 April 2022									76,101			9398			37,058		122,557
Charge for year									10,721						3,438		14,159
Eliminated on disposal Revaluation adjustments								~54,935)							(33,220)	(33,220) ~54 935)
At 31 March 2023									31,887			9398			7,276		48 561
Net book value
At 31 March 2023									490	492					6743		497 235
At 31 March 2022									632	506					6613		639 119

							Fixtures
						Freehold	and	Motor
						property	Rttings	vehicles	Totals
						E
Valuation Valuation	in 2022 in 2023					708,607 ~186,228)	9398	14,019	732,024 ~186228)
						522 379	9398	14019	545 796
Debtors:	amounts	falling		due	within one year
								2023	2022
								6
Trade debtors								326,007	969,445
Other debtors								321 994	70,993
								848 1101	I 040438
Creditors: amounts			falling due within one year
								2023	2022
									6
Bank loans and overdrafls				(see	note 12)			27,170	36,587
Trade creditors								83,506	51,133
Social security and		other taxes						219,773	218,936
Other creditors								311,231	342,018
Accrued	expenses							103757	20,034
								745437	668 708
Deferred	income brought forward							259,976	249,255
Amounts	released	to incoming			resources			(259,976)	(249,255)
Amounts	deferred	in	year					229188	259796
Deferred	income carried forward							229188	259976

Creditors	: amounts falling			due after mo	re than one ye	ar
							2023	2022
							E	f.
Bank loans (see note 12)							31 408	52 995
Loans
An analysis of the maturity		of		loans is given below:
							2023	2022
							E	E
Amounts	falling due within one year on demand:
Bankloans							27 170	36587
Amounts falling between one Bank bans —1-2years				and two years:			~13 987	24433
Amounts	falling due between			two and five	years:
Bank loans —2-5 years							17421	28 562
Secured	debts
The following secured debts			are included		within creditors:
							2023	2022
							E	f.
Bank bans							~58 578	89582
The bank	loans are secured		on the assets		of Community	Lives Consortium
Provisions for liabilities
							2023	2022
							E	E
Pension	Deficit Liability						488 000	459 000
							2023	2022
			f
Balance	brought forward						459,000	569,000
Amounts Amounts	provided in the year released in the year						29,000	~404 tltltli
Balance	carried forward						488000	408000

Movement ln	funds
							Nst
							movement	At
						At 1.4.22	in funds	31.3.23
						6	6	f.
Unrestricted	funds
General fund						(322,982)	(23,209)	(346,191)
SelfAssurance						99,964		99,964
CLC Assistive	Technology					734,664		734,664
R&R Reserve						17,756		17,756
Revaluation Reserve							~131293)	~131293)
						529,402	(154,502)	374,900
Restricted funds
Intensive Support						101,863		101,863
Local Authority						32,642		32,642
Ysgol Street Development						32,375		32 375
						166880		166,880
TOTAL FUNDS						696282	~154502)	541 780
Nel moveinenl	in I'unde,	included		in Ihe above	are as follows.
					Incoming	Resources	Gains and	Movement
					resources	expended	losses	in funds
						6	6	6
Unrestricted	funds
General fund Revaluation Reserve TOTAL FUNDS					14,030,604 14030604 14030 604	(13,846813) ~)3846813) ~)3 846 813	(207,000) ~)3)293 ~338293) ~338293	(23,209) ~)31293) ~)54502) 154502
Comparatives	for movement		in	funds
							Net
							movement	At
						At 1.4.21	in funds	31.3.22
						F	E
Unrestricted	funds
General fund						(518,617)	195,635	(322,982)
SelfAssurance						99,964		99,964
CLC Assistive	Technology					734,664		734,664
R&R Reserve						17,756		17,756
						333,767	195,635	529,402
Restricted funds
Intensive Support						101,863		101,863
Local Authority						32,642		32,642
Ysgol Street Development						32,375		32,375
						166,880		166,880
TOTAL FUNDS						~500647	~195635	~696282

Compara	tive	net movement in funds,	included in the above are as foll	ows:
			Incoming resources	Resources expended	Gains and losses	Movement in funds
			6	6	6
Unrestricted		funds
General	fund		12,194,715	(11,949080)	(50,000)	195,635
TOTAL	FUNDS		19194115	~tt 949 tl99	~559tltl	195695

assets, liabilities, income and exp	enditure in relation t	o the pension scheme.	o the pension scheme.
Presentation values of Defined	Benefit Obligation,	fair value ofassets and Defined Benefit Asset (liability)
		31 March	31 March
		2023	2022
		6 s	s
Fair value of plan assets		3,686	5,262
Present value of defined benefit obligation		4,174	5,721
Surplus/(Deficit) in plan		(488)	(459)
Unrecognised surplus
Defined benefit asset (liability) to	be recognised	(488)	(459)
Reconcifiatlon ofthe Impact of	the asset ceiling
		31 March 2023
		E s
Impact ofasset ceiling at start of	year
Effect ofthe asset ceiling included	in net interest cost
Actuarial losses (gains) on asset	ceiling
Impact ofasset ceiling at end of period

Social housing pension schem	e - con	e - con	e - con	tinued	tinued
Reconcifiatlon ofopening and	closing			balances		ofthe defined			benefit obligation
										31 March 2023
										6	s
Defined benefit obligation at start of		period										5,721
Current service cost
Expenses												6
Interest Expense												157
Contributions by plan participants
Actuarial losses (gains) due to scheme			experience									276
Actuarial losses (gains) due to changes				in demographic			assumptions					(10)
Actuarial losses (gains due to changes			in financial			assumptions						(1,769)
Benefits paid and expenses												(207)
Liabilities acquired in a business	combination
Liabilities extinguished on settlements
Losses (gains) on curtailments
Losses (gains) due to benefit changes
Exchange rate differences
Defined benefit obligation at end	of period											4,174
Reconciliation ofopening and	closing			balances		ofthe fair value ofplan assets
										31 March 2023 f s
Fair value of plan assets at start	of period											5,262
Interest income												147
Expenence on plan assets (excluding		amounts			included		in interest income) - gain
(loss)												(1,710)
Contnbutions by the employer												194
Contnbutions by plan participants
Benefits paid and expenses												(207)
Assets acquired in a business combination
Assets distributed on settlements
Exchange rate changes
Fair value of plan assets at end of period												3,686
The actual return on the plan assets		(including			any changes			in share ofassets) over		the penod ended		31 March 2023 was
(61,563,000).
Defined benefit costs recognised		in	statement			offinancial		activities - Net income and expenditure
										31 March 2023
											s
Current service cost
Expenses												6
Net interest Expense												10
Losses (gains) on business combinations
Losses (gains) on settlements
Losses (gains) on curtailments
Losses (gains) due to benefit changes
Defined benefit costs recognised	in statement				offinancial		activities					16
Defined benefit costs recognised		in	statement			offinancial		activities - Actuarial		Gains/(losses)
										31 March 2023
											s
Experience on plan assets (excluding		amounts			included		in net interest cost) —gain
(loss)												(1,710)
Experience gains and losses arising		on	the plan liabilities				—gain (loss)					(276)

Social housing p	ension scheme - c	ension scheme - c	ension scheme - c	ension scheme - c	ension scheme - c	ension scheme - c	o	ntinued	ntinued	ntinued
Effects ofchanges	in the demographic							assumptions			underlying		the present value
ofthe defined benefit		obligation			—gain		(loss)											10
Effects ofchanges	in the financial					assumptions				underlying		the	present		value	of the
defined benefit obligation			—gain		(loss)													1,769
Total actuarial gains		and losses			(before			restriction			due to	some	of	the	surplus	not
being recongisable)		—gain	(loss)															(207)
Effects ofchanges	in the amount					of surplus			that	is	not recoverable			(excluding
amounts included	in	net interest				cost)	—gain		(loss)
Total amount recognised			in	Actuarial			gains/(losses)											(207)
Assets
																	31 March
																	2023	31	March 2022
																	L s			6 s
Global Equity																	69			1.010
Absolute Return																	40			211
Distressed Opportunities																	112			188
Credit Relative Value																	139			175
Alternative Risk Premia																	7			174
Fund of Hedge Funds
Emerging Markets	Debt																20			153
Risk Sharing																	271			173
Insurance Linked Secunties																	93			123
Property																	159			142
Infrastructure																	421			375
Private Debt																	164			135
Opportunistic squid	Credit																158			177
High Yield																	13			45
Opportunistic Credit																				19
Cash																	27			18
Corporate Bond Fund																				351
Liquid Credit
Long Lease Property																	111			135
Secured Income																	169			196
Liability Driven Investment																	1,697			1,468
Currency Hedging																	7			(21)
Net Current Assets																	9			15
Total assets																	3,686			5,262
None of the fair values			of	the		assets		shown		above include			any		direct	investments	in the employer's		own	financial
instruments or any	property			occupied			by, or		other assets			used	by,	the	employer.
Key Assumptions
																	31 March 2023	31	March 2022
																	%per annum	%per		annum
Discount rate																	5.18			2.79
Inflation (RPI)																	2.80			3.26
Inflation (CPI)																	2.34			2.74
Salary Growth																	3.00			2.00
																				75% of
																75%of maximum			maximum
Allowance for commutation				of pension			for cash			at	retirement						allowance		allowance

				Life
			expectancy	at
			age 65
			Years
Mals retiring	in	2023		21.0
Female retiring		in 2023		23.7
Mals retiring	in	2043		22.2
Female retiring		in 2043		24.9