complete the income statement and please write it clearly (excel)

The work sheet for Segura Corporation is shown below. Complete the classified multi-step income statement on the right. Segura Corporation Income Statement For the year ended December 31, 2014 X + Net sales X + Gross profit from sales Operating expenses Selling expenses Total selling expenses General and administrative expenses + Balance Sheet and Income Statement of Statement Changes in Equity Debit Credit Debit Credit Accumulated Depreciation, Office Fixtures 44,500 Accumulated Depreciation, Office Furniture 76,000 Cost Of Goods Sold 89,000 Depreciation Expense, Office Fixtures 12,000 Depreciation Expense, Office Furniture 18,000 Dividends 25,500 Income Taxes Expense 4,200 Income Taxes Payable 4,200 Interest Expense 36,500 Liabilities 292,000 Merchandise Inventory 53,500 Office Fixtures 325,500 Office Furniture 175,500 Office Salaries Expense 83,500 Rent expense, office space 114,000 Rent expense, selling space 67,000 Rent revenue 170,500 Retained Earnings 52,500 Sales 330,000 Sales Discounts 10,500 Sales Returns and Allowances 8,000 Sales Salaries Expense 41,000 Share Capital 94,000 Totals 483,700 500,500 580,000 563,200 Net Income 16,800 16,800 Totals 500,500 500,500 580,000 580,000 Total general and administrative expenses Total operating expenses Other revenues and expenses X + Income before tax X