monte

  1. C

    Best Easy Monte Carlo for Odds Calculations?

    I need an inexpensive, easy to learn Monte Carlo simulator. Any suggestions? Here's the scenario - Residents and nonresidents can apply for any of 100 opportunities in a particular state. Each opportunity has a limited number of spots. But, once 10% of the total slots are filled, nonresidents...
  2. J

    Monte Carlo Method

    Can anyone help? I am needing to write a code in monte carlo method to solve the integral from 0 to 1 for the function e^-xdx. I am struggling with this project. This code should start with an amount of 10,000 and increase by 5,000 until the difference between the answers is less than 0.001. I...
  3. Y

    Auto Sorting a group of cells highest to lowest

    Ok, last question for tonight ;) This one is about how to Auto sort a group of cells highest to lowest, by using a formula. is this even doable? Below is a list I need to auto sort. I'd like to sort it by Scale Speed, fastest to slowest AL AM AN AO AP AQ AR...
  4. A

    Financial modelling/monte carlo - predicting share price movement with dividend

    I am trying to model a future share price, based on: - Dividend per year - yearly volatility (standard deviation) - price -exercise price -risk free rate -Time period I currently have the following equation to predict the daily movement of the share: =J8*(1+NORMINV(RAND(),0,$J$10)) Where J8...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top