Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -1,7 +1,7 @@
1	1
2	2
3	3	(% style="text-align: center;" %)
4		-(% style="color:#2980b9; font-size:28px" %)**CALCULATING AND LOADING INTERIM_FINAL RATES**
	4	+(% style="font-size: 28px; color: rgb(41, 128, 185)" %)**CALCULATING AND LOADING INTERIM_FINAL RATES**
5	5
6	6
7	7
...	...	@@ -24,11 +24,8 @@
24	24
25	25	[[image:Calculating and Loading Interim_Final Rates_html_2d15cc65377c4c7c.png||height="180" width="210"]]
26	26
	27	+== INTERIM RATE ==
27	27
28		-(% style="text-align: center;" %)
29		-== (% style="color:#2980b9" %)**INTERIM RATE**(%%) ==
30		-
31		-
32	32	When loading rates for the first time on the Fund, start with a price of 100. If not, determine the unit price as at the last month prior to the new interim rate. E.g., if the interim is being applied for the year 2021, the unit price from Everest to be utilized will be as at 31/12/2020. To do this, ensure that the Parent is selected, go to Client → Investment Products:
33	33
34	34	[[image:Calculating and Loading Interim_Final Rates_html_aeedf1ec7013a979.png||height="178" width="91"]]
...	...	@@ -142,10 +142,8 @@
142	142
143	143
144	144
145		-(% style="text-align: center;" %)
146		-== (% style="color:#2980b9" %)**FINAL RATE**(%%) ==
	142	+== FINAL RATE ==
147	147
148		-
149	149	Whilst waiting for the Final Rate to be declared, the interim rate unit prices were utilised to process claims. Once the Final Rate is received for the period, update the unit prices to use the Final Rate.
150	150	\\There are 2 ways of doing this. Applying the final rate retrospectively per month OR applying an annual rate at the end of the period.
151	151
...	...	@@ -158,9 +158,8 @@
158	158	**NB!** With both methods, if you were processing claims for the period AFTER the Final rate was declared for, these claims would also create orphan units. It is best practice to hold payment of claims until the Final Rate is declared.
159	159
160	160
161		-=== (% style="color:#2980b9" %)**Final – Monthly Retrospective Adjustment**(%%) ===
	156	+=== Final – Monthly Retrospective Adjustment ===
162	162
163		-
164	164	To calculate the monthly retrospective adjustment for the period, use the Unit Price calculator provided by your consultant. OVERRIDE the Interim prices used in the original calculation spreadsheet with the new final rate:
165	165
166	166	[[image:Calculating and Loading Interim_Final Rates_html_163d76866478adfc.png||height="209" width="463"]]
...	...	@@ -173,7 +173,7 @@
173	173
174	174	[[image:Calculating and Loading Interim_Final Rates_html_559d28bc8ecfc4a0.png||height="100" width="381"]]
175	175
176		-Click on the **“New Used Ups” **button at the bottom of the screen:
	170	+Click on the “New Used Ups” button at the bottom of the screen:
177	177
178	178	[[image:Calculating and Loading Interim_Final Rates_html_7126ffabb5613f89.png||height="59" width="131"]]
179	179
...	...	@@ -181,17 +181,17 @@
181	181
182	182	[[image:Calculating and Loading Interim_Final Rates_html_fe124aaa0aea5a6d.png||height="143" width="259"]]
183	183
184		-In this scenario you will need to (% style="color:#2980b9" %)**reprice**(%%) the transactions for the period. While on the Parent, go to
	178	+In this scenario you will need to **reprice** the transactions for the period. While on the Parent, go to
185	185
186		-(% style="color:#2980b9" %)Accounts → Unit Price Management:
	180	+Accounts → Unit Price Management:
187	187
188	188	[[image:Calculating and Loading Interim_Final Rates_html_570535c211e85663.png||height="191" width="86"]]
189	189
190		-Locate the (% style="color:#2980b9" %)“**Link your investments**” (%%)section:
	184	+Locate the “**Link your investments**” section:
191	191
192	192	[[image:Calculating and Loading Interim_Final Rates_html_b993779320601de0.png||height="103" width="573"]]
193	193
194		-Click on the (% style="color:#2980b9" %)**third**(%%) “Select” button – Reprice the cashflows for the selected Investment Policy’ section.
	188	+Click on the **third** “Select” button – Reprice the cashflows for the selected Investment Policy’ section.
195	195
196	196	In the screen that opens leave the policy row blank, populate the date range you want to link, “Check” = No, and “Confirmed Prices Only” = No.
197	197
...	...	@@ -201,14 +201,13 @@
201	201
202	202	[[image:Calculating and Loading Interim_Final Rates_html_42d6c79cb5c90d09.png||height="164" width="407"]]
203	203
204		-(% style="color:#2980b9" %)**NB!** (%%)If there are transactions that were processed AFTER the year end date, you will need to recalculate the unit prices for that period and reprice the transactions. The reason for this is that the unit price has changed at the year end, which then affects all unit prices thereafter. Follow the exact same procedure detailed above, but for the new year and utilising the new interim price for that year.
	198	+**NB!** If there are transactions that were processed AFTER the year end date, you will need to recalculate the unit prices for that period and reprice the transactions. The reason for this is that the unit price has changed at the year end, which then affects all unit prices thereafter. Follow the exact same procedure detailed above, but for the new year and utilising the new interim price for that year.
205	205
206		-=== (% style="color:#2980b9" %)**Final - Annual Adjustment**(%%) ===
	200	+=== Final - Annual Adjustment ===
207	207
208		-
209	209	For an Annual Adjustment you will need to calculate the closing unit price via an Asset Liability match. To do so follow this procedure:
210	210
211		-(% style="color:#2980b9" %)**Liabilities:**
	204	+**Liabilities:**
212	212
213	213	While on the Parent, run the batch ‘Parent Investment Member Product’ at the year-end date:
214	214
...	...	@@ -223,9 +223,8 @@
223	223
224	224	The report shows values for Active Members, Exited Members, and a combined total for both. If there are Exited Member values in the product you are calculating, you need to ascertain if the exits have been paid (call the Parent Investment Member Product report using the ‘By Member’ option). If they have been paid, they must be excluded from the Unit Price calculation.
225	225
	219	+**Assets:**
226	226
227		-(% style="color:#2980b9" %)**Assets:**
228		-
229	229	The total asset value is usually provided by the Actuary / Fund Accountant.
230	230
231	231	To calculate the closing unit price at year end, you divide the total asset value by the total UNITS in the product.
...	...	@@ -240,21 +240,20 @@
240	240
241	241	Total Assets = 49 832 892.00 (as received from Accounts)
242	242
243		-(% style="color:#2980b9" %)**Unit Price**(%%) = 49 832 892.00 ÷ 276442.52339 = (% style="color:#2980b9" %)**180.264929537**
	235	+**Unit Price** = 49 832 892.00 ÷ 276442.52339 = **180.264929537**
244	244
	237	+**Allocating on Everest:**
245	245
246		-(% style="color:#2980b9" %)**Allocating on Everest:**
247		-
248	248	We now need to adjust the Unit Price on Everest. While on the Parent, go to Accounts → Investment Products:
249	249
250	250	[[image:Calculating and Loading Interim_Final Rates_html_aeedf1ec7013a979.png||height="178" width="91"]]
251	251
252	252
253		-Double Click on the (% style="color:#2980b9" %)**“UPs” **(%%)button for the product you want to update (note that in this example we need to update the price for BOTH products):
	244	+Double Click on the “UPs” button for the product you want to update (note that in this example we need to update the price for BOTH products):
254	254
255	255	[[image:Calculating and Loading Interim_Final Rates_html_559d28bc8ecfc4a0.png||height="100" width="381"]]
256	256
257		-Click on the (% style="color:#2980b9" %)**“New Used Ups”**(%%) button at the bottom of the screen:
	248	+Click on the “New Used Ups” button at the bottom of the screen:
258	258
259	259	[[image:Calculating and Loading Interim_Final Rates_html_7126ffabb5613f89.png||height="50" width="112"]]
260	260
...	...	@@ -268,13 +268,13 @@
268	268
269	269	[[image:Calculating and Loading Interim_Final Rates_html_570535c211e85663.png||height="170" width="76"]]
270	270
271		-Locate the (% style="color:#2980b9" %)“**Link your investments**”(%%) section:
	262	+Locate the “**Link your investments**” section:
272	272
273	273	[[image:Calculating and Loading Interim_Final Rates_html_b993779320601de0.png||height="107" width="593"]]
274	274
275		-Click on the (% style="color:#2980b9" %)**fifth**(%%) “Select” button – ‘Update used product prices from the ‘Start Date’ to the ‘End Date’ section.
	266	+Click on the **fifth** “Select” button – ‘Update used product prices from the ‘Start Date’ to the ‘End Date’ section.
276	276
277		-In the screen that opens, select the product you want to update, date range must be the year end, and select “Test” in the (% style="color:#2980b9" %)**Custom 1**(%%) field. The Parent should be pre-populated but please do check it.
	268	+In the screen that opens, select the product you want to update, date range must be the year end, and select “Test” in the **Custom 1** field. The Parent should be pre-populated but please do check it.
278	278
279	279	[[image:Calculating and Loading Interim_Final Rates_html_9c7ad50c95447944.png||height="96" width="258"]]
280	280
...	...	@@ -292,9 +292,8 @@
292	292
293	293	To test the values, you can run the “Parent Investment Member Product” batch to see that the total member values now match the total asset value.
294	294
	286	+**NB!** If there are transactions that were processed AFTER the year end date, you will need to recalculate the unit prices for that period and reprice the transactions. The reason for this is that the unit price has changed at the year end, which then affects all unit prices thereafter.
295	295
296		-(% style="color:#2980b9" %)**NB!**(%%) If there are transactions that were processed AFTER the year end date, you will need to recalculate the unit prices for that period and reprice the transactions. The reason for this is that the unit price has changed at the year end, which then affects all unit prices thereafter.
297		-
298	298	Use the unit price calculator to calculate the new prices for the following year:
299	299
300	300	[[image:Calculating and Loading Interim_Final Rates_html_649a53d74e537d43.png||height="116" width="112"]]
...	...	@@ -304,11 +304,11 @@
304	304
305	305	[[image:Calculating and Loading Interim_Final Rates_html_aeedf1ec7013a979.png||height="178" width="91"]]
306	306
307		-Double Click on the (% style="color:#2980b9" %)**“UPs” **(%%)button for the product you want to update:
	297	+Double Click on the “UPs” button for the product you want to update:
308	308
309	309	[[image:Calculating and Loading Interim_Final Rates_html_559d28bc8ecfc4a0.png||height="100" width="381"]]
310	310
311		-Click on the (% style="color:#2980b9" %)**“New Used Ups”**(%%) button at the bottom of the screen:
	301	+Click on the “New Used Ups” button at the bottom of the screen:
312	312
313	313	[[image:Calculating and Loading Interim_Final Rates_html_7126ffabb5613f89.png||height="59" width="131"]]
314	314
...	...	@@ -317,15 +317,15 @@
317	317	[[image:Calculating and Loading Interim_Final Rates_html_fe124aaa0aea5a6d.png||height="143" width="259"]]
318	318
319	319
320		-You will need to (% style="color:#2980b9" %)**reprice**(%%) the transactions for the period. While on the Parent, go to Accounts → Unit Price Management:
	310	+You will need to **reprice** the transactions for the period. While on the Parent, go to Accounts → Unit Price Management:
321	321
322	322	[[image:Calculating and Loading Interim_Final Rates_html_570535c211e85663.png||height="191" width="86"]]
323	323
324		-Locate the (% style="color:#2980b9" %)“**Link your investments**”(%%) section:
	314	+Locate the “**Link your investments**” section:
325	325
326	326	[[image:Calculating and Loading Interim_Final Rates_html_b993779320601de0.png||height="114" width="630"]]
327	327
328		-Click on the (% style="color:#2980b9" %)**third**(%%) “Select” button – Reprice the cashflows for the selected Investment Policy’ section.
	318	+Click on the **third** “Select” button – Reprice the cashflows for the selected Investment Policy’ section.
329	329
330	330	In the screen that opens leave the policy row blank, populate the date range you want to link, “Check” = No, and “Confirmed Prices Only” = No.
331	331
...	...	@@ -337,6 +337,7 @@
337	337
338	338
339	339
	330	+
340	340	(% style="text-align: center;" %)
341	341	== (% style="color:#2980b9" %)**Disclaimer and Copyright**(%%) ==
342	342