OpenCharities

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

2023-03-31-accounts

2023 2022
Unrestricted Restricted Total Unrestricted Restricted Total
funds funds funds funds funds funds
6 f 6 6 f
Income and endowments
from
Donations
and legacies		 1,175 1,175 150 150
Investment
income		 19,667 19,667 4,664 4,664
Charitable
activities		 5
Received from people we
support 261,642 261,642 280,955 280,955
Local government
grants		 22,375,857 22,375,857 19,941,808 19,941,808
SPG and other allowances 733,086 733,086 927,706 927,706
Training and other income 1,976,096 1,976,096 1,020,708 1,020,708
Total 2,258,580 23,108,943 25,367,523 1,306,477 20,869,514 22,175,991
Expenditure
on Charitable
activities
Direct charitable
expenditure 274,455 25,088,319 25,362,774 388,468 21,740,415 22,128,883
Net income/ (expenditure)
before transfers 1,984,125 (1,984,415) 4,749 918,009 (870,901) 47,108
Transfers
between
funds		 1s (1,369,376) 1,369,376 49,099 (49,099)
Net income/ (expenditure)
before other recognised
gains and losses		 614,749 (610,000) 4,749 967,108 (920,000) 47,108
Net actuarial gains/(losses)
on defined benefit pension 22 920,000
scheme. 610,000 610,000 920,000
Net movement
in funds		 614,749 614,749 967,108 967,108
Reconciliation
offunds
Total funds brought
forward		 4,696,954 4,696,954 3,729,846 3,729,846
Total funds carried
forward		 5,311,703 5,311,703 4,696,954 4,696,954
Notes 2023 2022
Cash flows from operating activities
Cash generated
from operations		 (1,661,391) (152,321)
Net cash provided
by (used in) operating		 activities (1,661,391) (152,321)
Cash flows from investing activities
Purchase oftangible
fixed assets		 (45) (246,493)
Sale oftangible fixed assets
Interest received 19,667 4,664
Interest paid (3,194)
Net cash provided
by (used in) investing		 activities 19,622 (245,023)
Cash flows from financing activities
Loan repayment
in year
Net cash provided
by (used in) financing		 activities
Change
in cash and cash equivalents		 in the reporting period (1,641,769) (397,344)
Cash and cash equivalents at the beginning ofthe reporting
period 6,705,972 7,103,316
Cash and cash equivalents at the end of the reporting period 5,064,203 6,705,972

2023 2022
Notes Unrsstricted Restricted Total Unrestricted Restricted Total
Funds Funds Funds Funds Funds Funds
Fixed Assets
Tangible Assets 581,417 581,417 643,743 643,743
581,417 581,417 643,743 643,743
Current Assets
Debtors 13 3,029,520 3,029,520 1,948,674 1,948,674
Cash at Bank 4,730,286 333,917 5,064,203 4,053,211 2,652,761 6,705,972
Creditors 4,730,286 3,363,437 8,093,723 4,053,211 4,601,435 8,654,646
Amounts
falling due within		 (3,363,437) (3,363,437) (3,781,435) (3,781,435)
one year
Net Current Assets 4,730,286 4,730,286 4,053,211 820,000 4,873,211
Total Assets
Liabilities		 Less Current 5,311,703 5,311,703 4,696,954 820,000 5,516,954
Creditors
Amounts
due		 after more than 15
one year
Provision for Liabilities 17 (820,000) (820,000)
Net Assets 5,311,703 5,311,703 4,696,954 4,696,954
Unrestricted Funds 15 5,311,703 5,311,703 4,696,954 4,696,954
Restricted Funds
Total Funds 5,311,703 5,311,703 4,696,954 4,696,954

Notes Actual 6 Actual 6
2023 2022
2 - Donations
and Legacies		 1,175 150
3- Investment
Income		 19,667 4,664
4 - Reconciliation of net incomel(expenditure) to net
cash flow from operating activities
Net income/(expenditure)
for the reporting
per the statement
offinancial activities)		 period (as 4,749 47,108
Adjustments
for:
Depreciation
charges		 62,370 117,882
Interest received (19,667) (4,664)
Interest paid 3,194
Movement
on provisions		 (210,000) 50,000
Movement
on sales of		 fixed assets
(Increase) IDecrease in debtors (1,080,846) (672,868)
(Decrease) IIncrease in creditors (417,997) 307,027
Net cash provided
by (used		 in) operating activities (1,661,391) (152,321)
5 - Income from Charitable Activities
Local Authority
Care Fund		 17,192,344 15,150,187
Health Care Funding 2,720,162 2,372,037
Housing
Benefit Funds		 2,463,352 2,419,584
Supporting
People Grant		 733,086 927,706
Recharges 33,346 11,549
Personal Contributions 228,297 269,406
Grant Funding 106,476 173,856
Other Funding 1,869,620 846,852
25,346,683 22,171,177

Notes Actual 6 Actual 8
2023 2822
6-Charitable activities costs
Charitable
activities costs		 25,362,774 22,128,883
7 - Direct costs ofcharitable activities
Staff costs 19,355,271 16,286,525
Travel and car expenses 45,862 35,948
Accommodation Costs 2,205,083 1,941,308
Bad debts and provisions 96,967 (26,728)
Depreciation 12,743 768
Loss on sale ofassets
Apportionment ofcosts 3,372,393 3,502,594
25,088,319 21,740,415
8-Support Costs
Management
Wages 2,288Q94 2,454,426
Administration expenses 954,179 947,625
Establishment costs 258,296 275,999
Depreciation oftangible and heritage assets 39,836 117,114
Apportionment ofcost (3,372,393) (3,502,594)
168,213 292,570
Governance costs
Wages 77,366 71,290
Auditors'
remuneration		 16,296 13,080
Administration 12,581 11,529
106,243 95,698

Net income (expenditure) is stated after is stated after
charging/(crediting):
Auditors'
remuneration		 16,296 13,080
Depreciation - owned assets 52,579 128,700
Operating
leases
Surplus on disposal offixed asset
68,875 141,780
10 - Trustees'
renumeration		 and benefits
No Trustees received any remuneration in 2023 or 2022.
Trustee expenses
paid during the year		 815 450
11 - Staffcosts
Wages and salariies 19,918,980 17,093,631
Social security costs 1,784,657 1,435,053
Pension costs 63,156 319,505
Provision for redundancy
21,766,793 18,848,189
Average
Number ofPersons		 Employed during the year 772 751
Persons Employed
at End		 ofYear 764 746
(Permanent
and Casual)
The number
ofemployees		 whose emoluments amounted
to over 660,000 in the year were as follows:
f100,001tof110,000
f90,001 to6100,000
f80,001tof90,000
f70,001to680,000
f60,001to 870,000

Leasehold 8Freehold Properties Leasehold 8Freehold Properties
Cost:
At 1st April 550,000 550,000
Additions
Disposals
Depreciation:
At 1st April 179,115 156,723
Charge for Year 22,389 22,392
Disposals
Net Book Value 348,496 370,885
Improvements to Property
Cost:
At 1st April 258,870 36,701
Additions 222,169
Disposals
Depreciation:
At 1st April 43,981 32,280
Charge for Year 19,555 11,701
Disposals
Net BookValue 195,334 214,889
Project Furniture
Cost:
At 1st April 8,996 10,205
Additions
Disposals (1,209)
Depreciation:
At 1st April 7,530 7,284
Charge for Year 1,465 1,454
Disposals (1,208)
Net BookValue 1,466
Furniture
Cost:
At 1st April 12,870 30,513
Additions 4,698
Disposals (22,341)
Depreciation:
Page 32of40

At 1st April 5,687 15,634
Charge for Year 2,733 12,394
Disposals (22,341)
Net BookValue 4,450 7,184
Computer
Equipment
Cost:
At 1st April 104,137 263,904
Additions 45 19,625
Disposals (179,392)
Depreciation:
At 1st April 54,817 164,269
Charge for Year 16,228 69,940
Disposals (179,392)
Net BookValue 33,137 49,320
Total
Cost:
At 1siApril 934,873 891,322
Additions 45 246,493
Disposals (1) (202,942)
Depreciation:
At 1st Apdl 291,130 376,190
Charge for Year 62,370 117,882
Disposals (202,942)
Net Book Value 581,417 643,743
At 31stMarch Current Year 581,417 643,743
At 31stMarch Prior Year 643,743 515,132
13 - Debtors: amounts falling due within one year
Debtors Ledger 2,480,868 1,769,963
Prepayments and Accrued Income 548,652 178,711
3,029,520 1,948,674

14 - Creditors: amounts falling due within one year falling due within one year
Bank Loans and Overdrafts
Social Security and other Taxes 519,876 357,891
Other Creditors 1,227,484 1,218,213
Deferred Income 1,616,077 2,205,331
3,363,437 3,781,435
Deferred Income:
Deferred Income Brought Forward: 2,205,331 1,606,776
Amounts
Released to Income		 (2,205,331) (1,606,776)
Amounts
Deferred
in the Year		 1,616,077 2,205,331
15 - Creditors: amounts due after more than one year
Bank Loans
16-Loans
An analysis ofthe maturity ofloans is listed below:
Amounts
falling due in one		 year
Amounts
falling due in more than one year
17 - Provision for Liabilities
Pension
Provision		 820,000
18 - Movement
in Funds
Unrestricted
Funds:
General Fund 3,689,021 2,886,344
Housing
Benefit Reserve		 1,007,933 843,502
At 1stApril 4,696,954 3,729,846
General Fund 2,136,643 877,835
Housing
Benefit Reserve		 (152,518) 40,174
Net Movement
in Reserves		 1,984,215 918,009
General Fund (1,369,376) 49,099
Housing
Benefit Reserve
Transfers between
Funds		 (1,369,376) 49,099
General Fund 4,456,288 3,813,278
Housing
Benefit Reserve		 855,415 883,676
At 31stMarch 5,311,703 4,696,954

Restricted Funds:
Pension Reserve (820,000) (1,690,000)
Leasehold
Properties
Grant and SPG Fund 820,000 1,690,000
At 1stApril
Pension Reserve 820,000 870,000
Leasehold
Properties
Grant and SPG Fund (2,189,376) (820,901)
Net Movement
in Reserves		 (1,369,376) 49,099
Pension Reserve
Leasehold
Properties
Grant and SPG Fund 1,369,376 (49,099)
Transfers between Funds 1,369,376 (49,099)
Pension Reserve (820,000)
Leasehold
Properties
Grant and SPG Fund 820,000
At 31stMarch
TotalFunds 5,311,703 4,696,954

Net Movement in Funds, included in above are as
follows:
Unrestricted
Funds
General Funds 877,835 2,635,847
Housing
Benefit		 40,174 102,278
Incoming Resources 918,009 2,738,125
General Funds 1,258,808 (1,758,012)
Housing
Benefit		 (192,692) (62,104)
Resources Expended 1,066,116 (1,820,116)
General Funds 2,136,643 877,835
Housing
Benefit		 (152,518) 40,174
Movement
in Funds		 1,984,215 918,009

Office Equipment
Operating
lease due within
1 year		 26,245 30,998
Operating
lease due within 2 and 5years		 40,215 15,096
66,460 46,094
20 - Net Debt Reconciliation At Start Cash At End
ofYear Flows ofYear
Cash 6,705,972 (1,641,769) 5,064,203
Loans falling due within
1 year
21 - Related party disclosures
There were no related party transactions
ended 31stMarch 2023		 for the year

ASSUMPTIONS ASSUMPTIONS
The latest actuarial
valuation ofMirus.Wales's liabiliTies tock place as at 31 March
qualified
actuary on an actuarial basis using ihe projected
unit credit method. The
latest valuation
ofthe Fund forFRS102purposes are:		 2022. LiabiliTiss have
principal assumptions		 been esgmatsd
by
used by the actuary		 the independent
in updating
ths
PRINCIPAL FINANCIAL ASSUMPTIONS (% PER
ANNUM)
Discount rate 4.7% 2.7%
CPI Inflation 2.7% 3.0%
Rate ofincrease to pensions
in payment		 2.7% 3.0%
Pension accounts revaluation
rate		 2.7'ys 3.0sk
Rate ofgeneral
increase
in salaries		 3.7% 4.0%

EXPECTED RETURN ON ASSETS EXPECTED RETURN ON ASSETS EXPECTED RETURN ON ASSETS EXPECTED RETURN ON ASSETS EXPECTED RETURN ON ASSETS
The approximate
split ofassets for the Fund as a whole (based
beknv.
Also shown are the assumed
rates of return
adopted
by		 on date supplied
the Employer for		 by the Fund Administering
the purposes ofFRSf02.		 Authority) is shown in ths table
Estimated
asset split at
31 March
2023 ('yo)		 Estimated asset
split at 31
March 2022 (%)
Equities 67.9% 67.5%
Property 7.2% 6.g%
Government Bonds 8.8% 9.2%
Corporate Bonds 7.6% 8.4%
Cash 5.3% 2.3oro
Multi asset credit 3.2% 5.7'/o
Other 0.0% 0.0o/o
Total 100.0% 100.0%

RECONCILIATION
OF FUNDED STATUS TO		 RECONCILIATION
OF FUNDED STATUS TO		 RECONCILIATION
OF FUNDED STATUS TO		 RECONCILIATION
OF FUNDED STATUS TO		 RECONCILIATION
OF FUNDED STATUS TO		 Value at 31 Value at 31
BALANCE SHEET March 2023 March 2022
fM's KM's
Fair value ofassets 5.77 5.70
Present value offunded liabilities 4.90 6.52
Pension asset I (liability} 0.87 (0.82)
Unrecognised
asset due		 to limit 0.87
Pension asset I(liability)
Sheet		 recognised on the Balance (0.82)
ANALYSIS OF THE PROFIT AND LOSS CHARGE Period ending Period ending
31 March 2023 31 March 2022
EM's 9M's
Current service cost 0.12 0.11
Past service cost 0.00 0.00
Interest cost 0.02 0.03
Expected return
on assets
Curtailment
cost		 0.00 0.00
Settlement cost 0.00 0.00
Expense recognised 0.14 0.14
CHANGES TO THE PRESENT VALUE OF LIABILITIES Period ending Period ending
DURING THE ACCOUNTING PERIOD 31 March 2023 31 March 2022
FM's fM's
Opening
present value of liabilities		 6.52 6.81
Current service cost 0.12 0.11
Interest cost 0.17 0.14
Contributions
to participants		 0.03 0.03
Actuarial
(gains) Ilosses		 due to changes in financial (2.36) 0.00
assumptions
Actuarial
(gains) Ilosses		 due to changes in demographic (0.04) 0.00
assumptions
Actuarial
(gains) Ilosses		 due to liability experience 0.59 (0.49)
Net benefits
paid out		 (0.13) (0.08)
Past service cost 0.00 0.00
Net increase
in liabilities		 from disposals and acquisitions 0.00 0.00
Curtailments 0.00 0.00
Settlements 0.00 0.00
Closing present value of liabilities 4.90 6.52

Period ending Period ending
CHANGES TO THE FAIR VALUE OF ASSETS 31 March 2023 31 March 2022
DURING THE ACCOUNTING PERIOD
8M's 8M's
Opening fair value ofassets 5.70 5.12
Expected return on assets 0.15 0.11
Actuarial
gains/ (losses) on assets		 (0.33) 0.43
Contributions
by the employer		 0.35 0.09
Contributions
by participants		 0.03 0.03
Net benefits
paid out		 (0.13) (o.o8)
Net increase
in assets from disposals		 and acquisitions 0.00 0.00
Settlements 0.00 0.00
Closing fair value ofassets 5.77 5.70
ACTUAL RETURN ON ASSETS Period ending Period ending
31 March 2023 31 March 2022
8IVfs 8M's
Expected return
on assets		 0.15 0.11
Actuarial
gains/ (losses) on assets		 (0.33) 0.43
Actual return
on assets		 (0.18) 0.54
ANALYSIS OF AMOUNTS RECOGNISED IN STRGL Period ending Period ending
31 March 2023 31 March 2022
KM's EM's
Total asset gains/ (losses) arising during the period (0.33) 0.43
Actuarial
(gains)
/ losses due		 to changes in financial 2.36 0.00
assumptions
Actuarial
(gains)
/ losses due		 to changes in demographic 0.00
assumptions
Total liability gains/ (losses) arising during the period (0.59) 0.49
Adjustment (0.87) 0.00
Total gains/ (losses) in STRGL 0.61 0.92
Periiod ending Period ending
HISTORY OFASSET VALUES, PRESENT VALUE OF 31 March 2023 31 March 2022
LIABILITIES AND SURPLUS/DEFICIT
fM's 8M's
Fair value ofassets 5.77 5.70
Present value of liabilities 4.90 6.52
Surplus/
(deficit)		 0.87 (0.82)