I WILL THUMBS UP, PLEASE HELP SO CONFUSED

I

Download spreadsheet Ch12 P25 Build a Model-ea63f5.xlsx a. If each project's cost of capital is 8%, which project should be selected? Round your answers to the nearest cent. NPV (Project A): \$ NPV (Project B): $ should be selected. If the cost of capital is 15%, what project is the proper choice? Round your answers to the nearest cent. NPV (Project A): \$ NPV (Project B): $ should be selected. b. Construct NPV profiles for Projects A and B. Choose the correct graph. A. 3. C. The correct graph is c. What is each project's IRR? (Hint: Using the Excel IRR function, set the guess parameter to be 10\%.) Round your answers to two decimal places. c. What is each project's IRR? (Hint: Using the Excel IRR function, set the guess parameter to be 10\%.) Round your answers to two decimal places. IRR (Project A): % IRR (Project B): and for the NPV to the nearest cent. The crossover rate is %. The crossover rate represents the cost of capital at which the two projects have the NPV of $ e. What is each project's MIRR at a cost of capital of 8% ? At r=15% ? Round your answers to two decimal places. f. What is the regular payback period for these two projects? Round your answers to two decimal places. Regular payback period (Project A): years Regular payback period (Project B): years g. At a cost of capital of 8%, what is the discounted payback period for these two projects? Round your answers to two decimal places. Discounted payback period (Project A): years Discounted payback period (Project B): years h. What is the profitability index for each project if the cost of capital is 8% ? Round your answers to three decimal places. Profitability index (Project A): Profitability index (Project B)