Question

From the following trial balance and adjustment data, complete (1) a worksheet and (2) three financial statements (numbers ar
Adjustment Data A. Insurance Expired, $3. B. Plumbing Supplies on hand, $1. C. Depreciation Expensc, Plumbing Equipment, $1.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1) Worksheet

Unadjusted Adjustment Adjusted Income Statement Balance Sheet
Particulars Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
Cash $   14.00 $   14.00 $   14.00
A/R $      4.00 $      4.00 $      4.00
Prepaid Insurance $      5.00 $      3.00 $      2.00 $      2.00
Plumbing supplies $      3.00 $      2.00 $      1.00 $      1.00
Plumbing equipment $      7.00 $      7.00 $      7.00
Accu. Dep. $      5.00 $      1.00 $      6.00 $      6.00
A/P $      1.00 $      1.00 $      1.00
Salaries Payable $      2.00 $      2.00 $      2.00
Capital $   12.00 $   12.00 $   22.00
Withdrawal $      3.00 $      3.00 $      3.00
Fees $   27.00 $   27.00 $   27.00
Rent Expense $      4.00 $      4.00 $      4.00
Salaries Expense $      5.00 $      2.00 $      7.00 $      7.00
Insurance Expense $      3.00 $      3.00 $      3.00
Supplies Expense $      2.00 $      2.00 $      2.00
Depreciation Expense $      1.00 $      1.00 $      1.00
Net Income $   10.00
$   45.00 $   45.00 $      8.00 $      8.00 $   48.00 $   48.00 $   27.00 $   27.00 $   31.00 $   31.00

2)

Income Statement
Fees $   27.00
Less: Expenses:
Rent Expense $      4.00
Salaries Expense $      7.00
Insurance Expense $      3.00
Supplies Expense $      2.00
Depreciation Expense $      1.00
Net Income $   10.00
Owner's Capital
Beginning Capital $   12.00
Add: Net Income $   10.00
Less: Withdrawals $      3.00
Ending Capital $   19.00
Balance Sheet
Assets
Cash $   14.00
A/R $      4.00
Prepaid Insurance $      2.00
Plumbing supplies $      1.00
Plumbing equipment $      7.00
Accu. Dep. $    (6.00) $      1.00
Total assets $   22.00
Liabilities and Equity
A/P $      1.00
Salaries Payable $      2.00
Capital $   19.00
Total Liabilities and Equity $   22.00
Add a comment
Know the answer?
Add Answer to:
From the following trial balance and adjustment data, complete (1) a worksheet and (2) three financial...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Bob's P Worksheet Trial Balance Debit Credit Del Cash 4,700 5,000 500 3,000 8,000 Accounts Receivable...

    Bob's P Worksheet Trial Balance Debit Credit Del Cash 4,700 5,000 500 3,000 8,000 Accounts Receivable Prepaid Insurance Plumbing Supplies Plumbing Equipment Accumulated Depreciation, Plumbing Equipment 2,500 7,500 10,700 Accounts Payable . Frost, Captial . Frost, Withdrawals Plumbing Fees Rent Expense Salaries Expense 1,000 5,500 1,000 3,000 26,200 26,200 nsurance Net ncome osurance Expired, $500 Rlumbing Supplies on hand, 2,000 Depreciation Expense, Plumbing Equip, $600. Salaries Owed but not paid to employees, $1,200

  • Q) Complete the worksheet. Adjustment Data to Update the Trial Balance a. Rent expired, $400. b....

    Q) Complete the worksheet. Adjustment Data to Update the Trial Balance a. Rent expired, $400. b. Landscaping supplies on hand (remaining). $350. c. Depreciation expense, landscaping equipment, $375. d. Wages earned by workers but not paid or due until August, $450. Landry's Landscaping Service Worksheet Month Ended July 31, 201X Trial Balance Adjustments Dr. Cr. Dr. Adjusted Trial Balance Dr. Or Income Statement Dr. Cr. Balance Sheet Dr. Cr. Account Titles Cr. Cash in Bank Accounts Receivable Prepaid Rent Landscaping...

  • PROBLEM 1 -Worksheet The worksheet for Gibler Rental Company appears below. Using the adjustment data below,...

    PROBLEM 1 -Worksheet The worksheet for Gibler Rental Company appears below. Using the adjustment data below, complete the worksheet. Add any accounts that are necessary. Adjustment data: A physical count of supplies indicates $3 on hand at August 31. The amount of insurance that expired in the month of August was $2. Depreciation on equipment for August was $5. Interest accrued on the note payable was $1. GIBLER RENTAL COMPANY Worksheet For the Month Ended August 31, 2010 Trial Balance...

  • PROBLEM 1 (25pts) Update the trial balance for Kreg's Moving Co. October 31, 201X. Adjustment Data...

    PROBLEM 1 (25pts) Update the trial balance for Kreg's Moving Co. October 31, 201X. Adjustment Data to Update Trial Balance a. Insurance expired, $550. b. Moving supplies on hand, $800. c. Depreciation on moving truck, $550. d. Wages earned but unpaid, $300. Your task is to: 1. Complete a worksheet for Kreg's Moving Co. for the month of October. 2. Prepare an income statement for October, a statement of owner's equity for October, and a balance sheet as of October...

  • Required: 2. Complete the worksheet by making the following adjustments: supplies on hand at the end...

    Required: 2. Complete the worksheet by making the following adjustments: supplies on hand at the end of the month, $7,200; expired insurance, $7,000; depreciation expense for the period, $3,100. Analyze: How does the insurance adjustment affect Prepaid Insurance? Complete this question by entering your answers in the tabs below. Partial Worksheet Analyze Complete the worksheet by making the following adjustments: supplies on hand at the end of the month, $7,200; expired insurance, $7,000; depreciation expense for the period, $3,100. NEAL...

  • Q) Complete the worksheet. No need explanation (just want to check my answer) Updated for adjustment...

    Q) Complete the worksheet. No need explanation (just want to check my answer) Updated for adjustment data. Adjustment Data to Update the Trial Balance a. Rent expired, $400. b. Landscaping supplies on hand (remaining), $350. c. Depreciation expense, landscaping equipment, $375. d. Wages earned by workers but not paid or due until August, $450. Adjusted Trial Balance Dr. Cr Income Statement Dr. Cr. Balance Sheet Dr. Cr. Account Titles Cr. Landry's Landscaping Service Worksheet Month Ended July 31, 201X Trial...

  • 1. & 2. The following data are taken from the unadjusted trial balance of the Westcott...

    1. & 2. The following data are taken from the unadjusted trial balance of the Westcott Company at December 31, 2017. Complete the work sheet following adjustment. (Enter their balances in the correct Debit or Credit column.) Use the following adjustment information to complete the work sheet. a. Depreciation on equipment, $10 b. Accrued salaries, $16 c. The $12 of unearned revenue has been earned d. Supplies available at December 31, 2017, $6 e. Expired insurance, $12 । । ।...

  • The trial balance of Neal Company as of January 31, 2019, after the company completed the...

    The trial balance of Neal Company as of January 31, 2019, after the company completed the first month of operations, is shown in the partial worksheet below. Required: 2. Complete the worksheet by making the following adjustments: supplies on hand at the end of the month $7,400, expired insurance, $7,100; depreciation expense for the period, $3,200. Analyze: How does the insurance adjustment affect Prepaid Insurance? Complete this question by entering your answers in the tabs below. Partial Worksheet Analyze Complete...

  • 1. & 2. The following data are taken from the unadjusted trial balance of the Westcott...

    1. & 2. The following data are taken from the unadjusted trial balance of the Westcott Company at December 31, 2017. Complete the work sheet following adjustment. (Enter their balances in the correct Debit or Credit column.) ( REALLY NEED HELP FILLING THIS OUT) thanks!    Use the following adjustment information to complete the work sheet. Depreciation on equipment, $22 Accrued salaries, $14 The $25 of unearned revenue has been earned Supplies available at December 31, 2017, $17 Expired insurance,...

  • Selected worksheet data for Elsayed Company are presented below. Trial Balance Debit Credit Adjusted Trial Balance...

    Selected worksheet data for Elsayed Company are presented below. Trial Balance Debit Credit Adjusted Trial Balance Debit Credit 33,670 19,517 25,182 6,118 11,984 Account Titles Accounts Receivable Prepaid Insurance Supplies Accumulated Depreciation Equipment Salaries and Wages Payable Service Revenue Insurance Expense Depreciation Expense Supplies Expense Salaries and Wages Expense 4,051 96,094 88,888 10,675 4,429 48,737 Fill in the missing amounts. Trial Balance Debit Credit Adjusted Trial Balance Debit Credit 33,670 19,517 25,182 6,118 11,984 Account Titles Accounts Receivable Prepaid Insurance...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT