In-class assessment 3_Activity 1_Wednesday @9

.xltx

School

Royal Melbourne Institute of Technology *

*We aren’t endorsed by this school

Course

4160

Subject

Management

Date

May 8, 2024

Type

xltx

Pages

16

Uploaded by JusticeTank10642 on coursehero.com

RMIT Classification: Trusted #_x000D_ 2023 AUD Sales Revenue ### Cost of Goods Sold ### Cash at Bank $597,000,000.00 Trade Debtors $470,000,000.00 Inventory ### Other Current Assets $362,000,000.00 Total Current Assets ### Trade Creditors ### Total Current Liabilities ### Additional information AAI Average Inventory COGS AAI (Days) Resources tied in inventory ($) Coles Group Limited financial data WORKING CAPITAL MANAGEMENT RELATED RATIOS (a) Calculate wo to support a firm (b) Discuss results obtained (1) by highlighting trend pa company's performance against the industry standard (i. and 30 days in 2023 financial year (4 marks) . Consider 𝐶𝑂𝐺𝑆/ (365 𝑑𝑎𝑦𝑠) E.g., Annual Credit purchases = ending balance inventory (20 Annual Credit sales = sales revenue
RMIT Classification: Trusted #_x000D_ ACP Average Accounts receivable Annual credit sales ACP (Days) Resources tied in Receivables ($) APP Average Accounts payable Annual credit purchases APP (Days) Resources freed up from accounts payable ($) CCC (days) Funding requirements to support a firm's CCC Current ratio Quick ratio (b) Calculat the compan its past perf industry ave WORKING CAPITAL MANAGEMENT RELATED RATIOS (𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑟𝑒𝑑𝑖𝑡 𝑠𝑎𝑙𝑒𝑠)/(365 𝑑𝑎𝑦𝑠) (𝐴𝑛𝑛𝑢𝑎𝑙 𝑐𝑟𝑒𝑑𝑖𝑡 𝑝𝑢𝑟𝑐ℎ𝑎𝑠𝑒𝑠)/(365 𝑑𝑎𝑦𝑠)
RMIT Classification: Trusted #_x000D_
RMIT Classification: Trusted #_x000D_ 2022 2021 2020 2019 AUD AUD AUD AUD ### ### ### ### ### ### ### ### $589,000,000.00 $787,000,000.00 $992,000,000.00 $940,000,000.00 $ 386,000.00 $315,000,000.00 $314,000,000.00 $226,000,000.00 ### ### ### ### $713,614,000.00 $225,000,000.00 $307,000,000.00 $275,000,000.00 ### ### ### ### ### ### ### ### ### ### ### ### 2023 2022 2021 2,385,500,000 2,277,500,000 2,136,500,000 30,034,000,000 29,210,000,000 28,773,000,000 82,284,931.51 80,027,397.26 78,830,136.99 28.99 28.46 27.10 ### ### ### orking capital ratios (i.e., AAI, ACP, APP, and CCC) and Comp m's CCC for 2021, 2022, and 2023 (12 marks) . attern (i.e., trend analysis) in key ratios—AAI, ACP, APP, and C .e., industry analysis) using the company's 2023 ratios (i.e., AAI, ring your findings, could you explore potential strategies to enhan 016) + COGS - Biginning balance inventory (2015)
RMIT Classification: Trusted #_x000D_ 2023 2022 2021 235,193,000 157,693,000 314,500,000 40,483,000,000 39,369,000,000 38,585,000,000 110,912,328.77 107,860,273.97 105,712,328.77 2.12 1.46 2.98 ### ### ### 2023 2022 2021 3,246,000,000 3,002,500,000 2,846,000,000 472,000,000 930,000,000 728,000,000 1,293,150.68 2,547,945.21 1,994,520.55 2510.15 1178.40 1426.91 ### ### ### -2479.04 -1148.48 -1396.83 ### ### ### 2023 2022 2021 0.59 0.58 0.59 0.22 0.20 0.23 te the current and quick ratios for 2021, 2022 ny's liquidity position. This assessment aims to formance (i.e., trend analysis) and against its erage for current and quick ratios in 2023 is 0
RMIT Classification: Trusted #_x000D_
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help