Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problems: Series A SHOW ME HOW 3. Total assets: $354,500 EXCEL TEMPLATE GENERAL LEDGER PR 4-1A Financial statements and closing entries Obj. 1, 2, 3
Problems: Series A SHOW ME HOW 3. Total assets: $354,500 EXCEL TEMPLATE GENERAL LEDGER PR 4-1A Financial statements and closing entries Obj. 1, 2, 3 Lamp Light Company maintains and repairs warning lights, such as those found on radio towers and lighthouses. Lamp Light prepared the following end-of-period spreadsheet at December 31, 2018, the end of the fiscal year: A 1 2 3 4 5 6 Account Title 7 8 Cash 9 Accounts Receivable 10 Prepaid Insurance 11 Supplies 12 Land 13 Building 14 Accum. Depr-Building B C D Lamp Light Company End-of-Period Spreadsheet For the Year Ended December 31, 2018 Unadjusted Trial Balance Dr. Cr. 15 Equipment 16 Accum. Depr.-Equipment 17 Accounts Payable 18, Salaries & Wages Payable 19 Unearned Rent 20 Common Stock 21 Retained Earnings 22 Dividends 23 Fees Earned 24 Rent Revenue 25 Salaries & Wages Expense 26. Advertising Expense 27 Utilities Expense 28 Depr. Exp.-Building 29 Repairs Expense 30 Depr. Exp-Equipment 31 Insurance Expense 32 Supplies Expense 33 Misc. Expense 34 35 10,800 38,900 4,200 2,730 98,000 400.000 101.000 10,000 163,100 21,700 11.400 8.850 205,300 85,100 15,700 2,100 75,000 128,100 363.700 4,320 875,000 875,000 Adjustments Dr. 1,300 11,300 3,000 2,250 4,900 10,100 E 6,680 3,000 2,250 39,530 Cr. 10,100 6.680 4,900 11,300 1,300 F Adjusted Trial Balance Dr. Cr. 10,800 50.200 1,200 480 98,000 400.000 101.000 G 10,000 215.400 168,000 21,700 11,400 10.100 8,850 6,680 3,000 2.250 91.780 15,700 4,900 800 75,000 128,100 375,000 1,300 4,320 39,530 907.980 907.980 (Continued
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