Question

Cummings Products Company is considering two mutually exclusive investments whose expected net cash flows are as follows: EXPECTED NET CASH FLOWS Year Project A Project B 0 -$320 -$360 1 -387 134 2 -193 134 3 -100 134 4 600 134 5 600 134 6 850 134 7 -180 134 What is each project's IRR? Do not round intermediate calculations. Round your answers to two decimal places Calculate the two projects' NPVs, if you were told that each project's cost of capital was 11%. Do not round intermediate calculations. Round your answers to the nearest cent. Calculate the two projects' NPVs, if the cost of capital was 16%. Do not round intermediate calculations. Round your answers to the nearest cent. What is each project's MIRR at a cost of capital of 11%? (Hint: Consider Period 7 as the end of Project B's life.) Do not round intermediate calculations. Round your answers to two decimal places. What is each project's MIRR at a cost of capital of 16%? (Hint: Consider Period 7 as the end of Project B's life.) Do not round intermediate calculations. Round your answer to two decimal places. What is the crossover rate? Do not round intermediate calculations. Round your answer to two decimal places. I do not just need answers can you show me how you worked them out please.

Answer 1

I am solving using excel formulas as IRR not possible to solve manually