l Problem 2.xlsx Function; IRR: Cell Referencing Using Excel to Determine IRR PROBLEM Kanye Company is evaluating the purchase of a rebuilt spotwelding machine to be used in the manufacture of a new product. hie machine has an estimated useful life of 7 years. Additional information concemina the possible investment follows. Expected machine cost 5 176,000 Estimated sales vaiue at end of 7 years - Expected annual operating cash flows 35,000 i Estimated useful life in years 7 years Student Work Area Required: Provide input into cells shaded in yellow in this template. Cell reference the respective amounts from the Problem area to the respective input cells. Use the IRR function with cell referencing to determine the internal rate of return. Calculate the internal rate of return of the facilty to the company using Excel's IRR function. The solution will dier slightly from the solution using the approach in your text. Cash Flows Acquired Year 1 Year 2 Year 3 Year 4 Year 5 Year 5 Year 7 Internal rate of return