ACCT7106Financial Statement Analysis – Individual ProjectSemester 1, 2024PROJECT OVERVIEW AND ADMINISTRATIONObjectiveThe project provides students with an important opportunity to ‘learn by doing’. You will be asked to apply most of the analysis from the first five seminars to an Australian public company.Start working on the project early. Leaving it to the last minute will be stressful and may result in poor performance.CompanyYou need to analyse the financial statements of Breville Group Limited (ASX ticker: BRG). The financial statements and notes in Excel format and the annual reports for Breville Group Limited for FY 20, FY 21, FY 22 and FY23 will be shared with you on Learn.UQ.DeliverablesThe project consists of both short answer questions and Excel spreadsheet work. Please submit answers to short answer questions in one Word or PDF document (PDF document is recommended) and answers to spreadsheet questions in one Excel workbook, as indicated in the questions.Page LimitsI have specified page limits for the questions that are to be answered in the Word document. These are maximum page limits. I will enforce maximum page limits by simply not marking any material that appears beyond the page limit for a particular question. You do not necessarily need to write as much as the page limit if you can provide a correct, but succinct, answer.Cover pages and references lists are not counted towards the page limit.FormattingYour written answers should be in A4 page size, in Times New Roman font, 12pt font size, at least single line-spacing, margins at least 2cm on all sides.Please clearly separate and label your written answers to each question.Your Excel file should be formatted neatly and following the conventions described in class.Marking GuideA marking guide is provided at the end of the document. This contains the number of marks assigned to each part of the project.Frequently Asked Questions (FAQ)I may issue, and regularly update, an FAQ addressing frequently asked questions about the project. Please ensure that you check the Assessment tab on Learn.UQ on a regular basis.Submission of the ProjectThe project is to be completed individually.The due date for the project is 13:00 (Monday) April 8, 2024.Cover PagePlease include a cover page at the beginning of your Word or PDF document with your name and student number. This is not strictly necessary, as Learn.UQ manages assignment submissions and matches them to students, but it provides a useful backup for me to identify the author of each submission.Please include your name and student number in the excel file as well in “Student Details” worksheet.Project Submissions InstructionsFor the project, please submit two files by the submission date/time:- Your written answers must be submitted through the Turnitin link on Learn.UQ. Please use a format that Turnitin can accept, such as a Word document or PDF.- Your Excel file must be submitted through the Blackboard submission link on Learn.UQ.Note that both your written report and Excel workings must be submitted to achieve any marks. This is because I need to seeyour workings for financial calculations.Retention of Submission ReceiptsPlease keep all subm代 写ACCT7106 Financial Statement Analysis – Individual Project Semester 1, 2024Java ission receipt numbers provided by submission systems such as Turnitin and Learn.UQ as proof of your submission.Email BackstopIf you encounter any problems with the submission systems (Turnitin and Learn.UQ), please alert technical support and me of the problem. (You may email me a copy of your assignment if you have trouble submitting through the normal systems and if you are concerned about incurring a late penalty due to technical problems.)Late Submission of AssessmentUnless you have an approved extension, you will lose 10% of your assessed grade for the assignment for each 24-hour period (or part thereof) after the designated due date-time that your submission remains outstanding. Your submission time is based on the later of when your written component is submitted and when your Excel file is submitted, so please make sure to submit both on time. To be clear, you will incur a late submission penalty even if one component is submitted on time and the other component is submitted late. Please note that the 10% penalty rate for submission are set byUQ policy, not by me.Multiple Submission ‘Attempts’Some submission systems,e.g. Learn.UQ, allow students to submit multiple ‘attempts’ at an assessment before the due date. Only the most recently submitted attempt will be graded, unless otherwise agreed between the course coordinator and the student involved.For the avoidance of doubt, in the event that a student submits the assignment on time and then submits a different version of their assignment late, I will mark the late submission applying the normal late penalty.Applying for an ExtensionI do not decide on extensions. These are decided by UQ professional staff. Please see the instructions in Section 5 of the ACCT7106 ECP.Getting StartedTo help you,I will provide my spreadsheet for JB Hi-Fi, which you can adapt to the allocated company.DETAILED PROJECT INSTRUCTIONS AND MARKING GUIDEComplete the following tasks in your Word document or Excel workbook as indicated in the question.A. Reformulation and Accounting Analysis (Classes 2-4)You will be given an Excel file with the raw financial statements and notes for the company, which you should use as inputs in the reformulation. This information was obtained from the 2019, 2020, 2021, 2022 and 2023 annual reports of the company. These annual reports have been shared with you on Learn.UQ under Assessment tab. You should go through the annual reports carefully to better understand the company’s accounting.Answer the following in your Excel workbook in the indicated worksheet/tab:A1 Balance Sheet Reformulation (Excel worksheet: BS_R)• Reformulate the Balance Sheet (including any relevant information in the notes), following the approach taught in class, for FY19, FY20, FY21, FY22 and FY23.• For ambiguous accounts, state any assumptions you made with justifications in the Excel file next to the relevant account (in red text). You should consult the annual reports to help you to interpret the accounts.• Ensure you provide workings for how you separated operating and financing cash.• Ensure you utilise any relevant information from the notes to the fin WX：codehelp
