+ Reply to Thread
Results 1 to 1 of 1

Sensitivity Analysis

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Chicago
    MS-Off Ver
    MAC OS Excel 2007
    Posts
    1

    Sensitivity Analysis

    Greetings,

    I am trying to put together a sensitivity analysis where I put two variables into a seperate spreadsheet and would like the output to be put in the intercept cell (yellow) in the table. For example, I want to take the 2.4% value from terminal growth rate and 8.2% from terminal WACC and plug into the cells of my valuation in the second image (the green and red cells) I then want to take the yellow cell, my stock price per share from my valuation and input it in the sensitivity analysis table. See the sheets below: I think it more clear visually.

    Any assistance would be greatly appreciated.

    Best Regards.

    table.jpg

    dcff.jpg
    Last edited by Fabian_R; 04-17-2013 at 01:45 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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