OpenCharities

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

2021-03-31-accounts

Page
Reference and administrative
information
Trustees'
report (incorporating
the
directors' report and strategic report) 2 —9
Independent auditor's
report
10 —12
Consolidated statement
offinancial
activities 13
Consolidated balance sheet 14
Consolidated cash flow statement 15
Notes to the financial statements 16-33

Unrestricted Designated Restricted Total Total
funds funds funds funds funds
Notes
Income: 2021 2020
Donations
and legacies
1,521,966 1,811,709 1,655 3,335,330 3,263,161
Charitable
activities
3,783,795 2,447,844 6,231,639 2,915,501
Other trading
activities
3,874,547 3,874,547 6,239,270
Investment
income
130,463 130,463 198,467
Other 5,344,935 5,344,935
Total income 14,655,706 1 811709 2,449499 18,916,914 12,616,399
~Ex
nditure
Costs of raising funds 7 2,789,548 2,789,548 3,386,3i~
Charitable
activities
8 5,998,361 409,530 2,447,844 8,855,735 9,574,634
Total expenditure 8,787,909 409530 2,447,844 11,645,283 12,961,007
Net gains/ (loss) on investments 17 1,397,069 1,397,069 (577,193)
Net income
/ (expenditure)
7264 866 1,402,179 1,655 8668,700 921,801
Transfers between funds 25/26 (2,366,262) 2,550,222 (183,960)
Other recognised
gains and (losses)
Actuarial
gain / (loss) on defined
benefit
pension schemes 21 402,000 402,000 (127,000)
Net movement
in funds
5,300,604 3,952,401 182,305 9,070,700 1,048,801
Reconciliation
offunds:
Fund balances brought forward 1,895,425 10,060,866 227,308 12,183,599 13,232,400
Fund balances carried forward 7,196,029 14,013,267 45,003 21,254,299 12,183,5

Group Group Charity
2021 2020 2021 2020
Notes f. R
Fixed assets
Tangible assets 16 9,246,326 5,483,227 9,246,326 5,483,227
Investments 17 7,050,197 5,689,104 7,050,201 5,689,108
16,296,523 11,172,331 16,296,527 11,172,335
Current assets
Stocks 18 3,074 5,221
Debtors 19 2,911,641 1,123,783 3,428,406 1,123,783
Cash at bank and in hand 4,765,320 3,322,779 3,920,226 3,325,841
7,680,035 4,451,783 7,348,632 4,449,624
Creditors: amounts falling due within one year 20 985,259 1,196,515 669,766 1,220,254
Net current assets 6694 776 3255268 6,678,866 3,229,370
Total assets less current liabilities 22,991,299 14,427,599 22,975,393 14,401,705
iing net assets excluding pension liability
Defined benefit pension scheme liability 21 (1,737,000) (2,244,000) (1,737,000) (2,244,000)
Net assets including pension liability 21,254,299 12,183,599 21,238,393 12,157,705
Funds
Income funds
Restricted funds 25 45,003 227,308 45,003 227,308
Unrestricted
funds:
Designated
funds
26 14,013,267 10,060,866 14,013,267 10,060,866
Other charitable funds 8,933,029 4,139,425 8,917,123 4,113,531
Total funds excluding pension reserve 22,991,299 14,427,599 22,975,393 14,401,705
Pension reserve 21 1,737,000 2,244,000 1,737,000 2,244,000
Total funds 21,254,299 12,183,599 21,238,393 12,157,705

Group Charity
Notes 2021
R
2020f 2021 2020
Net cash provided
by operating
activities
28 5,361,229 9,361 4,513,073 69,937
Cash flows from investing
activities:
Dividends,
interest and rents from investments
130,463 198,467 130,463 198,467
Purchase of property,
plant and equipment
(4,172,629) (147,639) (4,172,629) (147,639)
Proceeds from sale of property,
plant and
equipment
Proceeds on sale ofinvestments 2,989,060 2,788,113 2,989,060 2,788,113
Purchase ofinvestments (2,865,582) (2,718,748) (2,865,582) (2,718,748)
Net cash used
in investing
activities
(3,918,688) 120,193 (3,918,688) 120,193
Change in cash and cash equivalents in the reporting period 1,442,541 129,554 594,385 190,130
Cash and cash equivalents
at the beginning
ofthe reporting period 3,322,779 3,193,225 3,325,841 3,135,711
Cash and cash equivalents
at the end
ofthe reporting period 4,765,320 3,322,779 3,920,226 3325,8

Donations
and legacies
Donations
and legacies
Donations
and legacies
Unrestricted Designated Restricted Total Total
funds fundsf funds
R
2021
R
2020
Donations
and gifts
1,468,278 1,655 1,469,933 1,593,302
Legacies 1,811,709 1,811,709 1,616,171
Department
of Health
53,688 53,688 53,688
1,521,966 1,811,709 1,655 3,335,330 3,263,161
For the year ended 31 March 2020
Unrestricted funds 1,645,377
Designated funds 1,616,171
Restricted funds 1,613
3,263,161
Income from charitable activities
Unrestricted Designated Restricted Total
funds funds funds 2021 2020
R
Charitable
activities
3,783,795 2,447,844 6,231,639 2,915,501
Forthe year ended 31 March 2020
Unrestricted funds 2,915,501
Designated funds
Restricted funds
2,915,501
Included within income relating to charitable activities are:
Clinical Commissioning Group 2,973,635 2,591,455
NHS England COVID 19 2,447,844
5,421,479 2,591,455

Unrestricted Designated Restricted Total Total
funds funds funds 2021 2
7
Fundraising
events
589,246 589,246 1,357,801
Income from commercial activities:
- Charity shops 1,939,340 1,939,340 3,335,581
- Lottery 1,345,961 1,345,961 1,545,888
3,874,547 3,874,547 6,239,270
For the year ended 31March 2020
Unrestricted funds 6,239,270
Designated funds
Restricted funds
6,239,270
Included within
income related to Charity shops are:
COVID 19related Local Authority Retail Grants 503,233
Job Retention Scheme Grant 530,821
1,034,054

Investment
Income
Investment
Income
2021f 2020f
Income from listed investments 123,145 181,926
Interest receivable 7,318 16,541
130,463 198,467
Forthe year ended 31 March 2020
Unrestricted funds 198,467
Designated funds
Restricted funds
198,467
Other
2021f 2020f
Transfer ofassets from The Donna Louise Trust 5,344,935
Land and buildings Land and buildings Land and buildings 4,106,868
Other debtors 301,453
Cash at bank and in hand 936614
5,344,935
Analysis ofcosts ofraising funds
Direct Support Total Total
costsf costsf 2021f 2020
Fundraising
Costs
354,250 354,250 651,503
Costs of commercial activities:
-Charity shops 1,955,710 1,955,710 2,055,481
- Lottery 479,588 479,588 679,389
2,789,548 2,789,548 3,386,373
Forthe year ended 31 March 2020
Unrestricted funds 3,386,373
Designated funds
Restricted funds
3,386,373
Analysis ofexpenditure on charitable activities
Direct Support Total Total
costs costsf 2021f 2020
Inpatient Services 2,978,744 566,243 3,544,987 4,362,211
Medical 465,342 88,460 553,802 779,972
Day hospice 370,505 70,432 440,937 669,633
Community 2,143,979 407,559 2,551,538 2,351,733
Hospice at home 616,183 117,135 733,318 777,068
Wellbeing 695,296 132,172 827,468 556,097
Learning
Children's
and Development
Hospice
101,577
69,578
19,306
13,224
120,883
82,802
77,920
7,441,204 1,414,531 8,855,735 9,574,634
Unrestricted funds 5,998,361 8,720,001
Designated funds 409,530 414,508
Restricted funds 2,447,844 440,125
8,855,735 9,574,634

Allocation ofsupport costs
Inpatient Day Children' s
Services Medical Hospice Hospice Community
R
Governance 38,336 5,990 4,769 895 27,593
Finance 61,059 9,539 7,595 1,426 43,948
Information technology 135,778 21,211 16,888 3,172 97,727
HR &reception 99,328 15,517 12,355 2,320 71,492
Facilities & health and safety 67,815 10,594 8,435 1,584 48,811
Depreciation 163,937 25,610 20,391 3,828 117,995
General overheads 42,022 6,565 5,227 982 30,246
Defined benefit pension scheme 42,032 6,566 5,228 983 30,253
566,243 88,460 70,432 13,224 407,559
Allocation ofsupport costs (Continued)
Hospice Learning
&
Total
at home Wellbeing Development 2021
Governance 7,930 8,949 1,306 95,7
Finance 12,631 14,252 2,082 152,53m
Information technology 28,088 31,693 4,631 339,188
HR &reception 20,547 23,185 3,387 248,131
Facilities & health and safety 14,028 15,829 2,313 169,409
Depreciation 33,912 38,266 5,590 409,529
General overheads 8,693 9,809 1,430 104,974
Defined benefit pension scheme 8,694 9,811 1,433 105,000
117,135 132,172 19,306 1,414,531
Analysis ofgovernance costs ofgovernance costs 2021 2020
Salaries, wages and related costs Allocated on time basis 32,453 33,968
Audit fees (parent company) Cost incurred 9,250 9,000
Premises costs 1.125% oftotal premises costs 19,276 21,724
Overheads 10%ofoverheads not included above 34,789 49,268
95,768 113,9F"
Net income I(expenditure) for the year 2021 2020
f.
Net income
/ (expenditure)
is stated after charging:
Depreciation 409,530 414,508
Loss on disposal oftangible fixed assets 8,689
Auditors' remuneration
(group) -audit services
14,700 14,295
Auditors' remuneration
(group) -non audit
services 6,025 3,360
Operating lease charges - buildings 264,096 271,628

12 Financial activities ofthe charity ofthe charity ofthe charity 2021 2020
Gross income 18,442,604 11,900,940
Total expenditure
on
charitable activities (8,960,735) (9,666,637)
Fundraising
costs
(2,305,250) (2,670,761)
Unrealised
gains/ (losses) on investment
assets 1,397,069 577,193
Net income/
(expenditure)
8,573,688 (1,013,651)
Total funds brought forward excluding pension
reserve
14,401,705 15,415,356
Total funds carried forward excluding pension reserve 22,975,393 14,401,705
Represented
by:
Unrestricted
income
funds 8,917,123 4,113,531
Designated
income
funds 14,013,267 10,060,866
Restricted
income funds
45,003 227,308
22,975,393 14,401,705
13 Trading subsidiaries
The charity controls the companies listed below by virtue of holding a controlling interest in the equity share capital:-
Name ofsubsidiary Country of incorporation % ofequity share capital held
Douglas
Macmillan
Hospice Staffordshire Enterprises Limited England &Wales 100
Douglas
Macmillan
Hospice Staffordshire Lotteries Limited England &Wales 100
Douglas
Macmillan
Hospice Staffordshire Enterprises Limited
Summary oftrading results 2021 2020
Restated
Turnover 20,617 62,117
Total expenditure (4,710) (36,223)
Profit for the year 15,907 25,894
The turnover
from this entity
is consolidated within total charity shop income reported in note 4of these accounts.
All profits
in this subsidiary
are
distributed to Douglas Macmillan Hospice after the year end.
The assets and liabilities ofthe Douglas Macmillan Hospice Staffordshire Enterprises Limited were:
Assets 133,356 33,089
Liabilities 117,447 7,193
Funds 15,909 25,896
Douglas
Macmillan
Hospice Staffordshire Lotteries Limited
Summary oftrading results 2021 2020
f. Restatedf
Turnover 1,345,961 1,545,888
Total expenditure (451,084) (679,389)
Profit for the year 894,877 866,499
The assets and liabilities ofthe Douglas Macmillan Hospice Staffordshire Lotteries Limited were:
Assets 1,207,829 1,187,041
Liabilities 313,050 320,540
Funds 894,779 866,501

The total staff costs and employees
benefits were:
2021 2020
K
Wages and salaries 7,382,237 7,740,676
Social security costs 640,031 642,847
Pension costs 991,141 1,056,432
9,013,409 9,439,955
The number
of employees
who received
total employee
benefi
follows:
ts
(excluding
employer
pension
costs) of more than
860,000 is as
2021 2020
Number Number
f60,001 to 270,000 1 1
f70,001 to 280,000 1 1
f80,001 to F90,000
E'90,001 tof100,000
6100,001 to8110,000
The averag e
monthly
number ofemployees
a
nd full time equivalent
(FTE)during the
year was as foll ows:
2021 2021 2020 2020
Number FTE Number FTE
Raising funds 99 86 103 86
Charitable activities 239 200 239 202
Governance 1 1 1 1
339 287 289

Tangible fixed assets Tangible fixed assets Tangible fixed assets
Group and company Land and Fixtures, Total
buildings fittings 8
equipment
Cost
At 1 April 2020 8,446,382 1,519,957 9,966,339
Additions 4,106,868 65,761 4,172,629
Disposals
At 31 March 2021 12,553,250 1,585,718 14,138,968
Depreciation
At 1 April 2020 3,316,781 1,166,331 4,483,112
Charge for the year 269,964 139,566 409,530
Disposals
At 31 March 2021 3,586,745 1,305,897 4,892,642
Net book value
At 31 March 2021 8,966,505 279,821 9,246,:
At 31 March 2020 5,129,601 353,626 5,483,227
Fixed asset investments Cash Listed Total 2020
Inv.
Market value at 1 April 2020 128,234 5,560,870 5,689,104 6,303,221
Additions at cost (2,865,582) 2,865,582
Disposals at carrying value 2,989,060 (2,989,060)
Change
in value
in the year
1,397,069 1,397,069 (577,193)
Other movement
in
cash balance 35,976 35,976 36,924
Market value at 31 March 2021 215,736 6,834,461 7,050,197 5,689,104
Historical cost at 31 March 2021 215,736 6,111,462 6,327,198 6,355,345
The following
investments
made up more than 5% each ofthe total market value oflisted investments or bonds at 31 March 2021.
2021 2020f
Maitland
Institutional
Services Ml select Managers Fund 623 670 429 5n"
Vanguard
Funds PLC
S&P500 541,819 600,4
Summary ofInvestments Group Charity
2021 2020 2021 2020f
Investment
in subsidiary
companies 4 4
Other investments 7,050,197 5,689,104 7,050,197 5,689,104
7,050,197 5,689,104 7,050,201 5,689,108

18 Stock Group Charity
2021 2020 2021 2020
R
Stock in hand 3,074 5,221
3,074 5,221
19 Debtors Group Charity
2021 2020 2021 2020
Trade debtors 358,682 1,221 358,682 1,221
Amounts
owed by subsidiary
undertakings 516,765
Other debtors 2,547,898 1,104,180 2,547,898 1,104,180
Prepayments
and accrued
income 5,061 18,382 5,061 18,382
2,911,641 1,123,783 3,428,406 1,123,783
20 Creditors: amounts
falling
due within one year Group Charity
2021 2020f 2021 2020
Trade creditors 10,240 140,334 130,885
Amounts
owed to subsidiary
undertakings 324,067
Other creditors 590,611 400,568 292,163 116,240
Taxes and social security 166,797 160,696 166,797 160,696
Accruals and deferred
income
217,611 494,917 210,806 488366
985,259 1,196,515 669,766 1,220,254
21 Pension and other postwetirement benefit commitments
Employee benefit obligations Defined benefit pension plans
2021 2020
a) The amounts
recognised
in the balance sheet are as follows: f. f.
Present value offunded
obligations
11,497,000 10,841,000
Fair value of plan assets 9,760,000 8,597,000
Deficit 1,737,000 2,244,000
Present value ofunfunded obligations
Unrecognised
past service
cost
Irrecoverable
surplus
Net pension
liability recognised
before tax 1,737,000 2,244,000
b) The amounts
recognised
in the statement offinancial activities are as follows:
Current service cost inciuded in staff costs within total resources expended
Past service cost
Net pension finance costs included within total resources expended:
Interest on obligation 244,000 258,000
Expected return
on pension
scheme assets 194,000 209,000
50,000 49,000
Total 50,000 49,000
Actual return
on scheme assets
over the period 1,487,000 281,000

21 Pension and other post-retirement Pension and other post-retirement Pension and other post-retirement benefit commitments (continued)
c) Included
with other
recognised gains and losses: 2021 2020
Return
on assets, excluding
interest income 1,293,000 (490,000)
Impact ofsurplus
restrictions
Change
in irrecoverable
surplus
Actuarial gains/(losses) on liabilities 891,000 363,000
402,000 127,000
d) Changes
In the present
value ofthe scheme liabilities:
2021 2020
Opening
liabilities
10,841,000 11,527,000
Current service cost
Past service cost
Interest cost 244,000 258,000
Contribution
by scheme
participants
Actuarial
(gains) / Losses
891,000 (363,0
Benefits paid 479,000 581,000
11,497,000 10,841,000
e)Changes
in fair value of
the scheme assets:
Opening
fair value ofscheme assets
8,597,000 9,318,000
Expected return 194,000 209,000
Actuarial
gains
1,293,000 (490,000)
Contributions
by employer
155,000 141,000
Contributions
from scheme participants
Benefits paid 479,000 581,000
9,760,000 8,597,000
f) The maJor categories ofscheme assets are as follows:
2021 2020
f.
Equity 3,535,000 2,690,000
Bonds 1,523,000 1,438,000
Diversified
funds
3,658,000 3073 Or
LDI 984,000 1,357,0i
Cash 43,000 15,000
Annuity contracts 17,000 24,000
9,760,000 8,597,000
g) Principal actuarial assumptions used by the actuary at the balance sheet date
2021 2020
Discount rate at 31 March 2.05 2.30
Rate of inflation (RPI) 3.35 2.90
Rate of inflation (CPI) 2.95 2.20
Rate ofsalary increase 2.50 2.50
Rate of increase to pensions in payment
-Pre 1997(Discretionary) 0.00 0.00
-1997-2009 (RPI max 5%) 3.25 2.90
-Post 2009 (RPI max 2.5%) 2.20 2.10

Analysis ofgroup n et asse ts bet ween funds
Unrestricted Designated Restricted Total
funds funds funds
f.
Fund balances at 31 March 2021 are represented by:
Tangible fixed assets 9,246,326 9,246,326
Investments 7,050,197 7,050,197
Current assets 2,868,091 4,766,941 45,003 7,680,035
Current
liabilities
985,259 985,259
8,933,029 14,013,267 45,003 22,991,299
Pension reserve (1,737,000) (1,737,000)
Group net assets 7,196,029 14,013,267 45,003 21,254,299
Reconciliation
ofnet movement
in funds to net cash flow from operating
activities
Group Charity
2021 2020 2021 2020
Net income for the reporting period 9,070,700 (1,048,801) 9,080,688 (1,048,651)
Adjustments
for.
Depreciation
charges
409,530 414,508 409,530 414,508
Loss on disposal oftangible fixed assets 8,689 8,689
Increase
in investment
cash balance (87,502) (32,441) (87,502) (32,441)
(Gains)/ losses on investments (1,397,069) 577,193 (1,397,069) 577,193
Actuarial
(gains)/ losses
(402,000) 127,000 (402,000) 127,000
Dividends,
interest and
rents from investments (130,463) (198,467) (130,463) (198,467)
Difference between pension charge and cash contributions (105,000) (92,000) (105,000) (92,000)
Decrease
in stocks
2,147 7,800
(Increase)/ decrease in debtors (1,787,858) 66,042 (2,304,623) 65,316
(Decrease)/ increase in creditors 211,256 179,838 550,488 248,790
Net cash provided by operating activities 5,361,229 9,361 4,513,073 69,937
Analysis ofnet cash balances
1 April Cash flow Noncash 31 March
2020 changes 2021
f.
Cash at bank and in hand 3,322,779 1,442,541 4,765,320
Fixed asset investments 5,689,104 35,976 1,397,069 7,050,197
9,011,883 1,406,565 1,397,069 11,815,517

The carrying
amounts
ofth e c harity's
fina
n cial
instruments
ar
e as follows:
Group Charity
Notes
2021
2020f 2021f 2020f
Financial assets
Measured
at fair value through
net income
Fixed asset listed investments
/ expenditure:
17
7,050,197 ' 5,689,104 7,050,201 5,689,108
Debt instruments
measured
at amortised cost:
Trade debtors 19 358,682 1,221 358,682 1,221
Amounts
owed by subsidiary
undertakings 19 516,765
Other debtors 19 2,547,898 1,104,180 2,547,898 1 104,180
2,906,580 1,105,401 3,423,345 1,105,401
Financial
liabilities
Measured
at amortised
cost
Trade creditors 20 10,240 140,334 130,885
Amounts
owed to subsidiary
undertakings 20 324,067
Other creditors 20 590,611 400,568 292,163 116,240
Taxes and social security 20 166,797 160,696 166,797 160,696
Accruals and deferred income 20 217,611 494,917 210,806 488,366
985,259 1,196,515 669,766 1 220 254
The income, expenses, net gains and net losses attributable to the charity's
financial
instruments are summarised as follows:
Group Charity
Notes
2021f
2020 2021 2020f
Financial assets measured at fair value through
net income
/ expenditure
17 1,397,069 577,193 1,397,069 577,193