Please prepare the following accounting statements:

Please 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