Question

In: Accounting

Option #1: Preparing Adjusting Entries in aWorksheetFollowing 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


Supplies Expense

$2,500


Utilities Expense

$2,150



$163,250

$163,250

The following additional information is available:

  1. Skylar Gaming, Inc. needs to accrue $2,000 in salaries that will not be paid until next month.

  2. Skylar Gaming, Inc. has earned $2,000 of the services that were paid for in advance as included in the unearned revenue account.

  3. At the end of the period, Skylar Gaming, Inc. has provided services in the amount of $500 to another customer (John Gartner). However, Skylar has not billed them yet since they only issue bills at the beginning of each month.

  4. Skylar Gaming, Inc. needs to record the annual $1,025 of depreciation on the equipment.

  5. One month of the 12-month insurance policy in prepaid insurance has been used up, and a journal entry is needed to reflect this.

  6. At the end of the period, $125 in supplies are remaining.

Required:

  1. Prepare all necessary adjusting entries at December 31, 20x7 Descriptions are not needed.

  2. Using the below linked template prepare an adjusted trial balance at December 31, 20x7.

  3. Using a worksheet template, prepare an income statement, statement of retained earnings, and a balance sheet.

  4. Prepare closing entries including descriptions.

Solutions

Expert Solution

Answer:-

ADJUSTING ENTRIES:
1) Salaries expense 2000
Salaries payable 2000
Unearned revenue 2000
Revenue 2000
Accounts receivable 500
Revenue 500
Depreciation expense-Equipment 1025
Accumulated expense-Equipment 1025
Insurance expense 1000
Prepaid insurance 1000
Supplies expense (550-125) 425
Supplies 425
2)CLOSING ENTRIES:
Revenue 83250
Income summary 83250
(To close revenue accounts)
Income summary 23150
Depreciation Expense-Equipment 3025
Salaries Expense 6750
Insurance Expense 4100
Rent Expense 4200
Supplies Expense 2925
Utilities Expense 2150
(To close expense accounts)
Income summary 60100
Retained earnings 60100
(To close income summary)
Retained earnings 3500
Dividend 3500
(To close dividend account)
Un adjusted Trial Balance Adjustments Adjusted Trial Balance
Account Name DR. CR. DR. CR. DR. CR.
Cash 71550 71550
Accounts Receivable 25200 500 25700
Supplies 550 425 125
Prepaid Insurance 12000 1000 11000
Equipment 31750 31750
Accumulated Depreciation-Equipment 4050 1025 5075
Accounts Payable 6700 6700
Salaries Payable 0 2000 2000
Unearned Revenue 2200 2000 200
Common Stock 45700 45700
Retained Earnings 23850 23850
Dividends 3500 3500
Revenue 80750 2500 83250
Depreciation Expense-Equipment 2000 1025 3025
Salaries Expense 4750 2000 6750
Insurance Expense 3100 1000 4100
Rent Expense 4200 4200
Supplies Expense 2500 425 2925
Utilities Expense 2150 2150
163250 163250 6950 6950 166775 166775
Net income
INCOME STATEMENT
Revenue 83250
Operating expenses:
Depreciation Expense-Equipment 3025
Salaries Expense 6750
Insurance Expense 4100
Rent Expense 4200
Supplies Expense 2925
Utilities Expense 2150
Total operating expenses 23150
Net operating income 60100
RETAINED EARNINGS
Beginning balance 23850
Add: Net income for the year 60100
Less: Dividends 3500
Ending balance 80450
BALANCE SHEET
Current Assets:
Cash 71550
Accounts receivable 25700
Supplies 125
Prepaid insurance 11000
Total current assets 108375
Non-Current assets:
Equipment 31750
Accumulated Depreciation-Equipment 5075 26675
Total assets 135050
Current Liabilities:
Accounts Payable 6700
Salaries Payable 2000
Unearned Revenue 200
Total current liabilities 8900
Shareholders' equity:
Common Stock 45700
Retained Earnings 80450 126150
Total liabilities & shareholders' equity 135050

Related Solutions

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...
Account Unadjusted trial balance(debit) Unadjusted trial balance(credit Adjusting entries(debit) adjusting entries(credit) adjusted trial balance(debit) Adjusted trial...
Account Unadjusted trial balance(debit) Unadjusted trial balance(credit Adjusting entries(debit) adjusting entries(credit) adjusted trial balance(debit) Adjusted trial balance(credit) Cash 32,236.75 32,236.75 baking supplies 18,500 18,500 merchandise inventory(fifo) 175.65 175.65 prepaid rent 1500 1500 prepaid insurance 2400 2400 baking equipment 6000 6000 accumulated depreciation 208.33 208.33 office supplies 600 600 accounts receivable 7700 7700 notes payable 10,000 10,000 wages payable 480 480 common stock 16,000 16,000 dividends 10,000 10,000 bakery sales 55,000 55,000 merchandise sales 221 221 baking supplies expense rent expense...
2-a. Post the balance from the unadjusted trial balance and the adjusting entries in to the...
2-a. Post the balance from the unadjusted trial balance and the adjusting entries in to the T-accounts. 2-b. Prepare an adjusted trial balance. [The following information applies to the questions displayed below.] Wells Technical Institute (WTI), a school owned by Tristana Wells, provides training to individuals who pay tuition directly to the school. WTI also offers training to groups in off-site locations. Its unadjusted trial balance as of December 31, 2017, follows. WTI initially records prepaid expenses and unearned revenues...
Prepare Journal Entries for January Activities Prepare Unadjusted Trial Balance Prepare Adjusting Entries Prepare Unadjusted Trial...
Prepare Journal Entries for January Activities Prepare Unadjusted Trial Balance Prepare Adjusting Entries Prepare Unadjusted Trial Balance Prepare Balance Sheet Prepare Income Statement Preare Statement of Cash Flows Prepare Statement of Stockholders Equity Prepare Analysis of Results The Wholesale Company began operations on January 1, 2019. During the month of January 2019, the following transactions occurred: Owners invest $50,000 cash in the corporation in exchange for 5,000 shares of common stock. Equipment is purchased for $20,000 cash. On the first...
Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and...
Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and balance sheet included with the data below. Also, create a pivot table. Create a general ledger, worksheet, income statement, changes in retained earnings, and balance sheet with the data below. June 1: Hudson Bloom invested $105,273.00 cash and computer equipment with a fair market value of $32,970.00 in his new business, Byte of Accounting. June 1:   Check # 5000 was used to purchased office...
need to fill this out            Account Unadjusted Trial Balance Adjusting Entries Adjusted Trial Balance Income...
need to fill this out            Account Unadjusted Trial Balance Adjusting Entries Adjusted Trial Balance Income Statement Number Name Debit Credit Debit Credit Debit Credit Debit Credit 1110 Cash 100,612.00               -                 -                 -   100,612.00               -   1120 Accounts Receivable               -           325.00               -                 -                 -           325.00 1130 Prepaid Insurance      4,968.00               -                 -                 -        4,968.00               -   1140 Prepaid Rent      4,800.00               -                 -                 -  ...
Cybertext. Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement,...
Cybertext. Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and balance sheet included with the data below. Also, create a pivot table. Create a general ledger, worksheet, income statement, changes in retained earnings, and balance sheet with the data below. Byte of Accounting, Inc. June 1: Byte of Accounting, Inc. issued 2,620 shares of its common stock to Jeremy after $27,250 in cash and computer equipment with a fair market value of $38,250...
Following is the unadjusted trial balance of Skylar Gaming, Inc. at the end of its first...
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 Supplies Expense $2,500 Utilities Expense $2,150 $163,250 $163,250...
Ledger Accounts, Adjusting Entries, Financial Statements, and Closing Entries; End-of-Period Spreadsheet. The unadjusted trial balance of...
Ledger Accounts, Adjusting Entries, Financial Statements, and Closing Entries; End-of-Period Spreadsheet. The unadjusted trial balance of Recessive Interiors at January 31, 2018, the end of the year, follows: Recessive Interiors Unadjusted Trial Balance January 31, 2018 Debit Balances Credit Balances 11 Cash 13,100 13 Supplies 8,000 14 Prepaid Insurance 7,500 16 Equipment 113,000 17 Accumulated Depreciation—Equipment 12,000 18 Trucks 90,000 19 Accumulated Depreciation—Trucks 27,100 21 Accounts Payable 4,500 31 Common Stock 30,000 32 Retained Earnings 96,400 33 Dividends 3,000 41...
Ledger Accounts, Adjusting Entries, Financial Statements, and Closing Entries; End-of-Period Spreadsheet. The unadjusted trial balance of...
Ledger Accounts, Adjusting Entries, Financial Statements, and Closing Entries; End-of-Period Spreadsheet. The unadjusted trial balance of Recessive Interiors at January 31, 2018, the end of the year, follows: Recessive Interiors Unadjusted Trial Balance January 31, 2018 Debit Balances Credit Balances 11 Cash 13,100 13 Supplies 8,000 14 Prepaid Insurance 7,500 16 Equipment 113,000 17 Accumulated Depreciation—Equipment 12,000 18 Trucks 90,000 19 Accumulated Depreciation—Trucks 27,100 21 Accounts Payable 4,500 31 Common Stock 30,000 32 Retained Earnings 96,400 33 Dividends 3,000 41...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT