Closed Thread
Results 1 to 2 of 2

NPV of a Project & Trial Simulation!!

  1. #1
    Registered User
    Join Date
    03-10-2012
    Location
    Kennesaw
    MS-Off Ver
    Excel: Mac 2011
    Posts
    2

    Exclamation NPV of a Project & Trial Simulation!!

    Hey guys. Hope you are doing good and in the mood to help a brother out

    I have been working on a project that I need to solve the NPV for...I made out the income statement and I believe I have the values correct. I also calculated the NPV for the project using the CFFA, but could anyone help me in making sure these are correct?

    The second question I have is running a 250 trial simulation of this project. I know I have to use the NORM.INV function to get random variables for the growth and inflation rate, but I'm not sure how to place it.

    Growth Rate: mean 10%, Standard Deviation .75%
    Inflation Rate: mean 3.2%, Standard Deviation .75%

    Once I run the simulation (how do I do that?) How can i figure out the mean and standard deviation of the NPVs collected. What is the probability the NPV will be positive based on the simulation results?

    I have already completed as much as I know how to, can someone help me out with the NPV and break even price for year 1 in the first worksheet and the trial simulation in the second? I have excel for MAC so i don't know how to compute random numbers like the f9 key in windows.

    THANK YOU
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,360

    Re: NPV of a Project & Trial Simulation!!

    Cross Posted at: http://www.mrexcel.com/forum/showthread.php?t=620191

    Welcome to the forum. Unfortunately:

    I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


Closed Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1