Question

Stellar Plastics is analyzing a proposed project with annual depreciation of $19,500 and a tax rate of 34 percent. The company expects to sell 12,000 units, plus or minus 5 percent. The expected variable cost per unit is $3.20 plus or minus 4 percent, and the expected fixed costs are $30,000 plus of minus 2 percent. The sales price is estimated at $7.50 a unit, plus or minus 4 percent. What is the operating cash flow for a sensitivity analysis using total fixed costs of $31,000

Answer 1

Answer:

$20,226

Explanation:

expected sales = 11,400 - 12,000 - 12,600

expected sales price = $7.20 - $7.50 - $7.80

expected variable cost = $3.072 - $3.20 - $3.328

total fixed costs = $31,000

if you use an excel spreadsheet you can calculate all the different possible simulations and combine all the expected sales x 3 different price levels x 3 different variable costs and 1 fixed cost. Once you get all the 27 possible solutions, you just get the average.

I attached it because there is no room here.

Download pdf