Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Could you fill out the spreadsheet with the following please DEBIT CREDIT 5-Jan 7-Jan Cash Sales Increase Decrease Contra 0 Debit Side Credit Side 10-Jan
Could you fill out the spreadsheet with the following please
DEBIT CREDIT 5-Jan 7-Jan Cash Sales Increase Decrease Contra 0 Debit Side Credit Side 10-Jan 12-Jan Increase Decrease Contra Debit Side Credit Side 0 Assets & Expenses Increase Decrease A/R Wages exp 0 Assets & Expenses Increase Decrease 0 15-Jan Liab. Revenue, Equity Decrease Increase Supplies Supplies exp Liab. Revenue, Equity Decrease Increase 20-Jan 0 22-Jan 25-Jan 0 Equipment Contra Assets (Acc Dep) Decrease Increase Contra Assets (Acc Dep) Decrease Increase 0 Acc. Deprec. Depreciation exp 31-Jan Contra Equity (Draw) Increase Decrease 0 31-Jan Notes payable 31-Jan 0 31-Jan Capital (Equity) 0 Owner's Draw 0 0 Contra Equity (Draw) Increase Decrease WORKSHEET Unadjusted Trial Balance Adjusted Trial Balance Adjustments Income Statement Balance Sheet Cash - - - Accts. receivable - - - Supplies - - - Equipment - - - - Accum. depreciation - Notes payable Owners capital - - - - - - Draw - - - - - Sales - Wages expense - - - - Depreciation exp. $ - $ - $ - - - - - - Supplies expenses Total - - - - $ - $ - $ - $ - $ - $ - $ - $ $ - $ - $ $ - - $ - Financial Statements Cash Flow Worksheet Income Statement Statement of Owners' Equity Sales $ Wages expense Supplies expense Beg. capital Contributed capital Less: Draw - Depreciation expense Total expense Net income (loss) Analysis of Balance Sheet Information $ - $ Net income Ending capital $ - Ending Balance - Current Assets (operating activity) Cash $ Increase in Supplies Cashflow from Oper. activities Purchased equipment Cashflow used for Invest. activities Increase in notes payable Increased Contributed Capital Cash paid to owner - Effect on the company's cash - - Increase N/A - - - Increase Increase Cash not received Cash paid out Current liabilities (operating activity) Notes payable Liabilities Cash A/R - - - - Increase Cash not paid out Supplies Equipment Acc. Deprec. $ Notes payable - - $ Owner's Capital Non-current assets (investing activity) Equipment - - - Increase Cash paid Equity (financing activity) Capital Draw - - - Increase Increase Cash received Cash paid out - - $ - - Total Assets Cashflow from Financing activities Increase in cash Plus: Beginning cash balance Ending cash balance Change Balance Sheet Assets Net Income Add: Depreciation Increase in A/R Increase (Decrease) - A/R Supplies Statement of Cash Flows Beginning Balance* $ - Total liabilities & capital $ - $ $ - *Beginning balances are zero because this is the first month of operations.Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started