Sum of the Product method

damo12

New member
Joined
Oct 27, 2015
Messages
8
Dear Forum,

I am assisting employees to evaluate their superannuation benefits and we have attempted to explain the elements of their individual accounts from the details supplied by their fund. I am in need of some guidance to provide a clearer analysis of the detail that has been supplied by their fund and we would appreciate any assistance you can provide on this matter. I have outlined this situation below:

Thank you.

Annual compound yield calculation

We are assisting our employees to evaluate the investment yields of their individual superannuation accounts. As an example, we have set out the details of one of our employees. During the period of 10 years, total member contributions = $28,840 and earnings for the same period were $20,577 accumulating to total benefits (at the end of 10 years) of $49,417.



Year
Contributions ($)​
Earnings ($)​
20122,740(29)
20135,407858
20142,0161,476
20152,4891,749
20162,170541
20172,5333,253
20182,5873,019
20192,6661,717
20202,89877
20213,3347,916
TOTAL$28,840$20,577


Due to the wide fluctuations in earnings, we are attempting to restate the yields into a distribution of the $20,577 across the 10-year period, by using the weighted average or sum of the products method, or any other method that would be appropriate.

Although this is a theoretical exercise, it may help a member to understand the fluctuations that occur in a long-term investment.

Your help in this matter is very much appreciated.

Thank you.
 
Screen Shot 2021-11-21 at 8.57.12 PM.pngScreen Shot 2021-11-21 at 8.58.53 PM.png
I suggest using their contribution as weights to redistribute the earnings. The intuition behind it is, the years with higher contributions should get higher earnings and vice versa.
 
Top