Background

In this assignment the data source is the Annual Report (including the Audited Financial Statements) ofMichael Hill International Limited.Michael Hill is an international multi-channel retail jewellery chain with a vision to be the most loved jewellery destination by creating fine jewellery accessible to all. As of 28 June 2020, it operates 290 stores and digital platform across Australia, New Zealand, and Canada.

You have been provided with the following:

1.Select extracted Financial Information forMichael Hill InternationalLtd in an Excelfile.

Please use only the financial information as provided in the Excel file. There is no need to find or refer to other information in the Financial Statements.

Required:

1.In the Excel file that has been provided to you, with the select extracted financial information forMichael Hill InternationalLtd, use appropriateExcel formulasto calculate ratios that provide information about the following:

a.Two (2) ratios in relation to the liquidity of the company for the 2020year.

b.Two (2) ratios in relation to the solvency of the company for the 2020year

(note:Free Cash Flow is not an accepted ratio calculationfor this assessmentpiece).

c.Two (2) ratios in relation to the profitability of the company for the 2020year.