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
- Paid $1,025 cash to Hillside Mall for Business Solutions share of mall advertising costs.
- Paid $500 cash for Minor repairs to the companys computer.
- Received $3,950 cash from Alexs Engineering Co for receivables from November
- Paid Cash to Lyn Addie for six days of work at the rate of $125 per day
- 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
- Purchased $1,100 of computer supplier on credit from Harris Office Products.
- Sent a reminder to Gomez Co. to pay its fee for services recorded on November 8th.
- Completed a project for Liu Corporation and received $5,625 cash.
- Received $3,000 cash from Gomez Co. on its receivable
- Reimbursed S. Rey for business automobile mileage. (Rey drove 600 miles and was reimbursed $0.32 per mile)
- S. Rey withdrew $1,500 cash from the company for personal use.
Additionally, the following facts are required to make the necessary adjusting entries.
- The December 31 inventory count of computer supplies shows $580 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 $125 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 prepared rent has expired.
REQUIREMENTs:
- Prepare journal entries to record each of the December transactions and events for Business Solutions. Post those entries to their respective T accounts
- Prepare adjusting entries to reflect a thru f. Post those entries to their respective T accounts
- Prepare an adjusted trial balance as of December 31, 2019
- Prepare an income statement for the three months ended December 31,2019
- Prepare a statement of owners equity for the three months ended December 31, 2019
- Prepare a balance sheet as of December 31, 2019
- Record the necessary closing entries as of December 31, 2019
- 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
Get step-by-step solutions from verified subject matter experts
