Question

Excel Spreadsheet Template Preparing a worksheet Exercise 4-1 The unadjusted trial balance of Overland Trekkers appears below
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Account Names Unadjusted Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet
Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
Cash 14,240 14,240 14,240
Accounts Receivable 11,880 840 12,720 12,720
Prepaid rent 2,400 1200 1200 1200
Supplies     6,780 3,200 3,580 3,580
Equipment 65,200 65,200 65,200
Accumulated dep    5680 260 5,940 5,940
Accounts Payable 10,320 10,320 10,320
Salaies payable 0 2100 2,100 2,100
Capital 72060 72,060 72,060
Withdrawalls 6000 6000 6000
Service revenue 23,600 840 24,440 24440
Amortization expense 0 260 260 260
Salaries expense 3600 2100 5700 5700
Rent expenses 0 1,200 1,200 1,200
Utulities expenses 1,560 1,560 1,560
Supplies expenses 0 3200 3,200 3200
Total 111,660 111660 7,600 7,600 114,860 114,860 11,920 24,440 102,940 90,420
Net Income 12,520 12,520
TOTAL 24,440 24,440 102,940 102,940
Thus Net Income for the year = 12520
Add a comment
Know the answer?
Add Answer to:
Excel Spreadsheet Template Preparing a worksheet Exercise 4-1 The unadjusted trial balance of Overland Trekkers appears...
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
  • Question: Option #1: Preparing Adjusting Entries in a Worksheet Following is the unadjusted trial balance o......

    Question: Option #1: Preparing Adjusting Entries in a Worksheet Following is the unadjusted trial balance o... Option #1: Preparing Adjusting Entries in a Worksheet Following is the unadjusted trial balance of Skylar Gaming, Inc. at the end of its first year of operations, December 31, 20x7: Account Name DR. CR. Cash $71,550 Accounts Receivable $25,200 Supplies $550 Prepaid Insurance $12,000 Equipment $31,750 Accumulated Depreciation-Equipment $4,050 Accounts Payable $6,700 Salaries Payable $0 Unearned Revenue $2,200 Common Stock $45,700 Retained Earnings $23,850...

  • Option #1: Preparing Adjusting Entries in a Worksheet Following is the unadjusted trial balance of Skylar...

    Option #1: Preparing Adjusting Entries in a Worksheet Following is the unadjusted trial balance of Skylar Gaming, Inc. at the end of its first year of operations, December 31, 20x7: Account Name DR. CR. Cash $71,550 Accounts Receivable $25,200 Supplies $550 Prepaid Insurance $12,000 Equipment $31,750 Accumulated Depreciation-Equipment $4,050 Accounts Payable $6,700 Salaries Payable $0 Unearned Revenue $2,200 Common Stock $45,700 Retained Earnings $23,850 Dividends $3,500 Revenue $80,750 Depreciation Expense-Equipment $2,000 Salaries Expense $4,750 Insurance Expense $3,100 Rent Expense $4,200...

  • E4-19 Preparing a worksheet Learning Objective 2 The unadjusted trial balance of Data Solution at November...

    E4-19 Preparing a worksheet Learning Objective 2 The unadjusted trial balance of Data Solution at November 30, 2018, follows DATA SOLUTION Unadjusted Trial Balance November 30, 2018 Balance Account Title Cash Accounts Receivable Prepaid Rent Office Supplies Equipment Accumulated Depreciation-Equipment Accounts Payable Salaries Payable Debit Credit $ 4,400 3,100 1,800 3,100 30,200 5 1,500 5,100

  • 3B-5. Below is the unadjusted trial balance of JUPITER Incorporated: JUPITER INCORPORATED Unadjusted Trial Balance September...

    3B-5. Below is the unadjusted trial balance of JUPITER Incorporated: JUPITER INCORPORATED Unadjusted Trial Balance September 1, 20x1 Credit Balances Debit Balances $4,900 2,300 8.400 27.000 Account Names Cash Accounts receivable Office supplies Equipment Accumulated depreciation - equipment Salaries payable Interest payable Unearned rent revenue Common stock Retained earnings Rent revenue Supplies expense Salary expense Interest expense Depreciation expense - equipment Totals $6,400 500 2,900 4,200 8,000 15,300 7,000 800 900 $44,300 $44,300 The adjusting entry information is as follows:...

  • 3B-5. Below is the unadjusted trial balance of JUPITER Incorporated: JUPITER INCORPORATED Unadjusted Trial Balance September...

    3B-5. Below is the unadjusted trial balance of JUPITER Incorporated: JUPITER INCORPORATED Unadjusted Trial Balance September 1, 20x1 Credit Balances Debit Balances $4,900 2,300 8.400 27.000 Account Names Cash Accounts receivable Office supplies Equipment Accumulated depreciation - equipment Salaries payable Interest payable Unearned rent revenue Common stock Retained earnings Rent revenue Supplies expense Salary expense Interest expense Depreciation expense - equipment Totals $6,400 500 2,900 4,200 8,000 15,300 7,000 800 900 $44,300 $44,300 The adjusting entry information is as follows:...

  • The unadjusted trial balance of Bolton Consulting is entered on the partial worksheet below. Bolton Consulting...

    The unadjusted trial balance of Bolton Consulting is entered on the partial worksheet below. Bolton Consulting Work Sheet For the year ended December 31 Account Unadjusted Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet and Statement of Stockholders’ Equity Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Cash 31,000 Accounts Receivable 8,000 Supplies 12,500 Automobiles 175,000 Accum. Depr. - Autos   52,000 Accounts payable 17,500 Unearned fees 26,500 Salaries payable Capital Stock 58,000 Dividends 42,500 Fees earned...

  • i Data Table Wireless Solution Unadjusted Trial Balance November 30, 2018 Balance Account Title Debit Credit...

    i Data Table Wireless Solution Unadjusted Trial Balance November 30, 2018 Balance Account Title Debit Credit Cat Accounts Receivable Prepaid Rent Office Supplies Equipment Accumulated Depreciation-Equipment Accounts Payable Salaries Payable Common Stock S 3,500 3,800 1,400 4,000 31,700 S 1,100 5,000 35.50a Print Done 1 of 9 (4 complete) i Data Table fo Equipment Accumulated Depreciation-Equipment Accounts Payable Salaries Payable Common Stock Divndends Service Revenue Depreciation Expense-Equipment Salaries Expense Rent Expense Utilities Expense 31,700 S 1,100 5,000 35,500 2,300 8,300...

  • The unadjusted trial balance of Princess Ltd. at October 31, 2017, appears below. The adjustment data...

    The unadjusted trial balance of Princess Ltd. at October 31, 2017, appears below. The adjustment data at October 31, 2017, is provided. Adjustment data at October 31, 2017. A. Accrued service revenue at October 31, 2017, $2,300. B. Prepaid rent expired during the month. The unadjusted prepaid balance of $3,000 relates to the period October through December. C. Supplies used during October, $2,600. D. Depreciation on furniture for the month. The estimated useful life of the furniture is three years....

  • GREEN PART: Unadjusted Trial Balance at December 31, 2020 BLUE PART: Adjusting entries for December 31,...

    GREEN PART: Unadjusted Trial Balance at December 31, 2020 BLUE PART: Adjusting entries for December 31, 2020, are to be entered here see below in additional info RED PART: Adjusted Trial Balance for   December 31, 2020 Please help me fill the Blue and Red parts. Letter Credit Debit Letter Ref Credit Ref Debit Credit $ 5,500 Debit (3,655.34) (3,049.54) (616.07) (1,740.39) (12,834.75) (18,661.72) 1,200 3,200 2,000 Cash Accounts Receivable Prepaid Rent Supplies Land Equipment Accumulated Amortization- Equipment Unearned Revenue Accounts...

  • PA 4-1 Preparing a Trial Balance, Closing Journal Entry, and Post-Closing Trial Balance [LO 4-3, LO...

    PA 4-1 Preparing a Trial Balance, Closing Journal Entry, and Post-Closing Trial Balance [LO 4-3, LO 4-5) [The following information applies to the questions displayed below) Starbooks Corporation provides an online bookstore for electronic books. The following is a simplified list of accounts and amounts reported in its accounting records. The accounts have normal debit or credit balances. Assume the year ended on September 30, 2018. Accounts Payable Accounts Receivable Accumulated Depreciation Cash Common Stock Deferred Revenue Depreciation Expense Equipment...

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