UNSW Business School
School of Accounting, Auditing & Taxation
business.unsw.edu.au
Last Updated 15/2/2022
ACCT5930 – MYOB Assignment Information Document
PART 3 of the Assignment
Section 9: Cash Flow Statement Excel File [6 marks]
Download the Excel file template shown to you on the ACCT5930 Moodle site, prepare a cash
flow statement for [YOUR zID] [YOUR NAME] Security Systems and Services using the direct
method. It is essential that you complete your answers for the cash flow statement in the blue
squares provided in the template as this part of the assessment is auto-graded. Please note
that there may be more blue square rows than required in some parts of the template; exercise
your judgement accordingly.

Section 10: Management Commentary [5 marks]
The Annual Report to shareholders is an important publication for every publicly traded
corporation. It is sent to its shareholders directly by the corporation and contains both audited
financial statements and other selected information about the company – typically a letter
from the CEO as well as Management Commentary. To complete this section of the
assignment you will be required to write only the Management Commentary section.
At present, your company is a private company with 21 shareholders (there were 20 at the start
of the simulated company period, 1 December, plus one additional shareholder on 31
December). The company wishes to expand through an IPO (initial public offering) through the
ASX and the board of directors hope that this year’s annual report will help to attract new
investors.
To complete this section of the assignment you are required to imagine yourself as the CEO of
the company and write the Management Commentary, dated 31 December 2021.
Your management commentary will be based on the two years of annual data provided in the
Cash Flow Excel file provided for Section 9 of this assignment.
You are required to write a Management Commentary on the financial statements of the
annual report for this simulated company. This Management Commentary section will include:
• Your evaluation of the company’s performance as at 31 December 2021.
• Two (2) issues and/or concerns, operational or financial, that you may have for your
business. For each issue/concern that you have identified, you must do the
following:
o Describe your concern or the risks of the particular business. These ‘risks’
must be concerned with the operational performance or financial
circumstances of your company.
Page 2
o Present evidence based on the Cash Flow Excel file to support your
arguments.
o Propose a course of action(s) that you believe will resolve the situation or
mitigate risks.
• At the 23 December Ed Castle of Castle Industry Park, a customer of this company,
has asked for a quote for 5 sets of Javas Ultra02 industrial security systems and 5
hours of installation. Include discussion of this quote in the management
commentary and explain to the shareholders about the impact on the future
profitability of the company.

The maximum words count for this section is 300 words. An example is provided
below; please use it for ‘inspiration’ rather than as a strict template.

AN EXAMPLE OF A MANAGEMENT COMMENTARY:

The z123456 Ethan Hunt Security Systems and Services Ltd [hereafter Hunt
SSS Ltd] had a [good/bad] year in 2021. Net Profits are [XX], [up/down]
[compared to last year]. [Compare cash and assets of 2020 to 2021].

There are three main sources of revenue for Hunt SSS Ltd: [XXX]. [Provide
comments on revenue trends of 2021 compared to 2021].

Growth in revenue for Hunt SSS depends on: [List two factors and with relevant
evidence]

The primary risk to future profits includes: [List two factors and with relevant
evidence]

Two courses of action that I believe will be able to resolve the situation or
rectify the business risks include: [Your answer].

[Comment whether there is sufficient cash to expand the operations beyond
Sydney]
[Comment on the customer quote.]
Signed: CEO – Ethan Hunt of z123456 Ethan Hunt Security Systems and
Services Ltd



Page 3
PART 3 - CHECK POINT SUBMISSION FILES
You must upload 2 files to the Moodle site. Please note there are two separate links for the
two documents. You may submit at any time up to and including the submission date on the
cover page of this assignment information document. Once you have uploaded the two
separate files, you have completed the MYOB assignment.
File 1: Cash flow statement
You must use the template file provided to you. You should save the file to your computer
regularly as you work through the assignment.
File name: You must save your file with the file name as follows: zID_Your name_Cash flows
part 2022T1 e.g. z4364021_John_ Doe_ Cash flows part 2022T1
Upload Link: You must upload the saved file to the link titled: Part 3 – Cash excel spreadsheet
submission
File 2: Your Management Commentary (in Word document format).
File name: You must save your file with the file name as follows: zID Full Name Management
Commentary e.g. z4364021_John_ Doe_ Management_Commentary
Upload Link: You must upload the saved file to the link titled: Part 3 – Management
Commentary submission.

Submission Checklist:
(1) Cash Flow Excel File. Uploaded to Part 3 – Cash
Excel Spreadsheet Submission link

(2) Management Commentary. Uploaded to Part 3 –
Management commentary Submission link


No late submissions will be accepted for this assignment unless special consideration
has been approved in advance of the submission date.


- THE END OF ASSIGNMENT INFORMATION DOCUMENT -