Question

Prepaid Insurance 1,000 89,020 Accounts Receivable 103,100 103 100 Equipment 100,000 Allowance for Doubtful Accounts 1,500 1.Adjusted Debit Credit Income Statement Debit Credit Retained Earnings Debit Credit UWIIIUDU Excel PiUjell #1.XISX (19.8 KB) T

Required: 1. Prepare the adjusting entries on the Trial Balance tab, and complete the worksheet on the Trial Balance tab

2. On the Financial Statements tab, prepare the income Statement, Retained Earnings Statement, and Balance Sheet for the 2020 year

3. On the Tab complete T-Accounts for all accounts. The ending balances in every should agree to the balances on the Balance Sheet as of December 31, 2020

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Unadjusted Adjustments Adjusted Income statement Retained Earnings Balance sheet
Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
Cash 89020 25000 64020 64020
Accounts Receivable 103100 2500 15000 90600 90600
Allowance for Doubtful debts 1500 1500 1500
Supplies 3920 3920 3920
Prepaid insurance 1000 500 500 500
Prepaid Rent 0
Equipment 100000 100000 100000
Accumulated Depreciation - Equipment 10000 20000 30000 30000
Unearned Service revenue 10000 10000 10000
Interest payable 342.5 342.5 342.5
Salaries and Wages payable 3400 3400 3400
Notes Payable 82200 82200 82200
Common stock 15000 15000 15000 15000
Retained earnings 27510 27510 116597.5 116597.5
Dividends 25000 25000 25000
Service revenue 196500 10000 2500 189000 189000
Bad debt expense 15000 15000 15000
Insurance expense 500 500 500
Depreciation expense 20000 20000 20000
Interest expense 342.5 342.5 342.5
Rent expense 10000 10000 10000
Salaries and wages expense 22800 3400 26200 26200
Utilities expense 1100 1100 1100
Office expense 1770 1770 1770
332710 332710 76742.5 76742.5 358952.5 358952.5 99912.5 189000 131597.5 259040 259040
Add a comment
Know the answer?
Add Answer to:
Required: 1. Prepare the adjusting entries on the Trial Balance tab, and complete the worksheet on...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Required: 1. Prepare the adjusting entries on the Trial Balance tab, and complete the worksheet on...

    Required: 1. Prepare the adjusting entries on the Trial Balance tab, and complete the worksheet on the Trial Balance tab 2. On the Financial Statements tab, prepare the income Statement, Retained Earnings Statement, and Balance Sheet for the 2020 year 3. On the Tab complete T-Accounts for all accounts. The ending balances in every should agree to the balances on the Balance Sheet as of December 31, 2020 Prepaid Insurance 1,000 89,020 Accounts Receivable 103,100 103 100 Equipment 100,000 Allowance...

  • 1.prepare a complete worksheet 2. prepare a classified balance sheet 3. journaliza the adjusting entries Problem...

    1.prepare a complete worksheet 2. prepare a classified balance sheet 3. journaliza the adjusting entries Problem 3-12 Wildhorse Company has a fiscal year ending on September 30. Selected data from the September 30 worksheet are presented below. WILDHORSE COMPANY Worksheet For The Month Ended September 30, 2020 Adjusted Trial Trial Balance Balance Debit Credit Debit Credit Cash 39,760 39,760 Supplies 20,960 4,161 Prepaid Insurance 31,900 4,265 Land 87,720 87,720 Equipment 127,720 127,720 Accumulated Depreciation-Equipment 38,560 40,850 Accounts Payable 16,960 16,960...

  • Selected worksheet data for Elsayed Company are presented below. Trial Balance Debit Credit Adjusted Trial Balance...

    Selected worksheet data for Elsayed Company are presented below. Trial Balance Debit Credit Adjusted Trial Balance Debit Credit 33,670 19,517 25,182 6,118 11,984 Account Titles Accounts Receivable Prepaid Insurance Supplies Accumulated Depreciation Equipment Salaries and Wages Payable Service Revenue Insurance Expense Depreciation Expense Supplies Expense Salaries and Wages Expense 4,051 96,094 88,888 10,675 4,429 48,737 Fill in the missing amounts. Trial Balance Debit Credit Adjusted Trial Balance Debit Credit 33,670 19,517 25,182 6,118 11,984 Account Titles Accounts Receivable Prepaid Insurance...

  • An inexperienced bookkeeper prepared the following trial balance that does not balance. Prepare a correct trial...

    An inexperienced bookkeeper prepared the following trial balance that does not balance. Prepare a correct trial balance, assuming all account balances are normal. IVANHOE COMPANY Trial Balance December 31, 2017 Credit Debit $21,970 Cash $5,220 Prepaid Insurance 3,670 Accounts Payable 3,990 Unearned Service Revenue 10,000 Common Stock 6,600 Retained Earnings 7,250 Dividends Service Revenue 27,320 12,350 Salaries and Wages Expense 4,790 Rent Expense $38,310 $64,850 IVANHOE COMPANY Trial Balance Debit Credit

  • (Adjusting Entries and Financial Statements) The following are the trial balance and the other information related...

    (Adjusting Entries and Financial Statements) The following are the trial balance and the other information related to Yorkis Perez, a consulting engineer. YORKIS PEREZ, CONSULTING ENGINEER TRIAL BALANCE DECEMBER 31, 2014    Debit                     Credit Cash                                                                                      $ 44,500 Accounts Receivable                                                           49,600 Allowance For Doubtful Accounts                                                             $       750 Inventory                                                                                  1,960 Prepaid Insurance                                                                  1,100 Prepaid Rent                                                                          3,750 Equipment                                                                              25,000 Accumulated Depreciation—Equipment                                                     6,250 Unearned Revenue                                                                                             15,000 Notes Payable                                                                                                         7,200 Owner’s Capital                                                                                                   35,010...

  • Use the following adjusting entries to complete the worksheet, prepare an income statement, statement of retained...

    Use the following adjusting entries to complete the worksheet, prepare an income statement, statement of retained earnings, closing entries, and balance sheet. Broomfield Company Adjusting Journal Entries For the Year Ended December 31, 2019 Account Titles DR CR a. Interest Expense            15,920 Interest Payable          15,920 b. Insurance Expense            19,152 Prepaid Insurance          19,152 c. Rent Expense            23,940 Prepaid Rent          23,940 d. Unearned Revenue            12,000 Consulting Revenue          12,000 e. Supplies Expense          116,622 Supplies...

  • Presented below is the adjusted trial balance of Crane Corporation at December 31, 2020. Debit Credit...

    Presented below is the adjusted trial balance of Crane Corporation at December 31, 2020. Debit Credit Cash $          ? Supplies 1,300 Prepaid Insurance 1,100 Equipment 48,100 Accumulated Depreciation-Equipment $  4,100 Trademarks 1,050 Accounts Payable 10,100 Salaries and Wages Payable 600 Unearned Service Revenue 2,100 Bonds Payable (due 2027) 9,100 Common Stock 10,100 Retained Earnings 25,100 Service Revenue 10,100 Salaries and Wages Expense 9,100 Insurance Expense 1,500 Rent Expense 1,300 Interest Expense 1,000     Total $          ? $          ? Additional information: 1. Net loss for the...

  • Post the adjusting entries to the ledger accounts. Enter the totals from the trial balance as...

    Post the adjusting entries to the ledger accounts. Enter the totals from the trial balance as beginning account balances. (Post entries in the order of journal entries presented in the previous part.) Sharon Lee started her own consulting firm, Lee Consulting, on May 1, 2020. The trial balance at May 31 is as follows. LEE CONSULTING Trial Balance May 31, 2020 Credit Debit $4,600 5.900 2.000 4.800 10.200 Account Number 101 112 126 130 149 201 209 301 400 726...

  • Problem 1 IS asked for each olot 80 marks) Given the adjusted trial balance for Destiny...

    Problem 1 IS asked for each olot 80 marks) Given the adjusted trial balance for Destiny Inc. below as of December 31, 2017, prepare the income statement and statement of retained earnings for the year ended December 31, 2017 Destiny Inc. Adjusted Trial Balance December 31, 2017 Debit Credit $62,500 40,200 550 820 36,000 Cash Accounts receivable Supplies Prepaid insurance Equipment Accumulated depreciation-equipment Accounts payable Unearned service revenue Salary payable Common shares Retained earnings Dividends Service revenue Salary expense Supplies...

  • Post the adjusting entries to the ledger accounts. Enter the totals from the trial balance as...

    Post the adjusting entries to the ledger accounts. Enter the totals from the trial balance as beginning account balances. (Post entries in the order of journal entries presented in the previous part.) arance as beginni Cash Date Explanation Ref. Debit No. 101 Balance Credit May 31 Balance Accounts Receivable Date Explanation No. 112 Debit Credit May 31 Balance > May 31 Adjusting I Supplies Date Explanation Balance May 31 - = > May 31 Adjusting Prepaid Insurance Date Explanation May...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT