Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    126
    Thanked 5 Times in 5 Posts

    Scenario Analysis Problem

    I have not used Excel's Scenario Analysis for several years now and am rusty regarding this.

    I have the following data which I need to need to develop a scenario analysis to show the results of the data below as well as to compute the NPV & IRR for each case

    I would like the steps on how to do this


    HTML Code:
    Current Values: Turnover $25000 per Sq M , Net profit margin  4%. , Cost of Capital 10% , expected growth 8%           Worst Case: Turnover $20000 margin 3% ; Cost of Capital 12% , expected growth 6%            Best Case:  turnover $30000, margin 5% ,  Cost of Capital 12% , expected growth 6%
    The solution to the above has been attached which I got from a PDF file.

    Your assistance regarding the above will me most appreciated
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    There is not enough information to setup the spreadsheet. You have provided the input and final results. The NPV and IRR are determined by using the input to create estimates for iniiial investment and the profit for some number of years. Does your original PDF have more details on its calculations/model developed which used the scenario?

    That model spreadsheet is needed before we can walk you through creating scenarios to evaluate

    Steve
    PS if you create and attach a spreadsheet to calculated the current values, we can walk you through the setup for creating the scenarios based on that and how to do the scenario analysis.
    Last edited by sdckapr; 2012-03-25 at 05:12.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

  4. #4
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    126
    Thanked 5 Times in 5 Posts
    Hi Steve

    Thanks for the rely. I will post the full data shortly

    Regards

    Howard

Posting Permissions

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