Using the categories and data from the Excel Spreadsheet, use only the items and their corresponding numbers to create an Income statement

3 D G H 1st Quarter 2018 (Jan Feb, & March 2018) Category Amounts Balance Income Cash Flow $100.00 $300.00 $3,000.00 $400.00 Accts payable Depreciation Expense Invested Capital 5 Dividend and interest Income 7 Interest Expense 8 Accumulated retained Eamings Taxes (25%) 10 Investment Portfolio $30.00 $5,000.00 Based on amount $2,000.00 11 Retums Sales $100.00 12 Dividends Dclared $10/share $2.500.00 $10,000.00 13 SGSA Expenses (Sales, Gen, & Admin) 24 Pre-Paid Expenses (Asset) 15 Revenue on Sales 26 Cost of goods Produced 17 Intangibles (Goodwill, Patents) $10,000.00 S8.500.00 $2.500.00 10 Cash $4,000.00 52,000.00 $12.000.00 $7,000.00 19 Acets Receivable 20 Building Equipment, machinery 21 Long Term Debt 22 Stand Rental/Month 23 Minus accumulated depreciation 24 Mac Supplies (Cups, Paper, Straws) 25 long-term Liabilities $200.00 $12,000.00 580000 $20,000.00 27 28 29 Category Revenue on Sales Amount Retur Sales Gross Sales Cost of Goods Sold (CGS) Gross Profit Dividends & Interest Income (Other Income) Depreciation Expense Interest Expense SG&A Expense Stand Rental/month Misc. Supplies Total Expenses Income before Taxes Taxes Net Income NPM