B E F G H K M N 0 P R 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 in the Cash Flows area. Use the IRR function, cell referencing the cash flow amounts in the your Cash Flows work area. A1 4 x fx Function: IRR; Cell Referencing D 1 Function: IRR; Cell Referencing 2 3 Using Excel to Determine IRR 4 PROBLEM 5 Kanye Company is evaluating the purchase of a rebuilt spot-welding 6 machine to be used in the manufacture of a new product. The 7 machine has an estimated useful life of 7 years. Additional information 8 concerning the possible investment follows. 9 9 10 Expected machine cost $ 176,000 11 Estimated sales value at end of 7 years 12 Expected annual operating cash flows 35,000 13 Estimated useful life in years 14 15 16 17 18 19 20 21 22 Calculate the internal rate of return of the facility to the company using Excel's IRR function. The solution will differ slightly from the solution using the approach in your text. 7 years Cash Flows Acquired Year 1 Year 2 Year 3 Year 4 Year Year 6 Year 7 Internal rate of return