代写115.112 Accounting Assessment 3 Business Financial Evaluation Semester 2, 2024代写C/C++语言

115.112 Accounting

Assessment 3

Business Financial Evaluation

Semester 2, 2024

ASSESSMENT 3 INSTRUCTIONS

The assessment will be in two parts:

Part A: Analysing financial statements using Power BI (a Microsoft software application) and a financial discussion.

Part B: Evaluating and reporting on Iwi financial performance using the TDB Advisory Ltd Iwi Investment Reports.

How to approach this Assessment

•        Please read all instructions before starting the assessment.

•       Study the relevant material in the textbook and other study materials and make sure you understand the concepts covered.

Before attempting Part A of the Assessment 3

1.      Download Power BI Desktop OR access Power BI through Massey’s Virtual Desktop as discussed on the following page.

2.      Download the following file from Stream under the Assessment 3 files folder and save it on your device:

115.112 Data Assessment 3.xlsx

3.      Access the material provided for Power BI training under the Assessment Resources section:

•    Power BI Recording – a quick run-through using the application.

•    Transcript. of the Power BI Recording.

•    Data visualisation slides – a useful resource for requirements (ii) and (iii).

4.      Attempt Part A.

5.      You can attempt Part A 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 :

Power BI Download

Download the ‘Microsoft Power BI Desktop’ version as highlighted in green 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 OR ANY OTHER CREDENTIALS. You use the application without logging in. Opt out of logging in by closing the dialogue box.

•    If you are asked to log into your Microsoft account, please ignore this prompt and close it.

•    You are now ready to upload the Excel file (see point 2 on page 2 of this booklet).

Power BI Desktop usage for Non-Microsoft users (Apple etc.)

Power BI Desktop cannot be downloaded to devices that do not use Microsoft. If you are unable to download Power BI Desktop to your computer, you can access the program by remotely accessing Massey’s Virtual Desktop. You will find the complete instructions under the Assessment Resources section on the Stream site. The file is called, ‘How to  use Microsoft Power BI using Massey’s Virtual Desktop’ .

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.

•       Submit  both  files  in  the  assignment submission  drop  box as  provided under the Assessment section, under the Assessment 3 information heading.

•        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.

• You must submit the Power BI file in a .pbix format.

•       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.)

•       For  policies  ref.  extensions  and  late  submissions,  see  the  Assessment  section. Penalties will be applied to late submissions for which an extension has not been granted.

ASSESSMENT BRIEF

PART A - Financial Statements Evaluation:

You have been hired by an investment firm, Ultimate Earnings as a financial analyst. Your manager has recently acquired a new client, who is interest in the American market, and in particular technology companies. Your manager has asked you to analyse the financial statements of the top six American technology companies and noted that the new client has very limited financial knowledge.

Your assistant has downloaded the 2023 and 2024 financial statements of the companies and  have  compiled the  relevant  Statement  of Financial  Position  (Balance  Sheet)  and Statement  of  Financial  Performance   (Income  Statement)   data   in  a   Microsoft  Excel spreadsheet. The file comprises of two (2) sheets, one for the 2023 financial data and one for the 2024 financial data.

To provide the client with comprehensive financial information, you calculate relevant ratios and prepare tables and graphs as visual presentation of the ratios in Microsoft  Power BI. You also prepare a simple discussion of the relevant ratios and what the ratios reveal about the companies.

Required:

In Power BI:

•    Upload the data from the provided Excel file, ‘115.112 Data Assessment 3.xlsx’ , and load the ‘2023’ and ‘2024’ sheets from this file.

•    DO NOT make any changes to the Excel file before uploading it to Power BI.

•    Work in the ‘Data view’ . Use the ‘New Column’ function to create a new calculated

column for each of the ratios provided below for 2024. Ensure you are working in the ‘2024’ sheet: (See Appendix A for the formulas, p. 8 . All amounts are in NZ$ .):

(i)

a)         Profit Margin

b)        Gross Profit Percentage

c)         Return on Total Assets

d)         Return on Owners’ Equity

e)        Inventory Turnover

f)         Sales % Increase

g)         Number of Days in Selling Period

h)        Accounts Receivable Turnover (Assume all net sales are on credit)

i)          Number of Days in Collection Period

j)          Current Ratio

k)         Quick Ratio

l)          Debt Ratio

m)       Interest Coverage (13 marks)

(ii)        In the ‘Report View’, present the 2024 ratios in relevant tables in your Power BI file to compare the companies. The tables must express profitability, efficiency, liquidity and financial gearing appropriately. (12 marks)

(iii)       In the Report View, create appropriate graphs(visualisations) in your Power BI file for the 2024 ratios to compare the companies. The graphs must express profitability, efficiency, liquidity and financial gearing appropriately. (12 marks)

In a Word document: [Use the same file as for requirements (iv), (v), and (vi)]

(iv)      Your client  is  particularly  interested  in  company  E’s performance, as they have

heard a lot about the company. Write a simple discussion where-in you:

•    Evaluate company E’s profitability by comparing the company’s 2024 results with its results for 2023.

•    Compare company E’s 2024 profitability, with that of the other companies for 2024.

To justify your explanations, use relevant 2024 ratios from requirement (i) and the

2023 ratios of company E, as provided below:

Ratio	2023
Profit Margin	26.39%
Gross Profit Percentage	64.52%
Return on Total Assets	12.35%
Return on Owner’s Equity	25.72%
Sales % Increase	30.13%

(25 marks)

PART B - Accounting Information for Maori Business:

In a Word document:  [Use the same file as for requirement (iv)]

A member of the Tūhoe iwi, Hemi Orupe  has been reading a copy of the latest TDB Advisory Report 2023 and asks for your help by providing the answers for the questions below. The TDB Advisory Reports from 2015 to 2023 (Iwi Investment Reports) can be accessed here:TDB Report

(v)        Explain the concept of kaitiakitanga and how it informs the investment decisions of iwi leadership. (14 marks)

(vi)       Discuss Tūhoe’s investment strategy and investment performance for 2023. Include a discussion of how Tūhoe’s asset base has changed from 2015 to 2023 . (20 marks)

(vii)      References for (v) and (vi). (4 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 400 to 500 words.

o Do not copy the tables and visualisations from (ii) and (iii) into the Word document as part of your discussion. Just refer to the ratio numbers.

o References are not required.

•     Your answer for (v) should range from 200 to 250 words and and (vi) should range from 400 to 450 words. These do not include the references.

o Consult the provided study material and the TDB Advisory Report for 2023 for  information.  It  is  also advisable to add to  this material from  other literature, e.g. websites from the internet (e.g., the iwi’s website)

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 or essays.

•     A good way to limit word usage is by using bullet points.