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?

R& m chatelaine is one of the largest tax-preparation firms in the united states. it wants to acquire the tax experts, a smaller rival. after the merger, chatelaine will be one of the two largest income-tax preparers in the u.s. market. what should chatelaine include in its acquisition plans? it should refocus its attention from the national to the international market. in addition to acquiring the tax experts, it should also determine the best way to drive independent "mom and pop" tax preparers out of business. chatelaine will need to explain to the federal trade commission how the acquisition will not result in an increase in prices for consumers. chatelaine should enter a price-based competition with its other major competitor to force it out of business and become a monopoly.