Please show all work in excel with formulas.

or the 5-year life of the vein. CTC's cost of capital is 20%. For the purposes of this problem, assume that the cash inflows occur at the end of the year. a. What is the project's NPV? Do not round intermediate calculations. Round your answer to the nearest dollar. Use a minus sign to enter negative value, if any. $ What is the project's IRR? Do not round intermediate calculations. Round your answer to two decimal places. %