Ed Bradley Co.xls Нome Insert Page Layout Formulas Data Review View P18 A B D E G ED BRADLEY Co. Worksheet (PARTIAL) For The Month Ended April 30, 2017 2 3 4 5 Adjusted Trial Balance Income Balance 6 Statement Sheet Account Titles Cr. Dr. 7 Dr. Dr. Cr. Cr. 8 Cash 9 Accounts Receivable 10 Prepaid Rent 11 Equipment 12 Accumulated Depreciation-Equipment 13 Notes Payable 18,972 6,920 2,280 18,050 4,895 5,700 14 Accounts Payable 15 Common Stock 4,472 34,960 16 Retained Earnings–April 1, 2017 17 Dividends 18 Service Revenue 19 Salaries and Wages Expense 20 Rent Expense 21 Depreciation Expense 22 Interest Expense 23 Interest Payable 1,000 6,650 12,590 6,840 3,760 145 83 83

Ed Bradley Co.xls Нome Insert Page Layout Formulas Data Review View P18 A B D E G ED BRADLEY Co. Worksheet (PARTIAL) For The Month Ended April 30, 2017 2 3 4 5 Adjusted Trial Balance Income Balance 6 Statement Sheet Account Titles Cr. Dr. 7 Dr. Dr. Cr. Cr. 8 Cash 9 Accounts Receivable 10 Prepaid Rent 11 Equipment 12 Accumulated Depreciation-Equipment 13 Notes Payable 18,972 6,920 2,280 18,050 4,895 5,700 14 Accounts Payable 15 Common Stock 4,472 34,960 16 Retained Earnings–April 1, 2017 17 Dividends 18 Service Revenue 19 Salaries and Wages Expense 20 Rent Expense 21 Depreciation Expense 22 Interest Expense 23 Interest Payable 1,000 6,650 12,590 6,840 3,760 145 83 83

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The trial balance columns of the worksheet for Cullumber Company at June 30, 2027, are as follows. Cash Cullumber Company Worksheet For the Month Ended June 30, 2027 Accounts Receivable Supplies Accounts Payable Unearned Service Revenue Common Stock Service Revenue Account Titles Salaries and Wages Expense Miscellaneous Expense 1. Other data: 2, 3. MPANY Complete the worksheet. Cr. 30, 2027 Trial Balance Dr. 2,080 2,520 Accrued salaries are $290. 2,000 620 260 7,480 Dr. Cr. 1,100 A physical count reveals $500 of supplies on hand. $200 of the unearned revenue is still unearned at month-end. 420 2,960 3,000 7,480 M Income Statement Cr. II Dr. Balance Sheet IN Cr.
Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet for Alert Security Services Co.: If an amount box does not require an entry, leave it blank. Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 20Y7 Account Title AdjustedTrial BalanceDebit AdjustedTrial BalanceCredit Income StatementDebit Income StatementCredit Balance SheetDebit Balance SheetCredit Cash 12 fill in the blank 1 fill in the blank 2 fill in the blank 3 fill in the blank 4 Accounts Receivable 103 fill in the blank 5 fill in the blank 6 fill in the blank 7 fill in the blank 8 Supplies 4 fill in the blank 9 fill in the blank 10 fill in the blank 11 fill in the blank 12 Prepaid Insurance 2 fill in the blank 13 fill in the blank 14 fill in the blank 15 fill in the blank 16 Land 190 fill in the blank 17 fill in the blank 18 fill…
Please see the picture below. This question utilizes excel. Please help with this.
On June 30 of the current year, Rosemount Copy Center has completed the Trial Balance columns of the work sheet. Analyze the adjustment information given here into debit and credit parts. Record the adjustments on the work sheet. Total the Adjustments columns. Adjustment Information June 30 Supplies on hand $188.00 Value of prepaid insurance 540.00 WORK SHEET For Month Ended June 30, 20-- ACCOUNT TITLE TRIAL BALANCE ADJUSTMENTS INCOME STATEMENT BALANCE SHEET DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT 1 Cash 8,715.00 1 2 Petty Cash 75.00 2 3 Accounts Receivable-Raymond O’Neil 642.00 3 4 Supplies 518.00 4 5 Prepaid Insurance 675.00 5 6 Accounts Payable-Western Supply 268.00 6 7 Akbar…
Please Answer In Excel Sheet....!
Lamp Light Company maintains and repairs warning lights, such as those found on radio towersand lighthouses. Lamp Light prepared the following end-of-period spreadsheet at December 31,2018, the end of the fiscal year: Instructions1. Prepare an income statement for the year ended December 31.2. Prepare a retained earnings statement for the year ended December 31.3. Prepare a balance sheet as of December 31.4. Based upon the end-of-period spreadsheet, journalize the closing entries.5. Prepare a post-closing trial balance.
The adjusted trial balance for Bonita Co. is presented in the following worksheet for the month ended April 30, 2020. BONITACO. Worksheet (PARTIAL) For the Month Ended April 30, 2020 Adjusted Trial Balance Income Statement Balance Sheet Account Titles Dr. Cr. Dr. Cr. Dr. Cr. Cash $20,632 %24 20.632 Accounts Receivable 8,580 8.580 Prepaid Rent 2,511 2511 Equipment 19,710 19.710 Accumulated Depreciation-Equipment 5.126 5,126 Notes Payable 7.360 7,360 Accounts Payable 6,132 6.132 Common Stock 36.620 36.620 Retained Earnings-April 1, 2020 1.000 1.000 Dividends 6.650 6.650 Service Revenue 14.250 14.250 Salaries and Wages Expense 8.500 8.500 Rent Expense 3,760 3.760 Depreciation Expense 145 145 Interest Expense 314 314 Interest Payable 314 314 Totals S70,802 $70,802 Net Income Totals
Complete the work sheet
Prepare adjusting journal entries, as needed, considering the account balances excerpted from the unadjusted trial balance and the adjustment data. amount due for employee salaries, $4,800 actual count of supplies inventory, $ 2,300 depreciation on equipment, $3,000
Can you please assist me Prepare the Statement of Comprehensive Income of Royal Traders for the year ended 28 February 2021.
The following selected accounts and their current balances appear in the ledger of Maroon Co. for the fiscal year ended December 31, 2019. Accounts Payable 32,480 LT Note Payable 44,800 Misc. Administrative Accounts Receivable 96,800 1,280 Expense Misc. Selling Expense Office Equipment Office Salaries Expense Office Supplies Office Supplies Expense Paid-in Capital Prepaid Insurance Rent Expense Retained Earnings Accum Depr - Office Equip Accum Depr- Store Equip Advertising Expense 10,240 1,280 27,360 68,000 35,040 67,320 Cash 123,000 4,480 Common Stock 75,000 1,040 Cost of Goods Sold 620,000 52,000 Customer refunds Payable Depr Expense - Office Equip Depr Expense - Store Equip 12,000 2,720 25,080 301,600 1,920 992,000 10,160 5,120 Dividends 28,000 Salaries Payable Insurance Expense 3,120 Sales Sales salaries Expense 138,560 Interest Expense Inventory 4,000 140,000 Store Equipment 122,400 Maroon Co. has 10,000 shares of common stock authorized and 7,500 shares issued and outstanding…
Can you please show me how to do the worksheet including the trial balance, adjustments, adjusted trial balance, income statement, and balance sheet. with the figures below the unadjusted trial balance should come equal $47,094. Adjustment column should be $4,040, and adjusted trial balance should equal $48,439. Please guide me in right direction.