Question

In: Accounting

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 23,385 Accounts Receivable 14,985 Merchandise Inventory 31,390 Supplies 7,375 Prepaid Insurance 4,695 Land 28,045 Building 51,180 Accumulated Depr.—Building 16,440 Store Equipment 27,690 Accumulated Depr.—Store Equip. 9,230 Accounts Payable 3,915 Wages Payable Sales Tax Payable 2,890 Unearned Storage Revenue 5,605 Mortgage Payable 44,600 D. Lamond, Capital 162,650 D. Lamond, Drawing 32,680 Income Summary Sales 50,960 Sales Returns and Allowances 2,410 Storage Revenue Purchases 20,795 Purchases Returns and Allow. 1,295 Purchases Discounts 1,935 Freight-In 1,750 Wages Expense 35,240 Advertising Expense 5,715 Supplies Expense Phone Expense 2,135 Utilities Expense 9,160 Insurance Expense Depreciation Expense—Building Depreciation Exp.—Store Equipment Miscellaneous Expense 890 299,520 299,520 Year-end adjustment information is as follows: (a and b) Merchandise inventory costing $22,165 is on hand as of December 31, 20--. (The periodic inventory system is used.) (c) Supplies remaining at the end of the year, $2,410. (d) Unexpired insurance on December 31, $1,775. (e) Depreciation expense on the building for 20--, $3,860. (f) Depreciation expense on the store equipment for 20--, $3,692. (g) Unearned storage revenue as of December 31, $1,950. (h) Wages earned but not paid as of December 31, $790.

Solutions

Expert Solution

  • All working forms part of the answer
  • Adjustment column and completion of Worksheet:

Accounts title

Unadjusted Trial Balance

Adjustments

Adjusted Trial Balance

Income Summary

Balance Sheet

Debit

Credit

Debit

Credit

Debit

Credit

Debit

Credit

Debit

Credit

Cash

$           23,385.00

$           23,385.00

$              23,385.00

Accounts receivables

$           14,985.00

$           14,985.00

$              14,985.00

Merchandise Inventory

$           31,390.00

$         22,165.00

$         31,390.00

$           22,165.00

$              22,165.00

Supplies

$             7,375.00

$           4,965.00

$             2,410.00

$                2,410.00

Prepaid Insurance

$             4,695.00

$           2,920.00

$             1,775.00

$                1,775.00

Land

$           28,045.00

$           28,045.00

$              28,045.00

Building

$           51,180.00

$           51,180.00

$              51,180.00

Accumulated Depreciation - Building

$        16,440.00

$           3,860.00

$        20,300.00

$     20,300.00

Store Equipment

$           27,690.00

$           27,690.00

$              27,690.00

Accumulated Depreciation - Store Equipment

$          9,230.00

$           3,692.00

$        12,922.00

$     12,922.00

Accounts Payable

$          3,915.00

$          3,915.00

$       3,915.00

Wages Payable

$               790.00

$              790.00

$           790.00

Sales Tax Payable

$          2,890.00

$          2,890.00

$       2,890.00

Uneanred Storage revenue

$          5,605.00

$            3,655.00

$          1,950.00

$       1,950.00

Mortgage Payable

$        44,600.00

$        44,600.00

$     44,600.00

D Lamond Capital

$      162,650.00

$      162,650.00

$   162,650.00

D Lamond Drawings

$           32,680.00

$           32,680.00

$              32,680.00

Income Summary

$         31,390.00

$         22,165.00

$             9,225.00

$                 9,225.00

Sales

$        50,960.00

$        50,960.00

$    50,960.00

Sales return & Allowances

$             2,410.00

$             2,410.00

$                 2,410.00

Storage Revenue

$           3,655.00

$          3,655.00

$      3,655.00

Purchases

$           20,795.00

$           20,795.00

$              20,795.00

Purchases Return & Allowances

$          1,295.00

$          1,295.00

$      1,295.00

Purchase Discounts

$          1,935.00

$          1,935.00

$      1,935.00

Freight In

$             1,750.00

$             1,750.00

$                 1,750.00

Wages Expenses

$           35,240.00

$               790.00

$           36,030.00

$              36,030.00

Advertising Expenses

$             5,715.00

$             5,715.00

$                 5,715.00

Supplies Expense

$            4,965.00

$             4,965.00

$                 4,965.00

Phone Expenses

$             2,135.00

$             2,135.00

$                 2,135.00

Utilities Expenses

$             9,160.00

$             9,160.00

$                 9,160.00

Insurance Expenses

$            2,920.00

$             2,920.00

$                 2,920.00

Depreciation Expense - Building

$            3,860.00

$             3,860.00

$                 3,860.00

Depreciation Expense - Store Equipment

$            3,692.00

$             3,692.00

$                 3,692.00

Miscellaneous Expenses

$                 890.00

$                 890.00

$                    890.00

TOTALs

$        299,520.00

$      299,520.00

$         73,437.00

$         73,437.00

$        307,862.00

$      307,862.00

$            103,547.00

$    57,845.00

$           204,315.00

$   250,017.00

Net Loss

$    45,702.00

$              45,702.00

TOTAL

$        299,520.00

$      299,520.00

$         73,437.00

$         73,437.00

$        307,862.00

$      307,862.00

$            103,547.00

$ 103,547.00

$           250,017.00

$   250,017.00

  • Adjustment entries

Adjustment no.

Accounts title

Debit

Credit

a.

Income Summary

$           31,390.00

Merchandising Inventory

$        31,390.00

(Beginning inventory balance cancelled)

b.

Merchandising Inventory

$           22,165.00

Income Summary

$        22,165.00

(Ending inventory balance recorded)

c.

Supplies Expenses

$             4,965.00

Supplies

$          4,965.00

(Supplies consumed)

d.

Insurance Expenses

$             2,920.00

Prepaid Insurance

$          2,920.00

(Insurance expired)

e.

Depreciation Expense - Building

$             3,860.00

Accumulated Depreciation - Building

$          3,860.00

f.

Depreciation Expense - Store Equipment

$             3,692.00

Accumulated Depreciation - Store Equipment

$          3,692.00

g.

Uneanred Storage revenue

$             3,655.00

Storage Revenue

$          3,655.00

(Unearned Revenue now earned)

h.

Wages Expenses

$                 790.00

Wages Payable

$              790.00

(Wages accrued to be paid)


Related Solutions

Work Sheet Extensions for Merchandise Inventory Adjustments: Periodic Inventory System 1. Complete the Adjustments columns for...
Work Sheet Extensions for Merchandise Inventory Adjustments: Periodic Inventory System 1. Complete the Adjustments columns for the merchandise inventory. 2. Extend the merchandise inventory to the Adjusted Trial Balance and Balance Sheet columns. 3. Extend the remaining accounts to the Adjusted Trial Balance and Income Statement columns. 4. Prepare a cost of goods sold section from the partial work sheet. The following partial work sheet is taken from Kevin's Gift Shop for the year ended December 31, 20--. The ending...
Use the following information from the Adjustments columns of a 10-column work sheet.    Adjustments No....
Use the following information from the Adjustments columns of a 10-column work sheet.    Adjustments No. Account Title Dr. Cr. 109 Interest receivable (d) $ 571 124 Office supplies (b) $ 1,628 128 Prepaid insurance (a) 878 164 Accumulated depreciation—Office equipment (c) 3,300 209 Salaries payable (e) 651 409 Interest revenue (d) 571 612 Depreciation expense—Office equipment (c) 3,300 620 Office salaries expense (e) 651 636 Insurance expense—Office equipment (a) 421 637 Insurance expense—Store equipment (a) 457 650 Office supplies...
1. Complete the Adjustments section of the work sheet using the following information: On October 30,...
1. Complete the Adjustments section of the work sheet using the following information: On October 30, an inventory of the supplies showed that items costing $1,730 were used this month. Record an adjustment for the supplies used in October. On October 1, 20xx the company purchased a twelve-month insurance policy for $8,400. Record an adjustment for the expired insurance during the month of October. On October 3, the company purchased a six-month advertising contract for $4,800. Record an adjustment for...
Complete the Adjustments column of the work sheet represented below. Ending merchandise inventory is $92,000.
Complete the Adjustments column of the work sheet represented below. Ending merchandise inventory is $92,000. If an amount box does not require an entry, leave it blank.
1. In the completed work sheet, which of the following sets of columns would contain the...
1. In the completed work sheet, which of the following sets of columns would contain the two balances in the Income Summary account representing beginning and ending inventory when using the periodic inventory system? a. Adjustments and Balance Sheet columns b. Trial Balance and Adjustments columns c. Trial Balance and Income Statement columns d. Adjustments and Income Statement columns e. Trial Balance and Balance Sheet columns 2. If the trial balance amount of Unearned Pest Spray Revenue is $50,000, and...
The Income Statement and Balance Sheet columns below are from the work sheet of the Mandle...
The Income Statement and Balance Sheet columns below are from the work sheet of the Mandle Company for the year ended December 31, 20--. Mandle Company Work Sheet (partial) For the year ended December 31, 20-- Income Statement Balance Sheet Account Title Debit Credit Debit Credit Cash 24,000 Accounts Receivable 12,500 Merchandise Inventory 8,000 Store Supplies 550 Office Supplies 1,200 Prepaid Insurance 750 Store Equipment 33,000 Accumulated Depreciation—Store Equipment 19,000 Office Equipment 9,000 Accumulated Depreciation—Office Equipment 5,000 Accounts Payable 9,900...
Using the Exhibit below (Adjustments to Net Income (Loss) Using the Indirect Method, assume that the...
Using the Exhibit below (Adjustments to Net Income (Loss) Using the Indirect Method, assume that the amount of Net Income on the Income Statement for the year was $101,800. When preparing the Statement of Cash Flow using the indirect method for the current year, which of the following statements would describe the proper presentation of net income on the Cash flow from operating activities section? EXHIBIT                                                                                       Increase                                                                                     (Decrease)      Net Income (loss)                                                         $XXX Adjustments to reconcile net income to net cash flow       ...
1. The fourth pair of columns on a 10-column work sheet prepared at the end of the period would be the
1. The fourth pair of columns on a 10-column work sheet prepared at the end of the period would be theIncome Statement columns.Adjusted Trial Balance columns.Balance Sheet columns.Adjustments columns.2. The third pair of columns on a 10-column work sheet prepared at the end of the period would be theAdjustments columns.Adjusted Trial Balance columns.Income Statement columns.Balance Sheet columns.3. The owner's equity in a business amounted to $52,000 at the beginning of the year and $100,000 at the end of the year....
1. Agile Methods Practice Problems. Complete these problems, showing your work. 1a. At the end of...
1. Agile Methods Practice Problems. Complete these problems, showing your work. 1a. At the end of Day 1 of a sprint there are 90 story points worth of work remaining, and at the end of Day 6 there are 40 story points of work remaining. What is the project’s current velocity, in units of story points per day? (Show your work) 1b. A project whose sprint velocity is 12 story points per day at the end of Day 4, and...
1) which balance day adjustments are classified as current liabilities in the balance sheet ? 2)...
1) which balance day adjustments are classified as current liabilities in the balance sheet ? 2) cartage outwards is transferred to what ledger account in the balance sheet?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT