Please. How can I incorporate Net Present Value functions in Crystal Ball simulation? I am trying to build a model which in addition to forecasting, give me...
I think you have it backward - you should build your NPV model the way you always would, and then convert it into a CB model. You do this by converting your...
Bernard, There are a few simple NPV examples on the Decisioneering Web site that may help you: http://www.crystalball.com/models/finrisk.html The DCF analysis...
Thanx, Bill. I'm puzzled with no response yet to the easy-to- understand correlation problem. The solution should be compelling since getting the right...
I invite you to review the file: TRABFINSEF.doc, date: 04/12/2004, where this concept is applied to decide between investment proposal related to electric...
Hello I am a Crystal Ball Pro I am using 2-D simulation to estimate my model 100 times. I need just these 100 simulation forecasts. Is there a way to avoid...
Hi. I recall that it is (or used to be) possible to set a option so that the values in the assumption cells reverted to their mean value from the last run...
I believe in "Cell Preferences" from the "Cell" menu item there is a check box option to "Set to Distribution Mean" which changes the cell value of all the...
Carl, Under the menu item "Cell" - "Cell Preferences", make sure the "set to distribution mean" is checked. I think that will do it. Kevin ... From: Phillips,...
Carl, it's not possible according to procedure indicated by Kevin. I tried it without sucess. I know other way using crystal Ball functions from excel (fx),...
I have Crystal Ball 2000.2, Professional Edition, June 2001. However, I invite you try the procedure indicated by me, while We look for the way suggested by...
Thanks to those of you who provided me with solutions. Obviously the version issue was a red herring -- presumably I had it set the way I wanted, but it...
Is there a way to incorporate constraints not based on decision variables into an optimization model? For example, say I have a problem where I'm maximizing...
Brian, Yes, you can specify a constraint by using a Crystal Ball forecast variable. You do this in the Forecast Selection window by selecting "requirement" for...
I am using a lognormal distribution. Actually Crystal Ball (CB) gives the answer. However, if anybody knows how to calculate without using CB to convert the...
Batch Assumption Entry I have to enter 240 assumption curves. Is there an easier way then click the button and type the data into all the fields 240 times?...
Nick, I see where you're coming from, and your last two suggestions already occurred to me. Problem is that it's a dynamic model where NPV is being maximized...
Brian, If you make the decision variable a percentage of standing stock, and then calculate the number of harvested trees separately, you should be able to...
Ladies And Gents, 1. Does anyone have a model (EXCEL) including : - Volatility - GBM - Mean Reversion - Random Jumps 2. Does anyone have Oil price volatility...
I was noticed that Crystall Ball is generating a different error about its execution, when the students run the model it does not generate the Frecuency Chart ...
You can also tried to write your assumptions just write as a formula. You can find help on this on the manual. Then simply copy those formulae easily....
Please see attached for calculations you requested. Best Regards, Nick Martino Decision Strategies, Inc. Calgary, Canada 403-283-2096 cell 403-560-9467 ... ...
Hi Nick, It's good to hear from you. I was interested to look at your answer here, but I couldn't find the attachment. There's no attachment on the email, and...
Questions about attachments have been popping up over the last few months so I thought I'd make a few quick comments and provide instructions for attachments. ...
This is similar to the other recent post about combining distributions though I think my question is slightly different. (1) I have an equation: 0.6(A) +...
CBUG Members, As some of you may know, Decisioneering is hosting the first ever Crystal Ball User Conference this June 17-18 in Denver, CO. We've had a...
Yes, this is the same phenomenon as reversion to the mean. Another way to think of it is to consider what would happen if A and B were perfectly correlated....
With all due respect, Eric, I believe the answer to the question does not involve means or correlations. B's mean, what ever it is, is not relevant to the...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
