Changes for page Calculating and Loading Interim_Final Rates
Last modified by Megan Kahl on 2022/06/17 08:36
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
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 to184 +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