Monte Carlo bands d...
 
Notifications
Clear all

Monte Carlo bands disappear when ROR is terrible

3 Posts
2 Users
0 Likes
94 Views
(@wmchbaker)
Active Member Customer
Joined: 10 months ago
Posts: 6
Topic starter  

Working in PRC2024, I took the starting spreadsheet and put in ROR of -20% for stocks and bonds for all 3 periods. The Monte Carlo results don't show bands, just a red line.


   
ReplyQuote
(@smatthews51)
Member Admin
Joined: 4 years ago
Posts: 728
 

@wmchbaker If you use PRC's default method of specifying standard deviation, using a ROR of -20% will result in a negative standard deviation, which is illegal. Consequently, PRC does not allow it to go below .01% and this means that there is virtually no variation in the returns from year to year during a Monte Carlo analysis and, hence, no blue bands.


   
ReplyQuote
(@wmchbaker)
Active Member Customer
Joined: 10 months ago
Posts: 6
Topic starter  

OK, thanks for the info.


   
ReplyQuote
Share: