Please help, super super important questions! 3. Download the kiwisaver fund information discolsure data...
80.2K
Verified Solution
Question
Finance
Please help, super super important questions!
3. Download the kiwisaver fund information discolsure data of December 2020 from the following website: https://fma.govt.nz/news-and-resources/reports-and-papers/compare-kiwisaver-data/.
Evaluate the performance of the NZ kiwisaver funds of 2020 by analysing the data. Address the following questions.
(a) How many funds disclosed their information of December 2020? (5 marks)
(b) Generate one column to calculate funds excess return using the difference between the funds last year return (%) net charges and tax and the market index return. Delete those funds with missing information of either last year return (%) net charges and tax or the market index return (5 marks).
(c) Using the information from (b), how any funds successfully beat the market and how many funds failed to beat the market after tax and fee are considered in 2020? (10 marks)
(d) Overall, did the kiwisaver fund beat the market in 2020? Explain your argument. (20 marks)
(e) Different funds charged different annual fees in 2020. Were the higher fees justified by a better performance in 2020? (Hint: to run the regression of excess returns on total annual fund fees.)
Submit your spreadsheet with your evaluation report on line
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.