Download the most recent kiwisaver fund information discolsure data (December 20

Question

Download the most recent kiwisaver fund information discolsure data (December 2017) from the following website: https://fima.govt.nz/news-and-resources/reports-and-papers compare-kiwisaver-datal, Evaluate the performance of the NZ kiwisaver funds of 2017 by analysing the data. Address the following questions:

(1) How many funds disclosed their information of December 2017? (10 marks)

(2) Generate one column to calculate the difference between the fund's last year return (%) net charges and tax and the market index return. (20 marks).

(3) How any funds successfully beat the market and how many funds fail to beat the market after tax and fee are considered in 2017? (10 marks)

(4) Overall, did the kiwisaver fund beat the market in 2017? (40 marks)

(5) List the top five best-performed fund and the top five worst-performed fund using information from (2). (10 marks)

(6) Other open comments. (10 marks)

Explanation / Answer

Ans 1) 243 funds disclosed their information in December 2017 out of this 238 disclosed their Past year return.

Ans 2) Below is table will provide difference between fund return and market return

Ans 3) There are total 22 funds which are able to beat the market.

Others 221 are unable to beat the market out which 216 disclosed their past year return.

Ans 4) Every kiwisaver fund generated less return than market thus it is unable to beat market in 2017.

Ans 5) Top Best performed fund

Top five worst performed fund who disclosed their return:

Fund Number Fund Name Market index past year return (%) Past year return(%) net charges and tax Fund return - Market Index return FND1001 STEPPING STONES 0-35 19.53 20.29 0.76 FND1002 STEPPING STONES 36-45 AND STEPPING STONES GROWTH 51-55 16.99 16.24 -0.75 FND1003 STEPPING STONES 46-55 AND STEPPING STONES GROWTH 56-60 14.45 12.19 -2.26 FND1004 STEPPING STONES 56-60 12.53 9.02 -3.51 FND1005 STEPPING STONES 61-64 AND STEPPING STONES GROWTH 61-64 11.79 7.91 -3.88 FND1050 CONSERVATIVE FUND 6.95 5.41 -1.54 FND1051 GROWTH FUND 16.93 14.95 -1.98 FND1052 BALANCED STRATEGY 12.35 10.57 -1.78 FND1080 PRESERVATION FUND 2.02 1.8 -0.22 FND1082 CASH ENHANCED FUND 6.57 5.08 -1.49 FND1083 CONSERVATIVE FUND 7.87 5.68 -2.19 FND1084 BALANCED FUND 12.6 9.84 -2.76 FND1085 GROWTH FUND 16.01 12.76 -3.25 FND1086 EQUITY FUND 21.34 17.62 -3.72 FND1087 GLIDEPATH AGE 25 21.34 17.62 -3.72 FND1088 GLIDEPATH AGE 40 17.7 14.3 -3.4 FND1089 GLIDEPATH AGE 55 12.97 10.16 -2.81 FND1090 GLIDEPATH AGE 65 8.66 6.38 -2.28 FND1091 GLIDEPATH AGE 75 7.39 5.37 -2.02 FND11 MERCER CASH FUND 2.06 1.49 -0.57 FND1165 NIKKO CASH FUND 2.02 1.66 -0.36 FND1166 RUSSELL LIFEPOINTS® CONSERVATIVE FUND 7.72 6.84 -0.88 FND1173 RUSSELL LIFEPOINTS® MODERATE FUND 11.21 10.27 -0.94 FND1174 ANZ BALANCED FUND 11.49 10.49 -1 FND1175 NIKKO BALANCED FUND 13.43 14.31 0.88 FND1176 RUSSELL LIFEPOINTS® BALANCED FUND 14.77 13.82 -0.95 FND1177 MILFORD ACTIVE GROWTH WHOLESALE FUND 16.69 14.67 -2.02 FND1178 RUSSELL LIFEPOINTS® GROWTH FUND 17.51 16.49 -1.02 FND1179 RUSSELL LIFEPOINTS® TARGET DATE 2015 FUND 7.72 6.84 -0.88 FND1180 RUSSELL LIFEPOINTS® TARGET DATE 2025 FUND 10.84 9.9 -0.94 FND1181 RUSSELL LIFEPOINTS® TARGET DATE 2035 FUND 14.41 13.44 -0.97

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.