ACCT 201 Project Assignment 1 Version 1(1) Excel Camron M Jones CM Home Insert Draw Page Layout Formulas Data Review View Help & Share fica fx N INSTRUCTIONS: This project is to be worked individually The submission must be typed and shitted in THIS Excel file Prepare the submission as if you are interested in this company and looking to use the company's financial statements to make me decisions. Show label all work for the problems ACCT 201 Corporatie General Ledger Cash (11) 32.400 Ilal BAL Accounts Receivable (1) 40.900 Accounts Payable (21) 44.00 Bal. Como tock (30 58.000 Hal Prepaid leserance (15) 11,500 Office Supplies (10 Hal Wapes Payable (22) Bal 19,700 Retailed Earnings (35) 24.S0 Ral Bal Bal Equipment (16) 179,000 Accumulated Depreciation Fat (17) 39,000 BaL al Dividends (33) 15000 Hal Trucks (1) 74,000 Accumulated the preciation - Trucks (19) 28.000 Hal Wages Expense 35,400 Service Revenue (41) Ral Hal Rent Expo (57) 9.750 Supplies upease (51) BAL Depreciation Free Equipment (5) Bal. Depreciation Expense - Trucks (54) Sheet1 ALLT Unment 1 Version 1) Excel e Search Camren Mlones CM Insert Draw Page Layout Formulas Data Review View Help Share f Rent Expresse (57) Supplies Expense (51) O Depreciation Frequipment (5) Hal T Depreciation Expense Trucks (54) ital Truck Exprese (56) 11,000 Miscellaneous Expense (5) 5.200 Insurance uprave (53) Bat. Hal The unadjusted balances in ACCT 201 Corporation accounts as of December 31st, 2019 are shown in the General Ledger above Additional information! The data needed to determine year-end adjustments are as follows: a) Supplies on hand at December 31, 2019 are 3.800 b) Insurance premiums expired during 2019 are: Depreciation of equipment during 2019 8.600 d) Depreciation of trucks during 2019 is 7,200 c) Wages accrued but not paidat December 31, 2019 are: 3800 2.900 Tasks! 1) Use the additional information provided at year-end to record the adjusting entries and post them into The ledger accounts to calculate the new year end balances. Adjusting Journal Fairies: DR CR heet1 G M N o 2) a. Post the Adjusting Entries in the Adjusted Trial Balance Spreadsheet below. b. Type the names of the accounts not listed in the spreadsheet in the lines provided below "Miscellaneous Expense." c. Complete the "Adjusted Bal" columns. d. Also update the General Ledger by posting the adjustments. Adjustments Dr. Cr. Adjusted Bal. Dr. Cr. Cash Accounts Receivable omce Supplies Prepaid Insurance Equipment Accumulated Depreciation - Equipment Trucks Accumulated Depreciation - Trucks Accounts Payable Wages Payable Common Stock Dividends Retained Earnings Service Revenue Wages Expense Truck Espense Rent Expense Miscellaneous Expense Adjusted Trial Balance Unadjusted Bal. Dr. Cr. 32.400 40,900 19.700 11,500 179,000 39,000 74,000 28.000 54,000 58,000 15,000 24,850 230,000 35,400 11,000 9,750 5,200 Totals 433,850 433,850 433,850 0 0 0 0
