thanks for the answer...but why is it when I put a target number less than the mean (that it calculated) that I can not get a higher success % than say 61%. I would think that I should be able to find a target that would give me 96% success. I even tried to put in .01 for target and still can't move it higher....
The monte carlo analysis is based on 95% level of confidence.
The probability percentage depends on the target return rate - i.e. the lower the rate, the higher the probability will be of achieving it in the optimal portfolio.
Excel Business Forums Administrator
Posted by Excel Helper on
Displaying page 1 of 1
Excel templates and solutions matched for Results Probability:
