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

<
From version < 69.1 >
edited by Megan Kahl
on 2022/06/17 06:50
To version < 70.1 >
edited by Megan Kahl
on 2022/06/17 07:00
>
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 **reprice** the transactions for the period. While on the Parent, go to
184 +In this scenario you will need to (% style="color:#2980b9" %)**reprice**(%%) the transactions for the period. While on the Parent, go to
185 185  
186 -Accounts → Unit Price Management:
186 +(% style="color:#2980b9" %)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 “**Link your investments**” section:
190 +Locate the (% style="color:#2980b9" %)“**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 **third** “Select” button – Reprice the cashflows for the selected Investment Policy’ section.
194 +Click on the (% style="color:#2980b9" %)**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 -**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 +(% 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.
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 -**Liabilities:**
211 +(% style="color:#2980b9" %)**Liabilities:**
212 212  
213 213  While on the Parent, run the batch ‘Parent Investment Member Product’ at the year-end date:
214 214  
... ... @@ -223,8 +223,9 @@
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:**
227 227  
227 +(% style="color:#2980b9" %)**Assets:**
228 +
228 228  The total asset value is usually provided by the Actuary / Fund Accountant.
229 229  
230 230  To calculate the closing unit price at year end, you divide the total asset value by the total UNITS in the product.
... ... @@ -239,20 +239,21 @@
239 239  
240 240  Total Assets = 49 832 892.00 (as received from Accounts)
241 241  
242 -**Unit Price** = 49 832 892.00 ÷ 276442.52339 = **180.264929537**
243 +(% style="color:#2980b9" %)**Unit Price**(%%) = 49 832 892.00 ÷ 276442.52339 = (% style="color:#2980b9" %)**180.264929537**
243 243  
244 -**Allocating on Everest:**
245 245  
246 +(% style="color:#2980b9" %)**Allocating on Everest:**
247 +
246 246  We now need to adjust the Unit Price on Everest. While on the Parent, go to Accounts → Investment Products:
247 247  
248 248  [[image:Calculating and Loading Interim_Final Rates_html_aeedf1ec7013a979.png||height="178" width="91"]]
249 249  
250 250  
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):
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):
252 252  
253 253   [[image:Calculating and Loading Interim_Final Rates_html_559d28bc8ecfc4a0.png||height="100" width="381"]]
254 254  
255 -Click on the “New Used Ups” button at the bottom of the screen:
257 +Click on the (% style="color:#2980b9" %)**“New Used Ups”**(%%) button at the bottom of the screen:
256 256  
257 257  [[image:Calculating and Loading Interim_Final Rates_html_7126ffabb5613f89.png||height="50" width="112"]]
258 258  
... ... @@ -266,13 +266,13 @@
266 266  
267 267  [[image:Calculating and Loading Interim_Final Rates_html_570535c211e85663.png||height="170" width="76"]]
268 268  
269 -Locate the “**Link your investments**” section:
271 +Locate the (% style="color:#2980b9" %)“**Link your investments**”(%%) section:
270 270  
271 271  [[image:Calculating and Loading Interim_Final Rates_html_b993779320601de0.png||height="107" width="593"]]
272 272  
273 -Click on the **fifth** “Select” button – ‘Update used product prices from the ‘Start Date’ to the ‘End Date’ section.
275 +Click on the (% style="color:#2980b9" %)**fifth**(%%) “Select” button – ‘Update used product prices from the ‘Start Date’ to the ‘End Date’ section.
274 274  
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.
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.
276 276  
277 277   [[image:Calculating and Loading Interim_Final Rates_html_9c7ad50c95447944.png||height="96" width="258"]]
278 278  
... ... @@ -290,8 +290,9 @@
290 290  
291 291  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.
292 292  
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.
294 294  
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 +
295 295  Use the unit price calculator to calculate the new prices for the following year:
296 296  
297 297   [[image:Calculating and Loading Interim_Final Rates_html_649a53d74e537d43.png||height="116" width="112"]]
... ... @@ -301,11 +301,11 @@
301 301  
302 302  [[image:Calculating and Loading Interim_Final Rates_html_aeedf1ec7013a979.png||height="178" width="91"]]
303 303  
304 -Double Click on the “UPs” button for the product you want to update:
307 +Double Click on the (% style="color:#2980b9" %)**“UPs” **(%%)button for the product you want to update:
305 305  
306 306   [[image:Calculating and Loading Interim_Final Rates_html_559d28bc8ecfc4a0.png||height="100" width="381"]]
307 307  
308 -Click on the “New Used Ups” button at the bottom of the screen:
311 +Click on the (% style="color:#2980b9" %)**“New Used Ups”**(%%) button at the bottom of the screen:
309 309  
310 310  [[image:Calculating and Loading Interim_Final Rates_html_7126ffabb5613f89.png||height="59" width="131"]]
311 311  
... ... @@ -314,15 +314,15 @@
314 314  [[image:Calculating and Loading Interim_Final Rates_html_fe124aaa0aea5a6d.png||height="143" width="259"]]
315 315  
316 316  
317 -You will need to **reprice** the transactions for the period. While on the Parent, go to Accounts → Unit Price Management:
320 +You will need to (% style="color:#2980b9" %)**reprice**(%%) the transactions for the period. While on the Parent, go to Accounts → Unit Price Management:
318 318  
319 319  [[image:Calculating and Loading Interim_Final Rates_html_570535c211e85663.png||height="191" width="86"]]
320 320  
321 -Locate the “**Link your investments**” section:
324 +Locate the (% style="color:#2980b9" %)“**Link your investments**”(%%) section:
322 322  
323 323  [[image:Calculating and Loading Interim_Final Rates_html_b993779320601de0.png||height="114" width="630"]]
324 324  
325 -Click on the **third** “Select” button – Reprice the cashflows for the selected Investment Policy’ section.
328 +Click on the (% style="color:#2980b9" %)**third**(%%) “Select” button – Reprice the cashflows for the selected Investment Policy’ section.
326 326  
327 327  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.
328 328  

Need help?

If you need help with XWiki you can contact: