PLEASE WRITE THE IRR fomula refering to the cells

F G H | [ M N 0 P Q 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. B C DE 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- 6 welding machine to be used in the manufacture of a new 7 product. The machine has an estimated useful life of 7 years. 8 Additional information concerning the possible investment 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 7 years 14 15 16 17 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. Cash Flows Acquired Year 1 (176,000) 35,000 Year 2 35,000 Year 3 35,000 Year 4 35,000 Year 5 35,000 Year 6 35,000 Year 7 35,000 Internal rate of return 18 19 20 21 22 23 24