Had three related practice sets and for this last part ,said to use just that unadjusted trial balance given. but attactched March from my previous practice if thats what you needed
March 31, 2020 Adjusting Entries Adjusted Trial Balance Account Credit Debit Credit Debit Credit Debit 69,602 2,800 9,045 5,220 5,800 176 3,310 1,665 3,300 6,000 300 24,000 1,500 320 Cash A/R - Alex's Engineering Co. A/R Wildcat Services A/R-West Leasing A/R-IFM Co. A/R.Liu Corp. A/R -Gomez Co. A/R-Delta Co A/R-KC, Inc. A/R.Dream, Inc. Merchandise inventory Computer supplies Prepaid insurance Prepaid rent Office equipment Accumulated depreciation Office equipment Computer equipment Accumulated depreciation - Computer equipment Accounts payable Wages payable Unearned computer services revenue Common stock Retained earnings Dividends Computer services revenue Sales Sales returns and allowances Sales discounts Cost of goods sold Depreciation expense-Office equipment Depreciation expense-Computer equipment Wages expense Insurance expense Rent expense Computer supplies expense Advertising expense Mileage expense Miscellaneous expenses Repairs expense-Computer Income Summary Totals 100,000 7,765 4,800 25,305 19,240 500 47 13,910 300 1,500 875 2,375 2,475 600 320 960 154,430 154,430 The following additional facts are available for preparing Computer Solutions adjustments on March 31 prior to financial statement preparation: a. The March 31 amount of computer supplies still available totals $2,005. b. Three more months have expired since the company purchased its annual insurance policy at a $2,220 cost for 12 months of coverage. c. Lyn Addie has not been paid for seven days of work at the rate of $125 per day. d. Three months have passed since any prepaid rent has been transferred to expense. The monthly rent expense is $825. e. Depreciation on the computer equipment for January 1 through March 31 is $1,500. f. Depreciation on the office equipment for January 1 through March 31 is $300. g. The March 31 amount of merchandise inventory still available totals $204. The purpose of part 4 is to prepare quarterly financial statements for Computer Solutions through March 31, 2020. These statements may be prepared using Excel or by hand. Follow the instructions below: 1. Open your file YourName_ACCT305_PS3 and save as YourName_ACCT305_PS4. 2. Before starting Part 4 you should ensure that your general ledger balances agree with the March 31, 2020 balances provided in this folder. 3. (2 points) Using the Unadjusted trial balance you prepared in part 3, prepare a partial work sheet in Excel consisting of the first seven columns that includes the unadjusted trial balance, the March 31 adjustments (a) through (g), and the adjusted trial balance. Use formulas where applicable. Do not prepare closing entries and do not journalize the adjustments or post them to the ledger. 4. (8 points) Prepare the following financial statements: a. Income statement for the three months ended March 31, 2020. Use a single-step format. b. Statement of retained earnings for the three months ended March 31, 2020. C. Classified balance sheet (from the adjusted trial balance) as of March 31, 2020. d. Statement of cash flows using the indirect method for the three months ended March 31, 2020. Owner Raymond Santana contributed $20,000 to the business in exchange for additional stock in the first quarter of 2020 and has received $4,800 in cash dividends. 2 The company purchased $8,000 of merchandise from Kansas Corp. with 6 terms of 1/10,n/30, FOB destination, invoice dated January 26. 2 The company sold merchandise with a $4,640 cost for $5,800 on credit to 6 KC, Inc., invoice dated January 26. 3 The company paid cash to Lyn Addie for 10 days' work at $125 per day. 1 1 The company paid $2,475 cash to Hillside Mall for another three months rent in advance. F e b. 5 3 The company paid Kansas Corp. for the balance due, net of the cash discount, less the $496 amount in the credit memorandum. 5 The company paid $600 cash to the local newspaper for an advertising insert in today's paper. 1 The company received the balance due from Alex's Engineering Co. for fees 1 billed on January 11 1 The company paid $4,800 cash in dividends. The company sold merchandise with a $2,660 cost for $3,220 on credit to 3 Delta Co., invoice dated February 23. 2 The company paid cash to Lyn Addie for eight days work at $125 per day 6 ? The company reimbursed Ray Santana for business automobile mileage 7 (600 miles at $0.32 per mile). 8 The company purchased $2.730 of computer supplies from Harris Office Products on credit, invoice dated March 8. 9 The company received the balance due from Delta Co. for merchandise sold on February 23. (Note discount period versus payment) The company paid $960 cash for minor repairs to the company's computer. 1 The company received $5,260 cash from Dream, Inc., for computing 6 Services provided 1 The company paid the full amount due to Harris Office Products, consisting 9 of amounts created on December 15 (of $1,100) and March 8. 2 The company billed West Leasing for $9,045 of computing services 4 provided M ar 1 ? The company sold merchandise with a $2,002 cost for $2,800 on credit to 5 Wildcat Services, invoice dated March 25. 3 The company sold merchandise with a $1,048 cost for $2.220 on credit to O IFM Company, invoice dated March 30. 3 The company reimbursed R. Santana for business automobile mileage (400 miles at $0.32 per mile) Required: 1