##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
##
|||||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)|