Calculating and Loading Interim_Final Rates

Everest is a unit-based system, and therefore requires that rates are converted to a unit price. To do this, a template is provided, for calculating the unit prices. Note that the template may change to accommodate the specific needs of the client, so please discuss your requirements with your EBSphere Consultant so that the correct template is provided.

31

32

[[image:Calculating and Loading Interim_Final Rates_html_2d15cc65377c4c7c.png||height="180" width="210"]]

33

34

35

(% style="text-align: center;" %)

36

== (% style="color:#2980b9" %)**INTERIM RATE**(%%) ==

37

38

39

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:

40

41

[[image:Calculating and Loading Interim_Final Rates_html_aeedf1ec7013a979.png||height="178" width="91"]]

42

43

Double Click on the (% style="color:#2980b9" %)**“UPs”**(%%) button for the product you want to update:

44

45

[[image:Calculating and Loading Interim_Final Rates_html_559d28bc8ecfc4a0.png||height="100" width="381"]]

46

47

A screen will open that reflects the (% style="color:#2980b9" %)**“Used Unit Prices”**(%%). These are the prices the system is currently using for calculation of member values and benefits.

48

49

[[image:Calculating and Loading Interim_Final Rates_html_c6e0cf71f2b8533.png||height="183" width="393"]]

50

51

If the last price is not reflected on the screen (in this example 31/12/2020) click on the “New Used Ups” button at the bottom of the screen:

52

53

[[image:Calculating and Loading Interim_Final Rates_html_7126ffabb5613f89.png||height="59" width="131"]]

54

55

If the last price is not reflected on the screen (in this example 31/12/2020) click on the “New Used Ups” button at the bottom of the screen – this screen reflects all prices that have been loaded for use:

56

57

[[image:Calculating and Loading Interim_Final Rates_html_26da9a9504e25af2.png||height="139" width="302"]]

58

59

Copy the price for the month prior to the new interim rate and use that as the starting price. In this example we are using a Nominal Rate calculation:

60

61

[[image:Calculating and Loading Interim_Final Rates_html_f768b169db3dc5bb.png||height="53" width="304"]]

62

63

64

To calculate the interim rate prices for the next year, insert the MONTHLY interim rate to be used in column B, Return for the Month, for each month of the year. The spreadsheet will calculate the unit prices for each month:

65

66

[[image:Calculating and Loading Interim_Final Rates_html_e8af78425277d3fb.png||height="194" width="191"]]

67

68

The new prices can be manually loaded in Everest, or the user may utilise the import file and function. Imports are preferred to prevent finger error.

69

70

To load the unit prices via the import functionality, first determine the (% style="color:#2980b9" %)‘**ProductID**’(%%) for the product being updated.

71

72

To do this, ensure that the Parent is selected, go to (% style="color:#2980b9" %)Client → Investment Products:

73

74

[[image:Calculating and Loading Interim_Final Rates_html_aeedf1ec7013a979.png||height="178" width="91"]]

75

76

On the screen that opens, note the (% style="color:#2980b9" %)**ProductID**(%%) for the relevant product:

77

78

[[image:Calculating and Loading Interim_Final Rates_html_b68b72a894d7efaa.png||height="88" width="366"]]

79

80

Once identified, prepare the Product Price Import file attached.

81

82

83

[[image:Calculating and Loading Interim_Final Rates_html_d5ab4359b6c55057.gif]]

84

85

Populate the Date, (% style="color:#2980b9" %)**ProductID**(%%) and Unit Price columns:

86

87

[[image:Calculating and Loading Interim_Final Rates_html_737d85a651d2cf90.png||height="158" width="139"]]

88

89

To import the file, go to (% style="color:#2980b9" %)Accounts → Unit Price Management:

90

91

[[image:Calculating and Loading Interim_Final Rates_html_570535c211e85663.png||height="191" width="86"]]

92

93

Locate the (% style="color:#2980b9" %)“**Import your unit prices**”(%%) section:

94

95

[[image:Calculating and Loading Interim_Final Rates_html_4f1b11fda376cd0c.png||height="121" width="294"]]

96

97

Click on the second (% style="color:#2980b9" %)**Import**(%%) button – Import Unit Prices for Parent Investment Products:

98

99

[[image:Calculating and Loading Interim_Final Rates_html_4f1b11fda376cd0c.png||height="121" width="294"]]

100

101

102

Browse to pick up your saved import file:

103

104

[[image:Calculating and Loading Interim_Final Rates_html_591f84d57fbc47ca.png||height="162" width="252"]]

105

106

Select (% style="color:#2980b9" %)**Save** (%%)and (% style="color:#2980b9" %)**Execute.**

107

108

109

A report will be produced indicating that the headings were recognised.

110

111

[[image:Calculating and Loading Interim_Final Rates_html_160a7632760e70b4.png||height="153" width="452"]]

112

113

114

To confirm the rates were correctly imported, while on the Parent go to:

115

116

(% style="color:#2980b9" %)Client → Investment Products.

117

118

Double click on “UPs” for the product imported. At the bottom of the screen click on the “New Used UPs” button. The screen that opens will reflect the new prices that are ready for use:

119

120

[[image:Calculating and Loading Interim_Final Rates_html_c2201debac9c4fd5.png||height="149" width="244"]]

121

122

Once satisfied that the unit prices have been successfully imported, the prices are required to be linked for use in calculating the member values and benefits for the interim rate period.

123

124

(% style="color:#2980b9" %)Go to Accounts → Unit Price Management:

125

126

[[image:Calculating and Loading Interim_Final Rates_html_570535c211e85663.png||height="191" width="86"]]

127

128

129

Locate the (% style="color:#2980b9" %)“**Link your investments**”(%%) section:

130

131

[[image:Calculating and Loading Interim_Final Rates_html_b993779320601de0.png||height="114" width="630"]]

132

133

Click on the(% style="color:#2980b9" %) **fifth** (%%)“Select” button – Update used product prices from the ‘Start Date’ to the End Date’ section.

134

135

In the screen that opens, select the product you want to update, date range you want to link and select “Test” in the (% style="color:#2980b9" %)**Custom 1**(%%) field. The Parent should be pre-populated but please do check it.

136

137

[[image:Calculating and Loading Interim_Final Rates_html_13e8528d92a2925e.png||height="103" width="250"]]

138

139

Save and Execute. A report will be produced confirming the prices it would write up:

140

141

[[image:Calculating and Loading Interim_Final Rates_html_c9fe771aada585dc.png||height="104" width="323"]]

142

143

Once satisfied with the results, repeat using the “Live” option.

144

145

To check that the prices updated correctly, while on the Parent go to:

146

147

(% style="color:#2980b9" %)Client → Investment Products.

148

149

Double click on “Ups” for the product. On the first screen that opens the new prices should appear.

150

151

[[image:Calculating and Loading Interim_Final Rates_html_c148949d49fee58c.png||height="141" width="383"]]

(% style="text-align: center;" %)

156

== (% style="color:#2980b9" %)**FINAL RATE**(%%) ==

157

158

159

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.

160

\\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.

161

162

The implication of each method is:

163

164

__[[Monthly Retrospective Adjustment>>path:#_Retrospective_monthly]]__– All transactions processed in the interim period will have to be repriced. Any claims processed in the interim period will result in either positive or negative orphan units. If you are going to reprocess the claims and either pay additional or claw back overpayments, then this method will work for you.

165

166

(% style="color:#2980b9" %)__Annual Adjustment__(%%) – The transactions for the interim period would be unaffected and the active member values would be adjusted at the final once off date.

167

168

(% style="color:#2980b9" %)**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.

169

170

171

=== (% style="color:#2980b9" %)**Final - Monthly Retrospective Adjustment**(%%) ===

172

173

174

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:

175

176

[[image:Calculating and Loading Interim_Final Rates_html_163d76866478adfc.png||height="209" width="463"]]

177

178

On Everest, manually adjust each month’s price. The import functionality cannot be used. While on the Parent go to Accounts → Investment Products:

179

180

[[image:Calculating and Loading Interim_Final Rates_html_aeedf1ec7013a979.png||height="178" width="91"]]

181

182

Double Click on the(% style="color:#2980b9" %)** “UPs”**(%%) button for the product you want to update:

183

184

[[image:Calculating and Loading Interim_Final Rates_html_559d28bc8ecfc4a0.png||height="100" width="381"]]

185

186

Click on the (% style="color:#2980b9" %)**“New Used Ups” **(%%)button at the bottom of the screen:

187

188

[[image:Calculating and Loading Interim_Final Rates_html_7126ffabb5613f89.png||height="59" width="131"]]

189

190

Edit each of the monthly unit prices to the new final prices:

191

192

[[image:Calculating and Loading Interim_Final Rates_html_fe124aaa0aea5a6d.png||height="143" width="259"]]

193

194

In this scenario you will need to (% style="color:#2980b9" %)**reprice**(%%) the transactions for the period. While on the Parent, go to

195

196

(% style="color:#2980b9" %)Accounts → Unit Price Management:

197

198

[[image:Calculating and Loading Interim_Final Rates_html_570535c211e85663.png||height="191" width="86"]]

199

200

Locate the (% style="color:#2980b9" %)“**Link your investments**” (%%)section:

201

202

[[image:Calculating and Loading Interim_Final Rates_html_b993779320601de0.png||height="103" width="573"]]

203

204

Click on the (% style="color:#2980b9" %)**third**(%%) “Select” button – Reprice the cashflows for the selected Investment Policy’ section.

205

206

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.

207

208

[[image:Calculating and Loading Interim_Final Rates_html_a33dc31135f02423.png||height="91" width="276"]]

209

210

A report will be produced reflecting all the batches that have been repriced:

211

212

[[image:Calculating and Loading Interim_Final Rates_html_42d6c79cb5c90d09.png||height="164" width="407"]]

213

214

(% 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.

215

216

=== (% style="color:#2980b9" %)**Final - Annual Adjustment**(%%) ===

217

218

219

For an Annual Adjustment you will need to calculate the closing unit price via an Asset Liability match. To do so follow this procedure:

220

221

(% style="color:#2980b9" %)**Liabilities:**

222

223

While on the Parent, run the batch ‘Parent Investment Member Product’ at the year-end date:

224

225

[[image:Calculating and Loading Interim_Final Rates_html_23e36b7dee89d05d.png||height="85" width="274"]]

226

227

Use the ‘By Client’ Report Output for the total values. If you want to see the data at member level, use the ‘By Member’ option.

228

229

A report will be produced:

230

231

[[image:Calculating and Loading Interim_Final Rates_html_e6e7ba44e13d0b5b.png||height="439" width="443"]]

232

233

234

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.

235

236

237

(% style="color:#2980b9" %)**Assets:**

238

239

The total asset value is usually provided by the Actuary / Fund Accountant.

240

241

To calculate the closing unit price at year end, you divide the total asset value by the total UNITS in the product.

242

243

In this example we are using the total member assets excluding the exits as the exits have already been paid.

244

245

[[image:Calculating and Loading Interim_Final Rates_html_ed5d26b2719bfd15.png||height="103" width="559"]]

246

247

//In this example we are calculating the unit price for both products, as both products are included in the total asset value.//

248

249

Member Units = 268669.05939 + 7773.46400 = 276 442.52339

250

251

Total Assets = 49 832 892.00 (as received from Accounts)

252

253

(% style="color:#2980b9" %)**Unit Price**(%%) = 49 832 892.00 ÷ 276442.52339 = (% style="color:#2980b9" %)**180.264929537**

254

255

256

(% style="color:#2980b9" %)**Allocating on Everest:**

257

258

We now need to adjust the Unit Price on Everest. While on the Parent, go to Accounts → Investment Products:

259

260

[[image:Calculating and Loading Interim_Final Rates_html_aeedf1ec7013a979.png||height="178" width="91"]]

261

262

263

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):

264

265

[[image:Calculating and Loading Interim_Final Rates_html_559d28bc8ecfc4a0.png||height="100" width="381"]]

266

267

Click on the (% style="color:#2980b9" %)**“New Used Ups”**(%%) button at the bottom of the screen:

268

269

[[image:Calculating and Loading Interim_Final Rates_html_7126ffabb5613f89.png||height="50" width="112"]]

270

271

Edit the year end unit price to the new final price:

272

273

[[image:Calculating and Loading Interim_Final Rates_html_f7d7f2360c7ed9e0.png||height="50" width="630"]]

Save and Close.

You now need to link the new Unit Price. While on the Parent, go to Accounts → Unit Price Management:

278

279

[[image:Calculating and Loading Interim_Final Rates_html_570535c211e85663.png||height="170" width="76"]]

280

281

Locate the (% style="color:#2980b9" %)“**Link your investments**”(%%) section:

282

283

[[image:Calculating and Loading Interim_Final Rates_html_b993779320601de0.png||height="107" width="593"]]

284

285

Click on the (% style="color:#2980b9" %)**fifth**(%%) “Select” button – ‘Update used product prices from the ‘Start Date’ to the ‘End Date’ section.

286

287

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.

288

289

[[image:Calculating and Loading Interim_Final Rates_html_9c7ad50c95447944.png||height="96" width="258"]]

290

291

Save and Execute. A report will be produced confirming the prices it would write up:

292

293

[[image:Calculating and Loading Interim_Final Rates_html_2fa50f4e6cc1b3db.png||height="108" width="548"]]

294

295

Once satisfied with the results, repeat using the “Live” option. You will need to do this for each product that needs to be updated.

296

297

To check that the prices updated correctly, while on the Parent go to:

298

299

Client → Investment Products. Double click on “Ups” for the product. On the first screen that opens the new prices should appear.

300

301

[[image:Calculating and Loading Interim_Final Rates_html_f913ee3d8d80e777.png||height="77" width="630"]]

302

303

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.

304

305

306

(% 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.

307

308

Use the unit price calculator to calculate the new prices for the following year:

309

310

[[image:Calculating and Loading Interim_Final Rates_html_649a53d74e537d43.png||height="116" width="112"]]

311

312

313

On Everest you will need to manually adjust each month’s price. The import functionality cannot be used in this case. While on the Parent go to Accounts → Investment Products:

314

315

[[image:Calculating and Loading Interim_Final Rates_html_aeedf1ec7013a979.png||height="178" width="91"]]

316

317

Double Click on the (% style="color:#2980b9" %)**“UPs” **(%%)button for the product you want to update:

318

319

[[image:Calculating and Loading Interim_Final Rates_html_559d28bc8ecfc4a0.png||height="100" width="381"]]

320

321

Click on the (% style="color:#2980b9" %)**“New Used Ups”**(%%) button at the bottom of the screen:

322

323

[[image:Calculating and Loading Interim_Final Rates_html_7126ffabb5613f89.png||height="59" width="131"]]

324

325

Edit each of the monthly unit prices to the new interim prices:

326

327

[[image:Calculating and Loading Interim_Final Rates_html_fe124aaa0aea5a6d.png||height="143" width="259"]]

328

329

330

You will need to (% style="color:#2980b9" %)**reprice**(%%) the transactions for the period. While on the Parent, go to Accounts → Unit Price Management:

331

332

[[image:Calculating and Loading Interim_Final Rates_html_570535c211e85663.png||height="191" width="86"]]

333

334

Locate the (% style="color:#2980b9" %)“**Link your investments**”(%%) section:

335

336

[[image:Calculating and Loading Interim_Final Rates_html_b993779320601de0.png||height="114" width="630"]]

337

338

Click on the (% style="color:#2980b9" %)**third**(%%) “Select” button – Reprice the cashflows for the selected Investment Policy’ section.

339

340

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.

341

342

[[image:Calculating and Loading Interim_Final Rates_html_a33dc31135f02423.png||height="101" width="306"]]

343

344

A report will be produced reflecting all the batches that have been repriced:

345

346

[[image:Calculating and Loading Interim_Final Rates_html_42d6c79cb5c90d09.png||height="164" width="407"]]

(% style="text-align: center;" %)

351

== (% style="color:#2980b9" %)**Disclaimer and Copyright**(%%) ==

352

353

354

(% style="color:#2980b9" %)**DISCLAIMER**

355

356

Please note, whilst care is taken to illustrate numerous scenarios, it is impossible to detail all instances and therefore this document should merely serve as a guide for the purposes of demonstrating system functionality and conducting employee training.

357

358

In accordance with the above paragraph, this training manual is published and distributed on the basis that EBSphere (Pty) Ltd is not responsible/accountable for any actions taken by users of information contained in this training manual nor for any error in or omission from this manual.

359

360

EBSphere (Pty) Ltd does not accept any responsibility whatsoever for a misrepresentation performed by any person in respect of claims, losses or damage or any other matter, either direct or consequential arising out of or in relation to the use and reliance, whether wholly or partially, upon any information contained or products referred to in this manual.

361

362

Further, the contents of this training manual are subject to change without any notice and further highlight the need for this training manual to serve only as a guide.

(% style="color:#2980b9" %)**COPYRIGHT**

367

368

This documentation and the software described in it is the exclusive property of EBSphere (Pty) Ltd. This manual or the software may not be copied in whole or part, without the express written consent of EBSphere (Pty) Ltd. Under the law, copying includes translating into another language or format.

369

370

371

EBSphere (Pty) Limited

P.O. Box 785803

Sandton