I need help with these two problems can you show me how to do them in excel.

what was 10%?15%? (Hint: The crossover rate is 7.81%.) er if the WACC 11-7 CAPITAL BUDGETING CRITERIA this year's capital budget. After-tax cash flows, including depreciation, are as o mediate A firm with a 14% WACC is evaluating two projects f ms 0 4 Project M $30,000 $10,000 $10,000 $10,000 $10,000 $10,000 Project N$90,000 $28,000 $28,000 $28,000 $28,000 $28,000 a. Calculate NPV, IRR, MIRR, payback, and discounted payback for each project. b. Assuming the projects are independent, which one(s) would you recommend? 4 Investing in Long-Term Assets: Capital Budgeting c. If the projects are mutually exclusive, which would you recommend? d. Notice that the projects have the same cash flow timing pattern. Why is there a conflict between NPV and IRR? 11-8 CAPITAL BUDGETING CRITERIA: ETHICAL cONSIDERATIONS A mining company is considering a new project. Because the mine has received a permit, the project would be legal, but it would cause significant harm to a nearby river. The firm could spend additional $10 million at Year o to mitigate the environmental problem, but it would not be required to do so. Developing the mine (without mitigation) would cost $60 million, and the expected cash inflows would be $20 million per year for 5 years. If the firm does invest in mitigation, the annual inflows would be $21 million. The risk-adjusted WACC is 12%. an a. Calculate the NPV and IRR with and without mitigation b. How should the environmental effects be dealt with wien this project is evaluated? c. Should this project be undertaken? If so, should the firm do the mitigation