Function: IPR; Cell Aeferencing Dsing Excel to Determine IRA PAOBLEM Kanye Company is evaluasing the purchase of a rebult spot-welding machine to be ised in the manulocture of a new product. The machine has an estimatod usetul life of 7 years. Addtenal information conceming the possble investment tolows. Expected machine cost Eatimated sales value at end of 7 yoor Expected annual operating cach fows Estimated usehul hle in years 5176,000 35,000 Student Work Aree Aequired: Provide input into cells shaded in yollow in this template. Cell reference the respective amounts lrom the Problem area to the respoctive input cells in the Cach Flows area. Use the IRA function, cell referencing the cash llow amounts in the your Cash Flows work area. Calculate the internal rate of return of the facility to the company using Excel's IAR function. The solution will ditter slightly from the solution using the approach in your text. 7 years Cash Fiows Acquied Year 1 Year 2 Year 3 Year 4 Year 5 Year 0 Yeat 7 Internal rase of retum