Company XYZ has net income of $100, $124, $119, $130, $143, and $127 from year 2016 to 2021.

1. Enter the data into an Excel file.

2. Derive the net and gross growth rates of net income for each year.

3. Derive the arithmetic average growth rate of net income.

4. Derive the geometric average growth rate of net income.

5. Create a column chart that shows the net income over the years.

Please show explanation and work on how you got the answers