Question

In: Accounting

Prepare a worksheet that contains the following columns: Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement...

Prepare a worksheet that contains the following columns: Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement and Balance Sheet.

From the following transactions as well as add't data, please complete the entire accounting cycle for Parker's Plowing (using the chart of accounts below) for 2018.

Jan. 1 Parker invested $10,000 cash and $12,000 worth of snow equipment into the plowing company.

Jan. 1 Paid rent for six months in advance for garage space, $6000

Jan. 6 Purchased snow supplies for $800 casj/

Jan. 8 Collected $14,000 from plowing local shopping centers.

Jan. 12 Parker muroney withdrew $4000 from the business for his own personal use.

Jan. 20 Plowed Alton Co. parking lots, payment not to be received until May, $1, 500.

Jan. 26 Paid salaries to employees, $1900.

Jan. 28 Paid Lumen Corp. one-half amount owed for office equipment

Jan. 29 Advertising bill received from Washington Co. but will not be paid until May, $700

Jan. 30 Paid telephone bill, $130

Adjustent Data

a. Snow supplies on hand, $700

b. Rent expired, $1000

c. Depreciation on office equipent, $210: (12,600/5 yr = $2,520/12 mo. = $210).

d. Depreciation on snow equipment, $200: ($12,000/5 yr = $2,400/12 mo. = $200).

e. Accrued salaries, $380

Chart of accounts

Assets

111 Cash

112 Accounts Receivable

114 Prepaid Rent

115 Snow Supplies

121 Office Equipment

122 Accumulated Depreciation, Office Equipment

123 Snow Equipment

124 Accumulated Depreciation, Snow Equipment

Liabilities

211 Accounts Payable

212 Salaries Payable

Owners Equity

311 Parker Muroney, Capital

312 Parker Muroney, Withdrawls

313 Income Summary

Revenue

411 Plowing Fees

Expenses

511 Salary Expense

512 Advertising Expense

513 Telephone Expense

514 Rent Expense

515 Snow Supplies Expense

516 Depreciation Expense, Office Equipment

517 Depreciation Expense, Snow Equipment

General Journal
Date Accounts Titles and Descriptions Dr. Cr.
2018 Jan 1 Cash 10000
Snow Equipment 12000
     Parker Muroney, Capital 22000
          Investent
1 Prepaid Rent 6000
     Cash 6000
          Rent Paid in Advance-6 months
4 Office Equipment 12600 12600
     Accounts Payable 12600
          Purchased Equipment on Account
6 Snow Supplies 800
     Cash 800
          Supplies purchased for cash
8 Cash 14000
     Plowing Fees 14000
12 Parker Muroney, Withdrawls 4000
     Cash 4000
          Personal use
20 Accounts Receivable 1500
     Plowing Fees 1500
          Services Rendered on Account
26 Salary Expense 1900
     Cash 1900
          Paid Salaries
28 Cash 6000
     Accounts Payable 6000
          Payment on Account
29 Advertising Expenses 700
     Accounts Payable 700
30 Telephone Expense 130
     Cash 130
Totals 69630 69630

Solutions

Expert Solution

Accounts Title

Trial Balance

Adjustments

Adjusted Trial balance

Income Statement

Balance Sheet

Debit

Credit

Debit

Credit

Debit

Credit

Debit

Credit

Debit

Credit

111 Cash

$    4,870.00

$    4,870.00

$    4,870.00

112 Accounts Receivable

$    1,500.00

$    1,500.00

$    1,500.00

114 Prepaid Rent

$    6,000.00

$ 1,000.00

$    5,000.00

$    5,000.00

115 Snow Supplies

$        800.00

$     100.00

$        700.00

$        700.00

121 Office Equipment

$ 12,600.00

$ 12,600.00

$ 12,600.00

122 Accumulated Depreciation, Office Equipment

$     210.00

$        210.00

$        210.00

123 Snow Equipment

$ 12,000.00

$ 12,000.00

$ 12,000.00

124 Accumulated Depreciation, Snow Equipment

$     200.00

$        200.00

$        200.00

211 Accounts Payable

$    7,000.00

$    7,000.00

$    7,000.00

212 Salaries Payable

$     380.00

$        380.00

$        380.00

311 Parker Muroney, Capital

$ 22,000.00

$ 22,000.00

$ 22,000.00

312 Parker Muroney, Withdrawls

$    4,000.00

$    4,000.00

$    4,000.00

313 Income Summary

$ 10,880.00

$ 10,880.00

411 Plowing Fees

$ 15,500.00

$ 15,500.00

$ 15,500.00

511 Salary Expense

$    1,900.00

$         380.00

$    2,280.00

$    2,280.00

512 Advertising Expense

$        700.00

$        700.00

$        700.00

513 Telephone Expense

$        130.00

$        130.00

$        130.00

514 Rent Expense

$      1,000.00

$    1,000.00

$    1,000.00

515 Snow Supplies Expense

$         100.00

$        100.00

$        100.00

516 Depreciation Expense, Office Equipment

$         210.00

$        210.00

$        210.00

517 Depreciation Expense, Snow Equipment

$         200.00

$        200.00

$        200.00

$ 44,500.00

$ 44,500.00

$ 45,290.00

$ 45,290.00

$ 15,500.00

$ 15,500.00

$ 40,670.00

$ 40,670.00


Related Solutions

Please prepare a full trial balance – Trial Balance, Adjustments,Adjusted Trial Balance, Income Statement, Balance...
Please prepare a full trial balance – Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement, Balance Sheet, and Statement of Owner’s Equity, as well the individual Balance Sheet, Income Statement, and Statement of Owners Equity. Include any journal entries necessary for this assignment. Use T accounts if you find them helpful. Attached are the files for your use. Check your formulas. 1. You are reporting for your client for the One Month period September 30, 2020 2. The started the...
Create a balance sheet The adjusted trial balance columns of the worksheet for Ayayai Company are...
Create a balance sheet The adjusted trial balance columns of the worksheet for Ayayai Company are as follows. Ayayai Company Worksheet (Partial) For the Month Ended April 30, 2019 Adjusted Trial Balance Account Titles Dr. Cr. Cash 11,500 Accounts Receivable 7,620 Prepaid Rent 2,180 Equipment 22,950 Accumulated Depreciation—Equip. 5,000 Notes Payable 5,800 Accounts Payable 4,500 Common Stock 20,500 Retained Earnings 8,550 Dividends 3,500 Service Revenue 15,500 Salaries and Wages Expense 10,800 Rent Expense 700 Depreciation Expense 600 Interest Expense 60...
The adjusted trial balance columns of the worksheet for Monty Company are as follows: Complete the...
The adjusted trial balance columns of the worksheet for Monty Company are as follows: Complete the worksheet. Monty Company Worksheet (Partial) choose the accounting period                                                          April 30, 2022For the Month Ended April 30, 2022 Adjusted Trial Balance Income Statement Balance Sheet Account Titles Dr. Cr. Dr. Cr. Dr. Cr. Cash 11,000 Accounts Receivable 8,000 Prepaid Rent 2,200 Equipment 22,700 Accumulated Depreciation—Equip. 5,000...
Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and...
Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and balance sheet included with the data below. Also, create a pivot table. Create a general ledger, worksheet, income statement, changes in retained earnings, and balance sheet with the data below. June 1: Hudson Bloom invested $105,273.00 cash and computer equipment with a fair market value of $32,970.00 in his new business, Byte of Accounting. June 1:   Check # 5000 was used to purchased office...
The adjusted trial balance columns of the worksheet for Ayayai Company are as follows. Ayayai Company...
The adjusted trial balance columns of the worksheet for Ayayai Company are as follows. Ayayai Company Worksheet (Partial) For the Month Ended April 30, 2019 Adjusted Trial Balance Account Titles Dr. Cr. Cash 11,500 Accounts Receivable 7,620 Prepaid Rent 2,180 Equipment 22,950 Accumulated Depreciation—Equip. 5,000 Notes Payable 5,800 Accounts Payable 4,500 Common Stock 20,500 Retained Earnings 8,550 Dividends 3,500 Service Revenue 15,500 Salaries and Wages Expense 10,800 Rent Expense 700 Depreciation Expense 600 Interest Expense 60 Interest Payable 60     Totals...
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...
Question 1 The adjusted trial balance columns of the worksheet for Martinez Company are as follows....
Question 1 The adjusted trial balance columns of the worksheet for Martinez Company are as follows. MARTINEZ COMPANY Worksheet (partial) For the Month Ended April 30, 2017 Adjusted Trial Balance Account Titles Dr. Cr. Cash 8,850 Accounts Receivable 7,769 Prepaid Rent 2,478 Equipment 23,235 Accumulated Depreciation—Equip. 5,386 Notes Payable 5,842 Accounts Payable 4,831 Share Capital—Ordinary 24,145 Retained Earnings 4,224 Dividends 3,287 Service Revenue 12,464 Salaries and Wages Expense 9,695 Rent Expense 842 Depreciation Expense 736 Interest Expense 22 Interest Payable...
Question 2 The adjusted trial balance columns of the worksheet for Indigo Company are as follows....
Question 2 The adjusted trial balance columns of the worksheet for Indigo Company are as follows. No ordinary shares were issued during April. INDIGO COMPANY Worksheet (partial) For the Month Ended April 30, 2017 Adjusted Trial Balance Account Titles Dr. Cr. Cash 7,099 Accounts Receivable 7,241 Prepaid Rent 2,491 Equipment 22,834 Accumulated Depreciation—Equip. 4,680 Notes Payable 5,613 Accounts Payable 5,569 Share Capital—Ordinary 21,320 Retained Earnings 4,887 Dividends 3,439 Service Revenue 12,434 Salaries and Wages Expense 9,933 Rent Expense 829 Depreciation...
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 (Partial) For the Month Ended April 30, 2022 Adjusted Trial Balance Account Titles Dr. Cr. Cash 11,500 Accounts Receivable 7,720 Prepaid Rent 2,340 Equipment 22,700 Accumulated Depreciation—Equip. 4,500 Notes Payable 5,900 Accounts Payable 5,500 Common Stock 21,010 Retained Earnings 8,200 Dividends 3,850 Service Revenue 15,000 Salaries and Wages Expense 10,600 Rent Expense 750 Depreciation Expense 650 Interest Expense 80 Interest Payable    80...
The adjusted trial balance columns of the worksheet for Alshwer Company are as follows. ALSHWER COMPANY...
The adjusted trial balance columns of the worksheet for Alshwer Company are as follows. ALSHWER COMPANY Worksheet For the Year Ended December 31, 2017 Adjusted Trial Balance Account No. Account Titles Dr. Cr. 101 Cash 5,400 112 Accounts Receivable 11,000 126 Supplies 1,400 130 Prepaid Insurance 1,800 157 Equipment 26,500 158 Accumulated Depreciation—Equipment 5,500 200 Notes Payable 13,200 201 Accounts Payable 6,200 212 Salaries and Wages Payable 2,100 230 Interest Payable 700 311 Common Stock 10,400 320 Retained Earnings 4,900...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT