Marks Corporation

Income Statements

$31-$Dec

Account

Net sales

Cost of Goods Sold

Gross Profit

Operating Expenses

Net Income

$\backslash$table$[[$Amount$],[2017,2016],[620,000,500,000],[450,000,400,000],[170,000,100,000],[54,000,40,000],[116,000,60,000]]$

I. Prepare a trend analysis of the income statement data for Marks corp using $2016$ as a base $-$ in Excel $-$ show amounts and $\%$

II$.$ Prepare a common size analysis of the income statement for Marks Corp in columnar format for both years $-$ in Excel