Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started