Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
Worksheet | Adjusted | Adjusted | Income Statement | Balance Sheet | ||||
Account Titles | Debit | Credit | Debit | Credit | Debit | Credit | Asset | Liabilities |
Cash | 37,000.00 | 37,000.00 | 37,000.00 | |||||
Supplies | 18,600.00 | 4,200.00 | 4,200.00 | |||||
Prepaid Insurance | 31,900.00 | 3,900.00 | 3,900.00 | |||||
Land | 80,000.00 | 80,000.00 | 80,000.00 | |||||
Equipment | 120,000.00 | 120,000.00 | 120,000.00 | |||||
Accumulated Depreciation- Equipment | 36,200.00 | 42,000.00 | (42,000.00) | |||||
Accounts Payable | 14,200.00 | 14,200.00 | 14,200.00 | |||||
Unearned Revenue | 2,700.00 | 700.00 | 700.00 | |||||
Interest Payable | 6,000.00 | 6,000.00 | ||||||
Property Tax Payable | 3,000.00 | 3,000.00 | ||||||
Common Stock | 50,000.00 | 50,000.00 | 50,000.00 | |||||
Retained Earnings | 109,700.00 | 109,700.00 | 109,700.00 | |||||
Dividend declared | 14,000.00 | 14,000.00 | (14,000.00) | |||||
Consulting Revenue | 278,500.00 | 280,500.00 | 280,500.00 | |||||
Salaries Expense | 109,000.00 | 109,000.00 | 109,000.00 | |||||
Repairs Expense | 30,500.00 | 30,500.00 | 30,500.00 | |||||
Advertising Expense | 9,400.00 | 9,400.00 | 9,400.00 | |||||
Utilities Expense | 16,900.00 | 16,900.00 | 16,900.00 | |||||
Property Tax Expense | 18,000.00 | 21,000.00 | 21,000.00 | |||||
Interest Expense | 6,000.00 | 12,000.00 | 12,000.00 | |||||
Insurance Expense | 28,000.00 | 28,000.00 | ||||||
Supplies Expense | 14,400.00 | 14,400.00 | ||||||
Depreciation Expense | 5,800.00 | 5,800.00 | ||||||
Total | 491,300.00 | 491,300.00 | 506,100.00 | 506,100.00 | 247,000.00 | 280,500.00 | ||
Net Income | 33,500.00 | 33,500.00 | ||||||
Total | 491,300.00 | 491,300.00 | 506,100.00 | 506,100.00 | 280,500.00 | 280,500.00 | 203,100.00 | 203,100.00 |
Accounting Worksheet 10 General AA EEB A E BI Wap Test Merge Center O 5 %...
Assignment: 1) complete the accountants worksheet excel (pictured below) 2) on a separate sheet, INCOME STATEMENT 3) on a separate sheet, RETAINED EARNINGS 4) on a separate sheet, BALANCE SHEET 5) on a separate sheet, ADJUSTING/CLOSING ENTRIES 6) POST CLOSING TRIAL BALANCE* Income Statement Debit Credit R. E. Statement Debit Credit Balance Sheet Debit Credit Unadjusted Trial Bal. Debit Credit 37,000 18,600 31,900 80,000 120,000 36,200 14,200 GWS Incorporated Accountant's Worksheet For the Month Ended September 30, 2010 Adjustments Adjusted...
#2 GENERAL LEDGER LIABILITIES OWNER'S EQUITY Un Bal 10,000 Accounts Payable 3.300 Un Bal M. Capital 22,100 Un Bal Un Ball M. Withdrawals 5,200 ACCOUNTS REC Salaries Payable Un Bal 26,900 Legal Fees Revenues 54,400 Un Bal PREPAID INSURANCE Un Ball 1,800 Uneared Legal Fees Utilities Expense S.000 Un Bal Office Supplies 2,000 Office Supplies Eup Office Equipment 5,000 Salaries Expense 26,000 Un Ball Un Bal Accumulated Depr. OE 1,500 Un Bal Insurance Expense Depreciation Expense 13 Compute balances of...
please help me create an income statement. asap Wap Text cop 2 Normal Paste Merge & Center - Format Panter e $ Conditional Formats Check Cell Foming Table N- Kobelsky CPA Services Ltd Adjusted Trial Balances For the Years Ending 2018 Credit Debit Debit Credit 534,293 16,854 691 40 12.000 526,945 21,377 $ 231,878 112,968 11.484 257,334 101,469 14.280 7 Sales revenue 8 Other revenue 9 Cost of goods sold 10 Operating expenses 11 Interest expense 12 Income Tax Expense...
(The following information applies to the questions displayed below/ The general ledger of Zips Storage at January 1, 2018, includes the following account balances Accounts Cash Accounts Recelvable Prepald Insurance Land Accounts Payable Deferred Revenue Common Stock Retained Earnings Deblits Credits 25,600 16.400 14,000 158,000 $ 7700 6,800 153,000 46,500 Totals $214,000 $214.000 The following is a summary of the transactions for the year: a. January 9 Provide storage services for cash, $144,100, and on account, $57,200 b. February 12...
Please make the year end adjustments in a worksheet and include and in a general journal Cascade Bicycle Shop Trial Balance December 31, 20 -- ACCOUNT TITLE DEBIT BALANCE CREDIT BALANCE Cash Accounts Receivable Merchandise Inventory Supplies Prepaid Insurance Land Building Accumulated Depr. -Building Store Equipment Accumulated Depr.-Store Equip Accounts Payable Wages Payable Sales Tax Payable Unearned Storage Revenue Mortgage Payable D. Lamond, Capital 22,895 14,640 31,390 7,475 4,505 28,130 51,440 16,520 27,450 9,150 3,530 2,985 5,660 43,400 163,640 D....
A B D E F. G н I к L M м. N o P Q R S T U V Adjustments Debit Credit Adjusted Trial Balance Debit Credit Closing Entries Debit Credit Post Closing Trial Balance Debit Credit 1 Trial Balance Item 2 Account Title Debit Credit 3 Cash 20,000.00 4 Supplies 5,000.00 5 Prepaid Rent 12,000.00 6 Equipment 200,000.00 7 Accumulated Depreciation 120,000.00 8 Accounts Payable 8,000.00 9 Unearned Revenue 10,000.00 10 Common Stock 20,000.00 11 Retained Earnings...
$ . % Merge & Center - .000 Formatting Table SIU. . . A. Number Styles Alignment Font Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings, Classified Balance Sheet). Formatting is important and will be graded so be sure you use dollar signs and underlines as appropriate. Also be sure you have headings and proper column usage for all statements. There is a tab for these statements. Heading are PARTIALLY completed for...
Required information The general ledger of Zips Storage at January 1, 2021, includes the following account balances: 18 Credits Accounts Cash Accounts Receivable Prepaid Insurance Land Accounts Payable Deferred Revenue Common Stock Retained Earnings Totals Debits $ 24,600 15,400 12,000 148,000 $ 6,700 5,800 143,000 44,500 $200,000 $200,000 The following is a summary of the transactions for the year: 52,660. 1. January 2. February 3. April 4. May 5. July 9 Provide storage services for cash, $134, 100, and on...
Instructions Chart of Accounts General Journal T Accounts Unadjusted Trial Balance Instructions Wickers Restoration Services had the following transactions on May. 1. 2. 3. 4. 5. Received $48,000 from sale of common stock. Paid rent on office for the month, $880. Purchased supplies on account, $1,750, Earned fees, receiving cash, $12,600. Paid creditor on account, $1,000 Paid automobile expenses for month, $375, and miscellaneous expenses, $250. Paid office salaries for the month, $3,900, Earned fees which the customer will pay...
i need help in what to put on the last three pages > Comprehensive Problem 1 for Chapters 1-4 Murphy Delivery Service completed the following transactions during December 2015 Dec. 1 Murphy Delivery Service began operations by receiving $13.000 cash and a truck with a fair value of $9.000 from Russ Murphy. The business issued Murphy shares of common stock in exchange for this contribution Paid 5600 cash for a six-month insurance policy. The policy begins December 1 Paid 5750...