Question: Please do in excel so I can copy and paste. Thank you Part I: Accounting Problem Directions Use the following unadjusted trial balance to: 1)

Please do in excel so I can copy and paste. Thank you
Part I: Accounting Problem Directions Use the following unadjusted trial balance to: 1) Prepare adjusting entries given the additional information below. Financial statements are prepared quarterly. Provide explanations. 2) Prepare T-accounts and post balances below and adjustments. 3) Prepare an Adjusted Trial Balance 4) Prepare financial statements (a) Income Statement. (b) Statement of Owner's Equity and (c) Balance Sheet. ** No investments or withdrawals were made by Jill Baker this quarter. Baker Financial Services Trial Balance September 30, 20x3 $ 10.000 3,200 500 1.800 4.800 Cash Accounts Receivable Office Supplies Prepaid Rent office Furniture Accumulated Depreciation, office Furniture Accounts Payable Unearned Revenge 3411 Baker, Capital Consulting Revenue Salaries Expense Insurance Expense $ 200 7,400 1.000 10.200 6,000 3,700 800 $24.800 $24.800 a b. C of the revenue received in advance: 70 percent remained uncarned on September 30, The office fumature has an estimated ten-year useful life. Hint Record depreciation for the quarter, Salaries camed, but unpaid, totaled SS60 The Prepaid Rent applies to the 12-month period beginning July 1, 20x3. Office supplies on hand totaled S120 at the end of the quarter. Services performed but not yet billed or recorded amount to $700. d. e
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
