{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

MonteCarlo - Variable marketsize marketshare price...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Variable Expected value r NPV Expected -1.5 market size 120000 0.1 $547,024.86  -1 market share 0.25 0.11 $495,784.39  -0.5 price 120 0.12 $446,579.15  0 variable cost 70 0.13 $399,304.88  0.5 fixed cost 800000 0.14 $353,863.72  1 investment 1500000 0.15 $310,163.75  1.5 0.16 $268,118.57  2 revenue 3600000 0.17 $227,646.93  2.5 costs 2900000 3 tax 160000 ann cash flow 540000 NPV random r 0.1 -0.621 0.166 -0.904 -0.504 -0.460 1.066 0.433 1.216 1.622 0.013 0.770 0.245 0.963 0.985 1.045 0.224 0.354 -0.134 1.327 -0.347 0.963 0.444 1.037 0.463 0.768 -0.196 0.638 -0.118 0.430 0.519 0.316 0.014 0.418 0.454 0.289 0.114 1.460 1.231 1.499 -0.524 -0.079 0.616 -0.297 0.622 -0.317 0.184 0.595 0.361 1.423 1.076 -0.202 0.903 0.154 0.827 1.094 -0.061 0.561 0.445 -0.173 1.277 1.986 -0.473 1.779 0.418 0.530 0.297 0.853 -0.027 -0.490 0.620 1.376 0.676 1.700 0.939 -0.281 0.947 0.701 1.436 -0.117 -0.576 0.320 0.968 0.566 0.510 0.251 1.039 -0.151 0.087 1.912 0.595 0.316 1.048 0.760 0.401 0.450 1.284 0.164 0.633 0.270 -0.555 1.076 0.962 0.259 -0.571 0.538 1.359 0.076 -0.577 0.659 0.298 0.899 0.156 0.893 1.322 0.619 0.817 0.588 -0.305 -0.227 1.138 0.460 0.758 0.103 0.013 0.818 0.936 0.292 0.499 1.034 0.680 0.543 0.457 -0.465 0.399 0.452 0.497 -0.458 0.118 0.299 1.272 0.310 0.755 1.300 -0.028 0.288 0.101 -0.264 -0.016 -0.253 1.732 0.232 -0.522 0.018 0.012 0.242 -0.225 0.435 -0.649 1.170 0.325 0.965 0.640 1.721 0.963 1.033 -0.207 0.254 1.878 2.137 0.425 0.408 1.111 1.100 0.250 0.945 0.555 -0.205 0.391 0.502 0.769 -0.760 0.629 -0.111 1.457 1.658 0.525 1.082 0.918 0.426 0.770 -0.238 0.868 0.809 0.121 -0.479 -0.071 0.127 2.369 0.260 0.847 0.467 0.227 0.206 0.218 1.484 1.602 1.266 0.841 0.254 0.817 1.633 1.344 -0.561 0.350 2.298 0.124 1.005 -0.497 0.416 1.614 0.051 0.198 0.060 -0.205 1.655 0.206 1.589 -0.253 0.753 1.297 0.575 1.178 0.162 1.167 -0.333 0.573 0.745 0.562 -0.654 0.492 0.526 1.449 0.805 -0.033 0.141 0.153 0.432 1.798 1.543 1.673 0.11 -0.643 0.124 -0.919 -0.529 -0.486 1.002 0.385 1.148 1.544 -0.025 0.713 0.201 0.902 0.923 0.981 0.181 0.308 -0.169 1.256 -0.376 0.901 0.396 0.973 0.414 0.712 -0.229 0.584 -0.152 0.382 0.468 0.271 -0.024 0.370 0.406 0.244 0.074 1.386 1.163 1.424 -0.549 -0.114 0.563 -0.328 0.569 -0.346 0.142 0.542 0.315 1.350 1.011 -0.234 0.843 0.112 0.768 1.029 -0.097 0.509 0.397 -0.207 1.207 1.899 -0.499 1.697 0.370 0.479 0.252 0.794 -0.064 -0.515 0.567 1.304 0.622 1.620 0.878 -0.311 0.886 0.646 1.362 -0.152 -0.599 0.274 0.906 0.514 0.460 0.207 0.976 -0.185 0.048 1.826 0.542 0.271 0.984 0.704 0.353 0.401 1.214 0.123 0.580 0.226 -0.579 1.011 0.901 0.215 -0.594 0.487 1.288 0.037 -0.600 0.605 0.253 0.839 0.115 0.834 1.251 0.566 0.759 0.535 -0.335 -0.259 1.072 0.411 0.702 0.063 -0.024 0.760 0.875 0.248 0.449 0.970 0.625 0.492 0.408 -0.491 0.352 0.403 0.447 -0.484 0.078 0.254 1.202 0.265 0.698 1.230 -0.064 0.243 0.061 -0.294 -0.053 -0.284 1.651 0.188 -0.546 -0.020 -0.025 0.199 -0.257 0.387 -0.671 1.103 0.279 0.903 0.586 1.640 0.901 0.969 -0.240 0.210 1.794 2.045 0.377 0.360 1.046 1.035 0.206 0.884 0.503 -0.237 0.344 0.452 0.712 -0.778 0.576 -0.146 1.383 1.579 0.475 1.018 0.858 0.378 0.714 -0.270 0.809 0.751 0.081 -0.505 -0.107 0.086 2.273 0.216 0.788 0.418 0.184 0.163 0.175 1.409 1.524 1.197 0.783 0.210 0.759 1.554 1.273 -0.584 0.304 2.203 0.084 0.943 -0.522 0.368 1.536 0.012 0.156 0.021 -0.237 1.576 0.163 1.511 -0.284 0.696 1.227 0.523 1.111 0.120 1.100 -0.362 0.521 0.688 0.511 -0.675 0.443 0.475 1.375 0.748 -0.070 0.100 0.112 0.384 1.716 1.467 1.594 0.12 -0.664 0.084 -0.933 -0.553 -0.511 0.940 0.338 1.083 1.468 -0.062 0.659 0.159 0.842 0.863 0.920 0.140 0.263 -0.201 1.188 -0.403 0.842 0.349 0.912 0.366 0.657 -0.260 0.533 -0.186 0.335 0.420 0.227 -0.060 0.324 0.359 0.201 0.035 1.315 1.097 1.352 -0.572 -0.149 0.513 -0.356 0.518 -0.375 0.101 0.492 0.270 1.280 0.949 -0.265 0.785 0.073 0.712 0.966 -0.132 0.460 0.350 -0.238 1.140 1.815 -0.524 1.618 0.323 0.430 0.209 0.737 -0.099 -0.539 0.516 1.235 0.569 1.543 0.820 -0.340 0.827 0.593 1.292 -0.185 -0.621 0.230 0.847 0.464 0.412 0.165 0.915 -0.217 0.009 1.744 0.492 0.227 0.923 0.649 0.307 0.354 1.147 0.083 0.528 0.183 -0.602 0.949 0.842 0.172 -0.616 0.438 1.219 -0.001 -0.622 0.553 0.210 0.781 0.075 0.776 1.183 0.515 0.703 0.485 -0.364 -0.289 1.009 0.364 0.647 0.024 -0.061 0.704 0.817 0.204 0.401 0.909 0.573 0.443 0.361 -0.516 0.306 0.356 0.399 -0.510 0.039 0.211 1.136 0.221 0.644 1.163 -0.100 0.200 0.022 -0.324 -0.088 -0.314 1.574 0.147 -0.570 -0.056 -0.062 0.157 -0.287 0.340 -0.691 1.039 0.235 0.844 0.535 1.563 0.842 0.908 -0.271 0.168 1.713 1.958 0.331 0.314 0.983 0.973 0.164 0.826 0.454 -0.269 0.299 0.404 0.658 -0.796 0.525 -0.179 1.312 1.503 0.426 0.956 0.799 0.332 0.659 -0.300 0.752 0.695 0.042 -0.529 -0.141 0.047 2.180 0.174 0.732 0.371 0.142 0.122 0.134 1.338 1.449 1.130 0.726 0.168 0.703 1.479 1.205 -0.607 0.260 2.112 0.045 0.882 -0.546 0.322 1.461 -0.025 0.115 -0.016 -0.268 1.500 0.122 1.437 -0.314 0.642 1.159 0.473 1.047 0.080 1.036 -0.390 0.472 0.634 0.461 -0.695 0.395 0.427 1.304 0.692 -0.105 0.061 0.072 0.337 1.636 1.393 1.518 0.13 -0.684 0.046 -0.947 -0.576 -0.535 0.881 0.294 1.020 1.396 -0.097 0.606 0.119 0.786 0.805 0.861 0.100 0.221 -0.233 1.123 -0.430 0.785 0.304 0.854 0.321 0.605 -0.290 0.483 -0.217 0.291 0.373 0.185 -0.095 0.280 0.313 0.160 -0.002 1.247 1.034 1.282 -0.595 -0.181 0.464 -0.384 0.469 -0.402 0.063 0.444 0.227 1.212 0.890 -0.295 0.729 0.034 0.659 0.907 -0.165 0.412 0.305 -0.269 1.076 1.734 -0.547 1.542 0.279 0.383 0.168 0.683 -0.133 -0.563 0.467 1.169 0.519 1.469 0.763 -0.369 0.770 0.542 1.224 -0.217 -0.643 0.188 0.790 0.417 0.365 0.124 0.856 -0.248 -0.027 1.665 0.444 0.185 0.864 0.597 0.263 0.309 1.083 0.044 0.479 0.142 -0.623 0.890 0.785 0.132 -0.638 0.391 1.153 -0.038 -0.643 0.503 0.169 0.726 0.037 0.721 1.118 0.467 0.650 0.437 -0.391 -0.319 0.948 0.319 0.595 -0.013 -0.096 0.651 0.760 0.163 0.355 0.851 0.523 0.396 0.316 -0.540 0.262 0.311 0.353 -0.534 0.002 0.169 1.072 0.180 0.592 1.098 -0.134 0.159 -0.015 -0.353 -0.123 -0.343 1.499 0.107 -0.592 -0.091 -0.097 0.117 -0.317 0.295 -0.711 0.977 0.193 0.787 0.486 1.488 0.785 0.850 -0.300 0.127 1.635 1.874 0.286 0.270 0.923 0.913 0.124 0.769 0.407 -0.299 0.255 0.358 0.605 -0.813 0.475 -0.211 1.244 1.430 0.379 0.896 0.744 0.287 0.607 -0.330 0.697 0.642 0.004 -0.553 -0.174 0.010 2.090 0.133 0.678 0.325 0.102 0.083 0.094 1.269 1.378 1.066 0.672 0.127 0.650 1.407 1.139 -0.628 0.217 2.024 0.007 0.824 -0.569 0.278 1.389 -0.061 0.076 -0.052 -0.298 1.427 0.083 1.366 -0.343 0.590 1.095 0.425 0.985 0.042 0.974 -0.417 0.424 0.583 0.414 -0.715 0.349 0.380 1.236 0.639 -0.139 0.023 0.034 0.293 1.560 1.323 1.444 0.14 -0.704 0.009 -0.960 -0.598 -0.558 0.824 0.251 0.960 1.327 -0.130 0.556 0.080 0.731 0.750 0.805 0.061 0.179 -0.263 1.060 -0.456 0.730 0.261 0.797 0.278 0.554 -0.319 0.436 -0.248 0.248 0.328 0.145 -0.129 0.237 0.270 0.120 -0.038 1.181 0.974 1.216 -0.616 -0.213 0.417 -0.411 0.422 -0.428 0.025 0.397 0.186 1.147 0.833 -0.324 0.676 -0.002 0.607 0.849 -0.197 0.366 0.262 -0.299 1.015 1.657 -0.570 1.469 0.237 0.338 0.128 0.631 -0.166 -0.585 0.420 1.105 0.471 1.398 0.709 -0.396 0.716 0.493 1.159 -0.248 -0.663 0.148 0.735 0.371 0.321 0.086 0.800 -0.278 -0.062 1.590 0.397 0.145 0.807 0.547 0.221 0.266 1.021 0.007 0.432 0.103 -0.644 0.833 0.730 0.093 -0.658 0.346 1.089 -0.073 -0.664 0.455 0.129 0.673 0.000 0.668 1.055 0.419 0.598 0.391 -0.418 -0.347 0.889 0.275 0.545 -0.048 -0.129 0.599 0.706 0.123 0.310 0.795 0.474 0.350 0.273 -0.563 0.220 0.268 0.309 -0.557 -0.034 0.129 1.010 0.139 0.542 1.036 -0.166 0.119 -0.050 -0.380 -0.156 -0.371 1.427 0.068 -0.614 -0.125 -0.130 0.078 -0.345 0.253 -0.730 0.918 0.152 0.733 0.438 1.417 0.731 0.794 -0.329 0.088 1.560 1.793 0.243 0.228 0.865 0.855 0.085 0.715 0.361 -0.327 0.213 0.313 0.555 -0.829 0.428 -0.242 1.178 1.360 0.334 0.839 0.690 0.244 0.556 -0.358 0.645 0.591 -0.032 -0.575 -0.206 -0.027 2.004 0.094 0.626 0.282 0.064 0.045 0.056 1.202 1.309 1.005 0.620 0.088 0.598 1.337 1.076 -0.649 0.176 1.940 -0.029 0.769 -0.592 0.235 1.320 -0.095 0.038 -0.087 -0.327 1.357 0.045 1.297 -0.370 0.540 1.033 0.379 0.925 0.005 0.915 -0.443 0.378 0.533 0.368 -0.734 0.304 0.335 1.171 0.588 -0.172 -0.014 -0.003 0.250 1.487 1.256 1.374 0.15 -0.722 -0.027 -0.973 -0.619 -0.581 0.769 0.209 0.902 1.260 -0.162 0.508 0.043 0.678 0.697 0.750 0.025 0.140 -0.292 1.000 -0.480 0.678 0.219 0.743 0.236 0.506 -0.347 0.390 -0.278 0.207 0.285 0.106 -0.161 0.196 0.228 0.082 -0.073 1.118 0.915 1.152 -0.637 -0.243 0.372 -0.437 0.377 -0.454 -0.011 0.352 0.146 1.085 0.778 -0.352 0.625 -0.038 0.557 0.794 -0.227 0.322 0.220 -0.327 0.955 1.583 -0.592 1.399 0.196 0.295 0.089 0.580 -0.198 -0.607 0.375 1.043 0.424 1.330 0.657 -0.422 0.664 0.446 1.096 -0.277 -0.683 0.109 0.683 0.327 0.278 0.048 0.745 -0.307 -0.096 1.517 0.352 0.106 0.753 0.499 0.181 0.224 0.962 -0.028 0.386 0.065 -0.664 0.778 0.678 0.055 -0.678 0.303 1.028 -0.106 -0.684 0.409 0.090 0.621 -0.036 0.617 0.995 0.374 0.549 0.346 -0.443 -0.374 0.833 0.234 0.497
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}