Finance Committee - Agenda - 8/17/2022 - P162
Required Supplementary Information
Required Supplementary Information
(This page intentionally left blank.)
[33
CITY OF NASHUA, NEW HAMPSHIRE
REQUIRED SLIPPLEMENTARY INFORMA TION
SCHEDULE OF PROPORTIONATE SHARE
OF THE NET PENSION LIABILITY
(Unaudited}
New Hampshire Retirement System
Fiscal
Year
June 30, 202)
June 30, 2020
June 30, 2019
June 30, 2018
June 30, 2017
June 30, 2016
June 30, 2015
Meas urement
Date
June 30, 2020
June 30, 2019
June 30, 2018
June 30, 2017
June 30. 2016
June 30, 2015
June 30, 2014
Proportion
ofthe
Net Pension
Liability
5.00%
5.02%
5.09%
497%
5.02%
5.01%
4.93%
Proportionate
4 bf GF 64 oF Gf of
Share of the
Net Pension
Liability
326,002,458
241,474,378
244,946,874
244,236,535
267,201,666
198,484,550
184,879, 108
Proporttonate Share of the
Net Pension Liability as a
Covered Payroll Percentage of Covered Payroll
$ 146,299,488 218.73%
$ 141,519,997 170.63%
$ 139,528,277 175.55%
$ 128,054,908 190.73%
$ 130,717,303 204.41%
$ 129,016,789 153.84%
$ 102,555,267 186.27%
Plan Fiduciary Net Position
Percentage of the Total
Pension Liability
58.72%
65.59%
64.73%
62.66%
58.30%
65.47%
66.32%
Schedules are intended to show information jor 10 years. Additional years will be displayed as they become available,
See notes to the City's financial statements for summary of significant actuanal methods and assumptions
See Independent Auditors’ Report
156
CITY OF NASHUA, NEW HAMPS HIRE
REQUIRED SUPPLEMENTARY INFORMATION
SCHEDULE OF PENSION CONTRIBUTIONS
(Unaudited)
New Hampshire Retirement System
Contributions in
Relation to the
Contractually
Contractually
Contribution
Contributions as
Fiscal Required Required Deficiency Covered a Percentage of
Year Contribution Contribution (Excess} Payroll Covered Payroll
June 30,2021 = $ 23,356.118 $ (23,356,118) § - $ 147,787,954 15.80%
June 30,2020 $ 22,184.819 3 (22,184,819) § - $ 146,299,488 15.16%
June 30,2019 $ = 21.854.348 9 =$ = (21,854,348) § - $ 141,519,997 15.44%
June 30,2018 $$ 23.924.823 $ (23,924,823) $§ - $ 139,528,277 17.15%
June 30,2017 $= 21,281.680 3 =$ (21,281,680) §$ - $ 128,054,908 16.62%
June 30,2016 $ 21,048.967 $ (21,048,967) § - $ 130,7'7,303 16.10%
June 30,2015 $ =19,432.673 $ (19.432,673) $ - $ 129,016,789 15.06%
Schedules are intended to show information for 10 years. Additional years will be displayed as
they become available.
See notes to the City's financial statements for summary of significant actuarial
methods and assumptions.
See Independent Auditors’ Report.
137
CITY OF NASHUA, NEW HAMPSHIRE
BOARD OF PUBLIC WORKS' RETIREMENT SYSTEM
REQUIRED SUPPLEMENTARY INFORMATION
SCHEDULE OF CHANGES IN THE NET PENSION LIABILITY
(Unaudited)
2021 2020 O19 2018 2017 2016 2015 O14
Total Pension Liability
Service cost $ 1,194,402 $ 0,159613 8 1.159.714 $1,125,936 8 1102418 § 1,070,306 F 833,083 $ 801,04)
Interest 3,546,569 3.438385 3,413,621 3,302,509 3,317,923 3,201,701 3,165,454 3,056,600
Differences between expected and actual expenence (933,080) = (794,224) = (262,266) . 84,012 -
Changes of assumptions 1,910,247 - (466,050) - 24,291 : (1,231,934) -
Benefit payments, inching refunds of
member conmibutons 3,179,286} (2,998,396) (2,931,280) (2,830,049) (2,752,954) (2,650,932) (2,526,991) (2,255,102)
Net change in total pension Kabibty 2,538,852 1,599,602 391,781 1,598,396 1,429,409 1,621,075 323,624 1,602,539
Total pension habilty - begwuing 51,033,623 49,434.02] 49042240 47,445,844 46.014435 44,393,360 —44.069,736 = 42,466,375
Total pension kability + ending (a) 53,572,475 St,033,623 49,434,021 49,042,240 47,443,844 46,014,435 44,393,360 44,068,914
Plan Fiduciary Net Position
Contributions - employer 907,292 852,993 832,686 823,768 795,263 794,440 772,343 743,527
Contribunons - member 907,292 852,993 832,686 823,768 795,263 794,440 772,343 742,704
Net mivestment income VL ,103,338 1,909,696 2,871,652 3,290,484 3,956,902 115,127 1,104,870 3,478,296
Benefit payments, mcludng refunds of
member contnbunons (3,179,286) (2,998,396) (2,921,280) (2,830,049) (2.752.954) (2,650,932) (2,526,991) (2,254,280)
Admamnustrative expense (61,626) (51.616) (2,580) (2,569) (2,504) (2,903) (2,359) (14,809)
Net change m plan fiduciary net posibon 9,677,010 565,670 1,613,164 2,105,402 2.791.570 (949,823) 126,206 2.695, 438
Plan fiduciary net posivon - begmung 43,638,120 43,072,450 41,459,286 39,353,884 36,562,314 37,512,143 37,391,937 34,696,499
Plan fiduciary net posinon - ending (b) 53,315,130 43,638,120 43,072,450 41,459,286 39,353,884 36,562,315 37,512,143 37,391,937 |
Net pension ability (asset) - ending (a-b) $ 257345 & 7.395503 3 6.365.571 $7,582,954 $ $.089,960 § 9.452.120 5 688217 $6,676,977 |
Schedule is tntended ta show information for 10 years. Additional years will be displayed as they become available.
Sce notes to the Cris’s fi ial for » of signifi Imeihods and 4
See Independent Audtors’ Report
158
CITY OF NASHUA, NEW HAMPSHIRE
BOARD OF PUBLIC WORKS' RETIREMENT SYSTEM
REQUIRED SUPPLEMENTARY INFORMATION
SCHEDULES OF NET PENSION LIABILITY. CONTRIBUTIONS, AND INVESTMENT RETURNS
Schedule of Net Pension Liability
Total pension lability
Plan fiduciary net position
Net pension lability
Plan fiducary net posinon as a percentage
of the total pension lability
Covered payroll
Parte paling employer net pension liability (asset)
as a percentage of covered payroll
Schedule of Contributions
Actuanalhy determmned contribunon
Contributions m relaton to the actuanally
determmed contribution
Contribution deficiency (excess)
Covered payroll
Contributions as a perceniage of covered payroll
Schedule of Investment Returns
Year Ended Stine 30
Annual money weighted rate of retum,
het of mvestment expense
Schedule és é ded 10 show infi
for 10 years. Additional years will be displayed as they become avatiable
See notes to the City’s financial statements for summaty of significant actuanal methods and assumptions
See Independent Auditors’ Report.
159
(Unaudited)
2021 2020 2019 2018 2017 2016 2015 2014
$ 53,572,475 $ $1,033,623 $ 49.434,021 $ 49,042,240 § 47,443,844 § 46.014,435 $ 44,393,360 § 44,068,914
$3.315.130 43.638.120 43,072,450 41,459,286 39,353,884 36,562,315 37,512,143 37,391,115
257.345 $ 7,395,503 $ 6361,571 § 7.582.954 § 8,089,960 $ 9452,120 $ 6,881,217 $ 6,677,799
99.52% 85.51% 87 13% £4.54% 82.95% 79 46% 84 50% 84.85%
$ 9.412.440 § 9,630,921 § 9.350409 $ 9,033,764 $ 8,770,645 $ 8,701,590 $ 8.448.146 $ 7,937,797
2.73% 76.79% 68.04% 83 94% 92.24% 108.63% 81.45% 84.13%
2021 2020 2019 2018 2017 2016 2015 2014
907,292 § 852.993 $ 832,686 $ 823,768 $ 795,263 § 794,440 § 772,343 § 743,527
(907.292) (852,993) (832,686) (823.768) (795.263) (794.440) (772,343) (743,527)
- § -_ § - § - §$ - - $ - .
$ 9.412.440 $ 9,630,921 § 9350409 § 9,033,764 $ 8,770,645 $ 8,761,590 $ 8.448146 $ 7,937,797
9.64% §.86% 8.91% 9.17% 907% 913% 914% 9.37%
2021 2020 2019 2018 2017 2016 2015 2014
25.65% 4 38% 7.02% 8.47% 10.97% 0.31% 2.99% 10.13%
CITY OF NASHUA, NEW HAMPSHIRE
REQUIRED SUPPLEMENTARY INFORMATION
SCHEDULES OF PROPORTIONATE SHARE AND CONTRIBUTIONS
OF THE TOTAL OPEB LIABILITY
(Unaudited)
Schedule of Proportionate Share
New Hampshre Retirement System Medical Subsidy
Proportion Proportionate
of the Share of the Proportionate Share of the Plan Fiduciary Net Position
Fiscal Measurement Net OPEB Net OPEB Covered Net OPEB Liability as a Percentage of the Total
Year Date Liability Liability Payroll Percentage of Covered Payroll OPEB Liability
June 30,2021 June 30, 2020 5.35% $23.435,551 $146,299,488 16.02% 7TA%
June 30,2020 June 30, 2019 5.42% $23,774,444 $141,519,997 16.80% 7.73%
June 30,2019 June 30, 2018 5.51% $25,221,946 $139,528,277 18.08% 7.53%
June 30,2018 June 30, 2017 5.22% $23,859,048 128,054,908 18 63% 7U%
Schedule of Contributions
New Hampshire Retrement System Medal Subsidy
Contributions
Relative to
Contractualy Contractualy © Contibution Contributions as a
Fiscal Required Required Deficiency Cavered Percentage of
Year Contribution Contribution (Excess) Payroll Covered Payroll
June 30,2021 $ 2,631,411 $(2,631.411) § - $147, 787,954 1.78%
June 30,2020 = § 2,485,438 $ (2,485,438) § : $146,299,488 1.70%
June 30,2019 § 2,475,017 $(2,475,017) §$ - $141,519,997 1.75%
June 30,2018 § 2,436,719 $(2,436.719) § . $139,528,277 1.75%
Schedules are intended to show information for 10 years, Additional years will be displayed as they become available.
See notes to the City’s fmancial statements for summary’ of significant actuanal methods and assumptions.
See Independent Audaors’ Report.
CITY OF NASHUA, NEW HAMPSHIRE
OTHER POST-EMPLOYMENT BENEFITS (OPEB)
REQUIRED SUPPLEMENTARY INFORMATION
SCHEDULES OF CHANGES IN THE TOTAL OPEB LIABILITY
Total OPEB Liability
Service cost
Interest
Differences between expected and actual experience
Changes of assumptions
Benefit payments
Net change in total OPEB liability
Total OPEB liability - beginning,
Total OPEB liability - ending
(Unaudited)
City of Nashua OPEB Plan*
202) 2020 2019 2018
$ 3.169049 $$ 2.730.983 $ 2412885 $$ 2.526279
1,504,631 1,798,307 1,777,895 1,645,880
(4,278,544) (462,851) 1,068,607 (3,613,115)
2,181,485 2,780,057 1,506.786 1,309,808
(1,916,517) (1,985.541) (1,598,222) (1.978, 182)
660,104 4,860,955 5,167,951 (109,330)
54,347,990 49,487,035 44,319,084 44,428,414
$ 55,008,094 $ 54347990 $ 49,487,035 $44,319,084
* Does not include New Hampshire Retirement System Medical Subsidy.
Schedule is intended to show information for 10 years. Additional years will be displayed as they become available
See notes to the City's financial statements for summary of significant actuarial methods and assumptions.
See Independent Auditors’ Report.
161
Combining Financial Statements
162
NON-MAJOR GOVERNMENTAL FUNDS
SPECIAL REVENUE FUNDS
Special Revenue Funds are established to account for resources obtained and expended for
specified purposes and restricted by law or local action.
Special Revenue Funds are established for the following purposes:
r
Police Grants: to account for federal and State grants for the Police Department.
Fire Grants: to account for federal and State grants for the Fire Department.
Community Health and Services Grants: to account for federal and State health and human
services grants.
Parks and Recreation Grants: to account for federal and State parks and recreation grants.
Transit Grants: to account for federal and State transportation grants.
CDBG/Home Grants: to account for the Community Development Block and HOME grants.
Community Development Division Grants: to account for the federal and State grants for the
Community Development Department.
Other Public Safety Grants: to account for federal and state public safety grants.
Other City Grants: to account for all other City grants.
Food Services: to account for the School Department’s Food Service Program.
School Grants: to account for the School Department’s federal, state and local grants.
City Revolving Funds: to account for the City’s revolving funds.
School Revolving Funds: to account for the School Department’s revolving funds, other than
Food Service.
Other Trust Funds: to account for other City’s Trust Funds.
163