bcat Coffee Review Problem Solution (From Module 1). Input it into the Excel Solution document via links from the balance sheet, income statement and statement of shareholders equity.

Curr Assets Cash Accounts Receivable Prepaid Insurance Supplies Inventory Total Current Assets 12,000 8,000 10,000 2,000 30,000 62,000 Property Plant & Equipment Land Equipment Accumulated Depreciation Total PPE Total Assets 81,500 100,000 (30,000) 151,500 213,500 Liabilities & Stockholders' Equity Current Liabilities Accounts Payable Salaries Payable Total Current Liabilities 5,000 15,000 20,000 100,000 Long Term Debt Stockholders' Equity Retained Earnings Common Stock Total Stockholders' Equity Total Liabilities & Stockholders' Equity 38,500 55,000 93,500 213,500 200,000 60,000 140,000 Amounts in $ Amounts in $ Income Statement Sales Cost of Goods Sold Gross Profit salaries Exp Supplies EXP Util Exp Rent Exp Depre Exp insurance exp tltal operating exp operating income interest exp net income Balance sheet As at 31.12.20x4 Assets Current Assets Cash Accounts Receivable Prepaid Insurance Supplies Inventory 47000 17000 3000 Amounts in $ Amounts in $ Liabilities Current Liabilities 88700 Accounts Payable 18000 Salaries Payable 1000 Unearned Revenue 6000 50000 163700 Non Current Liabilities Long Term Debt 52,000 1,000 5,000 12,000 7,000 9,000 67000 150000 86,000 54,000 300 53,700 Non Current Assets Land Equipment Accum. Depre - Equipment Total Assets 150000 -37000 81500 Shareholders Equity Common Stock 113000 Retained Earnings 358200 Total Liabilities & Equity 55000 86200 141200 358200 Curr Assets Cash Accounts Receivable Prepaid Insurance Supplies Inventory Total Current Assets 12,000 8,000 10,000 2,000 30,000 62,000 Property Plant & Equipment Land Equipment Accumulated Depreciation Total PPE Total Assets 81,500 100,000 (30,000) 151,500 213,500 Liabilities & Stockholders' Equity Current Liabilities Accounts Payable Salaries Payable Total Current Liabilities 5,000 15,000 20,000 100,000 Long Term Debt Stockholders' Equity Retained Earnings Common Stock Total Stockholders' Equity Total Liabilities & Stockholders' Equity 38,500 55,000 93,500 213,500 200,000 60,000 140,000 Amounts in $ Amounts in $ Income Statement Sales Cost of Goods Sold Gross Profit salaries Exp Supplies EXP Util Exp Rent Exp Depre Exp insurance exp tltal operating exp operating income interest exp net income Balance sheet As at 31.12.20x4 Assets Current Assets Cash Accounts Receivable Prepaid Insurance Supplies Inventory 47000 17000 3000 Amounts in $ Amounts in $ Liabilities Current Liabilities 88700 Accounts Payable 18000 Salaries Payable 1000 Unearned Revenue 6000 50000 163700 Non Current Liabilities Long Term Debt 52,000 1,000 5,000 12,000 7,000 9,000 67000 150000 86,000 54,000 300 53,700 Non Current Assets Land Equipment Accum. Depre - Equipment Total Assets 150000 -37000 81500 Shareholders Equity Common Stock 113000 Retained Earnings 358200 Total Liabilities & Equity 55000 86200 141200 358200