PLEASE SHOW ANSWER IN EXCEL

Uploaded NPV & IRR: Find the NPV (assume 8% just to calculate NPV initially & IRR of these projects. When would you choose one over the other (e. what is the crossover rate)? Draw the NPV profile using 11 intervals of interest rates ranging from (and including) 0% to 100%. You may need to shift some of the interest rates to get a crossover rate lie, consider going from -10% to 90%[negative interest rates?!)). Place all data, ratios, calculations, findings, etc. In the first Excel sheet with references to the information in other sheets. Time ACF B CF 0 -10000 -10000 1 12000 9000 2 6000 7000 6000 5000 3000