Reference no: EM133886607 , Length: word count:1500
Business Decision Making
Assessment - Financial statement analysis on selected ASX listed company & preparation of master Budget
Section 1: Financial Statement Analysis and interpretations of selected ASX listed companies
Assessment Description and Instructions:
The purpose of this assessment is to provide students with an understanding of financial statement analysis as well as using Microsoft Excel to aid in calculating financial statement ratios and aiding financial analysis. In business, accountants, managers, and financial analysts are required to understand how businesses or a particular business operates. Financial statement analysis by using common size calculations and percentages aids in this understanding and it also enables comparison to other businesses regardless of the absolute dollar size of these businesses.
Businesses today require that their employees can work in teams and collaborate to produce more innovative solutions, compared to what an individual can produce. Each student will be required to provide an individual report for the allocated ASX listed company analysis and calculations. This assignment involves analysing the financial statements and other information relating to selected listed Australian public companies. The selected ASX listed companies will be allocated to each individual student and uploaded on Moodle.
Each individual student is responsible for the calculations and analysis of the allocated company. The assignment is divided into two parts. Each student is responsible for collecting data from the selected ASX listed company data, analysis, drafting an answer and preparing presentation materials.
Required:
i). A brief statement of the selected company's operations and the statement of the CEO about the selected company's annual performance and strategy. You are required to write in your own interpretation not just cut and paste of the CEO's statement(s) on company's annual performance and strategies.
ii). Calculate the following ratios for 2022 and 2023 - (be sure you show the workings for supporting collected data)
iii). Using the ratios calculated in (ii) above of this case study, compare the liquidity, efficiency, profitability, solvency, and market performance of the company of your analysis. Get professional assignment help service now!
Section 2: Master Budget (extract)
SYDGEE makes and sells upmarket carry bags for personal PC. Jon, controller, is responsible for preparing SYDGEE's master budget and has assembled the following data for 2024.
The direct labour rate includes wages, all employee-related benefits and the employer's share of payroll tax. Labour-saving machinery will be fully operational by August 2024. Also, as of 1 August 2024, the entity's enterprise agreement calls for an increase in direct labour wages that is included in the direct labour rate.
SYDGEE expects to have 30 000 bags in inventory at 31 July 2024, and has a policy of carrying 50 per cent of the following month's projected sales in inventory.
Required
(a) Prepare the following budgets for SYDGEE for the three specified months (August, Sept and October) of 2024. Be sure to show supporting calculations:
(i) production budget in units
(ii) direct labour budget in hours
(iii) direct materials budget
(iv) sales budget.
(b) Calculate the total budgeted contribution margin for SYDGEE for the captioned three months of 2024. Be sure to show supporting calculations.
(c) Discuss at least three behavioural considerations in the profit-planning and budgeting process.