Question: Please provide the answers using EXCEL. I will really appreciate it! During the Month of December, Business Solutions had the following Transactions Paid $1,025 cash

Please provide the answers using EXCEL. I will really appreciate it!

During the Month of December, Business Solutions had the following Transactions

  1. Paid $1,025 cash to Hillside Mall for Business Solutions share of mall advertising costs.
  2. Paid $500 cash for Minor repairs to the companys computer.
  3. Received $3,950 cash from Alexs Engineering Co for receivables from November
  1. Paid Cash to Lyn Addie for six days of work at the rate of $125 per day
  1. Notified by Alexs Engineering Co that Business Solutions bid of $7,000 on a proposed project has been accepted. Alexs paid $1,500 cash advance to Business Solutions
  2. Purchased $1,100 of computer supplier on credit from Harris Office Products.
  3. Sent a reminder to Gomez Co. to pay its fee for services recorded on November 8th.
  1. Completed a project for Liu Corporation and received $5,625 cash.
  1. Received $3,000 cash from Gomez Co. on its receivable
  2. Reimbursed S. Rey for business automobile mileage. (Rey drove 600 miles and was reimbursed $0.32 per mile)
  1. S. Rey withdrew $1,500 cash from the company for personal use.

Additionally, the following facts are required to make the necessary adjusting entries.

  1. The December 31 inventory count of computer supplies shows $580 still available
  2. Three months have expired since the 12 month insurance premium was paid in advance
  3. As of December 31, Lyn Addie has not been paid for four days of work at $125 per day
  4. The computer system, acquired on October 1, is expected to have a four-year life with no salvage value.
  5. The office equipment, acquired on October 1, is expected to have a five-year life with no salvage value
  6. Three of the four months prepared rent has expired.

REQUIREMENTs:

  1. Prepare journal entries to record each of the December transactions and events for Business Solutions. Post those entries to their respective T accounts
  2. Prepare adjusting entries to reflect a thru f. Post those entries to their respective T accounts
  3. Prepare an adjusted trial balance as of December 31, 2019
  4. Prepare an income statement for the three months ended December 31,2019
  5. Prepare a statement of owners equity for the three months ended December 31, 2019
  6. Prepare a balance sheet as of December 31, 2019
  7. Record the necessary closing entries as of December 31, 2019
  8. Prepare a post-closing trial balance as of December 31, 2019

Business Solution

Trial Balance

As of November 30, 2019

Account Title

Debit

Credit

Cash

$38,264

Accounts Receivable

12,618

Computer Supplies

2,545

Prepaid Insurance

2,220

Prepaid Rent

3,300

Office Equipment

8,000

Accumulated Depreciation - Office Equipment

0

Computer Equipment

20,000

Accumulated Depreciation - Computer Equipment

0

Accounts Payable

0

wages Payable

0

Unearned Computer Services Revenue

0

S. Rey Capital

73,000

S Rey Withdrawals

5,600

Computer Services Revenue

25,659

Depreciation Expense - Office Equipment

0

Depreciation Expense - Computer Equipment

0

Wages Expense

2,625

Insurance Expense

0

Rent Expense

0

Computer Supplies Expense

0

Advertising Expense

1,728

Mileage Expense

704

Miscellaneous Expenses

250

Repairs Expense

805

$98,659

$98,659

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!