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 J
avas 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 –