Hi there!
I just downloaded @RISK for my very first time, and I've already managed to build a model for my cash flow (+NPV) sheet. Since I'm pretty much newb with @RISK, this is a bit hard to explain, but I'll give it a go :p
I'm using RiskTriang() for my Monte Carlo simulation model, but for two of the variables (rate1 and rate2), I have to make some adjustments. Rate1 is an income rate, and rate2 is an cost rate, so by using my model as it is now, rate2 can be in some cases higher than rate1 - which shouldn't be possible.
So I am wondering if it's possible to deny the random simulation to make the difference (rate1-rate2) at minimum 1,2% or something? Like =IF((C2-C3)<1,2%, newSimulation, continue). (just another way to explain my "problem". I know that that if sentence wouldn't work... :p)
A B C D E 1 Year 2014 2015 2016 2017 2 Rate1 =RiskOutput(,A2,1)+RiskTriang(B6,C6,D6) =RiskOutput(,A2,1)+RiskTriang(B6,C6,D6) =RiskOutput(,A2,1)+RiskTriang(B6,C6,D6) =RiskOutput(,A2,1)+RiskTriang(B6,C6,D6) 3 Rate2 =RiskOutput(,A3,1)+RiskTriang(B7,C7,D7) =RiskOutput(,A3,1)+RiskTriang(B7,C7,D7) =RiskOutput(,A3,1)+RiskTriang(B7,C7,D7) =RiskOutput(,A3,1)+RiskTriang(B7,C7,D7) 4 5 Triangles: Worst case Expected Best case 6 Rate1 1% 4,5% 8% 7 Rate2 1% 2,7% 6%
Bookmarks