Harvey Norman Ratios

The calculations for all ratios were easy sailing! However, I did run into some issues with the calculations involving the 'number of issued ordinary shares' - this was because this figure was expressed in millions in the Harvey Norman annual reports rather than thousands as entered in the financial statements. Did anyone else encounter this?

Harvey Norman Spreadsheet.xlsx

Download XLSX • 57KB