I want to know all of the excel values for the cash flow out, cash flow in, and total cash flow for the ten years as well as the IRR

2. An engineer made 10 annual end-of-year purchases of $1000 of common stock. At the end of the tenth year, just after the last purchase, the engineer sold all the stock for $12,000. What is the rate of return received on the investment? 3. A company is considering buying a new piece of machinery. Initial cost: $80,000 End-of-useful-life salvage value: $20,000 Annual operating cost: $18,000 Useful life: 10 years The machine will produce an annual saving in material of $25,700. What is the before-tax rate of return if the machine is installed? Year: Cash Flow In Total Cash Flow IRR=3.12%