HomeMy WebLinkAbout2013 12 05 Regular 602 Actuarial Evaluation BOARD OF TRUSTEES
AGENDA ITEM
Informational
ITEM 602 Consent
Public Hearings
Regular X
December 5, 2013
Regular Meeting
REQUEST:
Actuarial Evaluation for 2012.
GRS Gabriel Roeder Smith & Company One Ease Rruward BEd 954.527.161E3 phone
C:nnsultants .a�tuanc'ti Suil'r-7[15 54..525.00 fa\
Ft, Lauderdale,FI..333f11-]5[]d sr11-\v.g411n-icirc) dcr-cnm
October 14, 2013
Mr. Shawn Boyle
Finance and Administrative Services Director
City of Winter Springs
1126 East State Road 434
Winter Springs,Florida 32708
Re: City of Winter Springs Defined Benefit Plan Actuarial Valuation
Dear Shawn:
As requested, we are pleased to enclose eleven (11) copies of the October 1, 2012
Actuarial Valuation Report for the City of Winter Springs Defined Benefit Plan.
We appreciate the opportunity to partner with the Board on this important project.
As you are aware, a copy of the Report should be filed with the State at the following
address upon approval by the Board.
Mr. Douglas E. Beckendorf, A.S.A. Ms. Sarah Can
Bureau of Local Retirement Services Office of Municipal Police Officers'
Division of Retirement &Firefighters'Pension Fund
Building 8 Building 8
Post Office Box 9000 Post Office Box 3010
Tallahassee, Florida 32315-9000 Tallahassee, Florida 32315-3010
If you should have any questions concerning the above, please do not hesitate to contact us.
Sincerest regards,
J
Lawrence F. Wilson, A.S.A.
Senior Consultant and Actuary
Enclosures
GRsGabriel Roeder Smith & Company
Consunan s na Actuaries
Alddet
4
ORS
CITY OF WINTER SPRINGS
DEFINED BENEFIT PLAN
ACTUARIAL VALUATION AS OF OCTOBER 1, 2012
This Valuation Determines the Annual Contribution for the Plan Year October 1,2013 through September 30,2014 to be
Paid in Plan Year October 1,2013 to September 30,2014
October 14,2013
Gabriel Roeder Smith & Company
City of Winter Springs
Defined Benefit Plan
TABLE OF CONTENTS
Page
Commentary 1
L Summary of Retirement Plan Costs 5
IL Comparison of Cost Data of Current and Prior Valuations 7
III. Characteristics of Participants in Actuarial Valuation 8
IV. Statement of Assets 9
V. Reconciliation of Plan Assets 10
VI. Actuarial Gains (Losses) 12
VII. Amortization of Unfunded Actuarial Accrued Liability 13
VIII. Accounting Disclosure Exhibit 14
IX. Outline of Principal Provisions of the Retirement Plan 19
X. Actuarial Assumptions and Actuarial Cost Methods Used 22
XI. Distribution of Plan Participants by Attained Age Groups and Service Groups 29
XII. Statistics for Participants Entitled to Deferred Benefits and Participants
Receiving Benefits 34
XIII. Reconciliation of Employee Data 35
XIV. Projected Retirement Benefits 36
XV. Recent Plan Experience 37
XVI. State Required Exhibit 39
Gabriel Roeder Smith & Company
GRS Gabriel Roeder Smith & Company Onc F:,ist Brow:1rd B[r[i. 9"i4.527.1616 phonc
C-nnsult jI1N:� .-1r[u:[nc•s Sulu:.Y[15 95 .�2.7.U[183 fax
FT. l.:nidcr[]alc.FL 33301-1804 %vwu•.gahriclrocdcr.coin
October 14, 2013
Board of Trustees
c/o Mr. Shawn Boyle
Finance and Administrative Services Director
City of Winter Springs Defined Benefit Plan
1126 East State Road 434
Winter Springs, Florida 32708
Dear Board Members:
October 1, 2012 Actuarial Valuation
We are pleased to present our October 1, 2012 Actuarial Valuation for the City of Winter Springs
Defined Benefit Plan (Plan). The purpose of this report is to indicate appropriate contribution
levels, comment on the actuarial stability of the Plan and to satisfy State requirements. The Board
of Trustees has retained Gabriel, Roeder, Smith and Company (GRS)to prepare an annual actuarial
valuation under Section 3.02 of the Plan.
This report consists of this commentary, detailed Tables I through XV and the State Required
Exhibit on Table XVI. The Tables contain basic Plan cost figures plus significant details on the
benefits, liabilities and experience of the Plan. We suggest you thoroughly review the report at
your convenience and contact us with any questions that may arise.
Retirement Plan Costs
Our Actuarial Valuation develops the required minimum Plan payment for the plan year beginning
October 1, 2013 under the Florida Protection of Public Employee Retirement Benefits Act. The
minimum payment consists of payment of annual normal costs including amortization of the
components of the unfunded actuarial accrued liability over various periods as prescribed by law.
The minimum payment is $2,885,395 (35.1%). The figure in parentheses is the Plan cost
expressed as a percentage of projected covered annual payroll for fiscal year beginning October 1,
2013 ($8,216,342).
This total cost is to be met by member, County and City contributions. We anticipate member
contributions will be $410,817 (5.0% of covered payroll for fiscal year ending September 30, 2014.
The resulting minimum required County and City contribution is $2,474,578 (30.1%).
We recommend the City contribute the dollar amount of required contribution due to the recent
closing of the Plan to future general employees.
Board of Trustees
October 14, 2013
Page 2
Changes in Actuarial Assumptions, Methods and Plan Provisions
The Plan provisions remain unchanged from our October 1, 2011 Actuarial Valuation. The Plan
provisions are outlined on Table IX.
The actuarial assumptions and methods also remain unchanged from our October 1, 2011 Actuarial
Valuation. The actuarial assumptions and methods are outlined on Table X.
Comparison of October 1, 2011 and October 1, 2012 Valuation Results
Table II of our report provides information of a comparative nature. The left columns of the Table
indicate the costs as calculated for October 1, 2011. The right columns indicate the costs as
calculated for October 1, 2012.
Comparing the left and right columns of Table II shows the effect of Plan experience during the
year. The number of active participants decreased by approximately 9%while covered payroll
decreased by approximately 7%. Total normal cost increased both as a percentage of covered
payroll and as a dollar amount. The unfunded actuarial accrued liability also increased both as a
percentage of covered payroll and as a dollar amount. Similarly, the net County and City minimum
funding requirement increased both as a percentage of covered payroll and as a dollar amount.
The value of vested accrued benefits exceeds Plan assets, resulting in a Vested Benefit Security
Ratio (VBSR) of 69.9%which is an increase from 61.6% as of the October 1, 2011 Actuarial
Valuation. The VB SR is measured on a market value of assets basis.
Plan Experience
The Plan experienced an actuarial loss in the amount of$1,066,905 this year. This indicates actual
overall Plan experience was less favorable than expected.
Table XV(salary, turnover and investment yield)provides figures on recent Plan experience.
Salary experience indicates actual salary increases averaged approximately -2.4% for General and
Forensic Employees and -6.5% for Firefighters and Police Officers for the Plan Year ended
September 30, 2012. Salary experience was generally an offsetting source of actuarial gain.
Employee turnover this year was 240% of the assumed turnover for General and Forensic
Employees and 240% of the assumed turnover for Firefighters and Police Officers. Employee
turnover was generally an offsetting source of actuarial gain.
The smoothed value investment return of 2.3%was less than the investment return assumption of
8.0%. Smoothed value investment return was a substantial source of actuarial loss during the year.
The three and five year average annual smoothed value investment returns are 3.8% and 5.0%
Gabriel Roeder Smith & Company
Board of Trustees
October 14, 2013
Page 3
respectively. The one, three and five year average annual market value returns are 19.5%, 9.8%
and 2.4%, respectively.
Member Census and Financial Data
The City submitted the Member census data used for this actuarial valuation to us as of October 1,
2012. This information contains name, Social Security number, date of birth, date of hire, October
1, 2012 rate of pay, actual salary paid and member contributions for the previous year. Dates of
termination and retirement are provided where applicable. The City updated information on
inactive participants including retirees, beneficiaries and vested terminees.
We used financial information concerning Plan assets as provided by the City as of September 30,
2012. We do not audit the Member census data and asset information that is provided to us.
However, we perform certain reasonableness checks and on this basis we believe that the
information that we received is reliable.
Summary
In our opinion the benefits provided for under the current Plan will be sufficiently funded through
the payment of the amount as indicated in this and future Actuarial Valuation reports. We will
continue to update you on the future payment requirements for the Plan through our actuarial
reports. These reports will also continue to monitor the future experience of the Plan.
Future actuarial measurements may differ significantly from the current measurements presented in
this report due to such factors as the following: Plan experience differing from that anticipated by
the economic or demographic assumptions; changes in economic or demographic assumptions;
increases or decreases expected as part of the natural operation of the methodology used for these
measurements (such as the end of an amortization period); and changes in Plan provisions or
applicable law. Due to the limited scope of the actuary's assignment, the actuary did not perform
an analysis of the potential range of such future measurements.
This report should not be relied on for any purpose other than the purpose described in the primary
communication. Determinations of the financial results associated with the benefits described in
this report in a manner other than the intended purpose may produce significantly different results.
This report has been prepared by actuaries who have substantial experience valuing public
employee retirement systems. To the best of our knowledge the information contained in this
report is accurate and fairly presents the actuarial position of the Plan as of the valuation date. All
calculations have been made in conformity with generally accepted actuarial principles and
practices, with the Actuarial Standards of Practice issued by the Actuarial Standards Board and
with applicable statutes.
Gabriel Roeder Smith & Company
Board of Trustees
October 14, 2013
Page 4
The signing actuaries are independent of the Plan sponsor.
The undersigned are Members of the American Academy of Actuaries and meet the qualification
standards of the American Academy of Actuaries to render the actuarial opinions contained in this
report. We are available to respond to any questions with regards to matters covered in this report.
Very truly yours,
Lawrence F. Wilson, A.S.A. Kelly L. Adams, A.S.A.
Senior Consultant and Actuary Consultant and Actuary
Gabriel Roeder Smith & Company
Table I
City of Winter Springs
Defined Benefit Plan
Summary of Retirement Plan Costs as of October 1, 2012
Cost % of
Data Payroll
A. Participant Data Summary (Table III)
1. Active Employees 169 N/A
2. Terminated Vested 125 N/A
3. Receiving Benefits (including DROPs) 72 N/A
4. Total Annual Payroll of Active Employees $ 8,216,342 100.0%
B. Total Normal Costs
1. Age Retirement Benefits $ 702,659 8.6%
2. Termination Benefits 213,339 2.6%
3. Death Benefits 28,397 0.3%
4. Disability Benefits 28,017 0.3%
5. Estimated Expenses 309,874 3.8%
6. Total Annual Normal Costs $ 1,282,286 15.6%
C. Total Actuarial Accrued Liability
1. Age Retirement Benefits Active Employees $ 19,766,237 240.6%
2. Termination Benefits Active Employees 379,925 4.6%
3. Death Benefits Active Employees 546,672 6.7%
4. Disability Benefits Active Employees 558,109 6.8%
5. Retired or Terminated Vested Participants
Receiving Benefits (including DROPs) 15,464,181 188.2%
6. Terminated Vested Participants Entitled to
Future Benefits 5,308,023 64.6%
7. Deceased Participants Whose Beneficiaries
are Receiving Benefits 1,719,207 20.9%
8. Disabled Participants Receiving Benefits 0 0.0%
9. Miscellaneous Liability (Refunds in Process) 17,104 0.2%
10. Total Actuarial Accrued Liability $ 43,759,458 532.6%
D. Assets (Table V)
1. Actuarial Value of Assets $ 26,852,721 326.8%
2. Market Value of Assets $ 27,039,803 329.1%
E. Unfunded Actuarial Accrued Liability
(C. -D.1.) $ 16,906,737 205.8%
-5-
Gabriel Roeder Smith & Company
Table I
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Summary of Retirement Plan Costs as of October 1, 2012
Cost % of
Data Payroll
F. Minimum Required Contribution
1. Total Normal Cost(including expenses) $ 1,282,286 15.6%
2. Amortization of Unfunded Liability 1,473,330 17.9%
3. Interest Adjustment 129,779 1.6%
4. Total Payment $ 2,885,395 35.1%
G. Expected payroll of active employees for 2013 /2014 year
(1.000 x $8,216,342) $ 8,216,342 100.0%
H. Contribution Sources (percent of expected 2013 /2014 payroll)
1. County and City $ 2,474,578 30.1%
2. Member 410,817 5.0%
3. Total required contribution $ 2,885,395 35.1%
I. Actuarial Gains (Losses) $ (1,066,905) (13.0%)
J. Actuarial Present Value of Vested Accrued Benefits
1. Retired, Terminated Vested, Beneficiaries
and Disabled Receiving Benefits (including DROPs) $ 17,183,388 209.1%
2. Terminated Vested Participants Entitled to
Future Benefits and Miscellaneous 5,325,127 64.8%
3. Active Participants Entitled to Future Benefits 16,161,027 196.7%
4. Total Actuarial Present Value of Vested
Accrued Benefits $ 38,669,542 470.6%
K. Unfunded Actuarial Present Value of Vested
Accrued Benefits (J. -D.2., not less than zero) $ 11,629,739 141.5%
L. Vested Benefit Security Ratio (D.2. ±J.) 69.9% N/A
-6-
Gabriel Roeder Smith & Company
Table II
City of Winter Springs
Defined Benefit Plan
Comparison of Cost Data of October 1,2011 and October 1,2012 Valuations
October 1,2011 October 1,2012
Cost %of Cost %of
Data Compensation Data Compensation
A. Participants
1. Active Employees 185 N/A 169 N/A
2. Terminated Vested 114 N/A 125 N/A
3. Receiving Benefits 64 N/A 72 N/A
4. Total Annual Payroll of Active Employees $ 8,875,836 100.0% $ 8,216,342 100.0%
B. Total Normal Costs $ 1,232,055 13.9% $ 1,282,286 15.6%
C. Actuarial Accrued Liability $ 41,567,399 468.3% $ 43,759,458 532.6%
D. Present Value of Future Benefits $ 50,495,131 568.9% $ 52,063,071 633.7%
E. Actuarial Value of Assets $ 25,932,292 292.2% $ 26,852,721 326.8%
F. Market Value of Assets $ 22,336,010 251.6% $ 27,039,803 329.1%
G. Unfunded Actuarial Accrued Liability $ 15,635,107 176.2% $ 16,906,737 205.8%
H. County and City Minimum Funding Payment $ 2,258,769 25.4% $ 2,474,578 30.1%
I. Vested Benefit Security Ratio 61.6% N/A 69.9% N/A
-7-
Gabriel Roeder Smith&Company
Table III
City of Winter Springs
Defined Benefit Plan
Characteristics of Participants in
Actuarial Valuation as of October 1, 2012
A. Active Plan Participants Summary
1. Active participants fully vested 117
2. Active participants partially vested 34
3. Active participants non-vested 18
4. Total active participants 169
5. Annual rate of pay of active participants $ 8,216,342
B. Retired and Terminated Vested Participant Summary
1. Retired or terminated vested participants receiving
benefits (including DROPs) 61
2. Terminated vested participants entitled to
future benefits 125
3. Deceased participants whose beneficiaries are
receiving benefits 11
4. Disabled participants receiving benefits 0
C. Projected Annual Retirement Benefits
1. Retired or terminated vested receiving benefits (including DROPs) $ 1,484,371
2. Terminated vested entitled to future benefits $ 1,100,457
3. Beneficiaries of deceased participants $ 165,687
4. Disabled participants $ 0
-8-
Gabriel Roeder Smith & Company
Table IV
City of Winter Springs
Defined Benefit Plan
Statement of Assets as of October 1, 2012
Assets Market Value
A. Cash and Cash Equivalents $ 435,973
B. General Investments
1. Common Stocks $ 18,034,152
2. Bonds 6,731,591
3. Real Estate 1,668,088
C. Receivables
1. Accrued Interest $ 0
2. Employee Contribution Receivable 13,909
3. City and County Contributions Receivable 156,090
4. Accounts Receivable 0
D. Payables
1. Accounts Payable $ 0
2. Due to Broker 0
E. Plan Assets
(A+B + C -D) $ 27,039,803
-9-
Gabriel Roeder Smith & Company
Table V
City of Winter Springs
Defined Benefit Plan
Reconciliation of Plan Assets
A. Total Market Value of Assets as of October 1, 2011 $ 22,336,010
B. Receipts During Period
1. Contributions
a. Member $ 418,635
b. City and County 1,824,431
c. Total $ 2,243,066
2. Investment Income
a. Interest and dividends $ 352,187
b. Unrealized gains/(losses) 4,025,166
c. Net investment income $ 4,377,353
3. Total receipts during period $ 6,620,419
C. Disbursements During Period
1. Pension payments and contribution refunds $ 1,606,752
2. Administrative expenses 309,874
3. Total disbursements during period $ 1,916,626
D. Total Market Value of Assets as of September 30, 2012 $ 27,039,803
-10-
Gabriel Roeder Smith & Company
Table V
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Development of Actuarial Value of Assets as of September 30
2011 2012 2013 2014 2015 2016
A. Preliminary total actuarial value from prior year $ 23,887,446 $ 25,932,292 $ 26,852,721
B. Market value beginning of year 21,017,997 22,336,010 27,039,803
C. Market value end of year 22,336,010 27,039,803
D. Non-investment net cash flow 1,542,241 326,440
E. Investment return (224,228) 4,377,353
F. Phased-in recognition of investment return:
1. Current year (393,471) 515,483
2. First prior year (251,629) (393,471) 515,483
3. Second prior year (191,179) (251,629) (393,471) 515,483
4. Third prior year (885,152) (191,179) (251,629) (393,471) 515,483
5. Fourth prior year 480,907 (885,153) (191,178) (251,628) (393,473) 515,483
6. Total phased-in recognition of investment return (1,240,524) (1,205,949) (320,795) (129,616) 122,010 515,483
G. Total actuarial value end of year
1. Preliminary total actuarial value end of year 25,932,292 26,852,721
2. Upper corridor limit:120%of C. 26,803,212 32,447,764
3. Lower corridor limit:80%of C. 17,868,808 21,631,842
4. Total actuarial value end of year:
G.1.,not more than G.2.,nor less than G.3. 25,932,292 26,852,721
H. Difference between total market value and total actuarial value (3,596,282) 187,082
I. Actuarial value rate of return 2.0% 2.3%
J. Market value rate of return (1.0%) 19.5%
-11-
Gabriel Roeder Smith&Company
Table VI
City of Winter Springs
Defined Benefit Plan
Actuarial Gains (Losses) for
Plan Year Ending September 30, 2012
A. Derivation of Actuarial Gain (Loss)
1. City and County net normal cost $ 788,263
2. Unfunded actuarial accrued liability 15,635,107
3. City and County contributions previous year 1,824,431
4. Interest on:
(a) City and County net normal cost $ 63,061
(b) Unfunded actuarial accrued liability 1,250,809
(c) City and County contributions 72,977
(d) Net total: (a) + (b) - (c) $ 1,240,893
5. Expected unfunded actuarial accrued liability current year:
(1. + 2. - 3. +4.) $ 15,839,832
6. Actual unfunded actuarial accrued liability current year 16,906,737
7. Actuarial gain (loss): (5. - 6.) $ (1,066,905)
B. Approximate Portion of Gain (Loss)
Due to Investments
1. Actuarial value of assets previous year $ 25,932,292
2. Contributions during period 2,243,066
3. Benefits and administrative expenses during period 1,916,626
4. Expected appreciation for period 2,087,641
5. Expected actuarial value of assets current year:
(1. + 2. - 3. +4.) $ 28,346,373
6. Actual actuarial value of assets current year $ 26,852,721
7. Approximate investment gain (loss): (6. - 5.) $ (1,493,652)
C. Approximate Portion of Gain (Loss)
Due to Liabilities: A. -B. $ 426,747
-12-
Gabriel Roeder Smith & Company
Table VII
City of Winter Springs
Defined Benefit Plan
Amortization of Unfunded Actuarial Accrued Liability
A. Unfunded Actuarial Accrued Liability
Unfunded Amortization
Date Liability Payment
October 1, 2012 $ 16,906,737 $ 1,473,330
October 1, 2013 $ 16,668,080 $ 1,473,330
October 1, 2014 $ 16,410,330 $ 1,473,330
October 1, 2015 $ 16,131,960 $ 1,473,330
October 1, 2016 $ 15,831,320 $ 1,473,330
October 1, 2042 $ 0 $ 0
B. Covered Payroll History*
Covered Annual
Date Payroll Increase
October 1, 2012 $ 8,216,342 (7.4%)
October 1, 2011 $ 8,875,836 (13.9%)
October 1, 2010 $ 10,304,054 (4.2%)
October 1, 2009 $ 10,752,720 (0.1%)
October 1, 2008 $ 10,767,596 (3.8%)
October 1, 2007 $ 11,190,013 6.7%
October 1, 2006 $ 10,489,087 8.6%
October 1, 2005 $ 9,659,446 7.5%
October 1, 2004 $ 8,982,189 11.0%
October 1, 2003 $ 8,094,829 22.9%
October 1, 2002 $ 6,586,077 N/A
Ten-Year Average Annual Increase 2.2%
* Information prior to October 1, 2008 as reported by prior actuary.
-13-
Gabriel Roeder Smith & Company
Table VIII
City of Winter Springs
Defined Benefit Plan
Accounting Disclosure Exhibit
10/01/2011 10/01/2012
I. Number of Plan Members
a. Retirees and beneficiaries receiving benefits 64 72
b. Terminated plan members entitled to but not yet receiving benefits 114 125
c. Active plan members 185 169
d. Total 363 366
II. Financial Accounting Standards Board Allocation as of October 1, 2012
A. Statement of Accumulated Plan Benefits
1. Actuarial present value of accumulated vested plan benefits
a. Participants currently receiving benefits $ 15,498,049 $ 17,183,388
b. Other participants 20,736,588 21,486,154
c. Total $ 36,234,637 $ 38,669,542
2. Actuarial present value of accumulated
non-vested plan benefits $ 723,879 $ 649,175
3. Total actuarial present value of accumulated plan benefits $ 36,958,516 $ 39,318,717
B. Statement of Change in Accumulated Plan Benefits
1. Actuarial present value of accumulated plan benefits
as of October 1, 2011 $ 36,958,516
2. Increase (decrease) during year attributable to:
a. Plan amendment $ 0
b. Change in actuarial assumptions 0
c. Benefits paid including refunds (1,606,752)
d. Other, including benefits accumulated, increase
for interest due to decrease in the discount period 3,966,953
e. Net increase $ 2,360,201
3. Actuarial present value of accumulated plan benefits
as of October 1, 2012 $ 39,318,717
C. Significant Matters Affecting Calculations
1. Assumed rate of return used in determining actuarial present values 8.0%
2. Change in plan provisions None.
3. Change in actuarial assumptions None.
-14-
Gabriel Roeder Smith & Company
Table VIII
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Accounting Disclosure Exhibit
III. Financial Accounting Standards Board Allocation -Florida Statute Chapter 2011-216 Compliance
As of October 1, 2012
F.S., Chapter, 2011-216 effective July 1, 2011 mandates each plan report the plan's present value of accrued
vested, non-vested and total benefits, as adopted by the Financial Accounting Standards Board, using the
Florida Retirement System's assumed rate of return (currently 7.75%) in order to promote the comparability
of actuarial data between local plans.
10/01/2011 10/01/2012
A. Statement of Accumulated Plan Benefits
1. Actuarial present value of accumulated vested
plan benefits
a. Participants currently receiving benefits $ 16,155,049 $ 17,903,964
b. Other participants 22,409,915 23,198,682
c. Total $ 38,564,964 $ 41,102,646
2. Actuarial present value of accumulated non-vested
plan benefits $ 788,028 $ 704,896
3. Total actuarial present value of accumulated plan
benefits $ 39,352,992 $ 41,807,542
B. Significant Matters Affecting Calculations
1. Assumed rate of return used in determining actuarial present values 7.75%
2. Change in plan provisions N/A
3. Change in actuarial assumptions N/A
-15-
Gabriel Roeder Smith & Company
Table VIII
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Accounting Disclosure Exhibit
W. Notes to Required Supplementary Information (As required by GASB No.25)
Actuarial valuation date October 1, 2012
Contributions made To be determined
Actuarial cost method Entry Age Normal
Amortization method Level percent, closed
Remaining amortization period 25 years
Asset valuation method 5 year smoothed market
Actuarial assumptions:
Investment rate of return * 8.0%
Projected salary increases * 3.0% - 7.5%
* Includes expected inflation at 3.0%
-16-
Gabriel Roeder Smith & Company
Table VIII
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Accounting Disclosure Exhibit
V. Historical Trend Information
A. Schedule of Employer Costs (GASB No. 25)*
Fiscal Year Annual Required Percentage of
Ended Contribution (ARC) ARC Contributed
09/30/2007 $ 1,807,722 102%
09/30/2008 $ 2,005,100 100%
09/30/2009 $ 1,781,651 100%
09/30/2010 $ 2,311,058 100%
09/30/2011 $ 2,627,659 101%
09/30/2012 $ 1,965,643 97%
B. Schedule of Employer Costs (GASB No. 27)*
Fiscal Year Annual Pension Percentage of Net Pension
Ended Cost(APC) APC Contributed Obligation/(Asset)
09/30/2007 $ 1,810,230 102% $ (1,563)
09/30/2008 $ 2,004,975 100% $ (5,673)
09/30/2009 $ 1,781,197 100% $ (5,673)
09/30/2010 $ 2,331,410 99% $ 14,679
09/30/2011 $ 2,627,713 101% $ (17,878)
09/30/2012 $ 1,965,697 97% $ 34,102
VI. Annual Pension Cost and Net Pension Asset
Projected
Fiscal Year Ended 9/30/2012* 9/30/2013
Annual Required Contribution (ARC) $ 1,965,643 $ 2,258,769
Interest on Net Pension Asset(NPA) (450) (1,430)
Adjustment to ARC 504 (3,029)
APC $ 1,965,697 $ 2,254,310
City Contributions $ (1,913,717)
(Increase)Decrease in NPA $ 51,980
NPA(beginning of year) (17,878)
NPA(end of year) $ 34,102
* As reported in the Comprehensive Annual Financial Report (CAFR)
-17-
Gabriel Roeder Smith & Company
Table VIII
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Schedule of Funding Progress
(Dollar Amounts in Thousands)
VII. Schedule of Funding Progressl
Actuarial Accrued Unfunded UAAL as a
Actuarial Liability(EAN2) AAL Funded Percentage of
Actuarial Value of Assets (AAL) (UAAL) Ratio Payroll Payroll
Valuation Date (a) (b) (b-a) (a/b) (c) ((b-a)/c)
10/01/2007 $ 15,527 $ 20,114 $ 4,587 77.2% $ 11,190 41.0%
10/01/2008 $ 18,747 $ 32,414 $ 13,667 57.8% $ 10,768 126.9%
10/01/2009 $ 20,789 $ 37,651 $ 16,862 55.2% $ 10,753 156.8%
10/01/2010 3 $ 23,887 $ 40,331 $ 16,444 59.2% $ 10,304 159.6%
10/01/2010 4 $ 23,887 $ 37,307 $ 13,420 64.0% $ 10,304 130.2%
10/01/2011 $ 25,932 $ 41,567 $ 15,635 62.4% $ 8,876 176.1%
10/01/2012 $ 26,853 $ 43,759 $ 16,906 61.4% $ 8,216 205.8%
1 Information prior to October 1,2008 as reported by prior actuary.
2 Frozen Initial Liability prior to change in method as of October 1,2008.
3 Actuarial Valuation as of October 1,2010.
4 Actuarial Impact Statement as of October 1,2010.
-18-
Gabriel Roeder Smith&Company
Table IX
City of Winter Springs
Defined Benefit Plan
Outline of Principal Provisions of the Retirement Plan
A. Effective Date
Plan adopted as a Money Purchase Floor Offset plan on October 1, 1997. Plan amended and
restated as a Defined Benefit Plan effective October 1, 2000. Plan most recently amended by
Resolution 2011-57 adopted December 12, 2011.
B. Eligibility Requirements
General Employees hired prior to October 1, 2011, Police Officers and Forensic Professionals
working 30 or more hours per week are eligible to join the Plan on the first day of the month
following completion of six (6) months of service. Electing transferring Firefighters as of October
2, 2008 under the Agreement with the County.
C. Accrual Service
Years of Accrual Service are any Plan Years during which an Employee completes at least 1,000
hours of service, including years of service completed prior to participation in the Plan.
D. Compensation
Wages, salaries and other amounts received (whether or not paid in cash) for personal services
actually rendered in the course of employment. Effective October 10, 2011 Compensation shall
exclude commissions, bonuses, overtime pay in excess of one hundred fifty (150) hours per Plan
year and payments for accrued leave in excess of the dollar amount of an Employee's accrued leave
balance on July 1, 2011.
E. Final Average Compensation
Average earnings during the best five (5) consecutive years out of the last ten (10) years preceding
termination or retirement, but not less than the three (3) highest consecutive compensation periods
during employment with the City as of September 30, 2011.
F. Normal Retirement
1. Eligibility:
(a) Attainment of age 65; or
(b) Completion of 30 years of service and determined to be disabled under the City's long term
disability insurance policy.
-19-
Gabriel Roeder Smith & Company
Table IX
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Outline of Principal Provisions of the Retirement Plan
2. Benefit:
For Firefighters, Police Officers and Forensic Professionals, 3.00% times Final Average
Compensation multiplied by Accrual Service, up to a maximum of 30 years.
For General Employees, 3.00% times Accrual Service earned through September 30, 2011
times Final Average Compensation plus 2.50% times Accrual Service earned after September
30, 2011 times Final Average Compensation, up to a maximum of 30 years of Accrual Service.
G. Early Retirement
1. Eligibility:
(a) Attainment of age 55 and completion of 15 years of service; or
(b) Completion of 25 years of service.
2. Benefit:
Benefit accrued to date of early retirement, actuarially reduced for each year early retirement
benefit commencement precedes age 55.
H. Late Retirement
1. Eligibility:
Continued employment beyond Normal Retirement Date.
2. Benefit:
Greater of(a) and (b):
(a) Accrued benefit calculated as for Normal Retirement based upon service and pay at Late
Retirement Date.
(b) Actuarially increased benefit as of Late Retirement Date.
I. Disability Retirement
1. Eligibility:
Completion of 30 years of service and determined to be disabled under the City's long term
disability insurance policy.
2. Benefit:
Accrued benefit calculated as for Normal Retirement based upon service and pay at Disability
Retirement Date.
-20-
Gabriel Roeder Smith & Company
Table IX
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Outline of Principal Provisions of the Retirement Plan
J. Death Benefit
Beneficiary entitled to a monthly benefit supported by the present value of the non-forfeitable
accrued benefit at the time of the participant's death. If death occurs after actual retirement, the
beneficiary receives whatever is payable under the form of benefit option elected.
K. Participant Contributions
Five percent(5%) of compensation for all employees.
L. Vested Benefit Upon Termination
100% vested in required participant contributions. Participant contributions made after October 1,
2000 are included in the deferred vested benefit payable at normal or early retirement date.
Upon termination of service prior to normal or early retirement date a participant shall be entitled
to a benefit payable at normal or early retirement date calculated as for normal retirement. Based
on pay and service at date of termination multiplied by a percentage from the following table.
Years of Service Vested Percentage
Less Than 7 0%
7 or More 100%
M. Normal Form of Payment of Retirement Income
Monthly benefit payable for life.
Other Options
Actuarially equivalent joint and survivor at 50%, 75%, 100%; or ten (10)years certain and life.
N. Changes Since Previous Valuation
None.
-21-
Gabriel Roeder Smith & Company
Table X
City of Winter Springs
Defined Benefit Plan
Actuarial Assumptions and Actuarial Cost Methods
Used in the Valuation
A. Mortality
For healthy General Employee participants, the RP-2000 Combined Mortality Table was used with
separate rates for males and females and fully generational mortality improvements projected to each
future decrement date.
For healthy Firefighter and Police Officer participants, the RP-2000 Combined Mortality Table with
Blue Collar Adjustment was used with separate rates for males and females and fully generational
mortality improvements projected to each future decrement date.
For disabled participants, the RP-2000 Combined Disabled Mortality Table was used with separate rates
for males and females and fully generational mortality improvements projected to each future decrement
date.
B. Investment Return
8.0%, compounded annually, net of investment expenses.
C. Allowances for Expenses or Contingencies
Prior year's actual administrative expenses are included in normal cost.
D. Salary Increase Factors
Current salary is assumed to increase at a rate based on the table below per year until retirement.
General Firefighters and
Service Employees Police Officers
Less than 5 years 6.5% 7.5%
5 - 9years 5.5% 5.5%
10 - 14 years 4.5% 5.5%
15+years 3.0% 3.5%
-22-
Gabriel Roeder Smith & Company
Table X
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Actuarial Assumptions and Actuarial Cost Methods
Used in the Valuation
E. Employee Withdrawal Rates
1. Withdrawal rates for male General Employees were used in accordance with the following illustrative example:
Withdrawal Rates per 100 Employees■
Service
Age 0 1 2 3 4 5 6 7 8 9 10+
20 32.8 25.4 22.7 18.4 15.8 11.7 11.1 11.1 11.0 10.0 9.8
25 27.2 18.5 17.2 14.6 12.7 9.7 8.5 8.4 7.7 6.3 6.2
30 25.8 15.4 14.0 13.2 11.8 8.8 7.8 7.1 6.4 5.5 4.7
35 2.5.8 14.3 12.8 12.6 10.9 8.5 7.5 6.8 6.2 5.3 4.2
40 24.4 12.6 12.0 10.7 9.0 7.4 6.7 6.2 5.8 5.3 3.0
45 24.4 12.5 11.6 10.3 8.8 6.8 6.5 6.0 5.1 5.1 2.7
50 23.4 12.2 10.7 9.4 7.9 6.0 5.5 5.3 4.6 4.6 3.0
55 27.4 12.2 10.7 9.3 7.8 6.8 5.4 5.2 4.4 4.3 4.5
60 27.4 12.2 10.7 9.3 7.8 6.8 5.4 5.1 4.3 4.2 5.3
65 27.4 12.2 10.7 9.3 7.8 6.8 5.4 5.1 4.3 4.2 3.7
2. Withdrawal rates for female General Employees were used in accordance with the following illustrative example:
Withdrawal Rates per I00 Employees
Service
Age 0 1 2 3 4 5 6 7 8 9 10+
20 30.3 25.8 22.1 17.4 15.4 13.5 11.4 11.3 10.5 10.2 11.6
25 26.6 19.8 17.1 13.0 12.9 10.7 9.7 9.2 7.8 7.1 5.3
30 25.4 16.9 14.5 11.6 11.3 9.4 8.7 8.1 7.1 6.5 5.4
35 25.4 15.9 13.5 11.2 10.9 9.0 8.0 7.8 6.8 6.2 4.6
40 24.4 14.0 12.1 10.0 9.1 7.0 6.5 6.3 6.1 5.0 3.3
45 24.4 13.9 11.9 9.8 8.8 6.7 6.5 6.1 5.8 4.7 3.0
50 23.2 13.4 11.0 8.8 8.4 6.2 5.9 5.5 5.5 4.6 3.0
55 23.2 13.4 11.0 8.7 8.3 6.1 5.8 5.4 5.4 4.5 3.0
60 23.2 13.4 11.0 8.7 8.3 6.1 5.8 5.4 5.4 4.5 3.0
65 23.2 13.4 11.0 8.7 8.3 6.1 5.8 5.4 5.4 4.5 3.0
The withdrawal assumptions are the withdrawal assumptions used in the July 1, 2012 Florida Retirement System (FRS) Actuarial
Valuation.
-23-
Gabriel Roeder Smith & Company
Table X
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Actuarial Assumptions and Actuarial Cost Methods
Used in the Valuation
E. Employee Withdrawal Rates (continued)
3. Withdrawal rates for male Firefighters and Police Officers were used in accordance with the following illustrative example:
Withdrawal Rates per 100 Employees■
Service
Age 0 1 2 3 4 5 6 7 8 9 10+
20 21.4 10.3 8.6 8.4 7.5 5.3 5.2 3.1 2.9 2.6 2.3
25 20.6 9.8 8.1 7.9 7.0 5.3 5.2 3.1 2.9 2.6 2.3
30 20.6 9.5 7.7 7.5 6.7 5.3 5.2 3.1 2.9 2.6 2.1
35 20.6 8.8 7.4 7.2 6.5 5.3 5.1 3.1 2.9 2.6 2.0
40 20.6 8.0 6.8 6.7 6.0 4.8 4.6 3.1 2.9 2.6 1.9
45 20.6 7.3 6.0 6.0 5.5 4.3 4.1 3.1 2.9 2.6 1.8
50 20.6 6.5 5.3 5.3 5.0 3.8 3.6 3.1 2.9 2.6 1.8
55 20.6 5.8 4.7 4.7 4.6 3.3 3.2 3.1 2.9 2.6 1.8
60 20.6 5.3 4.7 4.7 4.6 3.3 3.2 3.1 2.9 2.6 1.8
65 20.6 5.3 4.7 4.7 4.6 3.3 3.2 3.1 2.9 2.6 1.8
4. Withdrawal rates for female Firefighters and Police Officers were used in accordance with the following illustrative example:
Withdrawal Rates per I00 Employees
Service
Age 0 1 2 3 4 5 6 7 8 9 10+
20 21.3 15.5 12.3 10.3 9.7 6.1 5.9 5.0 4.2 4.2 1.9
25 21.3 14.2 11.6 9.8 9.2 6.1 5.9 5.0 4.2 4.2 1.9
30 21.3 13.2 10.6 9.3 8.7 6.1 5.9 5.0 4.2 4.2 1.7
35 21.3 12.2 9.6 8.8 8.4 6.1 5.9 5.0 4.2 4.1 1.5
40 21.3 11.2 8.6 8.3 7.6 6.1 5.9 5.0 4.1 4.1 2.5
45 21.3 10.2 7.6 7.6 7.0 6.1 5.9 5.0 4.1 4.1 2.5
50 21.3 9.2 6.6 6.6 6.4 6.1 5.9 5.0 4.1 4.0 1.6
55 21.3 8.4 5.8 5.6 5.4 5.3 5.1 5.0 4.1 4.0 4.0
60 21.3 8.4 5.8 5.6 5.4 5.3 5.1 5.0 4.1 4.0 4.0
65 21.3 8.4 5.8 5.6 5.4 5.3 5.1 5.0 4.1 4.0 4.0
The withdrawal assumptions are the withdrawal assumptions used in the July 1, 2012 FRS Actuarial Valuation.
-24-
Gabriel Roeder Smith & Company
Table X
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Actuarial Assumptions and Actuarial Cost Methods
Used in the Valuation
F. Disability Rates
1. Line-of-duty disability rates for General Employees were used in accordance with the following
illustrative example.
Age Male Female
20 0.002% 0.000%
25 0.002% 0.001%
30 0.003% 0.001%
35 0.005% 0.003%
40 0.009% 0.005%
45 0.014% 0.008%
50 0.022% 0.010%
55 0.034% 0.016%
60 0.048% 0.022%
65 0.050% 0.020%
2. Non-duty disability rates for General Employees were used in accordance with the following illustrative
example.
Age Male Female
20 0.000% 0.000%
25 0.027% 0.010%
30 0.053% 0.026%
35 0.066% 0.049%
40 0.092% 0.070%
45 0.122% 0.114%
50 0.203% 0.184%
55 0.339% 0.294%
60 0.445% 0.419%
65 0.215% 0.105%
The disability assumptions are the disability assumptions used in the July 1, 2012 FRS Actuarial Valuation.
-25-
Gabriel Roeder Smith & Company
Table X
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Actuarial Assumptions and Actuarial Cost Methods
Used in the Valuation
F. Disability Rates (continued)
3. Line-of-duty disability rates for Firefighters and Police Officers were used in accordance with the
following illustrative example.
Age Male Female
20 0.012% 0.008%
25 0.012% 0.008%
30 0.017% 0.016%
35 0.029% 0.037%
40 0.051% 0.068%
45 0.087% 0.106%
50 0.138% 0.153%
55 0.215% 0.152%
60 0.301% 0.151%
65 0.231% 0.143%
4. Non-duty disability rates for Firefighters and Police Officers were used in accordance with the following
illustrative example.
Age Male Female
20 0.037% 0.036%
25 0.037% 0.036%
30 0.043% 0.046%
35 0.055% 0.075%
40 0.087% 0.118%
45 0.140% 0.209%
50 0.292% 0.254%
55 0.244% 0.328%
60 0.206% 0.328%
65 0206% 0.328%
The disability assumptions are the disability assumptions used in the July 1, 2012 FRS Actuarial Valuation.
-26-
Gabriel Roeder Smith & Company
Table X
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Actuarial Assumptions and Actuarial Cost Methods
Used in the Valuation
G. Assumed Retirement Age
Retirement rates were used in accordance with the following tables.
1. For Police Officers and Firefighters:
Years of Service
Age_ 0 - 10 10 - 15 15 - 25 25 -30 30 or more
Under 55 0% 0% 0% 4% 5%
55 0% 10% 15% 40% 50%
56 - 64 0% 10% 15% 15% 20%
65 and above 100% 100% 100% 100% 100%
2. For General Employees:
Years of Service
Age 0 - 10 10 - 15 15 - 25 25 -30 30 or more
Under 55 0% 0% 0% 2% 2%
55 0% 5% 10% 20% 25%
56 - 64 0% 5% 10% 4% 5%
65 and above 100% 100% 100% 100% 100%
H. Marital Assumptions
1. 100% of active members are assumed to be married.
2. Females are assumed to be three (3)years younger than their male spouses.
I. Interest on Future Participant Contributions
3.75%, compounded annually.
-27-
Gabriel Roeder Smith & Company
Table X
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Actuarial Assumptions and Actuarial Cost Methods
Used in the Valuation
J. Asset Valuation Method
The method used for determining the actuarial value of assets phases in the deviation between the
expected and actual return on assets at the rate of 20% per year. The actuarial value of assets will be
further adjusted to the extent necessary to fall within the corridor whose lower limit is 80% of the fair
market value of plan assets and whose upper limit is 120% of the fair market value of plan assets -
adjusted for equation of balance October 1, 2010.
K. Cost Method
Normal Retirement, Termination, Disability, and Death Benefits: Entry Age Normal Cost Method
Under this method the normal cost for each active employee is the amount which is calculated to be a
level percentage of pay that would be required annually from his entry age to his assumed retirement
age to fund his estimated benefits, assuming the Fund had always been in effect. The normal cost for
the Fund is the sum of such amounts for all employees. The actuarial accrued liability as of any
valuation date for each active employee or inactive employee who is eligible to receive benefits under
the Fund is the excess of the actuarial present value of estimated future benefits over the actuarial
present value of current and future normal costs. The unfunded actuarial accrued liability as of any
valuation date is the excess of the actuarial accrued liability over the assets of the Fund.
L. Changes Since Previous Valuation
None.
-28-
Gabriel Roeder Smith & Company
Table XI
City of Winter Springs
Defined Benefit Plan
Distribution by Attained Age Groups
and Service Groups as of October 1,2012
Firefighters
Attained COMPLETED YEARS OF SERVICE
Age Group 0-4 5-9 10-14 15-19 20-24 25-29 30&Over Total
Under 25 - - - - - - - 0
25-29 - - - - - - - 0
30-34 - - - - - - - 0
35-39 - - - - - - - 0
40-44 - - - - - - - 0
45-49 - - - - 4 1 - 5
50-54 - - - 1 3 2 1 7
55-59 - - - - - - - 0
60-64 - - - - - - - 0
65&Over - - - - - - - 0
TOTAL 0 0 0 1 7 3 1 12
10/01/2011 10/01/2012
Average Attained Age 49.90 years 50.68 years
Average Hire Age 26.90 years 27.18 years
Average Pay $ 63,880 $ 69,034
Percent Female 0.0% 0.0%
-29-
Gabriel Roeder Smith Sc Company
Table XI
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Distribution by Attained Age Groups
and Service Groups as of October 1,2012
General Employees
Attained COMPLETED YEARS OF SERVICE
Age Group 00=4 5-9 10-14 15-19 20-24 25-29 30&Over Total
Under 25 2 - - - - - - 2
25-29 5 3 - - - - - 8
30-34 6 2 3 - - - - 11
35-39 - 7 2 3 - - - 12
40-44 1 4 2 1 1 - - 9
45-49 2 4 1 1 - 1 - 9
50-54 2 6 3 3 4 1 - 19
55-59 - 5 - 3 3 2 - 13
60-64 - 2 4 - - 1 - 7
65&Over - - 1 - 1 - - 2
TOTAL 18 33 16 11 9 5 0 92
10/01/2011 10/01/2012
Average Attained Age 45.65 years 45.62 years
Average Hire Age 36.28 years 35.04 years
Average Pay $ 42,923 $ 43,465
Percent Female 33.3% 33.7%
-30-
Gabriel Roeder Smith Sc Company
Table XI
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Distribution by Attained Age Groups
and Service Groups as of October 1,2012
Police Officers
Attained COMPLETED YEARS OF SERVICE
Age Group 00=4 5-9 10-14 15-19 20-24 25-29 30&Over Total
Under 25 2 1 - - - - - 3
25-29 7 2 - - - - - 9
30-34 1 7 2 - - - - 10
35-39 1 5 4 3 - - - 13
40-44 - 4 3 3 3 - - 13
45-49 1 - 3 2 2 - - 8
50-54 1 - 1 - - 3 - 5
55-59 1 1 - - - - - 2
60-64 - - - - - - - 0
65&Over - - - - - - - 0
TOTAL 14 20 13 8 5 3 0 63
10/01/2011 10/01/2012
Average Attained Age 38.07 years 38.59 years
Average Hire Age 27.95 years 28.22 years
Average Pay $ 53,396 $ 52,561
Percent Female 15.0% 12.7%
-31-
Gabriel Roeder Smith Sc Company
Table XI
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Distribution by Attained Age Groups
and Service Groups as of October 1,2012
Forensic Professionals
Attained COMPLETED YEARS OF SERVICE
Age Group 00=4 5-9 10-14 15-19 20-24 25-29 30&Over Total
Under 25 - - - - - - - 0
25-29 - 1 - - - - - 1
30-34 - - - - - - - 0
35-39 - - - 1 - - - 1
40-44 - - - - - - - 0
45-49 - - - - - - - 0
50-54 - - - - - - - 0
55-59 - - - - - - - 0
60-64 - - - - - - - 0
65&Over - - - - - - - 0
TOTAL 0 1 0 1 0 0 0 2
10/01/2011 10/01/2012
Average Attained Age 30.48 years 31.48 years
Average Hire Age 19.48 years 19.48 years
Average Pay $ 39,094 $ 38,874
Percent Female 100.0% 100.0%
-32-
Gabriel Roeder Smith Sc Company
Table XI
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Distribution by Attained Age Groups
and Service Groups as of October 1,2012
All Members
Attained COMPLETED YEARS OF SERVICE
Age Group 00=4 5-9 10-14 15-19 20-24 25-29 30&Over Total
Under 25 4 1 - - - - - 5
25-29 12 6 - - - - - 18
30-34 7 9 5 - - - - 21
35-39 1 12 6 7 - - - 26
40-44 1 8 5 4 4 - - 22
45-49 3 4 4 3 6 2 - 22
50-54 3 6 4 4 7 6 1 31
55-59 1 6 - 3 3 2 - 15
60-64 - 2 4 - - 1 - 7
65&Over - - 1 - 1 - - 2
TOTAL 32 54 29 21 21 11 1 169
10/01/2011 10/01/2012
Average Attained Age 43.37 years 43.19 years
Average Hire Age 32.63 years 31.75 years
Average Pay $ 47,977 $ 48,617
Percent Female 25.4% 24.3%
-33-
Gabriel Roeder Smith Sc Company
Table XII
City of Winter Springs
Defined Benefit Plan
Statistics for Participants Entitled to Deferred Benefits
and Participants Receiving Benefits
A. Entitled to Deferred Benefits
Current Age Total Average
Group Count Annual Benefit Annual Benefit
Less than 40 31 $ 203,516 $ 6,565
40-44 27 263,978 9,777
45-49 31 355,312 11,462
50-54 20 200,554 10,028
55-59 8 45,600 5,700
60-64 5 26,322 5,264
65 & Over 3 5,175 1,725
TOTAL 125 $ 1,100,457 $ 8,804
B. Receiving Benefits
Current Age Total Average
Group Count Annual Benefit Annual Benefit
Less than 50 3 $ 24,124 $ 8,041
50-54 1 69,549 69,549
55-59 18 663,625 36,868
60-64 19 432,786 22,778
65-69 16 292,135 18,258
70-74 11 150,068 13,643
75 & Over 4 17,771 4,443
TOTAL 72 $ 1,650,058 $ 22,917
-34-
Gabriel Roeder Smith & Company
Table XIII
City of Winter Springs
Defined Benefit Plan
Reconciliation of Employee Data
A. Active Participants
1. Active participants previous year 185
2. Retired during year (6)
3. Died during year 0
4. Disabled during year 0
5. Terminated non-vested during year (4)
6. Terminated vested during year (17)
7. New active participants 11
8. Out on military leave 0
9. Rehired during year 2
10. Transferred to DC Plan (2)
11. Active participants current year 169
B. Participants Receiving Benefits
1. Participants receiving benefits previous year 64
2. New retired participants 6
3. New DRO recipient 0
4. New terminated vested receiving benefits 2
5. New beneficiaries receiving benefits 1
6. Died or ceased payment during year (1)
7. Retired or terminated vested receiving benefits current year 72
C. Terminated Vested Participants Entitled to Future Benefits
1. Terminated vested entitled previous year 114
2. Died during year 0
3. Commenced receiving benefits during year (2)
4. New terminated vested 16
5. Terminated vested paid lump sum (1)
6. Rehired (2)
7. Terminated vested entitled current year 125
-35-
Gabriel Roeder Smith & Company
Table XIV
City of Winter Springs
Defined Benefit Plan
Projected Retirement Benefits
Projected Total
Fiscal Year Annual Payout
2013 $ 1,817,364
2014 $ 2,027,095
2015 $ 2,196,001
2016 $ 2,373,066
2017 $ 2,578,747
2018 $ 2,810,758
2019 $ 3,124,999
2020 $ 3,320,732
2021 $ 3,544,425
2022 $ 3,970,096
The above projected payout of Plan benefits during the next ten years is based on assumptions
involving all decrements. Actual payouts may differ from the above estimates depending upon the
death, salary and retirement experience of the Plan. However, since the projected payment is
recomputed each valuation date, there is an automatic correction to the extent that actual experience
varies from expected experience.
-36-
Gabriel Roeder Smith & Company
Table XV
City of Winter Springs
Defined Benefit Plan
Summary of Transaction Information'
Year Benefits Administrative Employee City/County Actuarial
Ending Paid Expenses Contributions Contributions3 Value
09/30/2012 $ 1,606,752 $ 309,874 $ 418,635 $ 1,824,431 $ 26,852,721
09/30/2011 1,165,350 196,423 287,090 2,616,924 25,932,292
09/30/2010 886,521 178,530 284,866 2,311,058 23,887,446
09/30/2009 617,274 116,982 306,420 1,781,197 20,788,655
09/30/2008 384,482 70,423 365,288 1,663,951 18,746,975
09/30/2007 233,953 123,197 N/A 1,843,147 15,526,572
09/30/2006 171,697 84,340 N/A 1,505,020 11,951,383
09/30/2005 N/A N/A N/A 1,260,627 9,716,089
09/30/2004 140,509 62,225 N/A 1,013,379 8,134,588
09/30/2003 138,353 47,477 N/A 903,748 7,279,048
1 Information prior to September 30,2008 as reported by prior actuary.
2 Includes refunds.
3 Values prior to September 30,2008 include Employee Contributions.
-37-
+Gabriel Roeder Smith&Company
Table XV
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Recent Compensation,Termination and Investment Return Experience
General&Forensic Police&Fire General&Forensic Police&Fire
Compensation Termination Investment Return
Valuation %Increase/(Decrease) Ratio of Actual Net Market Net Actuarial Assumed Rate
Date Actual Assumed Actual Assumed to Expected Value Yield* Value Yield* of Return*
10/01/2012 (2.4%) 4.8% (6.5%) 5.0% 2.4 2.4 19.5% 2.3% 8.0%
10/01/2011 4.9% 4.8% 3.5% 5.2% 1.9 2.4 (1.0%) 2.0% 8.0%
10/01/2010 0.9% 5.0% 2.8% 5.3% 1.2 1.7 12.0% 7.3% 8.0%
10/01/2009 6.4% 5.1% 11.6% 5.3% 1.1 1.1 2.1% 3.5% 8.0%
10/01/2008 3.9% 3.0% 5.6% 3.0% 1.2 3.1 (16.8%) 10.1% 8.0%
10/01/2007 N/A N/A N/A N/A N/A N/A 13.8% 15.4% 8.0%
10/01/2006 N/A N/A N/A N/A N/A N/A 8.6% 9.5% 8.0%
10/01/2005 N/A N/A N/A N/A N/A N/A 11.5% 4.2% 8.0%
10/01/2004 N/A N/A N/A N/A N/A N/A 12.6% 0.6% 8.0%
Last3 Years 1.1% 4.9% (0.2%) 5.2% 1.8 2.1 9.8% 3.8% 8.0%
Last 5 Years 2.7% 4.5% 3.2% 4.8% 1.5 2.0 2.4% 5.0% 8.0%
Last 9 Years N/A N/A N/A N/A N/A N/A 6.4% 6.0% 8.0%
*Information prior to October 1,2008 as reported by prior actuary.
-38-
Gabriel Roeder Smith E Company
Table XVI
City of Winter Springs
Defined Benefit Plan
Actuarial Valuation as of October 1, 2012
State Required Exhibit
10/01/2011 10/01/2012
A. Participant Data
1. Active participants 185 169
2. Retired participants and beneficiaries
receiving benefits 64 72
3. Disabled participants receiving benefits 0 0
4. Terminated vested participants 114 125
5. Annual payroll of active participants $ 8,875,836 $ 8,216,342
6. Annual benefits payable to those currently
receiving benefits $ 1,474,151 $ 1,650,058
B. Value of Assets
1. Actuarial Value $ 25,932,292 $ 26,852,721
2. Market Value $ 22,336,010 $ 27,039,803
C. Liabilities
1. Actuarial present value of future expected
benefit payments for active members
a. Retirement benefits $ 26,647,279 $ 25,875,093
b. Vesting benefits 2,296,321 2,093,181
c. Death benefits 804,237 776,273
d. Disability benefits 792,182 810,009
e. Total $ 30,540,019 $ 29,554,556
2. Actuarial present value of future expected benefit
payments for terminated vested members $ 4,440,904 $ 5,308,023
3. Actuarial present value of future expected benefit
payments for members currently receiving benefits
a. Service retired (includes DROPs) $ 13,784,683 $ 15,464,181
b. Disability retired 0 0
c. Beneficiaries 1,713,366 1,719,207
d. Miscellaneous (Refunds in Process) 16,159 17,104
e. Total $ 15,514,208 $ 17,200,492
-39-
Gabriel Roeder Smith & Company
Table XVI
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Actuarial Valuation as of October 1, 2012
State Required Exhibit
10/01/2011 10/01/2012
4. Total actuarial present value of future
expected benefit payments $ 50,495,131 $ 52,063,071
5. Actuarial accrued liabilities $ 41,567,399 $ 43,759,458
6. Unfunded actuarial accrued liabilities $ 15,635,107 $ 16,906,737
D. Statement of Accumulated Plan Benefits
1. Actuarial present value of accumulated vested
benefits
a. Participants currently receiving benefits $ 15,498,049 $ 17,183,388
b. Other participants 20,736,588 21,486,154
c. Total $ 36,234,637 $ 38,669,542
2. Actuarial present value of accumulated non-
vested plan benefits 723,879 649,175
3. Total actuarial present value of accumulated
plan benefits $ 36,958,516 $ 39,318,717
E. Pension Cost
1. Total normal cost $ 1,232,055 $ 1,282,286
2. Payment required to amortize unfunded liability 1,349,497 1,473,330
3. Interest adjustment 121,009 129,779
4. Total required contribution $ 2,702,561 $ 2,885,395
5. Item 4 as a percentage of base payroll 30.4% 35.1%
6. Estimated employee contributions $ 443,792 $ 410,817
7. Item 6 as a percentage of base payroll 5.0% 5.0%
8. Net amount payable by County and City $ 2,258,769 $ 2,474,578
9. Item 8 as a percentage of base payroll 25.4% 30.1%
-40-
Gabriel Roeder Smith & Company
Table XVI
(Cont'd)
City of Winter Springs
Defined Benefit Plan
Actuarial Valuation as of October 1, 2012
State Required Exhibit
10/01/2011 10/01/2012
F. Past Contributions
1. Total contribution required (previous valuation, % of pay) $ 2,080,788 $ 2,702,561
2. Actual contributions made:
a. Members $ 418,635 N/A
b. City and County 1,824,431 N/A
c. Total $ 2,243,066 N/A
G. Disclosure of Following Items:
1. Actuarial present value of future salaries
- attained age $ 79,108,370 $ 73,826,561
2. Actuarial present value of future employee
contributions - attained age $ 3,955,418 $ 3,691,328
3. Actuarial present value of future contributions
from other sources N/A N/A
4. Amount of active members' accumulated
contributions $ 2,108,483 $ 2,347,257
5. Actuarial present value of future salaries and
future benefits at entry age N/A N/A
6. Actuarial present value of future employee
contributions at entry age N/A N/A
-41-
Gabriel Roeder Smith & Company
Table XVI
(Cont'd)
City of Winter Springs
Defined Benefit Plan
State Required Exhibit
Amortization balances are written down in proportion to amortization payments.
Current Remaining
Unfunded Amortization Funding
Unfunded Actuarial Accrued Liabilities Liabilities Payment Period
10/01/2000 Initial 2,080,120 205,512 18 years
10/01/2002 Assumption Change (26,767) (2,524) 20 years
10/01/2003 Plan Amendment 169,442 15,663 21 years
10/01/2004 Plan Amendment 257,049 23,332 22 years
10/01/2005 Plan Amendment 532,883 47,576 23 years
10/01/2006 Plan Amendment 613,197 53,926 24 years
10/01/2007 Plan Amendment 627,720 54,448 25 years
10/01/2008 Plan Amendment and Assumption Change 2,818,666 241,432 26 years
10/01/2008 Method Change 6,300,135 539,636 26 years
10/01/2009 Actuarial Loss(Gain) 2,694,381 228,144 27 years
10/01/2010 Actuarial Loss(Gain) (498,194) (41,742) 28 years
10/01/2010 Plan Amendment (2,888,410) (242,008) 28 years
10/01/2011 Actuarial Loss(Gain) 3,159,610 262,185 29 years
10/01/2012 Actuarial Loss(Gain) 1,066,905 87,750 30 years
TOTAL $ 16,906,737 $ 1,473,330
This actuarial valuation and/or cost determination was prepared and completed by me or under my direct supervision,
and I acknowledge responsibility for the results. To the best of my knowledge, the results are complete and accurate,
and in my opinion, the techniques and assumptions used are reasonable and meet the requirements and intent of Part
VII, Chapter 112, Florida Statutes. There is no benefit or expense to be provided by the plan and/or paid from the
plan's assets for which liabilities or current costs have not been established or other wise provided for in the valuation.
All known events or trends which may require material increase in plan costs or required contribution rates have been
taken into account in the valuation.
Enrollment Number: 11-02802
Dated: October 14,2013 Lawrence F. Wilson,A.S.A.
-42-
Gabriel Roeder Smith &Company