m Using Excel to Determine IRR Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Cell reference the Kanye Company is evaluating the purchase of a rebuilt spot- respective amounts from the Problem area to the respective input cells in the Cash Flows welding machine to be used in the manufacture of a new area. Use the IRR function, cell referencing the cash flow amounts in the your Cash iproduct. The machine has an estimated useful life of 7 years. Flows work area. iAdditional information concerning the possible investment Expected machine cost $ 176,000 Calculate the internal rate of return of the facility to the company using Excel's IRR Estimated sales value at end of 7 years function. The solution will differ slightly from the solution using the approach in your text. Expected annual operating cash flows 35,000 Estimated useful life in years 7 years Cash Flows Acquired Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Internal rate of return Enter Answer + Select destination and press ENTER or choose Paste