Refer to exercise #$6($page $54)$ in your textbook. Given the information in that exercise, which one should be Broken Arrow's first priority $($you must include values for NPV$/$ROR$/$ROI and$/$or other information used to finalize your decision$)?$

Calculate NPV for the project with first$/$highest priority. What is the maximum investment level for the project with the lowest priority that will lead to the same NPV as that for the project with first$/$highest priority $($assume that the revenue stream does not change for that project$)?$ Hint: You may use Excel's goal seek method $($shown in the Chapter$2\_$help file$)$ to find the unknown investment value in year $0,$ given known revenue stream, final NPV value known from the project with highest priority, and rate of return $($ROR$)$ as $20\%.$

Note: You must include values for NPV$/$ROR$/$ROI and$/$or other information used to finalize your priority. Answers provided without quantitative reasons will receive zero credits.