Excel Account final.xlsx - 2018 2019 2020 ROCE Percentage...

This preview shows page 1 - 5 out of 12 pages.

Year ROCE Percentage 2018 5.21% 2019 5.04% 2020 5.36% Year Profit Mark up Percentage 2018 139.19% 2019 147.02% 2020 145.32% Year 2018 58.19% 2019 59.52% 2020 59.24% Year 2018 7.80% 2019 6.66% 2020 7.54% 2018 2019 2020 4.80% 4.90% 5.00% 5.10% 5.20% 5.30% 5.40% 5.21% 5.04% 5.36% ROCE Year Percentage 2018 2019 2020 134.00% 136.00% 138.00% 140.00% 142.00% 144.00% 146.00% 148.00% 139.19% 147.02% 145.32% Profit Mark-up Year Percentage 2018 2019 2 57.50% 58.00% 58.50% 59.00% 59.50% 60.00% 58.19% 59.52% Gross Profit Margin Year Percentage 6.20% 6.40% 6.60% 6.80% 7.00% 7.20% 7.40% 7.60% 7.80% 8.00% 7.80% 6.66% Operating Profit Margin Percentage
Year 2018 5.21% 2019 5.04% 2020 7.52% Year 2018 6.82 2019 16.19 2020 13.89 Year 2018 6.07 2019 13.01 2020 11.12 Year 2018 4.76 2019 3.12 2020 2.85 2018 2019 6.00% 6.20% Year 2018 2019 2020 0.00% 1.00% 2.00% 3.00% 4.00% 5.00% 6.00% 7.00% 8.00% 5.21% 5.04% 7.52% Return on Equity Year Percentage 2018 2019 2020 0 2 4 6 8 10 12 14 16 18 6.82 16.19 13.89 Working Capital Year Ratio 2018 2019 2020 0 2 4 6 8 10 12 14 6.07 13.01 11.12 Acid Test Ratio Year Ratio 3 3.5 4 4.5 5 4.76 3.12 2.85 Average Stock Holding Period nnum
Year 2018 76.68 2019 117 2020 128.07 Year 2018 3.58 2019 9.92 2020 7.9 Year 2018 101.1 2019 36.79 2020 46.2 Year 2018 5.1 2019 11.6 2020 4.5 2018 2019 2020 0 0.5 1 1.5 2 2.5 3 Year Times per An 2018 2019 2020 0 20 40 60 80 100 120 140 76.68 117 128.07 Stock Days Year Days 2018 2019 2020 0 2 4 6 8 10 12 3.58 9.92 7.9 Debtors Payment Period Year Times per Annum 2018 2019 2020 0 20 40 60 80 100 120 101.1 36.79 46.2 Debt Collection Period Year Days 10 12 14 11.6 Creditors Payment Period m
Year 2018 71.17 2019 31.17 2020 81.11 Year 2018 0.67 2019 0.76 2020 0.71

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture