Completion of a Work Sheet Showing a Net Loss
1. Complete the Adjustments columns.
2. Complete the work sheet.
3. Enter the adjustments in a general journal. If an amount box does not require an entry, leave it blank.
The trial balance for Cascade Bicycle Shop, a business owned by David Lamond, is shown below.
Cascade
Bicycle Shop Trial Balance December 31, 20 -- |
||||||||||
---|---|---|---|---|---|---|---|---|---|---|
ACCOUNT TITLE | DEBIT BALANCE | CREDIT BALANCE | ||||||||
Cash | 23,105 | |||||||||
Accounts Receivable | 15,325 | |||||||||
Merchandise Inventory | 30,635 | |||||||||
Supplies | 7,000 | |||||||||
Prepaid Insurance | 4,665 | |||||||||
Land | 28,415 | |||||||||
Building | 49,750 | |||||||||
Accumulated Depr.—Building | 16,000 | |||||||||
Store Equipment | 26,490 | |||||||||
Accumulated Depr.—Store Equip. | 8,830 | |||||||||
Accounts Payable | 3,645 | |||||||||
Wages Payable | ||||||||||
Sales Tax Payable | 2,845 | |||||||||
Unearned Storage Revenue | 5,530 | |||||||||
Mortgage Payable | 40,800 | |||||||||
D. Lamond, Capital | 165,000 | |||||||||
D. Lamond, Drawing | 32,795 | |||||||||
Income Summary | ||||||||||
Sales | 51,240 | |||||||||
Sales Returns and Allowances | 2,565 | |||||||||
Storage Revenue | ||||||||||
Purchases | 21,385 | |||||||||
Purchases Returns and Allow. | 1,245 | |||||||||
Purchases Discounts | 1,975 | |||||||||
Freight-In | 1,515 | |||||||||
Wages Expense | 35,480 | |||||||||
Advertising Expense | 5,780 | |||||||||
Supplies Expense | ||||||||||
Phone Expense | 2,125 | |||||||||
Utilities Expense | 9,160 | |||||||||
Insurance Expense | ||||||||||
Depreciation Expense—Building | ||||||||||
Depreciation Exp.—Store Equipment | ||||||||||
Miscellaneous Expense | 920 | |||||||||
297,110 | 297,110 |
Year-end adjustment information is as follows:
(a and b) | Merchandise inventory costing $21,815 is on hand as of December 31, 20--. (The periodic inventory system is used.) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
(c) | Supplies remaining at the end of the year, $2,385. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
(d) | Unexpired insurance on December 31, $1,745. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
(e) | Depreciation expense on the building for 20--, $3,750. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
(f) | Depreciation expense on the store equipment for 20--, $3,532. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
(g) | Unearned storage revenue as of December 31, $1,905. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
(h) | Wages earned but not paid as of December 31,
$725.1. Complete the Adjustments columns.
2. Complete the work sheet. If an amount box does not require an entry, leave it blank.
|
Cascade Bicycle Shop | ||||||||||
Worksheet | ||||||||||
For the Year Ended December 31, 20-- | ||||||||||
Account Title | Trial Balance | Adjustments | Adjusted Trial Balance | Income Statement | Balance Sheet | |||||
Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | |
Cash | 23105 | 23105 | 23105 | |||||||
Accounts receivable | 15325 | 15325 | 15325 | |||||||
Merchandise inventory | 30635 | 21815 | 30635 | 21815 | 21815 | |||||
Supplies | 7000 | 4615 | 2385 | 2385 | ||||||
Prepaid insurance | 4665 | 2920 | 1745 | 1745 | ||||||
Land | 28415 | 28415 | 28415 | |||||||
Building | 49750 | 49750 | 49750 | |||||||
Accumulated depr.-building | 16000 | 3750 | 19750 | 19750 | ||||||
Store equipment | 26490 | 26490 | 26490 | |||||||
Accumulated depr.-store equip. | 8830 | 3532 | 12362 | 12362 | ||||||
Accounts payable | 3645 | 3645 | 3645 | |||||||
Wages payable | 725 | 725 | 725 | |||||||
Sales tax payable | 2845 | 2845 | 2845 | |||||||
Unearned storage revenue | 5530 | 3625 | 1905 | 1905 | ||||||
Mortgage payable | 40800 | 40800 | 40800 | |||||||
D. Lamond, capital | 165000 | 165000 | 165000 | |||||||
D. Lamond, drawing | 32795 | 32795 | 32795 | |||||||
Income summary | 30635 | 21815 | 8820 | 8820 | ||||||
Sales | 51240 | 51240 | 51240 | |||||||
Sales returns and allowances | 2565 | 2565 | 2565 | |||||||
Storage revenue | 3625 | 3625 | 3625 | |||||||
Purchases | 21385 | 21385 | 21385 | |||||||
Purchase returns and allowances | 1245 | 1245 | 1245 | |||||||
Purchases discounts | 1975 | 1975 | 1975 | |||||||
Freight-in | 1515 | 1515 | 1515 | |||||||
Wages expense | 35480 | 725 | 36205 | 36205 | ||||||
Advertising expense | 5780 | 5780 | 5780 | |||||||
Supplies expense | 4615 | 4615 | 4615 | |||||||
Phone expense | 2125 | 2125 | 2125 | |||||||
Utilities expense | 9160 | 9160 | 9160 | |||||||
Insurance expense | 2920 | 2920 | 2920 | |||||||
Depreciation expense-building | 3750 | 3750 | 3750 | |||||||
Depreciation exp.-store equip. | 3532 | 3532 | 3532 | |||||||
Miscellaneous expense | 920 | 920 | 920 | |||||||
Totals | 297110 | 297110 | 71617 | 71617 | 305117 | 305117 | 94472 | 58085 | 210645 | 247032 |
Net Loss | 36387 | 36387 | ||||||||
Totals | 94472 | 94472 | 247032 | 247032 |
Completion of a Work Sheet Showing a Net Loss 1. Complete the Adjustments columns. 2. Complete...
Completion of a Work Sheet Showing a Net Loss 1. Complete the Adjustments columns. 2. Complete the work sheet. 3. Enter the adjustments in a general journal. If an amount box does not require an entry, leave it blank. The trial balance for Cascade Bicycle Shop, a business owned by David Lamond, is shown below. Cascade Bicycle Shop Trial Balance December 31, 20 ACCOUNT TITLE DEBIT BALANCE CREDIT BALANCE Cash Accounts Receivable Merchandise Inventory Supplies Prepaid Insurance Land Building Accumulated...
Please make the year end adjustments in a worksheet and include and in a general journal Cascade Bicycle Shop Trial Balance December 31, 20 -- ACCOUNT TITLE DEBIT BALANCE CREDIT BALANCE Cash Accounts Receivable Merchandise Inventory Supplies Prepaid Insurance Land Building Accumulated Depr. -Building Store Equipment Accumulated Depr.-Store Equip Accounts Payable Wages Payable Sales Tax Payable Unearned Storage Revenue Mortgage Payable D. Lamond, Capital 22,895 14,640 31,390 7,475 4,505 28,130 51,440 16,520 27,450 9,150 3,530 2,985 5,660 43,400 163,640 D....
2. Use the following adjustment Information to complete the Adjustments columns of the work sheet. a. Depreciation on equipment, $3 b. Accrued salarles, $6 c. The $12 of unearned revenue has been earned d. Supplies available at December 31, $15 e. Explred Insurance, $15 3. Extend the balances in the Adjusted Trial Balance columns of the work sheet to the proper financial statement columns. Compute totals for those columns Including net Income. WESTCOTT COMPANY Partial Work Sheet For the year...
2. Use the following adjustment information to complete the Adjustments columns of the work sheet. a. Depreciation on equipment. $19 b. Accrued salaries, $22 C. The $28 of unearned revenue has been earned d. Supplies available at December 31, $95 e. Expired insurance, $31 3. Extend the balances in the Adjusted Trial Balance columns of the work sheet to the proper financial statement columns. Compute totals for those columns including net income. WESTCOTT COMPANY Partial Work Sheet For the year...
Question 21 The trial balance and information for year-end adjustments for J. Olsen Company are as follows: Credit J.Olsen Company Trial Balance December 31, 2017 Account Title Debit Cash 15,700 Accounts Receivable 9,400 Office Supplies 6,000 Prepaid Insurance 1,500 Equipment 50,000 Accumulated Depreciation Equipment Accounts Payable Wages Payable J. Olsen, Capital Vilardi, Drawing 1,500 Service Fees Wages Expense 15,100 Rent Expense 7,800 Supplies Expense Utilities Expense 860 Insurance Expense Depreciation Expense-Equipment 107,860 10,000 5,400 29,460 63,000 107,860 Supplies on hand...
DUE DATE: Tuesday, December 03, 2019. Use ONLY PENCIL or computer to do the special homework. The trial balance for December 31, 20.- has been entered below on the partial work sheet for Camping Supply Center Required: 1. Complete the Adjustments columns using the following year-end adjustments information. Identify each adjustment with its corresponding letter. a./b. Based on a physical count, it was determined that merchandise inventory costing $21,700 is on hand as of December 31, 20- c. Supplies remaining...
The trial balance for December 31 pocal UncОЛ К. The trial balance for December 31, 20-- has been entered below on the partial work sheet for Camping Supply Center Required: 1. Complete the Adjustments columns using the following year-end adjustments information. Identify each adjustment with its corresponding letter. a./b. Based on a physical count, it was determined that merchandise inventory costing $21,700 is on hand as of December 31, 20-- c. Supplies remaining at the end of the year, $6,300....
EXERCISE 4-5 Complete the work sheet for Ramey Company, dated December 31, 20--, through the adjusted trial balance using the following adjustment information: a. Expired or used-up insurance, $460. b. Depreciation expense on equipment, $870. (Remember to credit the Accumulated Depreciation account for equipment, not Equipment.) Wages accrued or earned since the last payday, $120 (owed and to be paid on the next payday). d. Supplies remaining, $80. А B 1 2 3 с D E Ramey Company Work Sheet...
Below, I have attached pictures of this particular assignment and its questions. I have tried to finish this assignment, but I am stuck and do not know how to finish it. The journal entries are not as difficult, but I would appreciate help with those as well because it would save me a lot of time. This assignment is due on 1/23/19 by 9:00AM EST. Thank you! (LO1/2/3/4) COMPLETION OF A WORK SHEET SHOWING A NET LOSS The trial balance...
Prepare a mulit-step income statement, balance sheet, and statement of owner's equity. I can't figure out the income statement but I believe I can get the other two! Yoder's Cool Stuff Worksheet For the month ended 12/31/13 Balance Income Adjusted Sheet Trial Balance Adjustments Trial Balance Credit Debit Debit Credit Debit Credit Credit Credit Debit Debit 37 Account Name 37 37 sh Receivable a 2000 4000 Merchandise Inven 60 175 Supplies Prepaid Insurance 175 25 Equipment f 1000 A/Depr-Equipment 18...