Question

In: Accounting

The Artisan Wines is a retail store selling vintage wines. On December 31, 2019, the firm’s...

The Artisan Wines is a retail store selling vintage wines. On December 31, 2019, the firm’s general ledger contained the accounts and balances below. All account balances are normal.

Artisan Wines
Worksheet
Year Ended December 31, 2019

Trial Balance

Adjustments

Adjusted Trial Balance

Income Statement

Balance Sheet

Account Name

Debit

Credit

Debit

Credit

Debit

Credit

Debit

Credit

Debit

Credit

Cash

$

28,386.00

$

28,386.00

$

28,386.00

Accounts Receivable

500.00

500.00

500.00

Prepaid Advertising

480.00

160.00

320.00

320.00

Supplies

300.00

140.00

160.00

160.00

Merchandise Inventory

15,000.00

13,000.00

15,000.00

13,000.00

13,000.00

Store Equipment

25,000.00

25,000.00

25,000.00

Accumulated Depreciation—Store Equipment

3,000.00

3,000.00

6,000.00

6,000.00

Office Equipment

5,000.00

5,000.00

5,000.00

Accumulated Depreciation—Office Equipment

1,500.00

1,125.00

2,625.00

2,625.00

Notes Payable, due 2020

20,000.00

20,000.00

20,000.00

Accounts Payable

2,705.00

2,705.00

2,705.00

Wages Payable

500.00

500.00

500.00

Social Security Tax Payable

31.00

31.00

31.00

Medicare Tax Payable

7.25

7.25

7.25

Unearned Seminar Fees

6,000.00

4,000.00

2,000.00

2,000.00

Interest Payable

100.00

100.00

100.00

Vincent Arroyo, Capital

32,700.00

32,700.00

32,700.00

Vincent Arroyo, Drawing

14,110.00

14,110.00

14,110.00

Income Summary

15,000.00

13,000.00

15,000.00

13,000.00

15,000.00

13,000.00

Sales

153,970.00

153,970.00

153,970.00

Sales Discounts

200.00

200.00

200.00

Seminar Fee Income

4,000.00

4,000.00

4,000.00

Purchases

91,000.00

91,000.00

91,000.00

Purchases Returns and Allowances

1,000.00

1,000.00

1,000.00

Freight In

225.00

225.00

225.00

Rent Expense

13,200.00

13,200.00

13,200.00

Wages Expense

24,000.00

500.00

24,500.00

24,500.00

Payroll Taxes Expense

3,324.00

38.25

3,362.25

3,362.25

Depreciation Expense—Store Equipment

3,000.00

3,000.00

3,000.00

Depreciation Expense—Office Equipment

1,125.00

1,125.00

1,125.00

Advertising Expense

160.00

160.00

160.00

Supplies Expense

140.00

140.00

140.00

Interest Expense

150.00

100.00

250.00

250.00

Totals

$

220,875.00

$

220,875.00

$

37,063.25

$

37,063.25

$

238,638.25

$

238,638.25

$

152,162.25

$

171,970.00

$

86,476.00

$

66,668.25

Net Income

19,807.75

19,807.75

$

171,970.00

$

171,970.00

$

86,476.00

$

86,476.00


Required:

Prepare a classified income statement for the year ended December 31, 2019. The company does not classify its operating expenses as selling expenses and general and administrative expenses.

Prepare a statement of owner’s equity for the year ended December 31, 2019. No additional investments were made during the year.

Prepare a classified balance sheet as of December 31, 2019.


Analyze:
What is the inventory turnover for Artisan Wines?

Solutions

Expert Solution


Related Solutions

The Artisan Wines is a retail store selling vintage wines. On December 31, 2019, the firm’s...
The Artisan Wines is a retail store selling vintage wines. On December 31, 2019, the firm’s general ledger contained the accounts and balances below. All account balances are normal. Artisan Wines Worksheet Year Ended December 31, 2019 Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet Account Name Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Cash $ 29,086.00 $ 29,086.00 $ 29,086.00 Accounts Receivable 570.00 570.00 570.00 Prepaid Advertising 900.00 300.00 600.00 600.00 Supplies 370.00 235.00...
The Artisan Wines is a retail store selling vintage wines. On December 31, 2019, the firm’s...
The Artisan Wines is a retail store selling vintage wines. On December 31, 2019, the firm’s general ledger contained the accounts and balances below. All account balances are normal. Cash $ 28,386 Accounts Receivable 500 Prepaid Advertising 480 Supplies 300 Merchandise Inventory 15,000 Store Equipment 25,000 Accumulated Depreciation—Store Equipment 3,000 Office Equipment 5,000 Accumulated Depreciation—Office Equipment 1,500 Notes Payable, due 2020 20,000 Accounts Payable 2,705 Wages Payable Social Security Tax Payable Medicare Tax Payable Unearned Seminar Fees 6,000 Interest Payable...
The Arti Wines is a retail store selling vintage wines. On December 31, 2019, the firm’s...
The Arti Wines is a retail store selling vintage wines. On December 31, 2019, the firm’s general ledger contained the accounts and balances below. All account balances are normal. Cash $ 38,916 Accounts Receivable 560 Prepaid Advertising 840 Supplies 360 Merchandise Inventory 15,600 Store Equipment 25,600 Accumulated Depreciation—Store Equipment 3,600 Office Equipment 5,600 Accumulated Depreciation—Office Equipment 1,800 Notes Payable, due 2020 26,000 Accounts Payable 2,765 Wages Payable Social Security Tax Payable Medicare Tax Payable Unearned Seminar Fees 9,600 Interest Payable...
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available...
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available information follows: The inventory at January 1, 2019, had a retail value of $50,000 and a cost of $36,200 based on the conventional retail method. Transactions during 2019 were as follows: Cost Retail Gross purchases $ 333,900 $ 540,000 Purchase returns 6,400 15,000 Purchase discounts 5,500 Gross sales 500,000 Sales returns 8,000 Employee discounts 5,500 Freight-in 29,000 Net markups 30,000 Net markdowns 15,000 Sales...
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available...
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available information follows: The inventory at January 1, 2019, had a retail value of $50,000 and a cost of $36,200 based on the conventional retail method. Transactions during 2019 were as follows: Cost Retail Gross purchases $ 333,900 $ 540,000 Purchase returns 6,400 15,000 Purchase discounts 5,500 Gross sales 500,000 Sales returns 8,000 Employee discounts 5,500 Freight-in 29,000 Net markups 30,000 Net markdowns 15,000 Sales...
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available...
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available information follows: The inventory at January 1, 2019, had a retail value of $31,000 and a cost of $11,000 based on the conventional retail method. Transactions during 2019 were as follows: Cost Retail Gross purchases $ 570,000 $ 953,000 Purchase returns 6,000 4,000 Purchase discounts 5,000 Gross sales 958,000 Sales returns 5,000 Employee discounts 3,000 Freight-in 20,000 Net markups 20,000 Net markdowns 4,000 Sales...
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available...
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available information follows: The inventory at January 1, 2019, had a retail value of $31,000 and a cost of $11,000 based on the conventional retail method. Transactions during 2019 were as follows: Cost Retail Gross purchases $ 570,000 $ 953,000 Purchase returns 6,000 4,000 Purchase discounts 5,000 Gross sales 958,000 Sales returns 5,000 Employee discounts 3,000 Freight-in 20,000 Net markups 20,000 Net markdowns 4,000 Sales...
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available...
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available information follows: The inventory at January 1, 2019, had a retail value of $45,000 and a cost of $27,500 based on the conventional retail method. Transactions during 2019 were as follows: Cost Retail Gross purchases $ 282,000 $ 490,000 Purchase returns 6,500 10,000 Purchase discounts 5,000 Sales 492,000 Sales returns 5,000 Employee discounts 3,000 Freight-in 26,500 Net markups 25,000 Net markdowns 10,000 Sales to...
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available...
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available information follows: The inventory at January 1, 2019, had a retail value of $45,000 and a cost of $27,500 based on the conventional retail method. Transactions during 2019 were as follows: Cost Retail Gross purchases $ 282,000 $ 490,000 Purchase returns 6,500 10,000 Purchase discounts 5,000 Sales 492,000 Sales returns 5,000 Employee discounts 3,000 Freight-in 26,500 Net markups 25,000 Net markdowns 10,000 Sales to...
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available...
Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available information follows: The inventory at January 1, 2019, had a retail value of $41,000 and a cost of $32,170 based on the conventional retail method. Transactions during 2019 were as follows: Cost Retail Gross purchases $ 224,310 $ 450,000 Purchase returns 6,100 24,000 Purchase discounts 4,600 Gross sales 408,500 Sales returns 5,000 Employee discounts 5,500 Freight-in 27,500 Net markups 21,000 Net markdowns 24,000 Sales...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT