abandonment - 4590.25 65% 21442.46 70% 38725.32 75%...

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

View Full Document Right Arrow Icon
Sheet1 Page 1 Abandonment Abandonment value $500,000.00 r Volatility Current Price Normal(0,1) 0.05 0.28 $553,000.00 #ADDIN? #ADDIN? #ADDIN? #ADDIN? Outputs Discounted value Simulations 1 Statistics / Cell $G$4 Minimum 0 Maximum 280536.9 Mean 34,092.91 Standard Deviation 54,870.25 Variance 3.01E+09 Skewness 1.66 Kurtosis 4.97 NumErrs 0 Mode 0.00 5% 0.00 10% 0.00 15% 0 20% 0 25% 0 30% 0 35% 0 40% 0 45% 0 50% 0 55% 0 60%
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 4590.25 65% 21442.46 70% 38725.32 75% 56629.09 80% 75891.44 85% 97239.83 90% 122114.8 95% 156315.4 Price 1 year from now Value of Option Discounted value A B C D E F G H I J 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...
View Full Document

This note was uploaded on 03/17/2010 for the course ACCT acct 4360 taught by Professor Robert during the Spring '10 term at DeVry Colorado Springs.

Ask a homework question - tutors are online