Question: please do it in excel form and use the built in excel functions We are evaluating a project that costs $845,000, has an eight-year life,

please do it in excel form and use the built in excel functions
please do it in excel form and use the built in excel
functions We are evaluating a project that costs $845,000, has an eight-year

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 \pm 10 percent. Colculate the best-case and worst-case NPV figures: input area: 19 (Use cells A to B17 from the given information to complete this question. You must use the bulltin Excel function to answer this 20 quertion. The OCF must be calculated using the depreciation tax shield approsch.) (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.)

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!