Preparation of Adjustments on a Spreadsheet for a Merchandising Business: Periodic Method The trial balance for the Venice Beach Kite Shop, a business owned by Molly Young is shown in the End-of-Period Spreadsheet. Year-end adjustment information: (a, b) A physical count shows that merchandise inventory costing $84,000 is on hand as of December 31, 20--. (c, d, e)  Young estimates that customers will be granted $5,700 in refunds of this year’s sales next year and the merchandise expected to be returned will have a cost of $4,300. (f) Supplies remaining at the end of the year, $3,300. (g) Unexpired insurance on December 31, $3,800. (h) Depreciation expense on the building for 20--, $11,500. (i) Depreciation expense on the store equipment for 20--, $6,500. (j) Unearned rent revenue as of December 31, $4,600. (k) Wages earned but not paid as of December 31, $3,400.

College Accounting, Chapters 1-27
23rd Edition
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:HEINTZ, James A.
Chapter14: Adjustments For A Merchandising Business
Section: Chapter Questions
Problem 1MP: John Neff owns and operates Waikiki Surf Shop. A year-end trial balance is provided on page 561....
icon
Related questions
icon
Concept explainers
Question

Preparation of Adjustments on a Spreadsheet for a Merchandising Business: Periodic Method

The trial balance for the Venice Beach Kite Shop, a business owned by Molly Young is shown in the End-of-Period Spreadsheet.

Year-end adjustment information:

(a, b) A physical count shows that merchandise inventory costing $84,000 is on hand as of December 31, 20--.
(c, d, e)  Young estimates that customers will be granted $5,700 in refunds of this year’s sales next year and the merchandise expected to be returned will have a cost of $4,300.
(f) Supplies remaining at the end of the year, $3,300.
(g) Unexpired insurance on December 31, $3,800.
(h) Depreciation expense on the building for 20--, $11,500.
(i) Depreciation expense on the store equipment for 20--, $6,500.
(j) Unearned rent revenue as of December 31, $4,600.
(k) Wages earned but not paid as of December 31, $3,400.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
College Accounting, Chapters 1-27 (New in Account…
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781305084087
Author:
Cathy J. Scott
Publisher:
Cengage Learning