Wiki source code of Benefit Scenarios - DB Funds

Last modified by Megan Kahl on 2021/12/01 06:35

Show last authors
1 (% class="wikigeneratedid" id="HCLIENTBENEFITSSCENARIOS-DBFUNDS" style="text-align: center;" %)
2 (% style="color:#2980b9; font-size:28px" %)**CLIENT BENEFITS SCENARIOS - DB FUNDS**
3
4
5 (% style="text-align: center;" %)
6 (% style="color:#2980b9" %)**BY**
7
8
9 (% style="text-align:center" %)
10 [[image:Benefit Header Scenarios - DB Funds_html_8cba33b1e8c9fa24.gif||height="128" width="463"]]
11
12 {{info}}
13 (% style="break-before: page; text-align: center;" %)
14 (% style="color:#2980b9; font-size:20px" %)**TABLE OF CONTENTS**
15
16
17 {{toc/}}
18
19
20 {{/info}}
21
22
23
24 (% style="break-before: page; text-align: center;" %)
25 = (% style="color:#2980b9" %)**Benefit Headers – DB Funds**(%%) =
26
27
28
29 A (% style="color:#2980b9" %)**defined benefit plan guarantees you a certain benefit when you retire.**(%%) How much you receive generally depends on factors such as your salary, age, and years of service with the company, regardless of how well the Fund performs.
30
31
32 There are MANY variations between Funds, making it impossible to show each scenario. We will cover the most common scenario to explain how the benefit header fields work together.
33
34
35 (% style="color:#2980b9" %)**Client:**(%%) Select the relevant Client
36
37
38 (% style="text-align:center" %)
39 [[image:1637322410146-707.png||height="196" width="273"]]
40
41 (% style="color:#2980b9" %)**Client Menu:**(%%)** **Select Client Benefits
42
43
44 (% style="text-align:center" %)
45 [[image:Benefit Header Scenarios - DB Funds_html_bff20e07b891f365.png||height="391" width="274"]]
46
47
48
49 (% style="break-before: page;" %)
50 == (% style="color:#2980b9" %)**Scenario Example**(%%) ==
51
52
53 (% style="color:#2980b9" %)**Benefit calc Pension**(%%) =** **Final Average Salary x number of month’s pensionable service x actuarial factor.
54
55 (% style="color:#2980b9" %)**Lumpsum**(%%) = Pension x Annuity Factor
56
57 (% style="color:#2980b9" %)**Where Final Average Salary**(%%) = the average salary for 1 year prior to exit date (this can differ from Fund to Fund and will be dictated in the Rules of the Fund). //There is an explanation of how the Final Average Salary is calculated on Everest later in the document//.
58
59 (% style="color:#2980b9" %)**Actuarial Factor**(%%) = age related factor (loading of factors is detailed in the [[Factor Tables manual>>doc:Everest User Manuals.2\. Super User Functions.System Menus.Other Menu.Factor Tables.WebHome]])
60
61 (% style="color:#2980b9" %)**Annuity Factor**(%%) = age related factor (loading of factors is detailed in the [[Factor Tables manual>>doc:Everest User Manuals.2\. Super User Functions.System Menus.Other Menu.Factor Tables.WebHome]])
62
63
64 For an explanation of each available field, please refer to the [[“Client Benefits – General Guidelines” Manual>>doc:Everest User Manuals.4\. Fund Setup.Adding a New Client.Client Benefits.Client Benefits - General Guidelines.WebHome]]
65
66
67 The (% style="color:#2980b9" %)**PENSION**(%%) benefit line on Everest will look like this – note the highlighted fields:
68
69
70 (% style="text-align:center" %)
71 [[image:1631277740866-633.png||height="auto" width="auto"]]
72
73
74
75 (% style="text-align:center" %)
76 [[image:1631277786228-507.png||height="auto" width="auto"]]
77
78
79 The (% style="color:#2980b9" %)**LUMPSUM**(%%) benefit line on Everest will look like this – note the highlighted fields:
80
81
82 (% style="text-align:center" %)
83 [[image:1631277701175-376.png||height="auto" width="auto"]]
84
85
86 (% style="text-align:center" %)
87 [[image:Benefit Header Scenarios - DB Funds_html_cec2b1873f345643.png||height="auto" width="auto"]]
88
89
90 (% style="break-before: page; text-align: center;" %)
91 == (% style="color:#2980b9" %)**Final Average Salary (FAS)**(%%) ==
92
93
94
95 The Rules of the Fund will define the Final Average Salary (FAS), if it is used in the calculation of benefits.
96
97 The FAS can be the last salary (i.e. the salary earned in the exit month), or the average of a number of year’s salary leading up to the exit date (e.g. salary earned 1 year prior to exit date).
98
99
100 The Member Benefit Enquiry report (detailed in the next section) reflects the(% style="color:#2980b9" %)** FAS**(%%) that Everest has calculated:
101
102
103 (% style="text-align:center" %)
104 [[image:1631518947024-830.png||height="163" width="601"]]
105
106
107 Everest uses the total number of (% style="color:#2980b9" %)**DAYS**(%%) in the average period (Ave Period on the benefit row) – note that 1 day is added for leap years.
108
109 (% style="text-align:center" %)
110 [[image:1631518984417-435.png||height="114" width="382"]]
111
112
113 If the member was only a member for part of the average period, the number of days from their first salary on Everest will be used in the calculation AND if there is a leap year there would be an additional day. This makes the calculation on Everest a more accurate calculation than if only the number of months were used.
114
115
116 (% style="color:#2980b9" %)**In the example above**(%%):
117
118
119 The Ave Period is indicated as 1 - i.e. 1 year’s average salary.
120
121 The member joined 01/12/2019
122
123 The member exited 31/03/2020
124
125
126 Therefore, the member was only on the Fund for 5 months.
127
128 1 month with a salary of 703 920.00 (Dec), and 4 months with a salary of 760 000.00 (Jan – Mar).
129
130
131 The (% style="color:#2980b9" %)**FAS calculation**(%%), in this example, is as follows:
132
133 703 920 x 31 = 21 821 520.00 (there are 31 days in Dec)
134
135 760 000 x 91 = 69 160 000.00 (there are 91 days from 01/01/2020 – 31/03/2020, including a leap year day in Feb)
136
137
138 (% style="color:#2980b9" %)**Total Accumulated Salary**(%%) = 21 821 520.00 + 69 160 000.00 = 90 981 520.00
139
140 (% style="color:#2980b9" %)**Total Number of Days**(%%) = 31 + 91 = 122
141
142
143 (% style="color:#2980b9" %)**FAS** (%%)= 90 981 520.00 / 122 = 745 750.16
144
145
146 The FAS of 745 750.16 will be used in the benefit calculations where Final Average Salary is required.
147
148
149 (% style="text-align: center;" %)
150 (% style="color:#e74c3c; font-size:28px" %)**NB!** (% style="font-size:28px" %)Average Salary, on Everest, is calculated using the actual (% style="color:#2980b9; font-size:28px" %)**NUMBER OF DAYS**(% style="font-size:28px" %)** **in the month (which will also include leap years).
151
152
153
154 (% style="break-before: page; text-align: center;" %)
155 == (% style="color:#2980b9" %)**Member Benefit Enquiry**(%%) ==
156
157
158
159 The Member Benefit Enquiry is used to view the calculation of Defined Benefits at member level.
160
161
162 (% style="color:#2980b9" %)**Batch Management:** (%%) ** **Select the batch “Member Benefit Enquiry”
163
164
165 (% style="text-align:center" %)
166 [[image:1631519097688-588.png||height="434" width="588"]]
167
168
169 The Commuted percentage must be adjusted to whatever percentage cash/lumpsum the member is taking at exit date. If they are not taking any cash, the percentage would be left as 0%.
170
171
172 [[image:1637323017237-212.png]]
173
174 [[image:1637323061036-821.png]]
175
176 [[image:1637323085257-166.png]]
177
178
179
180 (% style="break-before: page; text-align: center;" %)
181 == (% style="color:#2980b9" %)**Prescribed Minimum Benefit (PMB) / Minimum Individual Reserve (MIR)**(%%) ==
182
183
184
185 South African Defined Benefit Fund benefits are often subject to a Minimum Benefit. If this is the case, it will be detailed in the Rules of the Fund. This is the minimum benefit the member is entitled to as per S14A of the Pension Fund Act. The Earning Yield rates are circulated by the FSB monthly and must be maintained monthly.
186
187
188 Everest will use this rate with the effective date that corresponds to the Exit Date for calculation. These rates are maintained at system level.
189
190
191 (% style="color:#2980b9" %)**Custom Forms**(%%)                   Select “User” and then “40% Yield Earnings”
192
193
194 (% style="text-align:center" %)
195 [[image:1631519241412-451.png||height="625" width="400"]]
196
197
198 The 40% Yield Earnings screen will come up. Please note that these rates are as at end of the month and effective date should be captured as such. The rate format in this screen is in %. The best method of updating these is to copy directly from the spreadsheet and paste on the screen to avoid any typing error that could occur.
199
200
201 (% style="text-align:center" %)
202 [[image:1631519290509-940.png]]
203
204
205 Benefits that are subject to the Minimum Benefit must have an additional benefit line added, which uses the Prescribed Minimum Benefit stored procedure (% style="color:#2980b9" %)“**sp~_~_CalculatePrescMinBenefits**”.(%%) This stored procedure uses the rate loaded on the “40% Yield Earnings” table.
206
207
208 The Prescribed Minimum Benefit (sometimes referred to as Minimum Individual Reserve – MIR) is calculated by using this formula:
209
210 (% style="color:#2980b9" %)**MIR**(%%) = (GRATUITY + 0.5 x (VALUE OF PENSION + COMMUTATION)) x (1/1 + Index Linked yield) (% style="color:#2980b9" %)//period from date of exit to NRA//
211
212
213 (% style="color:#2980b9" %)**An example of the PMB Minimum Benefit line on Everest:**
214
215
216 (% style="text-align:center" %)
217 [[image:1631519329370-940.png||height="467" width="689"]]
218
219
220 This “Minimum” benefit line effectively calculates the Prescribed Minimum Benefit for this (% style="color:#2980b9" %)Retirement – Normal(%%) Benefit type. When the Retirement – Normal Benefit Type is calculated, Everest will first calculate the “Normal” Benefit Type line, then calculate the “Minimum” Benefit Type Line – the end result will be the higher value of the two benefit lines.
221
222
223 (% style="text-align:center" %)
224 [[image:1631519358777-260.png]]
225
226
227
228 (% style="break-before: page; text-align: center;" %)
229 == (% style="color:#2980b9" %)**Disclaimer and Copyright**(%%) ==
230
231
232
233 (% style="color:#2980b9" %)**DISCLAIMER**
234
235 Please note, whilst care is taken to illustrate numerous scenarios, it is impossible to detail all instances and therefore this document should merely serve as a guide for the purposes of demonstrating system functionality and conducting employee training.
236
237 In accordance with the above paragraph, this training manual is published and distributed on the basis that EBSphere (Pty) Ltd is not responsible/accountable for any actions taken by users of information contained in this training manual nor for any error in or omission from this manual.
238
239 EBSphere (Pty) Ltd does not accept any responsibility whatsoever for a misrepresentation performed by any person in respect of claims, losses or damage or any other matter, either direct or consequential arising out of or in relation to the use and reliance, whether wholly or partially, upon any information contained or products referred to in this manual.
240
241 Further, the contents of this training manual are subject to change without any notice and further highlight the need for this training manual to serve only as a guide.
242
243
244 (% style="color:#2980b9" %)**COPYRIGHT**
245
246 This documentation and the software described in it is the exclusive property of EBSphere (Pty) Ltd. This manual or the software may not be copied in whole or part, without the express written consent of EBSphere (Pty) Ltd.  Under the law, copying includes translating into another language or format.
247
248
249 EBSphere (Pty) Limited
250
251 P.O. Box 785803
252
253 Sandton
254
255 2146
256
257
258
259 (% style="text-align:center" %)
260 [[image:Benefit Header Scenarios - DB Funds_html_8cba33b1e8c9fa24.gif||height="128" width="463"]]