Results 1 to 3 of 3

Thread: Want to do sensitivity analysis in Excel 2007

  1. #1
    Join Date
    Feb 2012
    Posts
    13

    Want to do sensitivity analysis in Excel 2007

    How do I do sensitivity analysis in excel 2007. Is there way for this process. Is there any kind of any add-in available for it. I need help to do this as early as I can do. Thanks in advance for any help.

  2. #2
    Join Date
    Jun 2011
    Posts
    487

    Re: Want to do sensitivity analysis in Excel 2007

    Let say that you are looking at NPV and IRR (a financial example). You can place the NPR and IRR on the horizontal axis (x axis). Lets say these go in C1414. Make sure these are references to the cells where you actually calculated the NPV and IRR, based on the cash flows generated by the project that you are analyzing! Hard coding these values will not work in your data table/sensitivity analysis. Then, you can place numbers corresponding to a growth rate on the vertical axis (y axis). Let's say these go in B15:B20. Starting at 0% and going to 25%, in increments of 5%, may be a good idea. Then click on B14 (the empty cell between your x & y vales). Move down and right so that B1420 are selected. Then click, Data, Table, Column input cell (this should be your growth rate, whatever cell it is on your spreadsheet), Ok. Your data table should populate with all relevant information. Write back if you get stuck somewhere.

  3. #3
    Join Date
    Jul 2011
    Posts
    640

    Re: Want to do sensitivity analysis in Excel 2007

    Read the below link. This is a kind of very hepful solution for the thing you are looking for. There are some ready to use samples provides which can help you to test the given methods.
    Analyze business results with Excel 2007

Similar Threads

  1. Excel 2003 Macro doesn't work in Excel 2007
    By jjaw in forum Windows Software
    Replies: 3
    Last Post: 03-01-2014, 03:28 PM
  2. How to use principal component analysis in Microsoft Excel
    By $horizon$ in forum MS Office Support
    Replies: 2
    Last Post: 10-02-2012, 06:06 PM
  3. Excel 2007 file fails to get permission to open in Excel 2011
    By Raju Chacha in forum Windows Software
    Replies: 6
    Last Post: 13-01-2012, 09:17 PM
  4. Replies: 8
    Last Post: 12-09-2011, 10:45 PM
  5. Replies: 6
    Last Post: 17-05-2011, 10:00 PM

Tags for this Thread

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
  •  
Page generated in 1,711,687,504.81022 seconds with 17 queries