ACCT7101 Accounting – Assignment
Financial Report Analysis and Business Decision Making
Semester 2, 2024
Due Date for Submission: 1:00pm Thursday 10 October 2024
(Weight: 25% of Final Grade)
Aims of this assignment
This assignment aims to develop your
a) ability to understand and analyse financial reports,
b) skills and knowledge to compare financial information of two listed companies, and
c) capacity to evaluate financial information and synthesise financial and non-financial information to make business decisions.
This assignment is to be completed on an individual basis.
Your submitted assignment must be entirely your own work. You may seek guidance from lecturers, tutors or fellow students to clarify concepts or the application of concepts to the financial statements in general. In addition, please look at the "Frequently Asked Questions (FAQs)" document uploaded on Blackboard, which may have the clarifications you need. Advice that is clearly associated with the assignment tasks cannot be sought or provided.
Plagiarism is the submission of work or ideas which are not your own but for which academic credit is claimed. It is important that you review the University’s policy on plagiarism. The originality of your assignment will be assessed by the Turn-it-in system. Information from the course profile relating to plagiarism is reproduced below. Please note that it is strictly prohibited to use the AI technologies to develop your answers.
Plagiarism
The University has adopted the following definition of plagiarism:
Plagiarism is the act of misrepresenting as one's own original work the ideas, interpretations, words or creative works of another. These include published and unpublished documents, designs, music, sounds, images, photographs, computer codes and ideas gained through working in a group. These ideas, interpretations, words or works may be found in print and/ or electronic media.
Students are encouraged to read the UQ Student Integrity and Misconduct policy (http:// ppl.app.uq.edu.au/content/3.60.04-student-integrity-and-misconduct) which makes a comprehensive statement about the University's approach to plagiarism, including the approved use of plagiarism detection software, the consequences of plagiarism and the principles associated with preventing plagiarism.
Assignment overview
You have been randomly assigned two ASX listed companies that operate in the same industry (Company A and Company B). See the file “Allocation of companies to students” under the Assessment tab on Blackboard to find your companies.
Obtain each of your company’s annual reports for the 2023, 2022, and 2021 financial years from the company’s website or www.asx.com.au. The annual reports contain the chairperson’s report, directors’ report and financial statements (Statement of Financial Position, Statement of Profit or Loss, Statement of Changes in Equity, Statement of Cash Flows and Notes to the Financial Statements). The financial statements include comparative figures from the prior year, therefore, you will have data for four financial years: 2023, 2022, 2021 and 2020.
Research the financial press and other sources of available information to familiarise yourself with the industry in which your allocated companies operate and with company specific factors that may have or will affect either company’s performance.
Two business scenarios are described below. Scenario 1 relates to Company A only and Scenario 2 involves Company A and Company B. Knowledge of the industry, company specific context and their financial data will be important inputs that inform. the decision that you recommend in relation to each scenario.
Scenario 1
Company A has submitted an application to the Bank of Brisbane for a loan. The amount of the loan is equal to 40% of total shareholders’ equity at the end of the financial year 2023. The purpose of the loan is to fund expansion of Company A’s operating capacity. The loan term sought is 10 years and the loan would be secured against company’s property.
Assume you are a branch lending officer of the Bank of Brisbane who assesses loan applications. The lending officer must make a recommendation to the head office lending manager advising whether the loan application from Company A should be accepted or rejected.
Scenario 2
Both Company A and Company B have offered St. Lucia Investments Limited, a listed investment company (LIC), a private placement of ordinary shares. The amount of share offer is equal to 30% of total shareholders’ equity of each company at the end of the 2023 financial year. St. Lucia Investments Ltd can afford either of the two private placements. The purpose of an increase in equity for each company is to raise funds to finance an expansion of operating capacity.
Assume you are an investment manager at St. Lucia Investments Ltd who evaluates private equity placements. St. Lucia Investments Ltd has limited funds available for investing decisions. The manager must make a recommendation to the board of directors advising whether to accept Company A’s offer to sell to St. Lucia Investments a new issue of ordinary shares and reject Company B’s offer, or accept Company B’s offer to sell to St. Lucia Investments a new issue of ordinary shares and reject Company A’s offer or alternatively reject both offers.
Assignment tasks
Before commencing work on the tasks below, refer to the marking rubric for the criteria and standards that will be applied in the assessment of your assignment. See Blackboard.
1. Company background research (8 marks)
Review Company A’s and Company B’s annual reports, articles in the financial press and other sources of information. Write a short response to each item below to build background knowledge of each company and their industry.
(a) Describe the operating activities of each company noting similarities and differences between Company A and Company B.
(b) Identify two common economy wide factors and two common industry factors that could impact on the financial performance and position of two companies. Also identify two specific factors which could impact the financial performance and position of company A and B, respectively. (In total, you should identify and analyse, at least, eight factors.)
2. Financial ratio analysis (8 marks)
Calculate financial statement ratios for the 2023, 2022 and 2021 years for Company A and Company B respectively. Use the Excel template provided on Blackboard under the Assessment tab to present the analysis in a table. Obtain data for the ratios from the financial statements and notes to the accounts. You may add to this template (calculate additional ratios). See further instruction in the template.
Additionally, use horizontal analysis to present the trend in sales revenue and net profit for Company A and B respectively, assuming 2021 as the base year.
3. Lending decision (12 marks)
Write a business memorandum to the Bank of Brisbane head office loan manager from the branch bank lending officer in Scenario 1. The memorandum must address the following points below.
(a) Evaluate and discuss your assessment of the ability of Company A to repay the loan and interest. Make a recommendation to accept or reject the 10-years term loan application from Company A and justify your recommendation. Use knowledge that you have acquired in your company research from Q1 and refer to relevant ratios calculated in Q2.
(b) Briefly discuss Company A’s net cash flows from operating, investing and financing activities and the trends evident over the last three years. Explain how this analysis is consistent with your accept or reject recommendation.
(c) The use of estimates, cost, alternative accounting methods, the presence of atypical data, and diversification of firms have been cited as factors that limit the usefulness of financial statement analysis. In your recommendation, please discuss the limitation of your financial statement analysis. Identify ratios and explain how one or more of the limiting factors can affect the usefulness of that ratio.
4. Investment decision (12 marks)
Write a business memorandum to St. Lucia Investments Ltd’s board of directors from the investment manager in Scenario 2. The memorandum must address the points below.
(a) Use the most relevant financial ratios to analyse and compare trends in profitability and risk of Company A and Company B for the 2023, 2022 and 2021 years. Discuss your assessment of relative profitability and risk of both companies.
(b) Recommend whether St. Lucia Investments should invest in Company A or Company B or alternatively reject both offers. Justify the recommendation based on the evaluation of risk and profitability of each company and other relevant background information obtained from the annual reports and other sources. Use knowledge that you have acquired in your company research from Q1 and refer to the relevant ratios calculated in Q2.
(c) Explain the meaning of the price earnings (PER) ratio and EPS. Describe three year trends in these ratios for Company A and B and discuss their relevance to the investment decision.
Assignment administration
Format
Submit your work as a single PDF document. Include your student number and name as a header to the document.
Your written responses to Assignment tasks 1, 3 & 4 are limited to a maximum of 5 pages (Times Roman 12 point, 1.5 line spacing and minimum, 2 cm on each margin). Any submitted text exceeding this limit will NOT be assessed.
Attach the Excel table of financial ratios for Assignment Task 2 as the 6th, 7th and 8th pages of the document (excluded from page limit).
Attach a Reference List as the 9th page of the document. All sources used must be referenced using a consistent academic reference style. (e.g. APA 7th edition). See the UQ referencing style. guide in the library https://guides.library.uq.edu.au/referencing. To reference from an annual report, use the ASX Code of the company, year of the annual report and page number, e.g. COL 2023, p30).
Submission
Submit your assignment before or on the due date. Follow the instructions below.
(a) Submit the assignment electronically as a PDF to the Turn-it-in link in the course Blackboard, under the “Assessment” tab, then under “Assignment: Financial Report Analysis and Decision Making” folder. Follow the submission instructions. The title of your assignment in the Turn-it-in Submission Page must be the ASX code of your assigned Company A. Do not add anything else in the title. For example, Origin Energy Ltd's title would be ORG.
(b) When submitting the assignment, you can test it for text matching by submitting it and reviewing the report. Up to the due date, you can resubmit your assignment at any time (if you make changes to it). The system simply deletes your earlier version and replaces it with the resubmitted version.
Late submission
An assignment submitted after the due date and time for which no extension has been granted prior to the due date will incur a late submission penalty. The penalty is applied at the rate of 5% of the total available marks for the assignment for each calendar day or part thereof that the assignment remains overdue.
Extension of due date
Requests for granting an extension to the due dates must be made at least 24 hours prior to the submission date. The request must contain documentation satisfactorily supporting the request. Please refer to the Electronic Course Profile (ECP) Section 5.4 to understand the procedure for requesting an extension.
Assessment criteria
The criteria and standards that will be applied in the assessment of this assignment are available on Blackboard (under the “Assessment” tab). Review the rubric before you commence work to ensure you understand the requirements of the assessment and how it will be assessed.
Feedback on the assessment of your assignment will be available via Turn-it-in.