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 **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