Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need to fillout Statments sheet using the info from the last two pictures. - MAA A General F Wrap Test Merge Center 5 -% 9
Need to fillout Statments sheet using the info from the last two pictures.
- MAA A General F Wrap Test Merge Center 5 -% 9 Condition Formatting 2 Normal forms Calculation Table Bad check Good p lanter BCD Balance Sheet December 31, 2018 Statement of Owners Equity December 31, 2018 3 Assets Income Statement December 31, 2018 301 S Rey - Capital Net Income 73,000 19,547 Revenues 92,547 403 Computer Services Revenue 25,659 38,264 12,618 2,545 2,220 3,300 302 S Rey - Withdrawals 101 Cash 6 106 Accounts Receivables 7 126 Computer Supplies 8 128 Prepaid Insurance 9 131 Pre Paid Rent 10 163 Office Equipment 11 164 Accum. Deprec - Office Equ 12 167 Computer Equipment 13 168 Accum. Deprec - Comp Equi 5,600 86,947 Expenses 8,000 8,000 o 20,000 o 20,000 86,947 0 16 Liabilities 612 Depr. Expense - Office 0 613 Depr. Expense - Comp. 0 623 Wages Expense 2,625 637 Insurance Expenses 0 640 Rent Expense 652 Computer Supplies Expo 655 Advertising Expense 1.728 676 Milleage expense 704 677 Misc Expense 250 684 Repairs Expense - Com 805 Total Expenses Net Income 18201 Accounts Payable 19 210 Wages Payable 20 236 Unearned Comp Serv Revenue OOOO 6,112 19,547 23 Equity 25 301 S Rey - Capital 86,947 86,947 99 Journal Charts Trial Bal Statements 2. Complete the assignment with the template in Canvas Week 3. Part 1: Problem After the success achieved in the first two months of operations, Business Solutions continues to be managed by Santana Rey. The November 30, 2018, unadjusted trial balance of the company, reflecting its transactions for October and November of 2018, is shown in Figure 1.. Figure 1. Unadjusted Trial Balance - November 30, 2018 Credit / Debit $38,264 12,618 2,545 2,220 3,300 8,000 / / 01 20,000 Account Title 101 Cash US 106 Accounts Receivable 126 Computer Supplies 128 Prepaid Insurance 131 Prepaid Rent 163 Office Equipment 164 Accumulated Depreciation - Office Equipment 167 Computer Equipment 168 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 0 0 2,625 0 0 1,728 704 250 805 ords e here to search BRIN Share $98,659 Totals $98,659 Figure 2 shows the transactions and events Business Solutions had in December 2018: Figure 2. Transactions and Events - December 2018 Month, Day Transaction Paid $1,025 cash to Hillside Mali for Business Solutions' share of mall advertising costs. Paid $500 cash for minor repairs to the company's computer Received $3,950 cash from Alex's Engineering Co. for the receivable from November 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 proposed project has been accepted. Alex's paid a $1,500 cash advance to Business Solutions 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 10 14 December 2018 15 20 22-26 28 29 31 Completed a project for Liu Corporation and received $5,625 cash Took the week off for the holidays Received $3,000 cash from Gomez Coon 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. 5. Prepare a statement of owner's equity for the three months ended December 31, 2018 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