110.309 ADVANCED FINANCIAL ACCOUNTING
ASSIGNMENT 2
100 marks (20% of final grade)
Financial Statement Analysis
Semester One,
Please note that this assignment is due before Wednesday 3 May 2023, 11:55pm New
Zealand Time
Objective of this assignment: Developing an analytics mindset
Having and using an analytics mindset is critical in accounting and business. This assignment focuses
on developing all aspects of your analytics and critiquing mindset, namely the ability to:
Ask the right questions (the assignment questions illustrate what these may look like).
Apply appropriate data analytic techniques (Using Power BI, prepare appropriate tables and graphs).
Interpret and share the results with stakeholders (Prepare a report for Mr. Mark Brown).
How to Approach this Assignment
1. Please read all instructions before starting the assignment.
2. This assignment requires you to complete tasks using Power BI Desktop. It is free for
Microsoft Windows users. Mac users can use remote desktop which has Power BI installed.
3. Attend the Power BI Zoom workshop on 23 March, 12noon – 1.30pm.
4. Use the ‘Power BI Resources’ page provided on the 110.309 Stream site.
5. Study the Week 1 material on financial analysis to make sure you understand the concepts
covered.
Before attempting the assignment
1. Download Power BI Desktop OR access Power BI through Massey’s Flexible Learning
environment. See ‘Power BI Resources’ under Course resources tab on Stream.
2. Access the material provided for Power BI training under the ‘Power BI Resources’ on Stream.
Submitting the Assignment files
1. The assignment will result in 2 separate files: one Power BI file (.pbix) and one Word file (.docx).
2. Submit both files in the provided submission box for Assessment 2.
3. Stream records the submission date and time. See Stream for policies regarding extensions and
late submissions. Penalties will be applied to late submissions for which an extension has not
been granted.
4. Note that substantial marks could be lost if you fail to submit any of the required files as marks
are allocated to the content of each of the files.
1
, Naming Convention and backups
1. Use the following naming convention for the files that you create: use your Last Name and
Student ID number as the name of the file [Important: Do not change the file extension or you
(and the marker) will not be able to open the file]. For example, if your Last Name is Smith and
your Student ID number is 12345678; your files will be Smith12345678.pbix and
Smith12345678.docx.
2. Once you have started working on an assignment you should make backups. We recommend
you give each backup a new version number. (This allows you to go back to earlier versions)
2
ASSIGNMENT 2
100 marks (20% of final grade)
Financial Statement Analysis
Semester One,
Please note that this assignment is due before Wednesday 3 May 2023, 11:55pm New
Zealand Time
Objective of this assignment: Developing an analytics mindset
Having and using an analytics mindset is critical in accounting and business. This assignment focuses
on developing all aspects of your analytics and critiquing mindset, namely the ability to:
Ask the right questions (the assignment questions illustrate what these may look like).
Apply appropriate data analytic techniques (Using Power BI, prepare appropriate tables and graphs).
Interpret and share the results with stakeholders (Prepare a report for Mr. Mark Brown).
How to Approach this Assignment
1. Please read all instructions before starting the assignment.
2. This assignment requires you to complete tasks using Power BI Desktop. It is free for
Microsoft Windows users. Mac users can use remote desktop which has Power BI installed.
3. Attend the Power BI Zoom workshop on 23 March, 12noon – 1.30pm.
4. Use the ‘Power BI Resources’ page provided on the 110.309 Stream site.
5. Study the Week 1 material on financial analysis to make sure you understand the concepts
covered.
Before attempting the assignment
1. Download Power BI Desktop OR access Power BI through Massey’s Flexible Learning
environment. See ‘Power BI Resources’ under Course resources tab on Stream.
2. Access the material provided for Power BI training under the ‘Power BI Resources’ on Stream.
Submitting the Assignment files
1. The assignment will result in 2 separate files: one Power BI file (.pbix) and one Word file (.docx).
2. Submit both files in the provided submission box for Assessment 2.
3. Stream records the submission date and time. See Stream for policies regarding extensions and
late submissions. Penalties will be applied to late submissions for which an extension has not
been granted.
4. Note that substantial marks could be lost if you fail to submit any of the required files as marks
are allocated to the content of each of the files.
1
, Naming Convention and backups
1. Use the following naming convention for the files that you create: use your Last Name and
Student ID number as the name of the file [Important: Do not change the file extension or you
(and the marker) will not be able to open the file]. For example, if your Last Name is Smith and
your Student ID number is 12345678; your files will be Smith12345678.pbix and
Smith12345678.docx.
2. Once you have started working on an assignment you should make backups. We recommend
you give each backup a new version number. (This allows you to go back to earlier versions)
2
