Mercier\'s is analyzing a proposed 3-year project using standard sensitivity ana
ID: 2766707 • Letter: M
Question
Mercier's is analyzing a proposed 3-year project using standard sensitivity analysis. The company expects to sell 12,000 units, ±4 percent. The expected variable cost per unit is $7 and the expected fixed costs are $36,000. The fixed and variable cost estimates are considered accurate within a ±6 percent range. The sales price is estimated at $14 a unit, ±5 percent. The project requires an initial investment of $90,000 for equipment that will be depreciated using the straight-line method to zero over the project's life. The equipment can be sold for $39,000 at the end of the project. The project requires $11,200 in net working capital for the three years. The discount rate is 11 percent and tax rate is 34 percent What is the net income under the pessimistic case scenario? -$278.78 -$422.40 -$566.02 $3,554.50
Explanation / Answer
In pessimistic scenario, all costs would increase year on year & selling price and sales units would fall year on year. This movement would be maximum as specified in question.
Maximum Movement Selling Price 5% 13.30 Sales units 4% 11,520.00 Variable cost /unit 6% 7.42 Fixed Cost 6% 38,160.00 Sales Income 1,53,216.00 Less: Variable Cost 85,478.40 Less: Fixed Cost 38,160.00 Less: Depreciation 30,000.00 Net Income Pre Tax -422.40 Less: Tax @ 34% -143.62 Net Income Post Tax -278.78