| A | B | C | D | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | Revenue | Margin | Margin % | Total Income | Total Income % | Retro bonus | Retro bonus % | Shrinks | Shrinks % | |
2 | ||||||||||
3 | Forecast | 153 000 000 | 39 780 000 | 26,0% | 39 780 000 | 26,0% | 4 590 000 | 3,0% | -4 590 000 | -3,0% |
4 | ||||||||||
5 | ||||||||||
6 | Current indicators | 117 250 176 | 29 036 392 | 24,8% | 27 368 978 | 23,3% | 3 043 038 | 2,6% | -4 710 453 | -4,0% |
7 | ||||||||||
8 | Execution to the forecast | -35 749 824 | -10 743 608 | -1,2% | -12 411 022 | -2,7% | -1 546 962 | -0,4% | -120 453 | -1,0% |
9 | Execution to the forecast % | -23,4% | -27,0% | -4,8% | -31,2% | -10,2% | -33,7% | -13,5% | ||
10 | ||||||||||
11 | ||||||||||
12 | After the changes | 158 038 362 | 40 837 504 | 25,8% | 41 155 723 | 26,0% | 4 741 151 | 3,0% | -4 422 932 | -2,8% |
13 | ||||||||||
14 | After the changes to the forecast | 5 038 362 | 1 057 504 | -0,2% | 1 375 723 | 0,0% | 151 151 | 0,0% | 167 068 | 0,2% |
15 | After the changes to the forecast % | 3,3% | 2,7% | -0,6% | 3,5% | 0,2% | 3,3% | 0,0% | -3,6% | |
16 | ||||||||||
17 | After the changes to the current one | 40 788 186 | 11 801 112 | 1,1% | 13 786 745 | 2,7% | 1 698 113 | 0,4% | 287 521 | 1,2% |
18 | After the changes to the current one % | 34,8% | 40,6% | 4,3% | 50,4% | 11,6% | 55,8% | 15,6% | ||
19 | ||||||||||
20 | ||||||||||
21 | Potential | 168 744 435 | 43 744 006 | 25,9% | 26,30% | 5 062 333 | 3,00% | -4 422 932 | -2,60% | -2,6% |
22 | ||||||||||
23 | The potential for the forecast | 15 744 435 | 3 964 006 | -0,1% | 0,30% | 472 333 | 0,00% | 167 068 | 0,40% | 0,4% |
24 | The potential for the forecast % | 10,3% | 10,0% | -0,3% | 1,2% | 10,3% | 0,0% | |||
25 | ||||||||||
26 | Potential for the current | 51 494 259 | 14 707 614 | 1,2% | 3,00% | 2 019 295 | 0,40% | 287 521 | 1,40% | 1,4% |
27 | Potential for the current % | 43,9% | 50,7% | 4,7% | 12,7% | 66,4% | 15,6% |