Valuation Model
Valuation Model
2011 - 2020 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 PROMEDIO VALORES HISTORICOS
Sales growth                                                                          3.25%               1.56%              -7.66%              -0.89%              11.58%               9.03%              -4.20%               1.07%              -1.04%                                                                                 1.41%
Cost of goods sold                                               60.11%              53.13%              52.06%              52.25%              51.53%              51.19%              50.83%              56.30%              55.99%              56.55%                                                                                53.99%
SGA Expenses                                                     26.08%              33.28%              32.84%              31.27%              34.37%              34.01%              32.68%              25.14%              24.88%              24.98%                                                                                29.95%
Other Operating income/expense                                    0.31%              -0.14%               1.01%               1.98%              -0.66%              -0.46%              -1.01%               0.00%               0.00%               0.00%                                                                                 0.10%
Interest rate on financial debts (short and long term)                                4.35%               4.89%               4.27%               4.09%               3.85%               2.84%               2.89%               2.84%               2.43%                                                                                 3.61%
Interest rate on (short/long) term investments                                        9.25%               9.68%               9.24%              11.00%              10.75%              15.44%              10.13%              13.08%              13.13%                                                                                11.30%
% depreciation of PPE (and impairment)                           25.96%              25.98%              26.02%              27.87%              27.16%              25.73%              27.54%              20.57%              27.30%              24.05%                                                                                25.82%
Cash days
Accounts receivable days
Inventory days
Accounts payable days (Trade)
Accrued expenses/Total SGA Expenses
Capital Expenditures (CAPEX) PP&E
Capital Expenditures (CAPEX) Intangibles
Financial investments (Long-term)
Investment Property (related to PP&E)
Other non-current assets (related to sales)
Debt reduction (change) index (LT)
Change in common stocks (issuances/repurchases)
Dividend amount
Dividend payout (as a fraction of net profits)*
Depreciation (as %, related to past year)
Other current assets (related to Sales)
Prepaid expenses (growth-current asets)
Income tax payable
Other current liabilities (related to sales)
Other non-current liabilities (related to sales)
FINANCIAL ANALYSIS
                                                                                                                                                                                                                                                                                                                                                                                                                                                                  £ 107.87
LIQUIDITY
Current ratio                                                     0.7971              0.7681              0.6974              0.6286              0.6337              0.6754              0.7328              0.7681              0.7832              0.7846
Quick ratio                                                       0.5405              0.4876              0.4709              0.4164              0.4172              0.4673              0.5618              0.5547              0.5847              0.5679
Cash ratio                                                        0.1943              0.1559              0.1315              0.1095              0.1150              0.1645              0.1431              0.1603              0.1995              0.2694
EFFICIENCY RATIOS
Accounts receivable turnover                                    16.7047             18.3618             17.8602             17.7815             18.0050             15.2211             15.4213             11.5336             10.9687             14.7131
Inventory turnover                                               6.3221              6.1418              6.7360              6.3017              6.2429              6.0631              6.8046              6.5674              7.2501              6.4014
Accounts payable turnover                                        4.2985              3.8460              3.7912              3.4397              3.2622              3.0192              3.2810              3.0969              3.2850              3.4105
Collection period                                                 21.55               19.61               20.16               20.25               19.99               23.65               23.34               31.21               32.82               24.47 días
Days of inventory on hand                                         56.94               58.61               53.44               57.13               57.67               59.38               52.91               54.82               49.65               56.24 días
Payment period                                                    83.75               93.60               94.96              104.66              110.36              119.24              109.72              116.25              109.59              105.56 días
Operating cycle                                                                                                                                                                                               86.03               82.48               80.71 días
Cash Conversion Cycle                                                                                                                                                                                        -30.22              -27.11              -24.85 días
MARGINS
Gross profit margin                                              39.89%              46.87%              47.94%              47.75%              48.47%              48.81%              49.17%              43.70%              44.01%              43.45%
Operating margin                                                 13.51%              13.74%              14.09%              14.49%              14.76%              15.26%              17.50%              18.56%              19.14%              18.47%
Net profit margin                                                 8.87%               8.51%               9.72%              10.68%               9.21%               9.83%              11.27%              18.38%              10.82%              11.00%
PROFITABILITY RATIOS
ROA                                                              10.21%              10.58%              12.00%              12.22%              10.29%               9.81%              10.85%              16.26%              10.23%               9.17%
ROE                                                              28.76%              27.37%              33.43%              37.63%              30.09%              29.35%              41.54%              76.09%              42.02%              31.48%
ROIC                                                             16.90%              19.77%              20.31%              19.66%              18.64%              17.03%              17.35%              19.04%              17.85%              15.80%
FINANCIAL DEBT                                           £    11,430.95      £     8,462.36      £     9,404.60      £     9,685.13      £    10,481.28      £    14,267.17      £    21,632.16      £    24,029.20      £    23,782.76      £    24,282.24
EQUITY                                                   £    12,433.40      £    12,948.87      £    12,299.54      £    11,079.47      £    11,850.39      £    14,470.85      £    12,772.80      £    10,893.51      £    11,740.04      £    15,769.83
TOTAL INVESTED CAPITAL                                   £    23,864.35      £    21,411.23      £    21,704.14      £    20,764.60      £    22,331.67      £    28,738.02      £    34,404.96      £    34,922.71      £    35,522.80      £    40,052.07
TAX RATE                                                         25.96%              25.98%              26.02%              27.87%              27.16%              25.73%              27.54%              20.57%              27.30%              24.05%
NOPAT                                                    £     4,032.35      £     4,233.77      £     4,407.87      £     4,082.09      £     4,161.87      £     4,895.25      £     5,970.69      £     6,649.68      £     6,342.22      £     6,327.85
LEVERAGE RATIOS
Debt to Equity                                                      2.18                1.90                2.07                2.37                2.25                2.32                3.19                4.04                3.67                2.83
Debt to Total Assets                                             68.60%              65.47%              67.45%              70.30%              69.25%              69.91%              76.14%              80.17%              78.57%              73.91%
Equity multiplier                                                   3.18                2.90                3.07                3.37                3.25                3.32                4.19                5.04                4.67                3.83
                                                                                                                                                                                                                              COMMON SIZE INCOME STATEMENT                                                                                                    COMMON-SIZE BS VARIATIONS
Income Statement - Standardized (Currency: UK Pound
Sterling)
Field Name                                                30-12-2011       30-12-2012       30-12-2013      30-12-2014      30-12-2015       30-12-2016       30-12-2017       30-12-2018     30-12-2019     30-12-2020       2011            2012          2013       2014        2015          2016        2017        2018       2019        2020          2012        2013        2014        2015        2016        2017        2018        2019        2020
Revenues
Revenue from Business Activities - Total                  £    40,325.48 £      41,637.62 £     42,288.66 £     39,048.35 £      38,701.10 £      43,183.45 £      47,083.58 £      45,105.45 £    45,588.80 £    45,116.84   £      100.00    £ 100.00     £ 100.00    £ 100.00    £ 100.00      £ 100.00    £ 100.00   £ 100.00    £ 100.00   £ 100.00       £     -     £     -     £     -     £     -     £     -     £     -     £     -     £     -     £ -
Operating Expenses                                                                                                                                                                                                            £          -     £     -      £     -     £     -     £     -       £     -     £     -    £     -     £     -    £     -        £     -     £     -     £     -     £     -     £     -     £     -     £     -     £     -     £ -
Cost of Operating Revenue                                 £    24,238.51    £   22,120.09   £   22,016.91   £   20,402.92    £   19,941.91    £   22,104.97    £   23,934.92   £    25,394.49 £    25,523.76 £    25,513.20   £       60.11    £ 53.13      £ 52.06     £ 52.25     £ 51.53       £ 51.19     £ 50.83    £ 56.30     £ 55.99    £ 56.55       -£   6.98   -£   1.06    £   0.19   -£   0.72   -£   0.34   -£   0.35    £   5.47   -£   0.31    £ 0.56
Gross Profit - Industrials/Property - Total               £    16,086.97    £   19,517.53   £   20,271.75   £   18,645.43    £   18,759.19    £   21,078.48    £   23,148.66   £    19,710.96 £    20,065.04 £    19,603.64   £       39.89    £ 46.87      £ 47.94     £ 47.75     £ 48.47       £ 48.81     £ 49.17    £ 43.70     £ 44.01    £ 43.45        £   6.98    £   1.06   -£   0.19    £   0.72    £   0.34    £   0.35   -£   5.47    £   0.31   -£ 0.56
Selling, General & Administrative Expenses - Total        £    10,515.50    £   13,857.30   £   13,888.16   £   12,212.08    £   13,299.69    £   14,687.76    £   15,385.11   £    11,338.74 £    11,341.07 £    11,272.09   £       26.08    £ 33.28      £ 32.84     £ 31.27     £ 34.37       £ 34.01     £ 32.68    £ 25.14     £ 24.88    £ 24.98        £   7.20   -£   0.44   -£   1.57    £   3.09   -£   0.35   -£   1.34   -£   7.54   -£   0.26    £ 0.11
Other Operating Expense/(Income) - Net                    £       124.97   -£       59.22   £      425.46   £      773.94   -£      254.27   -£      200.71   -£      475.96                                                  £        0.31   -£ 0.14       £ 1.01      £ 1.98     -£ 0.66       -£ 0.46     -£ 1.01     £     -     £     -    £     -       -£   0.45    £   1.15    £   0.98   -£   2.64    £   0.19   -£   0.55    £   1.01    £     -     £ -
Operating Profit                                          £     5,446.50    £    5,719.45   £    5,958.13   £    5,659.41    £    5,713.77    £    6,591.43    £    8,239.51   £     8,372.22 £     8,723.97 £     8,331.55   £       13.51    £ 13.74      £ 14.09     £ 14.49     £ 14.76       £ 15.26     £ 17.50    £ 18.56     £ 19.14    £ 18.47        £   0.23    £   0.35    £   0.40    £   0.27    £   0.50    £   2.24    £   1.06    £   0.57   -£ 0.67
Non-Operating Expenses                                                                                                                                                                                                                                                                                                                                         £     -     £     -     £     -     £     -     £     -     £     -     £     -     £     -     £ -
Interest Income - Non-Bank                                 £      79.84 £         110.33 £         87.47 £         94.32 £         104.61 £          94.21 £         137.62 £         119.44 £       196.46 £       206.35     £       0.20 £        0.26 £        0.21 £     0.24 £      0.27 £        0.22 £      0.29 £      0.26 £     0.43 £      0.46    £   0.07   -£   0.06    £   0.03    £   0.03   -£   0.05    £   0.07   -£   0.03    £   0.17    £ 0.03
Interest Expense - Net of Capitalized Interest             £     465.16 £         425.11 £        422.06 £        391.81 £         401.02 £         468.59 £         498.75 £         646.74 £       669.19 £       575.48     £       1.15 £        1.02 £        1.00 £     1.00 £      1.04 £        1.09 £      1.06 £      1.43 £     1.47 £      1.28   -£   0.13   -£   0.02    £   0.01    £   0.03    £   0.05   -£   0.03    £   0.37    £   0.03   -£ 0.19
Non-Interest Financial Income/(Expense) - Total           -£      16.49 -£        128.99 -£       101.06 -£        39.50 -£         21.79 £           8.19 -£         68.37 -£          2.65 -£       26.31 -£       55.15    -£       0.04 -£       0.31 -£       0.24 -£    0.10 -£     0.06 £        0.02 -£     0.15 -£     0.01 -£    0.06 -£     0.12   -£   0.27    £   0.07    £   0.14    £   0.04    £   0.08   -£   0.16    £   0.14   -£   0.05   -£ 0.06
Equity Earnings/(Loss) - before Taxes including Non-
                                                          £       98.06 £          85.18 £         95.96 £         79.01 £          77.73 £         104.04 £         135.86 £         135.36 £       151.73 £       155.66    £        0.24 £        0.20 £        0.23 £     0.20 £      0.20 £        0.24 £      0.29 £      0.30 £     0.33 £      0.35   -£ 0.04 £ 0.02 -£ 0.02 -£ 0.00 £ 0.04 £ 0.05 £ 0.01 £ 0.03 £ 0.01
Recurring
Normalized Pre-tax Profit                                 £     5,142.75 £       5,360.86 £      5,618.44 £      5,401.43 £       5,473.30 £       6,329.28 £       7,945.87 £       7,977.63 £     8,376.66 £     8,062.93   £       12.75 £ 12.88 £ 13.29 £ 13.83 £ 14.14 £ 14.66 £ 16.88 £ 17.69 £ 18.37 £ 17.87                                            £ 0.12 £ 0.41 £ 0.55 £ 0.31 £ 0.51 £ 2.22 £ 0.81 £ 0.69 -£ 0.50
Non-Recurring Income/(Expense) - Total                    £       121.50 -£         60.85 £        422.91 £        762.65 -£        228.12 -£        210.54 -£        799.41 £       2,957.66 -£    1,106.83 -£      950.83   £        0.30 -£ 0.15 £ 1.00 £ 1.95 -£ 0.59 -£ 0.49 -£ 1.70 £ 6.56 -£ 2.43 -£ 2.11                                              -£ 0.45 £ 1.15 £ 0.95 -£ 2.54 £ 0.10 -£ 1.21 £ 8.26 -£ 8.99 £ 0.32
Pre-Tax Income                                            £     5,264.25 £       5,300.01 £      6,041.35 £      6,164.08 £       5,245.18 £       6,118.74 £       7,146.46 £      10,935.29 £     7,269.83 £     7,112.10   £       13.05 £ 12.73 £ 14.29 £ 15.79 £ 13.55 £ 14.17 £ 15.18 £ 24.24 £ 15.95 £ 15.76                                           -£ 0.33 £ 1.56 £ 1.50 -£ 2.23 £ 0.62 £ 1.01 £ 9.07 -£ 8.30 -£ 0.18
Taxes
Income Taxes                                              £     1,366.83 £       1,376.73 £      1,571.91 £      1,717.98 £       1,424.63 £       1,574.54 £       1,967.84 £       2,249.88 £     1,984.75 £     1,710.43   £        3.39 £        3.31 £ 3.72 £ 4.40 £                 3.68 £ 3.65 £ 4.18 £ 4.99 £ 4.35 £ 3.79                             -£ 0.08 £ 0.41 £ 0.68 -£ 0.72 -£ 0.03 £ 0.53 £ 0.81 -£ 0.63 -£ 0.56
Net Income After Tax                                                                                                                                                                                                          £          - £           - £     - £     - £                  - £     - £     - £     - £     - £     -                          £   - £    - £    - £     - £     - £    - £    - £     - £ -
Net Income after Tax                                      £     3,897.42 £       3,923.28 £      4,469.44 £      4,446.10 £       3,820.55 £       4,544.20 £       5,178.62 £       8,685.41 £     5,285.08 £     5,401.67   £        9.66 £        9.42 £ 10.57 £ 11.39 £               9.87 £ 10.52 £ 11.00 £ 19.26 £ 11.59 £ 11.97                        -£ 0.24 £ 1.15 £ 0.82 -£ 1.51 £ 0.65 £ 0.48 £ 8.26 -£ 7.66 £ 0.38
After Tax Income/Expense
Income before Discontinued Operations & Extraordinary
Items                                                 £         3,897.43 £       3,923.30 £      4,469.45 £      4,446.11 £       3,820.56 £       4,544.20 £       5,178.62    £    8,685.42 £     5,285.07 £     5,401.67   £        9.66   £      9.42   £ 10.57 £ 11.39 £             9.87   £ 10.52 £ 11.00 £ 19.26 £ 11.59 £ 11.97                      -£ 0.24 £ 1.15 £ 0.82 -£ 1.51 £ 0.65 £ 0.48 £                                8.26   -£   7.66   £ 0.38
Extraordinary Activities - after Tax - Gain/(Loss)                                                                                                          £         506.64   -£       25.66 £           -                   £          -    £        -    £    - £     - £                -    £    -  £ 1.08 -£ 0.06 £     - £     -                        £   - £     - £     - £     - £    - £ 1.08 -£                              1.13    £   0.06   £ -
Net Income before Minority Interest                   £         3,897.43 £       3,923.30 £      4,469.45 £      4,446.11 £       3,820.56 £       4,544.20 £       5,685.27    £    8,659.77 £     5,285.07 £     5,401.67   £        9.66   £      9.42   £ 10.57 £ 11.39 £             9.87   £ 10.52 £ 12.07 £ 19.20 £ 11.59 £ 11.97                      -£ 0.24 £ 1.15 £ 0.82 -£ 1.51 £ 0.65 £ 1.55 £                                7.12   -£   7.61   £ 0.38
Minority Interest                                     £           321.97 £         379.67 £        357.52 £        277.33 £         254.27 £         297.38 £         379.54    £      370.70 £       351.70 £       437.61   £        0.80   £      0.91   £ 0.85 £ 0.71 £               0.66   £ 0.69 £ 0.81 £ 0.82 £ 0.77 £ 0.97                            £ 0.11 -£ 0.07 -£ 0.14 -£ 0.05 £ 0.03 £ 0.12 £                              0.02   -£   0.05   £ 0.20
Net Income after Minority Interest (Income available to
common shares)                                            £     3,575.46 £       3,543.63 £      4,111.93 £      4,168.78 £       3,566.29 £       4,246.82 £       5,305.72 £       8,289.06 £     4,933.37 £     4,964.06   £        8.87 £        8.51 £        9.72 £ 10.68 £         9.21 £        9.83 £ 11.27 £ 18.38 £ 10.82 £ 11.00                  -£ 0.36 £ 1.21 £ 0.95 -£ 1.46 £ 0.62 £ 1.43 £ 7.11 -£ 7.56 £ 0.18