Question

In: Finance

Lawrence is analyzing a proposed 3‐year project using standard sensitivity analysis. The company expects to sell...

Lawrence is analyzing a proposed 3‐year project using standard sensitivity analysis. The company expects

to sell 18,000 units, ±4 percent. The expected variable cost per unit is $12 and the expected fixed costs are

$60,000. The fixed and variable cost estimates are considered accurate within a ±5 percent range. The

sales price is estimated at $17 a unit, ±5 percent. The project requires an initial investment of $162,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 $49,000 at the end of the project. The project requires $17,500 in net working

capital for the three years. The discount rate is 12 percent and tax rate is 25 percent. What is the operating

cash flow under the optimistic case scenario?

A. $55,667 B. $58,912 C. $61,308 D. $64,342 E. $67,115

Solutions

Expert Solution

Sales $             334,152 =18000*(1+4%)*17*(1+5%)
Less:
Costs $             270,408 =18000*(1+4%)*12*(1-5%)+60000*(1-5%)
Depreciation $               54,000 =162000/3
EBT $                  9,744
Less: Tax payable @ 25% $                  2,436
Net income $                  7,308
Add: Depreciation $               54,000
Operating cash flow $    61,308

Related Solutions

Tampa Company is analyzing a proposed 3-year project using standard sensitivity analysis. The company expects to...
Tampa Company is analyzing a proposed 3-year project using standard sensitivity analysis. The company expects to sell 14,000 units, ±4 percent. The expected variable cost per unit is $10 and the expected fixed costs are $45,000. The fixed and variable cost estimates are considered accurate within a ±5 percent range. The sales price is estimated at $16 a unit, ±5 percent. The project requires an initial investment of $120,000 for equipment that will be depreciated using the straight-line method to...
Norfolk Company is analyzing a proposed 3-year project using standard sensitivity analysis. The company expects to...
Norfolk Company is analyzing a proposed 3-year project using standard sensitivity analysis. The company expects to sell 22,000 units, ±4 percent. The expected variable cost per unit is $13.2 and the expected fixed costs are $51,000. The fixed and variable cost estimates are considered accurate within a ±5 percent range. The sales price is estimated at $16.8 a unit, ±5 percent. The project requires an initial investment of $204,000 for equipment that will be depreciated using the straight-line method to...
Insight Enterprise is analyzing a proposed 3-year project using standard sensitivity analysis. The company expects to...
Insight Enterprise is analyzing a proposed 3-year project using standard sensitivity analysis. The company expects to sell 17,000 units, ±4 percent. The expected variable cost per unit is $12 and the expected fixed costs are $60,000. The fixed and variable cost estimates are considered accurate within a ±5 percent range. The sales price is estimated at $17 a unit, ±5 percent. The project requires an initial investment of $162,000 for equipment that will be depreciated using the straight-line method to...
Broadwing Corporation is analyzing a proposed 5-year project using standard sensitivity analysis. The company expects to...
Broadwing Corporation is analyzing a proposed 5-year project using standard sensitivity analysis. The company expects to sell 30,000 units, ±5 percent. The expected variable cost per unit is $22.40 and the expected fixed costs are $180,000. The fixed and variable cost estimates are considered accurate within a ±5 percent range. The sales price is estimated at $42.00 a unit, ±5 percent. The project requires an initial investment of $350,000 for equipment that will be depreciated using the straight-line method to...
LongHorn Corp is analyzing a proposed project. The company expects to sell 10,000 units, plus or...
LongHorn Corp is analyzing a proposed project. The company expects to sell 10,000 units, plus or minus 4 percent. The expected variable cost per unit is $10 and the expected fixed costs are $400,000. The fixed and variable cost estimates are considered accurate within a plus or minus 10 percent range. The depreciation expense is $61,000. The tax rate is 32 percent. The sales price is estimated at $70 a unit. What is the operating cash flow under the best...
You are analyzing two proposed capital investments with the following cash flows: Year Project X Project...
You are analyzing two proposed capital investments with the following cash flows: Year Project X Project Y 0 - $20,000 - $20,000 1 13,730 6,470 2 6,060 6,470 3 6,460 6,470 4 2,120 6,470 The cost of capital for both projects is 10 percent. Calculate the profitability index (PI) for each project. (Do not round discount factors. Round intermediate calculations to 2 decimal places, e.g. 15.25 and final answer to 4 decimal places, e.g. 1.2527.) The PI for project X...
You are analyzing two proposed capital investments with the following cash flows: Year Project X Project...
You are analyzing two proposed capital investments with the following cash flows: Year Project X Project Y 0 - $20,000 - $20,000 1 13,530 6,370 2 5,960 6,370 3 6,460 6,370 4 1,920 6,370 The cost of capital for both projects is 10 percent. Calculate the profitability index (PI) for each project. (Do not round discount factors. Round intermediate calculations to 2 decimal places, e.g. 15.25 and final answer to 4 decimal places, e.g. 1.2527.) The PI for project X...
You are analyzing two proposed capital investments with the following cash flows: Year Project X Project...
You are analyzing two proposed capital investments with the following cash flows: Year Project X Project Y 0 - $20,000 - $20,000 1 12,530 6,570 2 6,360 6,570 3 6,160 6,570 4 2,020 6,570 The cost of capital for both projects is 10 percent. Calculate the profitability index (PI) for each project. (Do not round discount factors. Round intermediate calculations to 2 decimal places, e.g. 15.25 and final answer to 4 decimal places, e.g. 1.2527.) The PI for project X...
You are analyzing two proposed capital investments with the following cash flows: Year Project X Project...
You are analyzing two proposed capital investments with the following cash flows: Year Project X Project Y 0 -$20,000 -$20,000 1 13,630 7,720 2 5,860 7,720 3 6,160 7,720 4   2,020 7,720 The cost of capital for both projects is 10 percent. Calculate the profitability index (PI) for each project. (Do not round discount factors. Round intermediate calculations to 2 decimal places, e.g. 15.25 and final answer to 4 decimal places, e.g. 1.2527.) 1) What is the PI for project...
Using the below sensitivity report, answer the following questions: SENSITIVITY REPORT ANALYSIS PROBLEM
Using the below sensitivity report, answer the following questions:SENSITIVITY REPORT ANALYSIS PROBLEM  a. If this is a LP product mix problem report, how many units of each product should be produced?b. If one unit of French is force produced, what will happen to the Objective Function value?c. The Caribbean’s Objective Coefficient is increased to 80. How will the new Objective Function value be determined? d. Which constraints are binding?e. If Finishing is decreased by one unit, how will the Objective...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT