关键词 > 115.112/Acc代写
115.112 Accounting Assessment 3 Business Financial Evaluation 2021
发布时间:2022-01-25
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
School of Accountancy
115.112 Accounting
Assessment 3
Business Financial Evaluation
Summer School, 2021
ASSESSMENT 3 INSTRUCTIONS
The assessment will be in two parts:
Part A: Analysing financial statements using Power BI (a software application). Part B: Evaluating and reporting on Iwi financial performance using the
TDB Advisory Ltd. Iwi Investment Report.
How to approach this Assessment
Please read all instructions before starting the assessment.
Download Power BI Desktop (or access Power BI through remote access). See the following page for more information on this.
Access the Power BI material for training on Power BI, which are located under the ‘Assessment Resource’ section.
Study the relevant material in the textbook and other study material and make sure you understand the concepts covered.
Before attempting part A of the Assessment 2
1. Download Power BI Desktop OR access Power BI through Massey’s Flexible Learning environment as discussed below.
2. Download the following file from Stream under the ‘Assessment 3 files’ folder and save it on your device:
115.112 Assessment 3 Student Data.xlsx
3. Access the material provided for Power BI training under the Assessment Resources section:
a. Power BI Recording – a quick run through using the application.
b. Data visualisation slides – useful resource for requirement (ii) and (iii).
c. ‘How to access Flexible Learning environment from anywhere’ for students that are not Microsoft users.
4. Attempt Part A.
5. You can attempt Part A (i), (ii), and (iii) without the training material if you have prior knowledge of the Power BI application.
Power BI Desktop Download for Microsoft users
Part A of this assessment requires you to complete tasks using Power BI Desktop (It is a free to use program). Please follow this link to download the program:
Download the ‘Microsoft Power BI Desktop’ version as highlighted in purple below in the screen shot from the Microsoft website:
• After downloading and opening the application, you will be asked to log in.
DO NOT ATTEMPT TO LOG IN USING YOUR MASSEY CREDENTIALS. You can use the application without logging in. Opt out of logging in, by closing the dialogue box.
• You are now ready to upload the Excel file (see point 2 & 3 on page 2).
Power BI Desktop usage for Non-Microsoft users (Apple etc.)
If you are unable to download Power BI Desktop to your computer, you can access the program by remotely accessing Massey’s Flexible Learning environment. You will find the complete instructions under the Assessment Resources section on the Stream site. The file is called, ‘How to access Flexible Learning environment from anywhere’ .
Submitting the Assessment files
The assessment will result in 2 separate files; one Power BI file and one Word file. Submit both files in the provided submission point for Assessment 3.
Follow the instructions “Submitting Assignments to Stream Assignment boxes” , which is available under the Assessment section on Stream. Stream records the submission date and time. See the Course Guide for policies re extensions and late submissions. Penalties will be applied to late submissions for which an extension has not been granted.
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 [Do not change the file extension or you (and the marker) will not be able to use the file]. For example, if your Last Name is Smith and your Student ID number is 88888888; your files will be Smith88888888.pbix and Smith88888888.docx.
Once you have started working on an assessment you should make backups. It pays to rename different versions of your work. A simple way to do this is to use the Save as file instruction and add a number or letter to the end of the file name. (This allows you to go back to an earlier version.)
ASSESSMENT BRIEF
PART A – Financial Statement Evaluation
You have been hired by the consultancy firm, Finest Investments Ltd, as a financial analyst. Your manager, Andrew Jones, asked you to analyse the financial statements of seven technology companies. You have asked your support person to download the financial statements of the companies and extract the data in a spreadsheet. Provided as file ‘115.112 Assessment 3 Student Data.xlsx’ with the Assessment 3 material, under the assessment section. In the spreadsheet there are the following sheets:
1. 2019 financial data
2. 2020 financial data
In the 2019 and 2020 financial data sheets, there are columns for the relevant Income Statement and Balance Sheet items required for calculating the ratios.
Required:
In Power BI:
(i) Load the ‘2019 financial data’ sheet and ‘2020 financial data’ sheet into Power BI. Use the information in the data sheets in Power BI to calculate the following ratios for the seven companies for 2020 (See Appendix A for the formulas):
a) Profit Margin
b) Gross Profit Percentage
c) Return on Total Assets
d) Return on Equity
e) Inventory Turnover
f) Number of Days in Selling Period
g) Accounts Receivable Turnover
h) Number of Days in Collection Period
i) Current Ratio
j) Quick Ratio
k) Debt Ratio
l) Interest Coverage
m) Sales % Increase
TIP:- Use the ‘New Column’ function in the ‘Data view’ in Power BI to create a new calculated column for each of the ratios.
(13 marks)
(ii) Present the 2020 ratios in relevant tables in your Power BI file to compare the
seven technology companies. The tables have to express profitability, efficiency, liquidity and financial gearing appropriately.
(12 marks)
(iii) Create appropriate visualisations (graphs) in your Power BI for file for the 2020 ratios
to compare the seven technology companies. The visualisations have to express profitability, efficiency, liquidity and financial gearing appropriately.
(12 marks)
In a Word document:
(iv) Explain what the ratios reveal about the profitability and liquidity of company C. Include
a comparison between 2020 and 2019 for company C, and of company C to the other
companies in terms of 2020. To justify your answers, use relevant ratios from requirement (i) and the 2019 ratios for company C as provided below:
Ratio |
2019 |
Profit Margin |
7.27% |
Gross Profit Percentage |
46.68% |
Return on Total Assets |
5.21% |
Return on Owner’s Equity |
33.29% |
Current Ratio |
1.33 |
Quick Ratio |
0.58 |
Sales % Increase |
-0.99% |
(32 marks)
[PART A: TOTAL = 69 MARKS]
PART B – Accounting Information for Maori Business:
In a Word document: [Use the same file as for requirement (iv) from Part A]
To answer the following questions, use the TDB Report (2020), which can be accessed here:TDB Report
(v) Discuss and compare the investment strategies of the two iwis, Ngāpuhi and Ngāti Awa. Include a discussion of the asset classes each of the two iwis invested in.
(18 marks)
(vi) Evaluate and explain the Return on Assets of Ngāpuhi and Ngāti Awa over the years
2013 to 2020. Include a comparison between the two iwis.
(vii) References for (v) and (vi).
(9 marks)
(4 marks)
[PART B: TOTAL = 31 MARKS] [TOTAL = 100 MARKS]
Presentation of discussion requirements:
• Answer (iv), (v), (vi), and (vii) in the same Word file.
• Answers should be well reasoned and comprehensive.
• Your answer for (iv) should range from 900 to 1,200 words.
o Do not copy the tables and visualisations from (i), (ii) and (iii) into the Word document as part of your discussion.
o References are not required.
• Your answer for (v) should range from 500 to 600 words, and for (vi) should range from
300 to 400 words. This does not include the references.
o Consult the provided study material and the TDB report (2020) for information. It is also advisable to add to this material from other literature, e.g. the TDB reports from previous years and websites for each of the iwi.
o References are required. Apply the APA 7th ed. method of referencing. For a handy online, interactive tool,click here.
• The discussions of (iv), (v) and (vi) do not need to be presented in the form of reports.
• Do not include the question or marking template in your Word file.