Sensitivity analysis: Boulder Creek Industries Boulder Creek Industries is considering an investment in equipment based on the following estimates: Cost of $3,000,000 equipment Residual value 200,000 Useful life 10 years a. Determine the net present value of the equipment, assuming a desired rate of return of 12% and annual net cash flows of $800,000. Use the present value tables appearing in Exhibit 2 and 5 of this chapter. Net present value $ 1,584,40 b. Determine the net present value of the equipment, assuming a desired rate of return of 12% and annual net cash flows of $400,000, $600,000, and $800,000. Use the present value tables (Exhibit 2 and 5) provided in the chapter in determining your answer. If required, use the minus sign to indicate a negative net present value. Annual Net Cash Flow $400,000 $600,000 $800,000 Net present value c. Determine the net present value of the equipment, assuming a desired rate of return of 15% and annual net cash flows of $400,000, $600,000, and $800,000. Use the present value tables (Exhibit 2 and 5) provided in the chapter in determining your answer. If required, use the minus sign to indicate a negative net present value. Annual Net Cash Flow $400,000 $600,000 $800,000 Net present value d. Determine the minimum annual net cash flow necessary to generate a positive net present value, assuming a desired rate of return of 12%. Round to the nearest dollar. Annual Net Cash Flow $ e. Boulder Creek industries wish to invest in an equipment and the projections for the same is as follows: $400,000 $600,000 $800,000 Net cash inflow Net present value ($675,600) $454,400 $1,584,400 Year 6% 15% 20% 00 vau AWN- 0.943 0.890 0.840 0.792 0.747 0.705 0.665 0.627 0.592 0.558 Present Value of $1 at Compound Interest 10% 12% 0.909 0.893 0.826 0.797 0.751 0.712 0.683 0.636 0.621 0.567 0.564 0.507 0.513 0.452 0.467 0.404 0.424 0.361 0.386 0.322 0.870 0.756 0.658 0.572 0.497 0.432 0.376 0.327 0.284 0.247 0.833 0.694 0.579 0.482 0.402 0.335 0.279 0.233 0.194 0.162 7