Please complete the following financial statements based on the information given.
125% T Format Organize Add Category Insert Table Chart Text Shape Media Comment Collaborate View Zoom + Genl Journal T Accounts Worksheet Inc Stmt Stmt OE Bal Sheet K L M N P Q R S H J T O A B D E F G 2 Adjustments Adjusted Trial Balance Balance Sheet Trial Balance Income Statement o VOU Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit 2 00 12 Cash 13 Accounts Receivable 14 Supplies 15 Prepaid Insurance 16 Office Equipment 17 Accum Deprec 18 Accounts Payable 19 C. Mason, Capital 20 C. Mason, Drawing 21 Sales 22 Supplies Expense 23 Repairs Expense 24 Insurance Expense 25 Travel Expense 26 Utilities Expense 27 Miscellaneous Expense 28 Rent Expense 29 Wage Expense 30 FICA Expense 31 32 33 34 35 36 37 38 39T 125% Collaborate Format Organize Insert Table Chart Text Shape Media Comment View Zoom Add Category Inc Stmt Stmt OE Bal Sheet + Genl Journal T Accounts Worksheet Income Statement For Month Ended September 30, 2020 Revenues: Sales Total Revenues Expenses: Supplies Expense Repairs Expense surance Expense Travel Expense Utilities Expense Miscellaneous Expense Rent Expense Wage Expense FICA Expense Total Expenses Net IncomeT 125% Format Organize Insert Table Chart Text Shape Media Comment Collaborate View Zoom Add Category Bal Sheet Genl Journal T Accounts Worksheet Stmt OE + Inc Stmt Statement of Owner's Equity For Month Ended September 30, 2020 Subtotal[+] T 125% Collaborate Format Organize Insert Table Chart Text Shape Media Comment View Zoom Add Category Bal Sheet + Genl Journal T Accounts Worksheet Inc Stmt Stmt OE Balance Sheet 30-Sep-20 Assets Total Assets Liabilities Total Liabilities Owner's Equity Total Liabilities and Owner's Equity125% T Add Category Insert Table Chart Text Shape Media Comment Collaborate Format Organize View Zoom Genl Journal T Accounts Worksheet Inc Stmt Stmt OE Bal Sheet ASSETS Cash Accounts Receivable Prepaid Insurance Supplies Equipment Accumulated Depreciation 42,305 40,000 4,000 42,305 0 0 0 40,000 4,000 LIABILITIES & Accounts Payable Wages Payable FICA Payable Capital C Mason Drawing CAPITAL 4,335 73,970 -4,335 0 0 -73,970 0 0 REVENUES Sales 0 0 O 0 EXPENSES Supplies Expense Repairs Expense Insurance Expense Travel Expense Utilities Expense Misc Expense Rent Expense 0 0 0 0 0 0 Wage Expense FICA Expense 0Please prepare 10 column Worksheet Trial Balance, Adjustments, Adjusted Trial Balance, Do the journal entries to accrue the payroll expense and post to T accounts. The Income Statement, and Balance Sheet. information is as follows: Prepare the formal Income Statement, Statement of Owner's Equity, and Balance Sheet. Prepare the journal entries and post to the T aocmmta as directed helow. EmPloyee Hourly Rate Hows Fed Inc Tax withheld Mary 22.50 46 250 15.00 42 175 35.00 40 1205 a. The company started the month with Cash of $42,305; Equipment (5 year be 12.00 52 100 property) of $40,000; Accumulated Depreciation $4,000 (40,000/5/ 12 = 667 month); Accounts Payable $4,335, Capital 373,970. Verify the amounts in 'r accounts Use the Excel le for all your work. Check your formulas. I. You are reporting for your client for the One Month period September 30, 2020. 2. Prepare the Trial Balance in the 10 column worksheet Hank Cindy 15.00 45 125 b. Do the journal entries to accrue the monthly expense for Insurance, Supplies, and . During September they had the following transactions. Prepare Journal Entries \"Wild\" and P0\" '0 T \"90'1\"\"- and Post to T accounts: i, Sales to customers an account $55,375 . Prepare Adjusted Trial Balance in the 10 column Worksheet using T account balances. ii. Customers paid $10,000 on their accounts . Prepare the Income Statement in the 10 column worksheet. iii. Company purchased 1 year of Supplies for $12,000 cash (1,000 per - \"a?\" the 331"\" 5119\" in the 10 WW WNW month) . Prepare the formal income Statement. iv. Company has no Amt: Payable at month end. he They reduced balance to _ Ma" the {m1 Statement of Owners Equity zero by paying cash. . Prepare the formal Balance Sheet. v. Company prepaid the annual insurance premium $12,000 vi. The owner C Mason had 35,500 of draw vii.The company incurred and paid cash for the following expenses Rent $3500, Repairs 3200, Wages $3,000, Travel expenses S4200, Utilities 5150, Miscellaneous Expenses $750. 3. Prepare the follovn'ng Adjustments in the 10 column Worksheet. a. The last week ofpayroll was unpaid at September 30. Acerue payroll and the related expenses (FICA & Medicine FICA only) of the company. Time and one half is paid aer 40 hours
