PLEASE SOLVE USING EXCEL

Can someone please show me how they got the answers for these two problems?

(6D Question 1)

An investment that Kevin is considering offers the following cash flows.

Year 1 Initial investment of $180,000 Year 2 Inflow of $55,300 Year 3 Inflow of $27,500 Year 4 Additional investment of $25,000 Year 5 Inflow of $68,000 Year 6 Inflow of $72,600 Year 7 Additional investment $22,000 Year 8 Inflow of $51,050 Year 9 Inflow of $21,750 Year 10 Sale proceeds of $10,000

What is the internal rate of return (IRR) that this investment offers if all cash flows occur at the end of each period?

Round the answer to two decimal places in percentage form. (Write the percentage sign in the "units" box)

You should use Excel or financial calculator.

Answer: 9.04%

AND

(6D Question 2)

An investment that Kevin is considering offers the following cash flows.

Year 1 Initial investment of $230,000 Year 2 Inflow of $45,300 Year 3 Inflow of $27,500 Year 4 Additional investment of $15,000 Year 5 Inflow of $68,900 Year 6 Inflow of $72,600 Year 7 Additional investment $21,900 Year 8 Inflow of $51,050 Year 9 Inflow of $21,750 Year 10 Sale proceeds of $10,000

What is the internal rate of return (IRR) that this investment offers if all cash flows occur at the end of each period?

Round the answer to two decimal places in percentage form. (Write the percentage sign in the "units" box)

You should use Excel or financial calculator.

Answer: 2.80%