expand - 92.33 90% Perc = 128.87 95% Perc = 194.71 Filter...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 Expand for 40 million by 50%? r Volatility 0.08 100 104 -4 0.6 #NAME? #NAME? #NAME? #NAME? 40 0.5 Name Discounted value of cash flows DescriptionOutput Cell I5 Minimum = -91.88 Maximum = 987.5 Mean = 14.08 Std Deviati 95.02 Variance = 9029.21 Skewness 2.61 Kurtosis = 15.52 Errors Calc 0 Mode = -53.04 5% Perc = -72.91 10% Perc = -65.34 15% Perc = -59.2 20% Perc = -53.66 25% Perc = -48.33 30% Perc = -43.02 35% Perc = -37.73 40% Perc = -32.27 45% Perc = -24.78 50% Perc = -15.72 55% Perc = -5.88 60% Perc = 4.85 65% Perc = 16.87 70% Perc = 30.54 75% Perc = 46.76 80% Perc = 66.63 85% Perc =
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 92.33 90% Perc = 128.87 95% Perc = 194.71 Filter Minimum = Filter Maximum = Type (1 or 2) = # Values Fi Scenario #1>75% Scenario #2<25% Scenario #3>90% Current value Investment cost Value with no option Normal (0,1) Value One year from now Cash Flows in One Year Discounted value of cash flows Expansion cost Expansion factor A B C D E F G H I J K 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46...
View Full Document

Ask a homework question - tutors are online