Forecast : Total Expenses Chart Source Data
  Bin Interval Probability Frequency Percentiles
1 365.29 To 368,85 0,0004 2 0,0004
2 368,85 To 372,42 0 0 0,0004
3 372,42 To 375,99 0 0 0,0004
4 375,99 To 379,56 0 0 0,0004
5 379,56 To 383,12 0,0006 3 0,001
6 383,12 To 386,69 0,0008 4 0,0018
7 386,69 To 390,26 0,0004 2 0,0022
8 390,26 To 393,82 0,0014 7 0,0036
9 393,82 To 397,39 0,0028 14 0,0064
10 397,39 To 400,96 0,003 15 0,0094
11 400,96 To 404,53 0,0054 27 0,0148
12 404,53 To 408,09 0,0078 39 0,0226
13 408,09 To 411,66 0,0096 48 0,0322
14 411,66 To 415,23 0,0146 73 0,0468
15 415,23 To 418,79 0,0174 87 0,0642
16 418,79 To 422,36 0,0266 133 0,0908
17 422,36 To 425,93 0,0272 136 0,118
18 425,93 To 429,5 0,0352 176 0,1532
Forecast Definition 19 429,5 To 433,06 0,0414 207 0,1946
Location within the Model: [Advanced Model.xls] Balance sheet ! C6 20 433,06 To 436,63 0,0466 233 0,2412
Influenced by Assumptions: Employee Expense 68,48 % 21 436,63 To 440,2 0,0528 264 0,294
      Operating Expense 28,17 % 22 440,2 To 443,76 0,0552 276 0,3492
      Finance costs 3,35 % 23 443,76 To 447,33 0,0618 309 0,411
24 447,33 To 450,9 0,0664 332 0,4774
Basic Chart Statistics 25 450,9 To 454,46 0,0704 352 0,5478
Number of Trials:   5000 26 454,46 To 458,03 0,0596 298 0,6074
Number of Bins:   50 27 458,03 To 461,6 0,066 330 0,6734
Minimum Value:   365,29 28 461,6 To 465,17 0,057 285 0,7304
Maximum Value:   543,64 29 465,17 To 468,73 0,057 285 0,7874
Chart Range:   178,35 30 468,73 To 472,3 0,0446 223 0,832
Single Bin Range:   3,57 31 472,3 To 475,87 0,0384 192 0,8704
32 475,87 To 479,43 0,0298 149 0,9002
Simulation Output Values 33 479,43 To 483 0,0202 101 0,9204
Arithmetic Mean:   451,9007 34 483 To 486,57 0,0202 101 0,9406
Median:     452,077 35 486,57 To 490,14 0,0168 84 0,9574
Mode:     452,68 36 490,14 To 493,7 0,0142 71 0,9716
Standard Deviation:   21,7802 37 493,7 To 497,27 0,0096 48 0,9812
Variance:     474,3772 38 497,27 To 500,84 0,007 35 0,9882
Skewness:   -0,0042 39 500,84 To 504,4 0,0044 22 0,9926
Excess Kurtosis:   0,076 40 504,4 To 507,97 0,0022 11 0,9948
Highest Probability:   0,0704 41 507,97 To 511,54 0,0022 11 0,997
42 511,54 To 515,1 0,001 5 0,998
Sensitivity Analysis 43 515,1 To 518,67 0,0008 4 0,9988
 
44 518,67 To 522,24 0,0004 2 0,9992
45 522,24 To 525,81 0,0004 2 0,9996
46 525,81 To 529,37 0 0 0,9996
47 529,37 To 532,94 0,0002 1 0,9998
48 532,94 To 536,51 0 0 0,9998
49 536,51 To 540,07 0 0 0,9998
50 540,07 To 543,64 0,0002 1 1