Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need to create a Trial Balance from data in the first two pictures. art 1: Problem After the success achieved in ihe first two
I need to create a Trial Balance from data in the first two pictures.
art 1: Problem After the success achieved in ihe first two months of operations, Business Solutions continues to be nanaged by Santana Rey. The November 30, 2018, unadjusted trial balance of the company, reflecting is transactions for October and November of 2018, is shown in Figure 1. Figure 1. Unadjusted Trial Balance - November 30, 2018 Account Title Credit 101 Cash Debit $38,264 12,618 2,545 2,220 3,300 8,000 20,000 168 LACC 0 106 Accounts Receivable 126 Computer Supplies 128 Prepaid Insurance 131 Prepaid Rent 163 Office Equipment 164 Accumulated Depreciation - Office Equipment 167 Computer Equipment Accumulated Depreciation - Computer Equipment 201 Accounts Payable 210 Wages Payable 236 Unearned Computer Services Revenue 301 S. Rey, Capital 302 S. Rey, Withdrawals 403 Computer Services Revenue 612 Depreciation Expense - Office Equipment 613 Depreciation Expense - Computer Equipment 623 Wages Expense 637 Insurance Expense 640 Rent Expense 652 Computer Supplies Expense 655 Advertising Expense 676 Mileage Expense 677 Miscellaneous Expenses 684 Repair's Expense - Computer $73,000 5,600 25,659 2,625 0 0 1.728 704 250 805 DLL Totals . . . $98.659 $98.659 had in December 2018: Figure 2 shows the transactions and 5 9 9 05 O Figure 2. Transactions and Events - December 2018 Month, Day Transaction Paid $1,025 cash to Hillside Mall for Business Solutions' share of mall advertising costs. Paid $500 cash for minor repair to the company's computer Received $3,950 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 $125 per day Notified by Alex's Engineering Co. that Business Solutions' bid of $7,000 on a 14 proposed project has been accepted. Alex's paid a $1,500 cash advance to Business Solutions 15 Purchased $1,100 of computer supplies on credit from Harris Office Products Sent a reminder to Gomez Co. to pay the fee for services recorded on November December 2018 20 28 29 31 Completed a project for Liu Corporation and received $6,625 cash Took the week off for the holidays Received $3,000 cash from Gomez Co. on its receivable Reimbursed S. Rey for business automobile mileage (600 miles at $0.32 per mile) S. Rey withdrew $1,500 cash from the company for personal use 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 $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' prepaid rent has expired. Part 2: Assignment Use the Business Solutions template to complete the assignment 1. Prepare journal entries to record each of the December tractions and events for Business Solutions. Post those entries to the accounts in the ledger. 2. Prepare adjusting entries to reflect a through f. Post those entries to the accounts in the ledger. 3. Prepare an adjusted trial balance as of December 31, 2018 4. Prepare an income statement for the three months ended December 31, 2018 6. Prepare a statement of owner's equity for the three months ended December 31, 2018 Trial Balance December 31, 2018 Adjusted Nm Debit Credit Unadjusted Debit Credit 38,264 12,618 2,545 2,220 3,300 8,000 Adjusted Trial Balance Debit Credit 38,264 12,618 2,545 2,220 3,300 8,000 - 20,000 20,000 Goooo 4 101 Cash 5 106 Accounts Receivables 6 126 Computer Supplies 7 128 Prepaid Insurance 8 131 Pre Paid Rent 9 163 Office Equipment 10 164 Accum. Deprec - Office Equipment 11 167 Computer Equipment 12 168 Accum. Deprec - Comp Equip 13 201 Accounts Payable 14 210 Wages Payable 15 236 Unearned Comp Serv Revenue 16 301 S Rey - Capital 17 302 S Rey - Withdrawals 18 403 Computer Services Revenue 19 612 Depr. Expense - Office Equip 20 613 Depr. Expense - Comp. Equip 21 623 Wages Expense 22 637 Insurance Expense 23 640 Rent Expense 24 652 Computer Supplies Expense 25 655 Advertising Expense 26 676 Milleage expense 27 677 Misc Expense 28 684 Repairs Expense - Comp 73,000 73,000 5,600 5,600 25,659 25,659 ~ + 5D 1,728 704 250 805 98,659 250 805 98,659 29 98,659 0 98,659 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started