Last modified by Megan Kahl on 2022/06/17 08:36

<
From version < 70.1 >
edited by Megan Kahl
on 2022/06/17 07:00
To version < 69.1 >
edited by Megan Kahl
on 2022/06/17 06:50
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -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:
176 +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
184 +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:
186 +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:
190 +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.
194 +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,7 +201,7 @@
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.
204 +**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 206  === (% style="color:#2980b9" %)**Final - Annual Adjustment**(%%) ===
207 207  
... ... @@ -208,7 +208,7 @@
208 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:**
211 +**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  
226 +**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**
242 +**Unit Price** = 49 832 892.00 ÷ 276442.52339 = **180.264929537**
244 244  
244 +**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):
251 +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:
255 +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:
269 +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.
273 +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.
275 +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  
293 +**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:
304 +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:
308 +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:
317 +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:
321 +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.
325 +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  

Need help?

If you need help with XWiki you can contact: