2017	2018
Revenues and gains
*Sales revenue
*Interest revenue
*Investment Income
*Other revenue
Total revenue and gains
Expenses and losses
**Cost of goods sold			350,000
**Selling and admin administrative			160,000
***Computer (operating)
**Depreciation			35,000
**Interest expense			20,500
Total expenses and losses
Income before taxes
Income tax expense (25%)
Net Income

1.Using all relevant cells calculate the income tax expenses for each year.

2.Using the correct function or formula calculate the net income.

3. Format the comparative income statement use dollars signs where necessary. All values are to have the thousand separator format with TWO decimal places.

4. Using functions , complete the Aggregates worksheet

	2017	2018
Average Revenue
Largest Expenses
Lowest Revenues
Smallest Expenses
# of Expense components
# of Revenue components