Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Financial Accounting

Authors: Belverd E Needles, Marian Powers

11th Edition

0538755164, 9780538755160

More Books

Students also viewed these Accounting questions

Question

What is a confidence interval?

Answered: 1 week ago

Question

The role of life: It consists of your own service to yourself.

Answered: 1 week ago