+ Reply to Thread
Results 1 to 2 of 2

@RISK-question: RiskTriang(), do new simulation if X < 1,2%

  1. #1
    Registered User
    Join Date
    02-08-2013
    Location
    Malmö, Sweden
    MS-Off Ver
    Excel 2013
    Posts
    26

    @RISK-question: RiskTriang(), do new simulation if X < 1,2%

    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%

  2. #2
    Registered User
    Join Date
    02-08-2013
    Location
    Malmö, Sweden
    MS-Off Ver
    Excel 2013
    Posts
    26

    Re: @RISK-question: RiskTriang(), do new simulation if X < 1,2%

    Also, let's say that I've got 10 different rates/triangles * 5 years. How do I group the rates to see the sensitivity (how much each rate is affecting the NPV)?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to use solver to run Monte Carlo Simulation for this question
    By yangjason88 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2014, 01:25 AM
  2. Risk Map
    By ecknaveen in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-24-2014, 05:16 AM
  3. monte carlo simulation code for calculating value at risk
    By kmsoni in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2011, 03:08 PM
  4. Dice 'Simulation game' Question
    By Sabrina19 in forum Excel General
    Replies: 1
    Last Post: 12-14-2010, 07:35 PM
  5. @Risk for Excel question
    By minhiub in forum Excel General
    Replies: 0
    Last Post: 03-05-2009, 03:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1