a)
JAY'S SUPPLIES | ||||||||||||
WORKSHEET | ||||||||||||
FOR YEAR ENDED DECEMBER 31, 2000X | ||||||||||||
Account Titles | Trial Balance | Adjustments | Adjusted Trial Balance | Income Statement | Balance Sheet | |||||||
Cash | 2000 | 2000 | 2000 | |||||||||
Accounts receivable | 3000 | 3000 | 3000 | |||||||||
Merch. Inv., 1/1/XX | 11000 | (B) | 10400 | (A) | 11000 | 10400 | 10400 | |||||
Prepaid insurance | 1880 | (E) | 500 | 1380 | 1380 | |||||||
Equipment | 3400 | 3400 | 3400 | |||||||||
Accum. dep. equipment | 1080 | (D) | 400 | 1480 | 1480 | |||||||
Accounts payable | 5080 | 5080 | 5080 | |||||||||
Unearned training fees | 2120 | (C) | 320 | 1800 | 1800 | |||||||
Mortgage payable | 1200 | 1200 | 1200 | |||||||||
P. Jay, capital | 10560 | 10560 | 10560 | |||||||||
P. Jay, withdrawals | 4280 | 4280 | 4280 | |||||||||
Income summary | (A) | 11000 | (B) | 10400 | 600 | 600 | ||||||
Sales | 95800 | 95800 | 95800 | |||||||||
Sales returns and allowances | 3200 | 3200 | 3200 | |||||||||
Sales discount | 2600 | 2600 | 2600 | |||||||||
Purchases | 63600 | 63600 | 63600 | |||||||||
Purchases returns and allow. | 13600 | 13600 | 13600 | |||||||||
Purchases discount | 3200 | 3200 | 3200 | |||||||||
Freight-in | 2680 | 2680 | 2680 | |||||||||
Advertising expense | 11400 | 11400 | 11400 | |||||||||
Rent expense | 10000 | 10000 | 10000 | |||||||||
Salaries expense | 13600 | 13600 | 13600 | |||||||||
132640 | 132640 | |||||||||||
Training fees earned | (C) | 320 | 320 | 320 | ||||||||
Dep. Exp. Equipment | (D) | 400 | 400 | 400 | ||||||||
Insurance expense | (E) | 500 | 500 | 500 | ||||||||
22620 | 22620 | 133040 | 133040 | 108580 | 112920 | 24460 | 20120 | |||||
Net income | 4340 | 4340 | ||||||||||
Totals | 112920 | 112920 | 24460 | 24460 |
b)
JAY'S SUPPLIES | |||
INCOME STATEMENT | |||
FOR YEAR ENDED DECEMBER 31, 2000X | |||
Training fees revenue | 320 | ||
Sales revenue | 95800 | ||
Less: | |||
Sales returns and allowances | 3200 | ||
Sales discount | 2600 | 5800 | |
Net sales revenue | 90000 | ||
Cost of goods sold | |||
Beginning merchandise inventory | 11000 | ||
Add: Purchases | 63600 | ||
Purchase returns and allowances | -13600 | ||
Purchase discounts | -3200 | ||
Freight-in | 2680 | ||
Net purchases | 49480 | ||
Cost of goods available for sale | 60480 | ||
Less: Ending merchandise inventory | 10400 | ||
Cost of goods sold | 50080 | ||
Gross profit | 40240 | ||
Operating expenses: | |||
Advertising expense | 11400 | ||
Rent expense | 10000 | ||
Salaries expense | 13600 | ||
Dep. Exp. Equipment | 400 | ||
Insurance expense | 500 | ||
Total operating expenses | 35900 | ||
Net income | 4340 |
JAY'S SUPPLIES | ||
BALANCE SHEET | ||
DECEMBER 31, 2000X | ||
Assets | ||
Current assets | ||
Cash | 2000 | |
Accounts receivable | 3000 | |
Merchandise inventory | 10400 | |
Prepaid insurance | 1380 | |
Total current assets | 16780 | |
Property, plant, and equipment | ||
Equipment | 3400 | |
Less: Accumulated depreciation | 1480 | 1920 |
Total assets | 18700 | |
Liabilities and Owner's Equity | ||
Current liabilities | ||
Accounts payable | 5080 | |
Unearned training fees | 1800 | |
Mortgage payable | 800 | |
Total current liabilities | 7680 | |
Long-term liabilities | ||
Mortgage payable | 400 | |
Total liabilities | 8080 | |
Owner's Equity | ||
P. Jay, capital | 10620 | |
Total liabilities and owner's equity | 18700 |
c) Adjusting entries:
Closing entries:
12A-3.Hw a) Complete the worksheet for Jay's Supplies b) Prepare an income statement, a statement of...
12A-3. a. Complete the partial worksheet for Jay's Supplies. b. Prepare an income statement, a statement of owner's equity, and a classified balance sheet. Note: The amount of the mortgage due the first year is $800. C. Journalize the adjusting and closing entries. Completion of the Accountinly U Figure 12.16 Worksheet for Jay's Supplies JAY'S SUPPLIES WORKSHEET FOR THE YEAR ENDED DECEMBER 31, 2019 Trial Balance Adjustments Dr. Dr. (A) 1 0 0 0 00 50 000 (D) 40 000...
that is the complete question
1
Complete worksheet
2 Prepare income statement, statement of owners equity,
classified balance sheet (Note: the amount the mortgage due the
first year is $830)
3 Journalize the adjusting and closing entries
12A-4. From the partial worksheet for Jamie's Supplies in Figure 12A.35, do the following: 1. Complete the worksheet. 2. Prepare the income statement, statement of owner's equity, and classified bal- ance sheet. (Note: The amount of the mortgage due the first year is...
Use the information presented in this worksheet to prepare an income statement, retained earnings statement, and balance sheet. Show cell references if possible. ESP Corporation Worksheet for year ended December 31, 2018 Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet Cash 5,900 $ 5,900 $ 5,900 Accounts Receivable 12,450 $ 2,800 $ 15,250 $ 15,250 Office Supplies $ 200 $ 200 $ 200 Prepaid insurance 2,400 $ 1,800 $ 600 $ 600 Equipment 169,000 $ 169,000 $ 169,500...
Required:
1. Prepare and complete a worksheet.
2. Prepare an income statement for 2021 and a
balance sheet as of December 31, 2021.
Required information [The following information applies to the questions displayed below.) The December 31, 2021, unadjusted trial balance for the Wolkstein Drug Company is presented below. December 31 is the company's year-end reporting date. Credits Debits 50,810 29,750 4,600 46,250 102,000 30,600 33,000 Account Title Cash Accounts receivable Prepaid rent Inventory Equipment Accumulated depreciation Accounts payable Salaries...
a) Prepare a multiple-step income statement
b) Prepare a owner's equity statement for January
(list items that increase owner's equity first)
c) Prepare a classified balance sheet at the end of
January (list current assets in order of liquidity)
Prepare a trial balance at January 31, 2020, in the trial balance columns of the worksheet. Complete the worksheet using the following additional information. 1. Office supplies at January 31 total $900. 2. Insurance coverage expires on October 31, 2020. 3....
Use the following adjusting entries to complete the
worksheet, prepare an income statement, statement of retained
earnings, closing entries, and balance sheet.
Broomfield Company
Adjusting Journal Entries
For the Year Ended December 31, 2019
Account Titles
DR
CR
a.
Interest
Expense
15,920
Interest
Payable
15,920
b.
Insurance Expense
19,152
Prepaid
Insurance
19,152
c.
Rent
Expense
23,940
Prepaid
Rent
23,940
d.
Unearned
Revenue
12,000
Consulting Revenue
12,000
e.
Supplies
Expense
116,622
Supplies...
Required: 2. Complete the worksheet by making the following adjustments: supplies on hand at the end of the month, $7,200; expired insurance, $7,000; depreciation expense for the period, $3,100. Analyze: How does the insurance adjustment affect Prepaid Insurance? Complete this question by entering your answers in the tabs below. Partial Worksheet Analyze Complete the worksheet by making the following adjustments: supplies on hand at the end of the month, $7,200; expired insurance, $7,000; depreciation expense for the period, $3,100. NEAL...
Complete the worksheet using the excel file. Add your adjusting journal entries and complete the adjusted trial balance. Do not do the financial statements, closing entries, or post-close trial balance. The information for the adjusting journal entries are at the bottom of the tab- "adjusting entries" Adjusting Journal Entries Info. Insurance that expired during December was $275.00 A physical count of the supplies indicated that $715.00 were on hand. Depreciation on office equipment for the period was $330.00 Salaries worked...
Income statement, Statement of Owner’s Equity, and Balance
sheet
1. Prepare a Multiple-step income statement
2. Prepare a statement of owners equity
3. Prepare a balance sheet
Paulsons pet store completed the work sheet below for the year
ended dec. 31, 20–. Owners equity as of January 1,20–, was $22,696.
The current portion of mortgage payable is $536.
Paulson's Pet Store Work Sheet For Year Ended December 31, 20 - TRIAL BALANCE DEBIT CREDIT DEBIT CREDITDEBIT 15,872 ADJUSTMENTSADJUSTED TRIAL BALANCE...
Q) Complete the worksheet. Adjustment Data to Update the Trial Balance a. Rent expired, $400. b. Landscaping supplies on hand (remaining). $350. c. Depreciation expense, landscaping equipment, $375. d. Wages earned by workers but not paid or due until August, $450. Landry's Landscaping Service Worksheet Month Ended July 31, 201X Trial Balance Adjustments Dr. Cr. Dr. Adjusted Trial Balance Dr. Or Income Statement Dr. Cr. Balance Sheet Dr. Cr. Account Titles Cr. Cash in Bank Accounts Receivable Prepaid Rent Landscaping...