Question: Initial cost Project life Units sales Price/unit Variable cost/unit Fixed costs Tax rate Required return b. New quantity for calculation Projected sales change c.

Initial cost Project life Units sales Price/unit Variable cost/unit Fixed costs Tax

Initial cost Project life Units sales Price/unit Variable cost/unit Fixed costs Tax rate Required return b. New quantity for calculation Projected sales change c. New VC for calculation Projected VC change $845,000.00 8 51,000 $53.00 $27.00 $950,000.00 22% 10% 52,000 (500) $28.00 ($1.00) (Use cells A6 to C17 from the given information to complete this question. You must use the built-in Excel function to answer this question. The OCF must be calculated using the depreciation tax shield approach.) Output area: a. Depreciation per year Accounting break-even DOL b. Base OCF Base NPV $105,625 40,600.96 $376,000.00 OCF at new quantity NPV at new quantity DNPV/DQ Change in NPV for given quantity change c. OCF DOCF/DVC Change in NPV for given VC change $175,406.77 ($26,500.00) * ($13,500.00) *

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!