1. The managers of a company are considering an investment with the following estimated items. Capital Investment Annual Revenue Annual Expense Market Value MARR Useful Life $40,000 $20,000 $5,000 $1,000 15% per year 5 years The company is inclined to make the investment, but the managers are nervous because all of the cash flows and the MARR are approximate values. The capital investment is known to be within +5%. Annual expenses are known to be within +10%. The annual revenue, market value, and MARR estimates are known to be within +20%. a) Conduct break-even analyses for each of all 5 variables (use the Excel solver if necessary), and for each analysis, assuming that all the other items are fixed as above, clarify whether we can say that the company should accept the project or we cannot say about that b) Conduct sensitivity analyses by using the first (percentage change) method for each of all 5 variables (use the Excel solver if necessary) and rank those variables in descending order of sensitivity (from the most sensitive variable to the least sensitive variable). 1 c) Pick three most sensitive variables and conduct scenario analysis by setting three cases for each variable (using current estimate for the base case, and the bounds for the pessimistic and opti- mistic cases). Clearly mark the scenarios that results in the negative NPV. 1. The managers of a company are considering an investment with the following estimated items. Capital Investment Annual Revenue Annual Expense Market Value MARR Useful Life $40,000 $20,000 $5,000 $1,000 15% per year 5 years The company is inclined to make the investment, but the managers are nervous because all of the cash flows and the MARR are approximate values. The capital investment is known to be within +5%. Annual expenses are known to be within +10%. The annual revenue, market value, and MARR estimates are known to be within +20%. a) Conduct break-even analyses for each of all 5 variables (use the Excel solver if necessary), and for each analysis, assuming that all the other items are fixed as above, clarify whether we can say that the company should accept the project or we cannot say about that b) Conduct sensitivity analyses by using the first (percentage change) method for each of all 5 variables (use the Excel solver if necessary) and rank those variables in descending order of sensitivity (from the most sensitive variable to the least sensitive variable). 1 c) Pick three most sensitive variables and conduct scenario analysis by setting three cases for each variable (using current estimate for the base case, and the bounds for the pessimistic and opti- mistic cases). Clearly mark the scenarios that results in the negative NPV