BUSINFO 705
Group Project Assignment (30%)
Quarter Four 2024
This Group Project Contains:
One Group Project Report
Weighting:
This group project is worth 30% of your final grade.
Submission Instructions:
Please submit the following files:
(1) Group Report,
(2) Your Excel File (this should contain the data and the details of your models you worked on and your calculations),
(3) Team Task Allocation Form, and
(4) Meeting Minutes to Canvas.
Note: The Excel file will not be marked and does not contribute to your grade, but we reserve the right to check if the information in the report corresponds to the information in the file.
Final Individual Marks for This Group Project:
1. Your final individual mark for this group project will be adjusted based on peer-review evaluations (via Feedback Fruits) received from other team members.
2. The teaching team will evaluate your actual contributions to the group work to make any necessary adjustments to your individual mark.
3. The purpose of this approach is to encourage students to put forth their best effort in this group assignment, which aligns with the Graduate Profile Capability for Collaboration.
4. Further details regarding this process will be provided on Canvas and discussed in-class.
Word Count:
The stipulated word count for the report is 2000 words (±10%, line spacing 1.5, font and size: Times New Roman 12). The word count includes tables but excludes the cover page, the executive summary, the reference list, and any appendices. Your executive summary should be on the cover page and not exceed 200 words.
Format of Group Report:
1. Please use a professional report structure that includes
• an executive summary,
• introduction,
• main body,
• conclusion (insights from the findings and recommendations to the customer),
• reference list (if references are cited)
• academic honesty declaration (refer to page 8-11)
2. Organise your work using headings and sub-headings, and carefully check your grammar and punctuation.
3. You can find more detailed information about the structure of a report from here:
https://www.grammarly.com/blog/how-to-write-a-report/
Graphs, Tables and Charts:
Graphs, tables, and charts should be produced using Excel or other statistical software. Please note that graphs, tables, and charts should be selected and created carefully, and when included, must be discussed in your report.
Other Instructions:
A draft can be submitted via Canvas for language feedback from the Business Communication Team, up to 60 hours prior to the submission deadline. Answers should be processed in MS WORD or PDF format.
References:
If you include references, they should be in APA 7 format.
The Use of Generative AI Tools
1. You are not permitted to copy sentences or paragraphs from tools or software which generate multiple connected ideas in sentences when completing this assessment. This is because we need to assess your ability to develop and organise ideas, in particular, to report and interpret analytical output, and we are unable to do so if you use a tool that does this on your behalf. Examples of such tools/software include (but are not limited to) ChatGPT and Gemini. You may only use these Gen AI tools in the writing process to 1) brainstorm ideas and 2) edit your work. If you use these tools, you must acknowledge them in your work by attaching an Appendix illustrating how you have used them. You may also use Gen AI tools to draw or generate graphs. Such graphs must be clearly acknowledged using citations as indicated on the Quick Cite website. You must reference any use of such tools.
2. For guidance on how to reference AI generated content in your writing, visit Quick©ite (or by this link: https://www.cite.auckland.ac.nz/2.html).
3. Please be aware of the limitations of Gen AI tools.
4. Please refer to the detailed guide provided at the end of these assignment instructions.
Submission Policy:
1. Please take note that you are responsible for any possible technical issues that may occur while submitting your assignment. We recommend that you submit your assignment at least half an hour before the deadline to allow for any unforeseen issues.
2. The assignment instructions have been available since Week 1, and the submission link will open 48 hours before the deadline. This should provide ample time for you to complete the assignment and submit it on time.
3. The deadline for submission is 11:59 pm NZT on Tuesday, 26th November 2024. Please be aware that if you submit even one second late, it will be considered a late submission and subject to a late submission penalty. We recommend that you prepare for any potential technical issues and treat the deadline is 11:58 pm to ensure that your submission is on time.
4. Any late submissions will automatically incur a 5% (per day) mark reduction per day, applied directly by Canvas as part of the late submission penalty.
5. The submission link will close at 11:59 pm, Friday, 29 November 2024.
This Assignment Links to the Following Learning Outcomes:
LO2. Manage and assess the trade-off between modelling assumptions and tractability in authentic case studies (Capability 1 and 2)
LO3. Formulate , justify, and evaluate models for decision-making (Capability 2 and 3)
LO4. Present and articulate your own opinions both in class exercises and for your models on key modelling assumptions and likely decision biases in using the models (Capability 1, 2, 3, 4.1, 4.2, 4.3 and 5.1)
LO5. Contribute to a team to complete an open-ended modelling project (Capability 3 and 4.3)
And Helps to Develop These Graduate Attributes:
1. Disciplinary Knowledge and Practice
4. Written Communication.
Background:
You are a financial advisor at GSM Bank, based in Auckland, New Zealand. Emily, a 30-year-old data analyst working for a leading tech company, approaches you for advice. She earns a salary of NZD 80,000 and expects an average annual raise of 3.5% with a standard deviation of 0.7%, based on her industry and career prospects. She has been contributing to her superannuation scheme which matches 100% of her contributions up to 3% of her salary. She currently contributes the maximum amount to take full advantage of her employer's match. However, she is uncertain if her current strategy will meet her long-term financial goals. Emily is committed to ensuring her retirement plan aligns with her vision of a comfortable lifestyle. at 65, which she envisions as being financially secure enough to maintain her current standard of living, travel regularly, engage in leisure activities, and have sufficient funds to cover healthcare and other unforeseen expenses in retirement.
Emily's current superannuation account is diversified across three different funds:
• Stable Bonds Fund (Stable): A conservative fund, investing in government bonds and fixed-income securities, averaging an annual growth of 3.50% with a volatility measure of 4.00% over the past decade.
• Balanced Hybrid Fund (Balanced): A balanced fund, with a mix of stocks and bonds, showing a ten-year average growth of 6.50% and a volatility of 8.50%.
• SkyHigh Equity Fund (SkyHigh): A growth fund, focusing on equities, with a historic ten-year growth rate of 10.50% and a volatility of 20.50%.
She distributes her contributions as follows: 40% into Stable, 40% into Balanced, and 20% into SkyHigh.
As her financial advisor, your task is to help Emily develop a strategy for her superannuation fund that optimises her returns while aligning with her risk tolerance and retirement goals.
Assignment Tasks:
When preparing your report, please ensure that you answer each of the tasks below thoroughly. Structure your report by clearly labelling sections with relevant subtitles corresponding to each question. This will help in organising your findings and arguments systematically. Provide comprehensive explanations, analyses, and justifications for each of your answers, supported by relevant financial theories, data, and calculations where appropriate.
Your report should not only present your conclusions but also the reasoning and methodology behind them, allowing for a clear understanding of your analytical process. The tasks are:
1. Superannuation Strategy Review:
a. Evaluate Emily's current investment allocations. Consider the balance between risk and return in the context of her age and retirement goals.
b. Assess the sufficiency of her current and projected contributions towards meeting her expected retirement needs. Consider her current salary, expected salary increases, and contribution match from her employer.
c. Provide recommendations for any adjustments to her superannuation strategy to better align with her long-term financial goals.
2. Projection Methodology:
a. Propose a method to project the future value of Emily's superannuation fund by the time she retires at age 65. Consider the variability in salary increases and fund performance. Describe how you would account for these uncertainties in your projections.
b. Discuss the strategies you would implement to ensure that your analysis covers a wide range of scenarios and remains robust under various conditions.
3. Analysis Framework:
a. Detail the steps you would take to implement your proposed projection method from Question 2 “Projection Methodology”. Describe how you would use this framework to evaluate the potential future value of Emily's superannuation.
b. Discuss how you would interpret the results of this analysis, considering various potential retirement scenarios.
Final Guidance for Assignment Submission:
As you conclude your analysis and prepare your report, please remember:
• Implementation and Reporting Guidance: While structuring your report around the specified questions and tasks, ensure the last section is dedicated to effectively communicating your findings. This should be done in a manner that is clear and comprehensible, particularly for Emily, who may not have a background in business analytics. This part of your assignment is crucial for bridging the gap between complex analytical outcomes and practical, actionable advice.
• Application of Findings: Additionally, provide a thoughtful discussion on how Emily can leverage the insights gained from your analysis to make informed decisions regarding her superannuation contributions and investment allocations. This discussion should aim to translate your technical findings into strategic recommendations that Emily can easily understand and act upon.
This guidance is intended to remind you of the importance of clear communication and the practical application of your analytical work. It is not a separate question or task but a fundamental aspect of how you should approach the overall presentation of your assignment.