Results 1 to 2 of 2

Thread: Sensitivity analysis

  1. #1
    Neophyte AndrePrevin's Avatar
    Join Date
    Mar 2022
    Posts
    1
    Articles
    0
    Excel Version
    Microsoft 365

    Sensitivity analysis



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi

    I'm trying to set up a sensitivity analysis that will constantly update the table values if I enter a variance or change one of the input variables.
    I have a table of variables which all impact the NPV of a project. The NPV values are in the table.
    The problem is, I have to make the NPV values static every time I change a new variable, otherwise the new change overwrites the NPV values corresponding to the other variables.

    For e.g., if I enter -5% to one of the variables in the table, the baseline project NPV (in the table) and the tornado chart values should automatically update.
    If I reset that variable to 0 and change another variable, say to +10%, the baseline project NPV (in the table) and the tornado chart values should automatically update.
    Etc.

    Is this possible? Would greatly appreciate if someone could actually do a mock up for me and send me the Excel file.
    I've attached an image of the Excel sheet with my attempt at the sensitivity table and an explanation of what I want.

    Thank you





    NPV values in red are linked to another cell in the workbook which automatically calculates a new NPV whenever the variance is applied.
    Hence, I have to constantly change one variable, take the NPV from that other cell and paste as a value here
    Attached Files Attached Files

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,762
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    Welcome to the forum.

    If you cross-post on multiple forums, then you are required to share a link here. As you are new, I will do it for you today: https://www.mrexcel.com/board/thread...lysis.1197899/

    Read this to understand why we have this rule: https://www.excelguru.ca/forums/faq....osting_details
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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