Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please put formulas too! thanks! just need the OCF and NPV for best case and worst case We are evaluating a project that costs $845,000,
Please put formulas too! thanks!
We are evaluating a project that costs $845,000, has an eight-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 51,000 units per year. Price per unit is $53, variable cost per unit is $27, and fixed costs are $950,000 per year. The tax rate is 22 percent, and we require a return of 10 percent on this project. Suppose the projections given for price, quantity, variable costs, and fixed costs are all accurate to within 10 percent. Calculate the best-case and worst-case NPV figures, (Use cells A6 to B17 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.) just need the OCF and NPV for best case and worst case
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