Question

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

Notes Payable

16,000

Common Stock

120,000

Retained Earnings

98,525

Dividends

34,000

Service Revenue

100,700

Rent Expense

29,400

Salaries Expense

37,900

Supplies Expense

400

Utilities Expense

22,000

Depreciation Expense—Building

1,100

Depreciation Expense—Furniture

1,900

Interest Expense

900

Total

$349,000

$349,000

Net income or loss

Enter any number in the edit fields and then click Check Answer.

PARTIAL BALANCE SHEET:

Caroline Eagle, CPA

Worksheet

December 31, 2018

Unadjusted Trial Balance

Adjustments

Adjusted Trial Balance

Income Statement

Balance Sheet

Account Names

Debit

Credit

Debit

Credit

Debit

Credit

Debit

Credit

Debit

Credit

Cash

$46,500

$46,500

Accounts Receivable

9,500

(h)

$3,600

13,100

Office Supplies

600

(b)

$400

200

Prepaid Rent

9,000

(a)

3,400

5,600

Land

5,000

5,000

Building

130,000

130,000

Accumulated Depreciation—Building

(c)

1,100

$1,100

Furniture

21,000

21,000

Accumulated Depreciation—Furniture

(d)

1,900

1,900

Accounts Payable

$3,900

3,900

Utilities Payable

675

675

Salaries Payable

(f)

3,900

3,900

Interest Payable

(g)

900

900

Unearned Revenue

2,500

(e)

1,100

1,400

Notes Payable

16,000

16,000

Common Stock

120,000

120,000

Retained Earnings

98,525

98,525

Dividends

34,000

34,000

Service Revenue

96,000

(e, h)

4,700

100,700

Rent Expense

26,000

(a)

3,400

29,400

Salaries Expense

34,000

(f)

3,900

37,900

Supplies Expense

(b)

400

400

Utilities Expense

22,000

22,000

Depreciation Expense—Building

(c)

1,100

1,100

Depreciation Expense—Furniture

(d)

1,900

1,900

Interest Expense

(g)

900

900

Total

$337,600

$337,600

$16,300

$16,300

$349,000

$349,000

PrintDone

Homework Answers

Answer #1
Income statement Balance sheet
Cash 46500
Accounts receivable 13100
Office supplies 200
Prepaid rent 5600
Land 5000
Building 130000
Acc. Depreciation building 1100
Furniture 21000
Acc. Depreciation furniture 1900
Accounts payable 3900
Utilities payable 675
Salaries payable 3900
Interest payable 900
Uneraned revenue 1400
Notes payable 16000
Common stock 120000
Retained earnings 98525
Dividend 34000
Service revenue 100700
Rent expense 29400
Salaries expense 37900
Supplies expense 400
Utilities expense 22000
Depreciation expense - building 1100
Depreciation expense - furniture 1900
Interest expense 900
Total 93600 100700 255400 248300
Net income / loss 7100 7100
Total 100700 100700 255400 255400
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
The adjustments columns of the worksheet for Becker Company are shown below: Adjustments Account Titles Debit...
The adjustments columns of the worksheet for Becker Company are shown below: Adjustments Account Titles Debit Credit Accounts Receivable 1,100 Prepaid Insurance 300 Accumulated Depreciation—Equipment 900 Salaries and Wages Payable 500 Service Revenue 1,100 Salaries and Wages Expense 500 Insurance Expense 300 Depreciation Expense 900 Total 2,800 2,800 a. Prepare the adjusting entries. b. Indicate the financial statement column (debit or credit) to which each account balance should be extended.
Selected worksheet data for Elsayed Company are presented below. Trial Balance Adjusted Trial Balance Account Titles...
Selected worksheet data for Elsayed Company are presented below. Trial Balance Adjusted Trial Balance Account Titles Debit Credit Debit Credit Accounts Receivable ? 33,311 Prepaid Insurance 26,057 20,182 Supplies 7,197 ? Accumulated Depreciation—Equipment 12,313 ? Salaries and Wages Payable ? 4,852 Service Revenue 87,773 96,120 Insurance Expense ? Depreciation Expense 11,973 Supplies Expense 4,478 Salaries and Wages Expense ? 49,220
The adjusted trial balance columns of the worksheet for Martinez Company are as follows. Martinez Company...
The adjusted trial balance columns of the worksheet for Martinez Company are as follows. Martinez Company Worksheet For the Year Ended December 31, 2019 Adjusted Trial Balance Account No. Account Titles Dr. Cr. 101 Cash 5,300 112 Accounts Receivable 10,700 126 Supplies 1,600 130 Prepaid Insurance 1,900 157 Equipment 27,500 158 Accumulated Depreciation—Equipment 5,100 200 Notes Payable 14,000 201 Accounts Payable 6,100 212 Salaries and Wages Payable 2,100 230 Interest Payable 700 311 Common Stock 9,900 320 Retained Earnings 3,400...
complete a Trial Balance, Income Statement, Statement of Retained Earnings, Balance Sheet, and calculate all of...
complete a Trial Balance, Income Statement, Statement of Retained Earnings, Balance Sheet, and calculate all of the ratios. Accounts Receivable        16,250 Accumulated depreciation: Office equipment        25,000 Cash        25,300 Land        58,500 Merchandise inventory        25,250 Office equipment        41,000 Office supplies          4,410 Prepaid rent          1,800 Cost of Goods Sold      112,575 Depreciation expense: office equipment          2,750 Income tax expense          9,000 Insurance expense          1,900 Office supplies expense              520 Rent expense          5,700...
The adjusted trial balance columns of the worksheet for Martinez Company are as follows. Martinez Company...
The adjusted trial balance columns of the worksheet for Martinez Company are as follows. Martinez Company Worksheet For the Year Ended December 31, 2019 Adjusted Trial Balance Account No. Account Titles Dr. Cr. 101 Cash 5,300 112 Accounts Receivable 10,700 126 Supplies 1,600 130 Prepaid Insurance 1,900 157 Equipment 27,500 158 Accumulated Depreciation—Equipment 5,100 200 Notes Payable 14,000 201 Accounts Payable 6,100 212 Salaries and Wages Payable 2,100 230 Interest Payable 700 311 Common Stock 9,900 320 Retained Earnings 3,400...
Option #1: Preparing Adjusting Entries in a Worksheet Following is the unadjusted trial balance of Baltimore...
Option #1: Preparing Adjusting Entries in a Worksheet Following is the unadjusted trial balance of Baltimore Rentals Corporation at the end of its first year of operations, December 31, 20X5: Account Debit Credit Cash 3,300 Accounts receivable 4,000 Supplies 500 Truck 8,000 Acc. dep. – truck 0 Accounts payable 5,000 Unearned rent revenue 2,400 Income taxes payable 0 Capital Stock 7,000 Dividends 1,000 Rent earned 16,000 Commissions expense 1,000 Depreciation expense-truck 0 Supplies expense 0 Salaries expense 7,000 Telephone expense...
Prepare the Income Statement,  the Retained Earning Statement , the Classified  Balance Sheet, and the Closing Entries using...
Prepare the Income Statement,  the Retained Earning Statement , the Classified  Balance Sheet, and the Closing Entries using the adjusted trial balance for Stockton Company. Stockton Company Adjusted Trial Balance For the Year ended December 31, 2018 Cash $  6,030 Accounts Receivable 2,100 Prepaid Expenses    700 Land 10,000 Equipment 13,700 Accumulated Depreciation $  1,100 Accounts Payable 1,900 Notes Payable,   4,200 Common Stock 10,000 Retained Earnings 12,150 Fees Earned 8,750 Wages Expense 2,500 Rent Expense 1,960 Utilities Expense 775 Depreciation Expense 250 Miscellaneous Expense 85...
31. Presented below is the adjused trial balance columns on a worksheet of Kimberly Company for...
31. Presented below is the adjused trial balance columns on a worksheet of Kimberly Company for the year ended December 31, 2018. Using this adjusted trial balance to answer questions 31 and 32:                                                                                 Adjusted Trial Balance Account Titles                                                             Debit             Credit ______________                                                       _____            _____ Cash                                                                           1,000 Supplies                                                                         300 Prepaid...
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...
The income statement and selected balance sheet information for Direct Products Company for the year ended...
The income statement and selected balance sheet information for Direct Products Company for the year ended December 31 are presented below. Income Statement   Sales Revenue $ 42,600   Expenses:        Cost of Goods Sold 18,000        Depreciation Expense 1,400        Salaries and Wages Expense 8,400        Rent Expense 3,900        Insurance Expense 1,600        Interest Expense 1,500        Utilities Expense 1,100   Net Income $ 6,700 Selected Balance Sheet Accounts Ending Balances Beginning Balances   Accounts Receivable $ 565     $ 590       Inventory 830     690       Accounts Payable...