Develop a Monte Carlo simulation in Excel with 50 iterations and 10 years of returns.
A company wants to launch a new product line. The investment in facilities is expected to be between $1,000,000 and $2,000,000 with a uniform distribution. The initial marketing campaign is expected to be normally distributed with a mean cost of $500,000 and a standard deviation of $100,000. The annual profit/return is expected to be normally distributed with a mean of $250,000 and a standard deviation of $100,000
1. What is the average IRR?
2. What is the average NPV at 10%?
3. For what percent of the iterations is the total cash flow negative?
4. For what percent of the iterations is the NPV at 10% negative?
Solved
Show answers
More tips
- G Goods and services How to Make Soap at Home: Useful Tips for Beginners...
- C Computers and Internet How to Reinstall Windows: A Detailed Guide for Beginners...
- S Style and Beauty How to Get Rid of a Bruise: Tips and Tricks...
- F Food and Cooking Лечо: вкусное и простое блюдо для любой кухни...
- H Health and Medicine Relieving Swelling in Legs: Causes and Ways to Alleviate the Symptom...
Answers on questions: Business
- B Business Danielle enjoy working as in certified public accountant (cpa) and assisting small business and individuals with managing their financial and taxes . which general area of accounting...
- B Business Which of the following is not needed to calculate simple interest? yearly interest rate time down payment principal...
- S Social Studies A bay is surrounded by land on how sides?...
- M Mathematics 3. The initial amount for J.W. s new bank account is $2,500. The total amount. a(t). for J.W. after t years can be represented by a(t) = 2500*/(1+2), J.W. has $4,400 at the end...
- S Social Studies Why did problems continue to linger after the Persian Gulf War ended? A)Many Arabs were upset about the American presence in the region. B)Chaos broke out after Saddam Hussein...
- M Mathematics The U.S. Department of Education reported that in 2007, 67% of students enrolled in college or a trade school within 12 months of graduating from high school, in 2013, a random...
- G Geography What is a coral reef made of?...
- L Law (3) How can prosecutors use “pleading blind” to their advantage?...
- M Mathematics How do u write 58842716 word form...
- M Mathematics 34.04 - The Which statement best describes one of these transformations? O O O O Triangle 1 is rotated to result in triangle 2. Triangle 1 is dilated to result in triangle 3....
Ответ:
restaurants
Explanation:
like when you have a vegetarian people that only eats vegies that means that the only thing that is going to sell out is the vegies not that meat