Worksheet
Sharp Outfitters fiscal year ends on July 31. The following additional information is available:
Supplies on hand at July 31 amount to $3,380.
Insurance expense for the year is $1,680.
Depreciation for the year is $8,330.
The unearned rental fees consist of deposits received from
customers in advance when reservations are made.
During the year, the amount earned of the unearned rental fees was
$4,930.
The remaining deposits apply to rentals for August and September
2013
At July 31, revenue from rental services earned during July but
not yet billed or received amounts to $2,580.
(Note: use Debit Fees Receivable)
Accrued wages payable total $980 for equipment handlers and guides at July 31.
Required
Sharp Outfitters' unadjusted trial balance was prepared as of July
31. Using the adjustment data given above, complete the following
worksheet.
SHARP
OUTFITTERS Worksheet For the Year Ended July 31, 2013 |
|||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Unadjusted Trial Balance | Adjustments | Adjusted Trial Balance | Income Statement | Balance Sheet | |||||||||||||||
Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | ||||||||||
Cash | $6,750 | $Answer? | $Answer | ? | $Answer | ? | $Answer? | $Answer? | $Answer? | $Answer? | $Answer? | ||||||||
Supplies | 15,480 | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | ||||||||||
Prepaid Insurance | 5,760 | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | ||||||||||
Equipment | 171,000 | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | ||||||||||
Accumulated Depreciation | 29,700 | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | ||||||||||
Accounts Payable | 6,300 | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | ||||||||||
Unearned Rental Fees | 15,930 | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | ||||||||||
Common Stock | 54,000 | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | ||||||||||
Retained Earnings | 16,200 | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | ||||||||||
Dividends | 2,160 | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | ||||||||||
Rental Fees Earned | 140,670 | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | ||||||||||
Answer | |||||||||||||||||||
Wage Expense | 50,040 | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | ||||||||||
Rent Expense | 5,940 | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | ||||||||||
Advertising Expense | 4,140 | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | ||||||||||
Travel Expense | 1,530 | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | ||||||||||
Supplies Expense | Answer? | Answer? | Answer | ? | Answer | ? | Answer? | Answer? | Answer? | Answer? | |||||||||
Insurance Expense | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | |||||||||||
Depreciation Expense | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | |||||||||||
Fees Receivable | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | |||||||||||
Wages Payable | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | |||||||||||
Totals | $262,800 | $262,800 | $Answer | $Answer | $Answer | $Answer | $Answer | $Answer | $Answer | $Answer | |||||||||
Net Income | $Answer | $Answer | $Answer | $Answer | |||||||||||||||
Totals | $Answer? | $Answer? | $Answer? | $Answer? |
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | |||||
Event | Account | Debit | Credit | ||
1 | Supplies Expenses | $ 12,100 | 15480-3380 | ||
1 | Supplies | $ 12,100 | |||
2 | Insurance Expense | $ 1,680 | |||
2 | Prepaid Insurance | $ 1,680 | |||
3 | Depreciation Expense | $ 8,330 | |||
3 | Accumulated Depreciation | $ 8,330 | |||
4 | Unearned Rental Fee | $ 4,930 | |||
4 | Rental Fees earned | $ 4,930 | |||
5 | Rental Fees Receivable | $ 2,580 | |||
5 | Rental Fees earned | $ 2,580 | |||
6 | Wages Expenses | $ 980 | |||
6 | Wages Payable | $ 980 |
Worksheet | ||||||||||
For the Year Ended July 31, 2013 | ||||||||||
Unadjusted Trial Balance | Adjustments | Adjusted Trial Balance | Income Statement | Balance Sheet | ||||||
Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | |
Cash | $ 6,750 | $ 6,750 | $ 6,750 | |||||||
Supplies | $ 15,480 | $ 12,100 | $ 3,380 | $ 3,380 | ||||||
Prepaid Insurance | $ 5,760 | $ 1,680 | $ 4,080 | $ 4,080 | ||||||
Equipment | $ 171,000 | $ 171,000 | $ 171,000 | |||||||
Accumulated Depreciation | $ 29,700 | $ 8,330 | $ 38,030 | $ 38,030 | ||||||
Accounts Payable | $ 6,300 | $ 6,300 | $ 6,300 | |||||||
Unearned Rental Fees | $ 15,930 | $ 4,930 | $ 11,000 | $ 11,000 | ||||||
Common Stock | $ 54,000 | $ 54,000 | $ 54,000 | |||||||
Retained Earnings | $ 16,200 | $ 16,200 | $ 16,200 | |||||||
Dividends | $ 2,160 | $ 2,160 | $ 2,160 | |||||||
Rental Fees Earned | $ 140,670 | $ 7,510 | $ 148,180 | $148,180 | ||||||
Wage Expense | $ 50,040 | $ 980 | $ 51,020 | $ 51,020 | ||||||
Rent Expense | $ 5,940 | $ 5,940 | $ 5,940 | |||||||
Advertising Expense | $ 4,140 | $ 4,140 | $ 4,140 | |||||||
Travel Expense | $ 1,530 | $ 1,530 | $ 1,530 | |||||||
Supplies Expense | $ 12,100 | $ 12,100 | $ 12,100 | |||||||
Insurance Expense | $ 1,680 | $ 1,680 | $ 1,680 | |||||||
Depreciation Expense | $ 8,330 | $ 8,330 | $ 8,330 | |||||||
Fees Receivable | $ 2,580 | $ 2,580 | $ 2,580 | |||||||
Wages Payable | $ 980 | $ 980 | $ 980 | |||||||
Totals | $ 262,800 | $ 262,800 | $ 30,600 | $ 30,600 | $ 274,690 | $ 274,690 | $ 84,740 | $148,180 | $ 189,950 | $ 126,510 |
Net Income | $ 63,440 | $ 63,440 | ||||||||
Total | $ 262,800 | $ 262,800 | $ 30,600 | $ 30,600 | $ 274,690 | $ 274,690 | $ 148,180 | $148,180 | $ 189,950 | $ 189,950 |
Worksheet Sharp Outfitters fiscal year ends on July 31. The following additional information is available: Supplies...
End of year condensed worksheet for Amoss Company as of December 31. Additional Information and/or entries to be adjusted: a. Prepaid insurance is for a two-year theft policy dated July 1. b. The ending inventory balance is $300. c. The building is using the straight-line method with a useful life of 30 years and no salvage value. d. The balance in Unearned Consulting Revenue pertains to a contract sold on September 1, to provide service to a client for one...
Reece Financial Services Co. Unadjusted Trial Balance July 31, 2019 Debit Balances Credit Balances Cash 10,200 34,750 Accounts Receivable Prepaid Insurance 6,000 Supplies Land 1,725 50,000 155,750 Building Accumulated Depreciation---Building 62,850 Equipment 45,000 Accumulated Depreciation Equipment 17,650 Accounts Payable 3,750 Unearned Rent Joni Reece, Capital Joni Reece, Drawing 3,600 153,550 8,000 Fees Eamed 158,600 Salaries and Wages Expense 56,850 Land 155,750 Building Accumulated Depreciation-Building S 62,850 45.000 I SA 17,650 Equipment Accumulated Depreciation-Equipment Accounts Payable Unearned Rent 3,750 3,600 Joni...
3. REM Consulting is completing the accounting information processing at the end of the fiscal year, December 31. The following trial balances are available. Accounts Unadjusted Adjusted Trial Balance Trial Balance Debit Credit Debit Credit Cash 13,000 13,000 Accounts Receivable 1,500 1,800 Prepaid Insurance 600 200 Supplies 3,800 3,000 Machines 30,000 30,000 Accumulated Depreciation 12,000 17,500 Wages Payable 900 Unearned Fees 6,700 6,500 Owner's Capital 24,000 24,000 Owner's Drawing 4,800 4,800 Fees Earned 25,000 25,500 Wages Expense 14,000 14,900 Depreciation...
Crazy Mountain Outfitters Co. Unadjusted Trial Balance December 31, 2015 Debit Balances Credit Balances Cash 14,030 Accounts Receivable 93,140 Supplies 22,440 Equipment 479,560 Accum Deprec 0 Accounts Payable 21,880 0 Wages payable 24,690 Unearned Fees Common Stock 55,000 Retained Earnings 277,000 Dividends 18,520 Fees Earned 561,080 Wages Expense 130,170 99,310 Rent Expense Supplies Expense Depreciation Expense 0 0 71,260 Utilities Expense Miscellaneous Expense 11,220 939,650 939,650 1. For preparing the 5 adjusting entries, the following data were assembled: a. Supplies...
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...
Chapter 3 - Instruction #1 The unadjusted trial balance for PS Music as of July 31, 2019 is as follows: PS Music Unadjusted Trial Balance July 31, 2019 Account No. Debit Balances Credit Balances Cash 119 12 ,945 2,750 Accounts Receivable Supplies Prepaid Insurance 1,020 15 2,700 Office Equipment 17 7,500 Accounts Payable Unearned Revenue 23 8,350 7,200 9,000 Peyton Smith, Capital Peyton Smith, Drawing 1,750 Fees Earned 41 16,200 Wages Expense 2,800 51 2,550 Office Rent Expense Equipment Rent...
July 31 Fees Earned 21,200 Wages Expense Office Rent Expense 2,940 2,550 1,375 Equipment Rent Expense Utilities Expense 1,215 Music Expense 3,610 Advertising Expense 1,500 Supplies Expense 925 Insurance Expense 225 Depreciation Expense 50 Miscellaneous Expense 1,855 Peyton Smith, Capital 4,955 DATE ACCOUNT POST. REF. DEBIT CREDIT July 31 Peyton Smith, Capital 1,750 Peyton Smith, Drawing 1,750 PS Music Post-Closing Trial Balance July 31, 2019 Debit Balances Credit Balances Cash Accounts Receivable Supplies Prepaid Insurance Office Equipment Accumulated Depreciation Office...
The following unadjusted Trial Balance for Shawn's Construction for year ended Dec 31, 2013. Beginning Capital Balance on December 31 2012 was $30000. Shawn's Construction Company Unadjusted Trial Balance December 31, 2013 No Account Title Debit Credit 101 Cash $20000 126 Supplies 10000 128 Prepaid Insurance 7200 167 Equipment 130000 168 Accumulated Depreciation- Equipment $26000 201 Accounts Payable 6000 203 Interest Payable Rent payable 208 210 Wages payable Property Taxes payable 213 25000 Long Term Notes Payable 251 87060 S....
The data for year-end adjustments are as
follows:
Fees earned, but not yet billed, $26.
Supplies on hand, $6.
Insurance premiums expired, $32.
Depreciation expense, $13.
Wages accrued, but not paid, $13.
Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the end-of-period spreadsheet for the year ended October 31, 2018, shown below. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2018 Unadjusted...
Bolton Consulting Work Sheet For the year ended December 31 Balance Sheet and Statement of Stockholders Income Statement Equity Adjusted Unadjusted Trial Trial Balance Adjustments Balance Account Credit Debit Credit Debit Credit Debit Credit Debit Credit Debit Cash 31,000 Accounts Receivable 8,000 Supplies 12,500 Automobiles 175,000 Accum. Depr. - Autos 52,000 17,500 Accounts payable Unearned 26,500 fees Salaries payable Capital Stock 58.000 Dividends 42,500 241,750 Fees earned Salary 91,000 Module 8: Portfolio Project 262020 expense Rent expense 35,750 Advertising expense...