Spreadsheet: 113301d1309263437-calculate-the-discounted-cash-flow-and-net-present-value-business-case-omv-petrom-v1
Sheet: Assumptions centralized

General Assumptions
Severance Payments | SR | BG | MD | RO
Average Personnel Costs | 567.7451246571428 | 1691.358835273585 | 118.6773250379245 | 13458.68776267143
Severance Payments | 17603.07866521875 | 26174.70631987689 | 10648.09492787959 | 41949.30561057739
Average gross salary p.p | 2560.44780585 | 3734.797572396226 | 1415.029226296291 | 1415.029226296291
1.Expenses
 |  |  |  |  |  | 1.a. Severance Payments | 321 Petrom
 | 321  Petrom |  |  |  |  | BU | OMV SR | OMV BG | OMV MD | OMV RO | Total | Displacements | Act. reduced by Deplacement | Total | Savings | Severance Payments 321 Petrom
Average Severance Payments | 24093.79638088815 |  |  |  |  |  | Actual FTE | Actual FTE | Actual FTE | Actual FTE | Actual |  |  | Target FTE | FTE | EUR
 |  |  |  |  |  | Commercial | 6 | 6 | 6 | 6 | 24 | 4 | 20 | 56 | -36 | -867376.6697119735
 |  |  |  |  |  | Finance | 14 | 14 | 14 | 14 | 56 | 4 | 52 | 136 | -84 | -2023878.895994605
 |  |  |  |  |  | Retail | 18 | 29 | 18 | 18 | 83 | 4 | 79 | 156 | -77 | -1832332.311999512
 |  |  |  |  |  | Supply & Logistics | 4 | 4 | 4 | 4 | 16 | 4 | 12 | 36 | -24 | -578251.1131413156
 |  |  |  |  |  | Total | 42 | 53 | 42 | 42 | 179 | 16 | 163 | 384 | -221 | -5301838.990847406
Recruiting Costs Estimations |  |  |  |  |  |  | Costs 321 Petrom | Replacements FTE 321 Petrom |  |  |  |  |  |  |  | Total 321  Petrom
Salary Average 321 Petrom | 2281.325957709702 |  |  |  |  | 1.b. Recruiting Costs per Person 321
Relocation Costs Estimations | 321  Petrom |  |  |  |  |  | Costs p.a. | Years | Relocated |  |  |  |  |  |  | Total 321  Petrom
Costs p.a. / [NAME] (EUR) | 143925.3736702 |  |  |  |  | 1.c. Relocation Costs | 143925.3736702 | 1 | 16 |  |  |  |  |  |  | 2302805.9787232
Years to pay | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total 321  Petrom
 |  |  |  |  |  | 1.d. External Consulting Costs |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 1.e. Internal Consulting Costs |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 1.f.  Contingency Costs |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 1.g  Other |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Total |  |  |  |  | ? |  |  |  |  | 0
2. Benefits
 |  |  |  |  |  | 2.a. Salary Benefits
 |  |  |  |  |  | Business Unit | Mgt. Level | Employee Level | Annual Costs Mgt | Annual Costs Empl. | Savings Mgt | Savings Empl | Yearly Increase |  |  | Total Savings p.a.
 |  |  |  |  |  | SR |  |  |  |  |  |  |  |  |  | -2027069.018968629
 |  |  |  |  |  | Commercial |  | -8 |  | 37538.31516608572 |  | -300306.5213286857 |  |  |  | -300306.5213286857
 |  |  |  |  |  | Finance |  | -20 |  | 37538.31516608572 |  | -750766.3033217144 |  |  |  | -750766.3033217144
 |  |  |  |  |  | Retail |  | -21 |  | 37538.31516608572 |  | -788304.6184878001 |  |  |  | -788304.6184878001
 |  |  |  |  |  | Supply & Logistics |  | -5 |  | 37538.31516608572 |  | -187691.5758304286 |  |  |  | -187691.5758304286
 |  |  |  |  |  | BG |  |  |  |  |  |  |  |  |  | -2799896.706357623
 |  |  |  |  |  | Commercial |  | -8 |  | 65113.87689203773 |  | -520911.0151363019 |  |  |  | -520911.0151363019
 |  |  |  |  |  | Finance |  | -20 |  | 65113.87689203773 |  | -1302277.537840755 |  |  |  | -1302277.537840755
 |  |  |  |  |  | Retail |  | -10 |  | 65113.87689203773 |  | -651138.7689203774 |  |  |  | -651138.7689203774
 |  |  |  |  |  | Supply & Logistics |  | -5 |  | 65113.87689203773 |  | -325569.3844601887 |  |  |  | -325569.3844601887
 |  |  |  |  |  | MD |  |  |  |  |  |  |  |  |  | -993841.8452645713
 |  |  |  |  |  | Commercial |  | -8 |  | 18404.47861601058 |  | -147235.8289280846 |  |  |  | -147235.8289280846
 |  |  |  |  |  | Finance |  | -20 |  | 18404.47861601058 |  | -368089.5723202116 |  |  |  | -368089.5723202116
 |  |  |  |  |  | Retail |  | -21 |  | 18404.47861601058 |  | -386494.0509362222 |  |  |  | -386494.0509362222
 |  |  |  |  |  | Supply & Logistics |  | -5 |  | 18404.47861601058 |  | -92022.39308005289 |  |  |  | -92022.39308005289
 |  |  |  |  |  | RO |  |  |  |  |  |  |  |  |  | -16316364.56516537
 |  |  |  |  |  | Commercial |  | -8 |  | 302154.8993549143 |  | -2417239.194839315 |  |  |  | -2417239.194839315
 |  |  |  |  |  | Finance |  | -20 |  | 302154.8993549143 |  | -6043097.987098286 |  |  |  | -6043097.987098286
 |  |  |  |  |  | Retail |  | -21 |  | 302154.8993549143 |  | -6345252.886453201 |  |  |  | -6345252.886453201
 |  |  |  |  |  | Supply & Logistics |  | -5 |  | 302154.8993549143 |  | -1510774.496774571 |  |  |  | -1510774.496774571
 |  |  |  |  |  | Total 321 |  |  |  |  |  |  |  |  |  | -22137172.13575619
 |  |  |  |  |  | Total 321 + Yearly Increase |  |  |  |  |  |  | ?formula |  |  | #N/A
 |  |  |  |  |  | Additional Benefits | Average p.a. 321 Petrom in K EUR | Reduced FTE 321 Petrom |  |  |  |  |  |  |  | Total 321 Petrom
 |  |  |  |  |  | 2.b. Average IT costs p.a. (per employee) | 24257.91523044716 | -221 |  |  |  |  |  |  |  | -5360999.265928822
 |  |  |  |  |  | 2.c. Average office costs p.a. (per employee) |  | -221 |  |  |  |  |  |  |  | 0
Savings for Replacements |  |  |  |  |  |  | Target Org | % of target org. to be replaced | Number of Replacement | % of Replacement Savings | Average Personell cost
% of target org. to be replaced | 0.1 |  |  |  |  | 2.d. Savings for Replacements | 384 | 0.1 | 38.40000000000001 | 0.15 | 2281.325957709702 |  |  |  |  | 13140.43751640788
% of replacement savings | 0.15 |  |  |  |  |  | Savings 321 Petrom p.a. |  |  |  |  |  |  |  |  | Total 321 Petrom
 |  |  |  |  |  | 2.e. Purchasing |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total 321  Petrom
 |  |  |  |  |  | 2.f. Other Savings |  |  |  |  |  |  |  |  |  | -148046.3584164291
 |  |  |  |  |  | Telecommunications |  |  |  |  |  |  |  |  |  | -148046.3584164291
 |  |  |  |  |  | Company Cars
 |  |  |  |  |  | Other
 |  |  |  |  |  | 3. Relocation Savings
3. Totals - Expenses and Savings
Total Savings | -27633077.32258504
Total Savings + Yearly Increase
Total Costs | -2999033.012124206