Question

Based on the data below, complete a formal income statement, statement of owner's equity, and formal...

Based on the data below, complete a formal income statement, statement of owner's equity, and formal balance sheet:

Income Statement Section of Work Sheet:

Service Fees: 20,000 cr. balance

Supplies Expense: 400 dr. balance

Insurance Expense: 800 dr. balance

Depreciation Expense: 20,000 dr. balance

Wage Expense: 4000 dr. balance

Rent Expense: 12,000 dr. balance

Utilities Expense: 10,000 dr. balance

Net Loss = 27,200

Balance Sheet Section of Worksheet:

Cash: 40,000 dr. balance

Supplies: 2000 dr. balance

Prepaid Insurance: 2000 dr. balance

Equipment: 20,000 dr. balance

Accumulated Depreciation: 2000 cr. balance

Accounts Payable: 42,200 cr. balance

Wages Payable: 4000 cr. balance

Capital: 45,000 cr. balance

Drawing: 2000 dr. balance

Homework Answers

Answer #1

Income statement:

Particulars Amt (Cr) Amt(Cr)

Service Fees 20,000

Less

Wage Expense 4,000

Supplies Expense 400

Gross Profit 15,600

Less:

Oprating Expense

Insurance Expense 800

Depreciation Expense 20,000

Rent Expense 12,000

Utilities Expense    10,000

Net Loss   27,200

Owner's Equity:

Opening balance =45,000 Cr

(-)Drawings =   2000 Cr

43,000 Cr

Balance Sheet:

     

Particulars Amt(Cr) Particulars Amt(Cr)
Capital 43,000

Equipment-AD

(20,000-2,000)

18,000
Wages payable 4,000 Insurance prepaid 2,000
accounts payable 42,200 Debtors 2,000
Cash 40,000
Profit and Loss 27,200
89,200 89,200
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Based on the data below, close out the revenue, expense, income summary, and drawing accounts. Service...
Based on the data below, close out the revenue, expense, income summary, and drawing accounts. Service Fees = $100,000 Rent Expense = $10,000 Wage Expense = $20,000 Utilities Expense = $12,000 Supplies Expense = $1000 Insurance Expense = $1000 Depreciation Expense = $4000 Drawing = $1000
PETE'S CONSTRUCTION YEAR ENDED DECEMBER 31, 2018 ADJUSTED TRIAL BALANCE INCOME STATEMENT STATEMENT OF OWNER'S EQUITY...
PETE'S CONSTRUCTION YEAR ENDED DECEMBER 31, 2018 ADJUSTED TRIAL BALANCE INCOME STATEMENT STATEMENT OF OWNER'S EQUITY OR BALANCE SHEET ACCOUNT TITLES DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT Cash $37,000 $37,000 Accounts receivable 10,278 10,278 Interest receivable 1,200 1,200 Office supplies 1,000 1,000 Prepaid insurance 1,000 1,000 Prepaid rent 1,800 1,800 Note receivable 10,000 10,000 Computer equipment 24,000 24,000 Accumulated depreciation, computer equipment $10,000 $10,000 Office equipment 15,000 15,000 Accumulated depreciation, office equipment 9,000 9,000 Accounts payable 20,878 20,878 Interest payable...
The following items appeared on December 31 Excel work sheet. Based on the following information, what...
The following items appeared on December 31 Excel work sheet. Based on the following information, what is profit for the year? Account Unadjusted Trial Balance Adjustments Adjusted Trial Balance Dr. Cr. Dr. Cr. Dr. Cr. Cash 975 Prepaid insurance 3,600 150 Supplies 180 70 Equipment 10,320 Accounts payable 1,140 Unearned fees 4,500 375 Owner, capital 9,180 Owner, withdrawals 1,650 Fees earned 5,850 {375 {300 Rent expense 1,500 315 Salaries expense 2,100 Utilities expense 345 Insurance expense 150 Supplies expense 70...
MATTHEWS LANES Work Sheet For Year Ended June 30 Account Income Statement Balance Sheet Dr Cr...
MATTHEWS LANES Work Sheet For Year Ended June 30 Account Income Statement Balance Sheet Dr Cr Dr Cr Cash 11,275 Accounts receivable 1,750 Office supplies 800 Prepaid insurance 3,400 Scoring equipment 140,000 Accumulated depreciation –      scoring equipment 21,700 Salaries payable 800 Common stock 20,000 Retained earnings (unadjusted) 40,000 Dividends 46,425 Bowling revenue 138,075 Depreciation expense –      scoring equipment 10,825 Salaries expense 1,800 Insurance expense 1,200 Rent expense 1,600 Office supplies expense 400 Repairs expense 350 Telephone expense 750 Totals 16,925...
Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...
Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. In addition, the data for year-end adjustments are as follows: Fees earned but not yet billed, $37. Supplies on hand, $9. Insurance premiums expired, $46. Depreciation expense, $18. Wages accrued but not paid, $18. Enter the adjustment data and place...
Complete the worksheet by preparing the Income Statement and Balance Sheet columns. Be sure to calculate...
Complete the worksheet by preparing the Income Statement and Balance Sheet columns. Be sure to calculate the total debits and credits in each step. Caroline Eagle, CPA Worksheet December 31, 2018 Adjusted Income Trial Balance Statement Account Names Debit Credit Debit Credit Cash $46,500 Accounts Receivable 13,100 Office Supplies 200 Prepaid Rent 5,600 Land 5,000 Building 130,000 Accumulated Depreciation—Building $1,100 Furniture 21,000 Accumulated Depreciation—Furniture 1,900 Accounts Payable 3,900 Utilities Payable 675 Salaries Payable 3,900 Interest Payable 900 Unearned Revenue 1,400...
Prepare a multiple-step income statement for Yazdy Company for 2020 DR. CR. Accounts Payable 26,000 Accounts...
Prepare a multiple-step income statement for Yazdy Company for 2020 DR. CR. Accounts Payable 26,000 Accounts Receivable 57,000 Accumulated Depreciation – Equipment   40,000 Depreciation Expense 13,000 Sales Revenue 250,000 Cash 25,000 Common Stock 50,000 Equipment 150,000 Investment in Debt Securities 45,000 Freight-out 5,000 Insurance Expense 2,500 Salaries and Wages expense 30,000 Rent Expense 20,000 Sales Discount 8,000 Retained Earnings 25500 Prepaid Insurance 7,500 Sales Return and Allowance 12,000 Gain on Disposal of Plant Asset 6,000 Dividends 7,000 Interest Expense 7,500...
Bank Dr 16,062.92 Prepaid insurance Dr 500 Kitchen supplies Dr 2000 Office supplies Dr 200 Building...
Bank Dr 16,062.92 Prepaid insurance Dr 500 Kitchen supplies Dr 2000 Office supplies Dr 200 Building supplies DR 183.70 Furniture Dr 4500 Accumulated depreciation furniture Cr 375 Gst paid on purchases - Wages payable Cr 1485.71 Interest payable Cr 200 Deductions payable Cr 1,280 Bank loan payable Cr 10,000 N.R capital Cr 5000 N.R withdrawals Dr 500 Revenue Cr 27,250 Wages expense Dr 9805.71 Training expense Dr 250 Supplies expense Dr 250 Depreciation expense Dr 375 Bookkeeper expense Dr 400...
Using the Adjusted Trial Balance below prepare an Income Statement in proper form for the month...
Using the Adjusted Trial Balance below prepare an Income Statement in proper form for the month ended August 31, 2018. XYZ COMPANY WORKSHEET FOR THE MONTH ENDED AUGUST 31, 2018 ADJUSTED TRIAL BALANCE ACCOUNT TITLES   DEBIT ($)   CREDIT ($)        Accumulated depreciation - Machinery      88,000.00 Accounts Payable      31,100.00 Accounts Receivable   27,800.00      Capital -Mr. Owner      23,600.00 Cash   56,820.00      Depreciation - Machinery   8,000.00      Insurance Expense   1,200.00      Interest Expense   200.00      Interest Income      800.00...
The adjusted trail balance columns of the worksheet for auburn company are as follows. Auburn Company...
The adjusted trail balance columns of the worksheet for auburn company are as follows. Auburn Company Worksheet (partial) For the Month Ended April 30, 2020 Adjusted Income Income Trial Balance Statement Balance Sheet Account Titles Dr. Cr. Dr. Cr. Dr. Cr. Cash 10,000 Accounts Receivable 7,840 Prepaid Rent 2,280 Equipment 23,050 Accumulated Depreciation—Equip. 4,900 Notes Payable 5,700 Accounts Payable 4,920 Owner’s Capital 27,960 Owner’s Drawings 3,650 Service Revenue 15,590 Salaries and Wages Expense 10,840 Rent Expense 760 Depreciation Expense 650...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT