Operating Activities: Creating/selling goods & services to outsiders Simpson Company results of operation for 2018 & 1017 Net Sales $780,000 $624,000 THIS IS OUR REV Utilities Expense Salaries & Wages Expense Interest Expense Cost of Goods Sold Selling expense Insurance Expense Depreciation Expense $5,880 $105,000 $9,920 $440,000 $46,000 $10,000 $10,000 $4,760 $95,000 $7,200 $405,600 $34,000 $8,000 $8,000 From the Data above, the Comparative Statement of Operations was prepared. QUESTION 1, Determine the TREND ANALYSIS Simpson Company Statement of Operations For the years ending December 31 Tre Net Sales Cost of Goods Sold Gross Profit (Gross Margin) Gross Profit X.GPX 2018 $780,000 $440,000 $340,000 2017 $624,000 $405,600 $218.400 Selling, General & Admin, - SGA Selling expense Insurance Expense Utilities Expense Salaries & Wages Expense Depreciation Expense $46,000 $10,000 $5,880 $105,000 $10,000 $34,000 $8,000 $4,760 $95,000 $8,000 $175,880 22.7% $149,760 240% $0 Total SGA Expenses Total SGA EBITAD Earnings before Income tax, interest EBITAD $163, 120 20.9% $68.640 11.0% $9.920 $153 200 19.6% 57 200 $51.440 9.8% 2018 2017 Interest Expense Net Income before Income Tax Net Income before Income Tax Expense - NI % Simpson Company Balance Sheet AT December 31 Current Assets Cash Short term Investment Accounts Receivable Inventory Prepaid Insurance Total Current Property. Plant & Equipment Total Assets $23,100 $108,200 $44,800 $114,400 $2.000 $290,500 $21,600 $83.800 $33,000 $73,000 $1.000 $212,400 $485300 439,600 $775,800 $652,000 Liabilities & Stockholders Equity Current Liabilities Accounts Payable Salaries & Wages Payable Long Term Liabilities Bonds Payable Total Liabilities $138,200 $25 300 $163,500 $132,000 $24,000 $156,000 $132.000 $295,500 $120,000 $276.000 Stockholders Equity Common stock Retainmed Earning Total Storkholder's Equity Total Liabilities & Stockholders equity $150,000 $330 300 $480 300 $130.000 $246.000 $376,000 $775 800 $652.000 Simpson Company Statement of Retained Earnings For the years ending December 31 Retained Earning. 01/01/2017 Net income $245,000 $153 200 $399,200 $68 900 $330,300 Less Dividend Operating Activities: Creating/selling goods & services to outsiders Simpson Company results of operation for 2018 & 1017 Net Sales $780,000 $624,000 THIS IS OUR REV Utilities Expense Salaries & Wages Expense Interest Expense Cost of Goods Sold Selling expense Insurance Expense Depreciation Expense $5,880 $105,000 $9,920 $440,000 $46,000 $10,000 $10,000 $4,760 $95,000 $7,200 $405,600 $34,000 $8,000 $8,000 From the Data above, the Comparative Statement of Operations was prepared. QUESTION 1, Determine the TREND ANALYSIS Simpson Company Statement of Operations For the years ending December 31 Tre Net Sales Cost of Goods Sold Gross Profit (Gross Margin) Gross Profit X.GPX 2018 $780,000 $440,000 $340,000 2017 $624,000 $405,600 $218.400 Selling, General & Admin, - SGA Selling expense Insurance Expense Utilities Expense Salaries & Wages Expense Depreciation Expense $46,000 $10,000 $5,880 $105,000 $10,000 $34,000 $8,000 $4,760 $95,000 $8,000 $175,880 22.7% $149,760 240% $0 Total SGA Expenses Total SGA EBITAD Earnings before Income tax, interest EBITAD $163, 120 20.9% $68.640 11.0% $9.920 $153 200 19.6% 57 200 $51.440 9.8% 2018 2017 Interest Expense Net Income before Income Tax Net Income before Income Tax Expense - NI % Simpson Company Balance Sheet AT December 31 Current Assets Cash Short term Investment Accounts Receivable Inventory Prepaid Insurance Total Current Property. Plant & Equipment Total Assets $23,100 $108,200 $44,800 $114,400 $2.000 $290,500 $21,600 $83.800 $33,000 $73,000 $1.000 $212,400 $485300 439,600 $775,800 $652,000 Liabilities & Stockholders Equity Current Liabilities Accounts Payable Salaries & Wages Payable Long Term Liabilities Bonds Payable Total Liabilities $138,200 $25 300 $163,500 $132,000 $24,000 $156,000 $132.000 $295,500 $120,000 $276.000 Stockholders Equity Common stock Retainmed Earning Total Storkholder's Equity Total Liabilities & Stockholders equity $150,000 $330 300 $480 300 $130.000 $246.000 $376,000 $775 800 $652.000 Simpson Company Statement of Retained Earnings For the years ending December 31 Retained Earning. 01/01/2017 Net income $245,000 $153 200 $399,200 $68 900 $330,300 Less Dividend