Ejemplo de Informe Gerencial
Ejemplo de Informe Gerencial
Ejemplo de Informe Gerencial
18.0%
MESES
Inversin
2,114,874,011.77
Ingresos
Egresos
Flujo de Caja
-2,114,874,011.77
468,000,000.00
42,231,987.06
425,768,012.94
468,000,000.00
42,231,987.06
425,768,012.94
468,000,000.00
42,231,987.06
425,768,012.94
468,000,000.00
42,231,987.06
425,768,012.94
468,000,000.00
42,231,987.06
400,768,012.94
468,000,000.00
42,231,987.06
425,768,012.94
468,000,000.00
42,231,987.06
425,768,012.94
468,000,000.00
42,231,987.06
425,768,012.94
468,000,000.00
42,231,987.06
425,768,012.94
468,000,000.00
42,231,987.06
400,768,012.94
11
468,000,000.00
42,231,987.06
425,768,012.94
12
468,000,000.00
42,231,987.06
425,768,012.94
13
468,000,000.00
42,231,987.06
425,768,012.94
14
468,000,000.00
42,231,987.06
425,768,012.94
468,000,000.00
42,231,987.06
637,255,414.12
-25000000
10
15
-25000000
211487401.2
VPN
TIR
Bs. 54,915,096.30
19%
Cell: E25
Median
Standard Deviation
Variance
Skewness
Kurtosis
Coeff. of Variability
Range Minimum
Range Maximum
Range W idth
Mean Std. Error
Forecast: V PN
10,000 T ri als
Frequency Chart
9,896 Di splayed
. 016
159
. 012
119. 2
. 008
79.5
. 004
39.75
. 000
-$80,527,991.30
-$13,220,351.29
$121, 394,928.72
$188, 702,568.73
Cell: E25
Percentiles:
Percentile
0%
10%
20%
30%
40%
BS
-$158,657,245.15
-$10,588,472.60
$12,515,961.23
$27,614,176.33
$41,720,126.40
Cell: E27
Summary:
Certainty Level is 16.31%
Certainty Range is from 19% to +Infinity %
Display Range is from 18% to 20% %
Entire Range is from 17% to 20% %
After 10,000 Trials, the Std. Error of the Mean is 0%
Statistics:
Trials
Mean
Median
Mode
Standard Deviation
Variance
Skewness
Kurtosis
Coeff. of Variability
Range Minimum
Range Maximum
Range W idth
Mean Std. Error
Value
10000
19%
19%
--0%
0%
0.11
3.06
0.02
17%
20%
3%
0.00%
Freq u en cy Cha rt
.023
229
.017
171.7
.011
114.5
.006
57.25
.000
0
18%
18%
19%
19%
20%
Cell: E27
Percentiles:
Percentile
0%
10%
20%
30%
40%
%
17%
18%
18%
18%
18%
TMAR
ANUAL
18.0%
MESES
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Inversion
2,114,874,011.77
-25000000
-25000000
211487401.2
Ingresos
Egresos
378,000,000.00
378,000,000.00
378,000,000.00
378,000,000.00
378,000,000.00
378,000,000.00
378,000,000.00
378,000,000.00
378,000,000.00
378,000,000.00
378,000,000.00
378,000,000.00
378,000,000.00
378,000,000.00
378,000,000.00
42,231,987.06
42,231,987.06
42,231,987.06
42,231,987.06
42,231,987.06
42,231,987.06
42,231,987.06
42,231,987.06
42,231,987.06
42,231,987.06
42,231,987.06
42,231,987.06
42,231,987.06
42,231,987.06
42,231,987.06
VPN
-Bs 403,326,884.01
TIR
14%
Flujo de Caja
-2,114,874,011.77
335,768,012.94
335,768,012.94
335,768,012.94
335,768,012.94
310,768,012.94
335,768,012.94
335,768,012.94
335,768,012.94
335,768,012.94
310,768,012.94
335,768,012.94
335,768,012.94
335,768,012.94
335,768,012.94
547,255,414.12
Cell: E25
Summary:
Certainty Level is 0.33%
Certainty Range is from -$320,382,448.90 to +Infinity BS
Display Range is from -$482,077,032.13 to -$320,382,448.90 BS
Entire Range is from -$514,755,882.58 to -$273,350,748.84 BS
After 10,000 Trials, the Std. Error of the Mean is $317,185.31
Statistics:
Trials
Mean
Median
Mode
Standard Deviation
Variance
Skewness
Kurtosis
Coeff. of Variability
Range Minimum
Range Maximum
Range W idth
Mean Std. Error
Value
10000
-$403,188,905.33
-$403,560,574.59
--$31,718,531.27
1.01E+15
-0.02
2.97
-0.08
-$514,755,882.58
-$273,350,748.84
$241,405,133.74
$317,185.31
Fore cast: VP N
1 0,0 0 0 T ria l s
Freq u en cy Cha rt
.022
217
.016
162.7
.011
108.5
.005
54.25
.000
-$482,077,032.13
-$441,653,386.32
-$401,229,740.51
-$360,806,094.70
-$320,382,448.90
Cell: E25
Percentiles:
Percentile
0%
10%
20%
30%
40%
BS
-$514,755,882.58
-$443,771,629.08
-$429,661,284.43
-$419,779,686.82
-$411,409,885.35
Cell: E27
Summary:
Certainty Level is 10.37%
Certainty Range is from 14% to +Infinity %
Display Range is from 13% to 14% %
Entire Range is from 13% to 15% %
After 10,000 Trials, the Std. Error of the Mean is 0%
Statistics:
Trials
Mean
Median
Mode
Standard Deviation
Variance
Skewness
Kurtosis
Coeff. of Variability
Range Minimum
Range Maximum
Range W idth
Mean Std. Error
Value
10000
14%
14%
--0%
0%
0.05
3.02
0.02
13%
15%
2%
0.00%
Freq u en cy Cha rt
.023
226
.017
169.5
.011
113
.006
56.5
.000
0
13%
13%
14%
14%
14%
Cell: E27
Percentiles:
Percentile
0%
10%
20%
30%
40%
%
13%
13%
13%
13%
14%