Income Statement Dr. Cr. Account Title Cash CD'S Other Securities Loan Payable Owner' Equity Revenue Interest Income Utilities expense Internet & Telephone Advertising Expense Trial Balance Dr. Cr. 13,200 a 22,000 5,400 25,000 0 15,600 b 0 Balance Sheet Dr. Cr. 29,250 0 22,000 0 5,400 0 25,000 0 15,100 Sample Worksheet Work Sheet For the Month Ended January 31, 2020 Adjustments Adj. T/Balance Dr. Cr. Dr. Cr. 20,000 b-h 3,950 29,250 0 22,000 0 5,400 0 25,000 500 0 15,100 a 20,000 0 20,000 0 0 300 300 0 150 150 0 300 300 0 0 0 2,000 2,000 0 450 450 0 250 250 0 23,950 23,950 60,100 60,100 0 0 20,000 0 0 0 0 0 d e f Rent Expense Supplies expense Insurance expense 300 150 300 0 2,000 450 250 3,450 16,550 20,000 g 0 0 40,600 h 40,600 0 0 20,000 0 20,000 Net income 56,650 0 56,650 40,100 16,550 56,650 1. Cash is overstated by 500.00 and Owners Equity is overstated by $500.00. 2. Utilities Expense of $300.00 was paid on January 25. 3. Insurance expense of $250.00 was paid on January 27. 4. supplies for the month in the amount of $450.00 was purchased. 5. Rent for $2000.00 for the month was paid on January 31. 6. The total revenue of $20,000.00 was collected in the month of January and deposited in the Bank. 8. Internet and Telephone expense for the month was $150.00 9. Advertising Expense for the month was $300.00. Required: Complete the above worksheet with the necessary adjusing or journal entries manually or utilize an excel worksheet if you can. Make the journal entries for thre above transactions or simply make adjusting entries to the worksheet provided. Prepare the Income Statement for Sample Co as of January 31, 2020. Prepare the Balance sheet as of January 31, 2020. Submit your Worksheet, Income Statement and Balnce Sheet to your Instructor for grading. Sample Co. Income Statement For the Period Ending January 31, 2020 $20,000 $20,000 2,000 Revenue Revenue Total Revenues Expenses Rent Expense Telephone & Internet Utilities Expense Advertising Expense Insurance Expense Supplies Expense Total Expenses Net Income - - - - - $2,000 $18,000 Sample Co. Owner's Equity For the Period Ending January 31, 2020 Beginning Balnce, Dec. 31, 2019 Add Net Income Less withdrawals Ending Blance, January 31, 2020 $15,100 0 0 $ 15,100 Sample Co. Balance Sheet As of January 31, 2020 $29,250 Assets Current Assets Cash CD's Other Securities Total Current Assets Total Assets $29,250 $29,250 Liabilities Loan Payable Total Liabilities $0 $0 Owner's Equity Owner's Equity Total Liabilities and Owner's Equity $0 $0