subject
Business, 18.03.2021 01:20 jivsf

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?

ansver
Answers: 3

Another question on Business

question
Business, 22.06.2019 01:30
The strength of the economy depends on the balance pf production and consumption of goods and consumption of goods and services
Answers: 1
question
Business, 22.06.2019 12:20
Alarge university wanted to study the relationship between completing an internship during college and students' future earning potential. prom the same graduating class, they selected a random sample of 80 students who completed an internship and 100 students who did not complete an internship and examined their salaries five years after graduation. they found that there was a statistically higher mean salary for the internship group than for the noninternship group. which of the following interpretations is the most appropriate? a. there could be a confounding variable, such as student major, that explains the difference in mean salary between the internship and no internship groups.b. we cannot infer anything from these data since the distribution of salaries is likely right skewed.c. you cannot draw any valid conclusions because the sample sizes are different.d. more students should complete internships because having an internship produces a higher salary.
Answers: 1
question
Business, 22.06.2019 19:30
Which of the following statements are false regarding activity-based costing? non-manufacturing costs are important to include when calculating the cost of each product. costs are allocated based on a pre-determined overhead rate. transitioning from traditional costing methods to activity-based costing can be complicated and costly. activity-based costing follows the same basic calculation methods as traditional costing approaches. none of the above
Answers: 2
question
Business, 22.06.2019 20:10
Your sister is thinking about starting a new business. the company would require $375,000 of assets, and it would be financed entirely with common stock. she will go forward only if she thinks the firm can provide a 13.5% return on the invested capital, which means that the firm must have an roe of 13.5%. how much net income must be expected to warrant starting the business? a. $41,234b. $43,405c. $45,689d. $48,094e. $50,625
Answers: 3
You know the right answer?
Develop a Monte Carlo simulation in Excel with 50 iterations and 10 years of returns. A company wan...
Questions
question
Mathematics, 04.07.2019 22:30
question
History, 04.07.2019 22:30
question
Mathematics, 04.07.2019 22:30
question
Mathematics, 04.07.2019 22:30
question
Business, 04.07.2019 22:30
question
Computers and Technology, 04.07.2019 22:30
Questions on the website: 13722362