Revenue Management Home Insert Draw Page Layout Formulas Data Review View Automate 8 Tell me X Calibri (Body) 12 V A^ A = = 9€ ab Wrap Text v General V Paste BIU V Hv { v Av Merge & Center v $ + % , .00 Conditional For Formatting as 1 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? E15 × V fx A B C D E F G H 1 Monte Carto Simulation using What If Analysis 2 3 4 Revenue FC VC 5 Expected 194,500 6 St.Dev. 7 60,000 100,000 15,000 4,000 40,000 8 First.Simulation 9 194,789 60,032 115,815 10 11 mean 12 sd 13 Min 14 Max 15 31920.072 43844.593 -101412.2 157193.18 16 Risk of loss 17 23% 18 19 20 21 22 23 24 25 26 27 28 29 30 Profits 18,941 Trial Profits - J K L M N 1 18,941 2 -65697.213 3 4482.7047 4 35161.716 5 97123.434 6 18352.385 7 -4661.7577 8 -5312.0064 9 7566.9679 10 56175.053 11 51946.452 12 69749.879 13 58865.453 14 -21682.393 15 48592.749 16 19847.012 17 42377.674 18 99940.137 19 -2473.0688 20 -5548.2006 21 40936.983 22 107376.16 23 85253.052 24 13140.061 25 -29845.566 26 19985.148 27 88363.547
Stock price simulation: 1 Staring Price $620 2 Annual Volatility 30.42% 3 Daily Volatility 1.92% 4 Days in Furture Simulated Price 5 Mean Price $ 614.86 6 Median Price $ 612.04 7 Standard Deviation $ 55.23 8 Precentiles 5 $587.34 9 5% $ 526.28 1 $602.13 2 $610.26 3 $612.33 4 $602.72 6 $589.93 10 95% $ 714.62 7 $599.33 11 25% $ 578.08 8 $619.69 12 75% $ 649.84 9 $623.34 13 10 $611.40 $ 640.00 Chart Title 14 $ 630.00 15 $620.00 12 $618.95 12 507.225827 16 $ 610.00 13 $605.76 13 749.820768 17 $600.00 14 $617.43 14 597.63566 18 $ 590.00 15 $610.09 19 $580.00 16 $608.79 20 $570.00 17 $610.64 21 $ 560.00 18 $604.51 22 11 $629.32 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 19 $616.37 23 20 24 21 $615.32 25 26 27 28 29 30 $630.89 $615.32 1 607.006986 2 597.580603 3 610.544679 4 608.132826 5 683.343468 6 662.828039 7 668.315533 8 637.947504 9 617.43119 10 612.533116 11 504.975109 15 702.100533 16 652.638509 17 565.984087 18 619.65416 19 618.168229 20 596.818539 21 625.002533 22 593.562897 23 555.213505 24 612.665939 25 661.060599 26 514.994951 27 605.361112