b. Construct NPV profiles for Projects A and B. Before we can graph the NPV profiles for these projects, we must create a data table of project NPVs relative to differing costs of capital. Note: if you complete the data table, the plot will complete automaticallv. Please don't adiust it. c. What is each project's IRR? We find the internal rate of return with Excel's IRR function: IRRA= Note: you do not need to enter a "guess" for these cashflows. IRRB= d. What is the crossover rate, and what is its significance? b. Construct NPV profiles for Projects A and B. Before we can graph the NPV profiles for these projects, we must create a data table of project NPVs relative to differing costs of capital. Note: if you complete the data table, the plot will complete automaticallv. Please don't adiust it. c. What is each project's IRR? We find the internal rate of return with Excel's IRR function: IRRA= Note: you do not need to enter a "guess" for these cashflows. IRRB= d. What is the crossover rate, and what is its significance