Question

In: Accounting

Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s...

Serial Problem Business Solutions LO P1, P2, P3, P4, P5

After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2016, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2016) follows.

No. Account Title Debit Credit
101 Cash $ 38,664
106 Accounts receivable 12,718
126 Computer supplies 2,545
128 Prepaid insurance 2,160
131 Prepaid rent 3,020
163 Office equipment 8,400
164 Accumulated depreciation—Office equipment $ 0
167 Computer equipment 22,000
168 Accumulated depreciation—Computer equipment 0
201 Accounts payable 0
210 Wages payable 0
236 Unearned computer services revenue 0
307 Common stock 63,000
318 Retained earnings 0
319 Dividends 6,200
403 Computer services revenue 38,374
612 Depreciation expense—Office equipment 0
613 Depreciation expense—Computer equipment 0
623 Wages expense 2,500
637 Insurance expense 0
640 Rent expense 0
652 Computer supplies expense 0
655 Advertising expense 1,628
676 Mileage expense 664
677 Miscellaneous expenses 150
684 Repairs expense—Computer 725
Totals $ 101,374 $ 101,374

Business Solutions had the following transactions and events in December 2016.

Dec. 2 Paid $940 cash to Hillside Mall for Business Solutions’s share of mall advertising costs.
3 Paid $420 cash for minor repairs to the company’s computer.
4 Received $4,350 cash from Alex’s Engineering Co. for the receivable from November.
10 Paid cash to Lyn Addie for six days of work at the rate of $100 per day.
14 Notified by Alex’s Engineering Co. that Business Solutions’s bid of $7,500 on a proposed project has been accepted. Alex’s paid a $1,800 cash advance to Business Solutions.
15 Purchased $1,500 of computer supplies on credit from Harris Office Products.
16 Sent a reminder to Gomez Co. to pay the fee for services recorded on November 8.
20 Completed a project for Liu Corporation and received $6,475 cash.
22–26 Took the week off for the holidays.
28 Received $3,500 cash from Gomez Co. on its receivable.
29 Reimbursed S. Rey for business automobile mileage (400 miles at $0.32 per mile).
31 The company paid $1,400 cash in dividends.

The following additional facts are collected for use in making adjusting entries prior to preparing financial statements for the company’s first three months:

The December 31 inventory count of computer supplies shows $620 still available.

Three months have expired since the 12-month insurance premium was paid in advance.

As of December 31, Lyn Addie has not been paid for four days of work at $100 per day.

The computer system, acquired on October 1, is expected to have a four-year life with no salvage value.

The office equipment, acquired on October 1, is expected to have a five-year life with no salvage value.

Three of the four months' prepaid rent has expired.

2.1 Prepare adjusting entries to reflect a through f.

2.2 Post the journal entries to record each of the December transactions, adjusting entries to the accounts in the ledger.


General Ledger Accounts


3. Prepare an adjusted trial balance as of December 31, 2016.

4. Prepare an income statement for the three months ended December 31, 2016.


5. Prepare a statement of retained earnings equity for the three months ended December 31, 2016.


6. Prepare a balance sheet as of December 31, 2016.


7. Record and post the necessary closing entries for Business Solutions. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.)

a) Record the entry to close the revenue account.
b)Record the entry to close the expense accounts.
c)Record the entry to close the income summary account.
d)Record the entry to close the dividends accounts.

8.Prepare a post-closing trial balance as of December 31, 2016.

Solutions

Expert Solution

Business Solutions
General journal for the month ended December 31, 2016
Date Account Title Debit Credit
Dec.2 Advertising Expenses 940
Cash 940
Dec.3 Repair Expense - Computers 420
Cash 420
Dec.4 Cash 4350
Accounts Receivable 4350
Dec.10 Wages Expense 600
Cash 600
Dec.14 Cash 1800
Unearned Service Revenue 1800
Dec.15 Computer Supplies 1500
Accounts Payable 1500
Dec.16 No entry required
Dec.20 Cash 6475
Computer Service Revenue 6475
Dec.28 Cash 3500
Accounts Receivable 3500
Dec.29 Mileage Expense 128
Cash 128
Dec.31 Dividends 1400
Cash 1400
Adjusting Entries
Date Account Title Debit Credit
Dec.31 Computer Supplies Expense 3425
Computer Supplies 3425
Dec.31 Insruance Expense 540
Prepaid Insurance 540
Dec.31 Wages Expense 400
Wages Payable 400
Dec.31 Depreciation expense - Computer Equipment 1375
Depreciation expense - Office Equipment 420
Accumulated Depreciation - Computer Equipment 1375
Accumulated Depreciation - Office Equipment 420
Dec.31 Rent Expense 2265
Prepaid Rent 2265
Computer supplies
Unadjusted balance 4045
Supplies on hand 620
Computer Supplies Expense 3425
Insurance Expense
Prepaid insurance - for 12 months 2160
Insurance Expense - for 3 months 540
Cash Accounts Receivable
Date Ref Debit credit Balance Date Ref Debit credit Balance
Debit Credit Debit Credit
Dec.1 Balance 38664 Dec.1 Balance 12718
Dec.2 Advt. 940 37724 Dec.4 Cash 4350 8368
Dec.3 Repairs 420 37304 Dec.28 Cash 3500 4868
Dec.4 A/R 4350 41654 4868
Dec.10 Wages 600 41054 4868
Dec.14 Unearned 1800 0 42854 4868
Dec.20 Serv.Rev. 6475 49329
Dec.28 A/R 3500 52829 Computer Supplies
Dec.29 Mileage 128 52701 Date Ref Debit credit Balance
Dec.31 Dividend 1400 51301 Debit Credit
51301 Dec.1 Bal. 2545
Dec.15 A/p 1500 4045
Dec.31 Exp. 3425 620
Office Equipment
Date Ref Debit credit Balance Prepaid Insurance
Debit Credit Date Ref Debit credit Balance
Dec.1 Bal. 8400 Debit Credit
8400 Dec.1 Bal. 2160
Dec.31 Expense 540 1620
Prepaid Rent
Date Ref Debit credit Balance Accumuluated Depreciation - Office Equipment
Debit Credit Date Ref Debit credit Balance
Dec.1 Bal. 3020 Debit Credit
Dec.31 2265 755 Dec.31 Dep. 420 420
755
Accumulated Depreciation - Computer Equipment
Computer Equipment Date Ref Debit credit Balance
Date Ref Debit credit Balance Debit Credit
Debit Credit Dec.31 Dep. 1375 1375
Dec.1 Bal. 22000 1375
22000
Accounts Payable
Common stock Date Ref Debit credit Balance
Date Ref Debit credit Balance Debit Credit
Debit Credit Dec.1 Bal. 0
Dec.1 Bal. 63000 Dec.15 Supplies 1500 1500
63000 1500
63000
Wages Payable
Dividends Date Ref Debit credit Balance
Date Ref Debit credit Balance Debit Credit
Debit Credit Dec.1 Bal. 0
Dec.1 Bal. 6200 Dec.31 400 400
Dec.31 Cash 1400 7600 400
Unearned Service Revenue
Computer Service Revenue Date Ref Debit credit Balance
Date Ref Debit credit Balance Debit Credit
Debit Credit Dec.1 Bal. 0
Dec.1 Bal. 38374 Dec.14 Cash 1800 1800
Dec.20 Cash 6475 44849
44849 Wages Expense
Date Ref Debit credit Balance
Computer Supplies Expense Debit Credit
Date Ref Debit credit Balance Dec.1 Bal. 2500
Debit Credit Dec.10 Cash 600 3100
Dec.31 Supplies 3425 3425 Dec.31 400 3500
3425
Depreciation expense - Office Equipment Insurance Expense
Date Ref Debit credit Balance Date Ref Debit credit Balance
Debit Credit Debit Credit
Dec.31 Exp. 420 420 Dec.31 Prepaid 540 2500
420 2500
Depreciation expense - Computer equipment Rent Expense
Date Ref Debit credit Balance Date Ref Debit credit Balance
Debit Credit Debit Credit
Dec.31 Exp. 1375 1375 Dec.31 Bal. 0
1375 Dec.31 2265 2265
Advertising Expense Mileage Expense
Date Ref Debit credit Balance Date Ref Debit credit Balance
Debit Credit Debit Credit
Dec.1 Bal. 1628 Dec.1 Bal. 664
Dec.2 Cash 940 2568 Dec.29 Cash 128 792
Miscellaneous Expense Repairs Expense - Computers
Date Ref Debit credit Balance Date Ref Debit credit Balance
Debit Credit Debit Credit
Dec.1 Bal. 150 Dec.1 Bal. 725
150 Dec.3 Cash 420 1145
Business Solutions
Worksheet for the month of December 2016
Unadjusted Adjustments Adjusted Income statement Post Closing
Account Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
Cash 51301 51301 51301
Accounts Receivable 4868 4868 4868
Computer Supplies 4045 3425 620 620
Prepaid Rent 3020 2265 755 755
Prepaid Insurance 2160 540 1620 1620
Office Equipment 8400 8400 0 8400
Accumulated Depreciation - Office Equipment 420 420 420
Computer Equipment 22000 22000 0 22000
Accumulated Depreciation - Computer Equipment Equipment 1375 1375 1375
Accounts Payable 1500 1500 1500
Wages Payable 400 400 400
Unearned Service Revenue 1800 0 1800 1800
Common stock 63000 0 63000 63000
Retained Earnings 0 0 21069
Dividends 7600 7600
Computer Service Revenue 44849 44849 44849
Wages Expense 3100 400 3500 3500
Rent Expense 0 2265 2265 2265
Computer Supplies Expense 3425 3425 3425
Advertising Expense 2568 2568 2568
Insurance Expense 540 540 540
Depreciation expense - Offie Equipment 420 420 420
Depreciation expense - Computer Equipment 1375 1375 1375
Mileage expense 792 792 792
Repairs expense 1145 1145 1145
Miscellaneous Expense 150 150 150
111149 111149 8425 8425 113344 113344 16180 44849 89564 89564
Business Solutions
Income Statement
For the year ended December 31, 2016
Service Revenue 44849
Expenses:
Wages Expense 3500
Rent Expense 2265
Computer Supplies Expense 3425
Advertising Expense 2568
Insurance Expense 540
Depreciation expense - Offie Equipment 420
Depreciation expense - Computer Equipment 1375
Mileage expense 792
Repairs expense 1145
Miscellaneous Expense 150
Total Expenses 16180
Net Income 28669
Business Solutions
Statement of Retained Earnings
For the year ended December 31, 2016
Beginning Balance 0
Net income for the month 28669
Dividends -7600
Balance as at July 31 21069
Eli's Consulting Services
Balance Sheet
as at December 31, 2016
Assets
Cash 51301
Accounts Receivable 4868
Computer Supplies 620
Prepaid Rent 755
Prepaid Insurance 1620
Total current Asets 59164
Office Equipment 8400
Accumulated Depreciation - Office Equipment 420 7980
Computer Equipment 22000
Accumulated Depreciation - Computer Equipment Equipment 1375 20625
Total Assets 87769
Liabilities and equity
Accounts Payable 1500
Wages Payable 400
Unearned Service Revenue 1800
Total Liabilities 3700
Stockholders' equity
Common Stock 63000
Retained Earnings 21069
Total Stockholders' equity 84069
Total Liabilities and stockholders' equity 87769

Related Solutions

Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2017, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2017) follows. No. Account Title Debit Credit 101 Cash $ 38,764 106 Accounts receivable 13,418 126 Computer supplies 2,545 128 Prepaid insurance 2,040 131 Prepaid rent 3,140 163 Office equipment 8,000 164 Accumulated depreciation—Office equipment $...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2017, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2017) follows. No. Account Title Debit Credit 101 Cash $ 38,864 106 Accounts receivable 12,718 126 Computer supplies 2,645 128 Prepaid insurance 2,040 131 Prepaid rent 2,940 163 Office equipment 8,400 164 Accumulated depreciation—Office equipment $...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2015, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2015) follows. No. Account Title Debit Credit 101   Cash $ 39,164 106   Accounts receivable 12,918 126   Computer supplies 2,645 128   Prepaid insurance 1,980 131   Prepaid rent 2,960 163   Office equipment 8,400 164   Accumulated depreciation—Office equipment $...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2015, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2015) follows. No. Account Title Debit Credit 101   Cash $ 39,164 106   Accounts receivable 12,918 126   Computer supplies 2,645 128   Prepaid insurance 1,980 131   Prepaid rent 2,960 163   Office equipment 8,400 164   Accumulated depreciation—Office equipment $...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2017, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2017) follows. No. Account Title Debit Credit 101 Cash $ 39,264 106 Accounts receivable 13,418 126 Computer supplies 2,645 128 Prepaid insurance 2,040 131 Prepaid rent 2,920 163 Office equipment 8,100 164 Accumulated depreciation—Office equipment $...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2017, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2017) follows. No. Account Title Debit Credit 101 Cash $ 38,664 106 Accounts receivable 12,818 126 Computer supplies 2,645 128 Prepaid insurance 2,040 131 Prepaid rent 3,240 163 Office equipment 8,700 164 Accumulated depreciation—Office equipment $...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2017, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2017) follows. No. Account Title Debit Credit 101 Cash $ 38,264 106 Accounts receivable 12,618 126 Computer supplies 2,545 128 Prepaid insurance 2,220 131 Prepaid rent 3,300 163 Office equipment 8,000 164 Accumulated depreciation—Office equipment $...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2016, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2016) follows. No. Account Title Debit Credit 101 Cash $ 38,764 106 Accounts receivable 12,918 126 Computer supplies 2,645 128 Prepaid insurance 2,160 131 Prepaid rent 3,280 163 Office equipment 8,300 164 Accumulated depreciation—Office equipment $...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2016, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2016) follows. No. Account Title Debit Credit 101 Cash $ 38,764 106 Accounts receivable 12,918 126 Computer supplies 2,645 128 Prepaid insurance 2,160 131 Prepaid rent 3,280 163 Office equipment 8,300 164 Accumulated depreciation—Office equipment $...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s...
Serial Problem Business Solutions LO P1, P2, P3, P4, P5 After the success of the company’s first two months, Santana Rey continues to operate Business Solutions. The November 30, 2016, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2016) follows. No. Account Title Debit Credit 101 Cash $ 38,764 106 Accounts receivable 12,918 126 Computer supplies 2,645 128 Prepaid insurance 2,160 131 Prepaid rent 3,280 163 Office equipment 8,300 164 Accumulated depreciation—Office equipment $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT