Use excel to help you solve the following problem:

A company is considering the purchase of a new machine at a cost of $45,000. The machine is expected to generate annual after-tax cash flows of $12,000, $19,000, and $16,000 respectively, over its three-year life. The company has a required rate of return on investments in capital equipment of at least 7%. Should the company purchase the equipment?

Group of answer choices

No, the IRR is less than the required rate of return.

Yes, as the total net cash flows are positive.

Yes, as the rate of return on the equipment is positive.

No, as the total net cash flows are negative.