Santa Ana, Inc. has a 6% cost of capital. The firm decides to invest in equipment that costs $250,000. Santa Ana, Inc. forecasts that the project will generate $33,000 of annual cash inflow in each of the next eleven years.

(Note that the present value for i = 6% and n = 10 is 7.36009 and for i = 6% and n = 11 is 7.8887.)

Required:

1. Using Excel formulas, compute the projects net present value (NPV) and internal rate of return (IRR).
2. State the reason why Santa Ana, Inc. should or should not make the investment.
3. Use sensitivity analysis to determine:
   • The maximum hurdle rate that could exist before Santa Ana, Inc. rejects the investment.
   • The minimum annual cash flow that Santa Ana could generate and still invest in the project.
   • The minimum number of years that Santa Ana could generate a $33,000 annuity and still invest in the project.