Spreadsheet: 780047d1652270105-help-with-summary-tables-using-average-index-and-match-sample_model
Sheet: Input

Broker |  | ABC |  |  |  |  |  |  |  |  |  |  |  |  |  | DEF |  |  |  |  |  |  |  |  |  |  |  |  |  | GHI |  |  |  |  |  |  |  |  |  |  |  |  |  | JKL |  |  |  |  |  |  |  |  |  |  |  |  |  | MNO
Name
Date current report |  | 2022-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-25 00:00:00
Current reco |  | Buy |  |  |  |  |  |  |  |  |  |  |  |  |  | Buy |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  | Buy |  |  |  |  |  |  |  |  |  |  |  |  |  | Buy
Current TP |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Date previous change |  | 2022-03-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-02-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-03-03 00:00:00
Previous reco |  | Buy |  |  |  |  |  |  |  |  |  |  |  |  |  | Sell |  |  |  |  |  |  |  |  |  |  |  |  |  | Neutral |  |  |  |  |  |  |  |  |  |  |  |  |  | Sell |  |  |  |  |  |  |  |  |  |  |  |  |  | Buy
Previous TP |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
Model date |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-25 00:00:00
€m |  | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | FY 2022 | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023 | FY 2023 | FY 2024 | FY 2025 | FY 2026 |  | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | FY 2022 | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023 | FY 2023 | FY 2024 | FY 2025 | FY 2026
New orders |  | 12 | 12.6 | 13.23 | 13.8915 | 51.72150000000001 | 15 | 15.75 | 16.5375 | 17.364375 | 64.651875 | 67.88446875000001 | 71.27869218750001 | 74.84262679687502 |  | 14 | 14.7 | 15.435 | 16.20675 | 60.34175 | 18 | 18.9 | 19.845 | 20.83725 | 77.58225000000002 | 81.46136250000002 | 85.53443062500003 | 89.81115215625003 |  | - | - | - | - | - | - | - | - | - | - | - | - | - |  | 20 | 21 | 22.05 | 23.1525 | 86.2025 | 26 | 27.3 | 28.665 | 30.09825 | 112.06325 | 117.6664125 | 123.549733125 | 129.72721978125 |  | 26 | 27.3 | 28.665 | 30.09825 | 112.06325 | 27 | 28.35 | 29.7675 | 31.255875 | 116.373375 | 122.19204375 | 128.3016459375 | 134.716728234375
Revenue BU 1 |  | 20 | 21 | 22.05 | 23.1525 | 86.2025 | 23 | 24.15 | 25.3575 | 26.625375 | 99.13287500000001 | 104.08951875 | 109.2939946875 | 114.758694421875 |  | 24 | 25.2 | 26.46 | 27.783 | 103.443 | 23 | 24.15 | 25.3575 | 26.625375 | 99.13287500000001 | 104.08951875 | 109.2939946875 | 114.758694421875 |  | - | - | - | - | - | - | - | - | - | - | - | - | - |  | 27 | 28.35 | 29.7675 | 31.255875 | 116.373375 | 26 | 27.3 | 28.665 | 30.09825 | 112.06325 | 117.6664125 | 123.549733125 | 129.72721978125 |  | 30 | 31.5 | 33.075 | 34.72875000000001 | 129.30375 | 33 | 34.65 | 36.3825 | 38.201625 | 142.234125 | 149.34583125 | 156.8131228125 | 164.653778953125
Revenue BU 2 |  | 27 | 28.35 | 29.7675 | 31.255875 | 116.373375 | 23 | 24.15 | 25.3575 | 26.625375 | 99.13287500000001 | 104.08951875 | 109.2939946875 | 114.758694421875 |  | 29 | 30.45 | 31.9725 | 33.571125 | 124.993625 | 23 | 24.15 | 25.3575 | 26.625375 | 99.13287500000001 | 104.08951875 | 109.2939946875 | 114.758694421875 |  | - | - | - | - | - | - | - | - | - | - | - | - | - |  | 28 | 29.4 | 30.87 | 32.41350000000001 | 120.6835 | 25 | 26.25 | 27.5625 | 28.940625 | 107.753125 | 113.14078125 | 118.7978203125 | 124.737711328125 |  | 31 | 32.55 | 34.17750000000001 | 35.88637500000001 | 133.613875 | 34 | 35.7 | 37.48500000000001 | 39.35925000000001 | 146.54425 | 153.8714625 | 161.565035625 | 169.64328740625
Total revenue |  | 47 | 49.35 | 51.8175 | 54.40837500000001 | 202.575875 | 46 | 48.3 | 50.715 | 53.25075 | 198.26575 | 208.1790375 | 218.5879893750001 | 229.5173888437501 |  | 53 | 55.65000000000001 | 58.4325 | 61.35412500000001 | 228.436625 | 46 | 48.3 | 50.715 | 53.25075 | 198.26575 | 208.1790375 | 218.5879893750001 | 229.5173888437501 |  | - | - | - | - | - | - | - | - | - | - | - | - | - |  | 55 | 57.75 | 60.6375 | 63.66937500000001 | 237.056875 | 51 | 53.55 | 56.22750000000001 | 59.038875 | 219.816375 | 230.80719375 | 242.3475534375 | 254.464931109375 |  | 61 | 64.05000000000001 | 67.25250000000001 | 70.615125 | 262.917625 | 67 | 70.35 | 73.8675 | 77.56087500000001 | 288.778375 | 303.21729375 | 318.3781584375 | 334.297066359375
Cost of sales |  | -42.3 | -44.415 | -46.63575 | -48.96753750000001 | -182.3182875 | -41.4 | -43.47000000000001 | -45.6435 | -47.92567500000001 | -178.439175 | -187.3611337500001 | -196.7291904375001 | -206.5656499593751 |  | -47.17 | -49.52850000000001 | -52.004925 | -54.60517125000001 | -203.30859625 | -40.94 | -42.987 | -45.13635 | -47.3931675 | -176.4565175 | -185.2793433750001 | -194.5433105437501 | -204.2704760709375 |  | - | - | - | - | - | - | - | - | - | - | - | - | - |  | -48.4 | -50.82 | -53.361 | -56.02905000000001 | -208.61005 | -44.88 | -47.124 | -49.4802 | -51.95421 | -193.43841 | -203.1103305 | -213.265847025 | -223.92913937625 |  | -53.07 | -55.72350000000001 | -58.50967500000001 | -61.43515875000001 | -228.73833375 | -58.29 | -61.2045 | -64.264725 | -67.47796125 | -251.23718625 | -263.7990455625 | -276.988997840625 | -290.8384477326563
Gross profit |  | 4.7 | 4.935 | 5.181750000000001 | 5.440837500000001 | 20.2575875 | 4.600000000000001 | 4.830000000000001 | 5.0715 | 5.325075000000001 | 19.82657500000001 | 20.81790375000001 | 21.85879893750001 | 22.95173888437501 |  | 5.83 | 6.121500000000001 | 6.427575000000001 | 6.748953750000001 | 25.12802875 | 5.06 | 5.313000000000001 | 5.578650000000001 | 5.8575825 | 21.8092325 | 22.89969412500001 | 24.04467883125001 | 25.24691277281251 |  | - | - | - | - | - | - | - | - | - | - | - | - | - |  | 6.6 | 6.93 | 7.2765 | 7.640325000000001 | 28.446825 | 6.12 | 6.425999999999999 | 6.7473 | 7.084665 | 26.377965 | 27.69686325 | 29.0817064125 | 30.53579173312501 |  | 7.930000000000001 | 8.326500000000001 | 8.742825000000002 | 9.179966250000001 | 34.17929125000001 | 8.71 | 9.1455 | 9.602775000000001 | 10.08291375 | 37.54118875 | 39.41824818750001 | 41.389160596875 | 43.45861862671875
Gross margin |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 |  | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 |  | - | - | - | - | - | - | - | - | - | - | - | - | - |  | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 |  | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13 | 0.13
Net profit |  | 2.35 | 2.4675 | 2.590875 | 2.72041875 | 10.12879375 | 2.3 | 2.415 | 2.53575 | 2.6625375 | 9.913287500000003 | 10.408951875 | 10.92939946875 | 11.4758694421875 |  | 2.915 | 3.060750000000001 | 3.2137875 | 3.374476875 | 12.564014375 | 2.53 | 2.6565 | 2.789325 | 2.92879125 | 10.90461625 | 11.4498470625 | 12.022339415625 | 12.62345638640625 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.3 | 3.465 | 3.63825 | 3.8201625 | 14.2234125 | 3.06 | 3.213 | 3.37365 | 3.5423325 | 13.1889825 | 13.848431625 | 14.54085320625 | 15.2678958665625 |  | 3.965 | 4.163250000000001 | 4.371412500000001 | 4.589983125000001 | 17.089645625 | 4.355 | 4.57275 | 4.801387500000001 | 5.041456875000001 | 18.770594375 | 19.70912409375 | 20.6945802984375 | 21.72930931335938