Chapter 4 Completing the Accounting Cycle PROB. I Last Chance Company End of Period Spreadsheet Work Sheet For the Year Ended November 30, 2 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Dr. CE Dr. Cr. D. Cr. Account Title 1 Cash Accounts Receivable Prepard Insurance 4 Supplies 5 Land 6 Building 7 Ac. Depr Building 8 Equipment 9 Ace Deprquipment 10 Accounts Payable 11 teamed Rent 12 Corey Evans, Capital 13 Corey Evans, Drawing 10 Fees Revenue 15 Sataries & Wages Expense 16 Advertising Expense 17 Uites Expense 15 Travel Expanse 19 Mic Expense 20 21 Insurance Exponse 22 Supplies Expense 23 Dept. Exp. ---Building 24 Depr. Exo.--Equipment 25 S. & Wagos Payable 26 Rent Revenue 27 28 129 4.800 400 15750 19.90 2.700 (1.450 2025 1535 500 75.000 25.000 205.000 205.000 75.000 92.000 78.000 139,000 129600 54450 05.200 5590 9.750 9.750 4500 192,000 2.500 318,00 318 800 15 ODO 286,500 4.200 250.700 144 300 102.700 147.000 94 800 54800 27 000 27,000 18.750 18.750 5.8125 5.87 75000.000 1,450 1535 155 Id 2000 2.000 200 5.200 U 2.700 2,700 G2000 2000 197075 19.025764 100 24.900 Instructions: Prepare in good form: 1. Income Statement 2. Statement of owner's equity 3. Balance Sheet (Use data from adjusted trial balance) * Open Book Time limit: 45 MINUTES Be sure to also use accounts on lines 21-26 when preparing the financial statements