Data Analysis & Monte Carle Simulation

[eastofwestla]

Hi,

Thank you so much for the great website. I have found it really useful in my finance classes at B school. I have a question about your Data Tables and MC Sim article (http://chandoo.org/wp/2010/05/06/data-tables-monte-carlo-simulations-in-excel-a-comprehensive-guide/)

I am having a problem running this simulation in excel. After I run the what if analysis, the new values repeat themselves for the whole tables. The column under “Growth” is filled with the formula =norm.inv(rand(), .03, .04). Below they result in 2%, 5%, etc. The input row cell is hard coded at 3%. There is no column input. My calc settings are Automatic and enable iterative calculations. I have also tried it as Manual+F9 to no avail. I am using excel 2013 on Bootcamp.

Any ideas on how to prevent the IRR and criteria columns from repeating? Thank you in advance.
-John

Before
#_Growth__IRR_____Meets Criteria?
__________1.77%___No_________
1_2%_________________________
2_5%_________________________
3 6%_________________________
4 1%_________________________

After
#_Growth__IRR_____Meets Criteria?
__________1.77%___No_________
1_-3%____1.77%___No__________
2_5%_____1.77%___No__________
2_1%_____1.77%___No__________
4_0%_____1.77%___No__________
5_11%____1.77%___No__________
. . .

 

[Hui]

Can you post the actual file ?
Of email it to me ?

 

[Hui]

I have responded to your email