Prepare a classified comparative balance sheet


Response to the following problem:

The Best Clothing Company, a retail corporation, had the following post closing trial balance, December 31, 2016(in thousands of dollars).

ACCOUNT

NUMBER         NAME OF ACCOUNT                                        DEBIT           CREDIT

10                       CASH                                                        30

20                       ACCOUNTS RECEIVABLE                              91

34                       NOTES RECEIVABLE, CURRENT                    100

35                       ACCRUED INTEREST RECEIVABLE                 16

40                       MERCHANDISE INVENTORY                           160

52                       PREPAID FIRE INSURANCE                              3

62                       NOTES RECEIVABLE LONG TERM                   100

74                       EQUIPMENT                                                 120

74A                    ACCUMULATED DEPREC. EQUIP.                                              76

100                     ACCOUNTS PAYABLE                                                             90

111                     ACCRUED WAGES PAYABLE                                                    8

123                     ACCRUED INCOME TAXES PAYABLE                                          4

137                     UNEARNED SALES REVENUE                                                   10

200                     PAID IN CAPITAL                                                                    110

230                     RETAINED INCOME                                            ___                 322

                                                                                                 620                620

The following summarized transactions occurred during 2017 and are shown in thousands of dollars.

a. Merchandise inventory purchased on open account was $480.

b. Total sales were $890, of which 80% were on credit.

c. The sales in (b) were exclusive of the deliveries of goods to customers who had paid in advance as of December 31, 2016. See account # 137 on the above trial balance. All of those goods ordered in advance were all delivered in 2017.

d. The cost of goods sold including those in (c), was $440.

e. Collections from credit customers were $682.

f. The notes receivable are from a major supplier of belts. Interest on all notes was collected on May 1, 2017. The rate is 12% per annum. The accounting system provides for cash collections of interest to be credited first to existing accrued interest receivable (see account #35) carried over from the preceding period.

g. The principal of the current notes receivable was collected on May 1, 2017. The principal of the remaining notes is payable on May 1, 2018(see entry [r]).

h. As of December 31, 2017, customers had made a total of $7 in advance cash payments for "layaway" plans and for merchandise not yet in stock. These payments were exclusive of any other transactions described above.

CASH DISBURSEMENTS WERE:

i. To trade creditors for accounts payable, $470.

j. To employees for wages, $193. The accounting system for wages is to debit any existing accrued payables (see account #111) first and debit any remainder of a disbursement to wage expense.

k. For miscellaneous expenses such as store rents, advertising, utilities, and suppliers, which were paid in cash, $189. It is not necessary to establish separate accounts for these items.

l. New equipment was acquired on July 1, 2017for $74.

m. A new fire insurance policy for 36 months was secured and paid in full on September 1, 2017. The effective date of the policy was September 1, 2017and the cost is $36.

n. Income taxes were paid to the Federal and State governments in the amount of $19. Only $15 of the $19 was debited to income tax expense because the company pays taxes on a quarterly basis (see account #123).

o. The board of directors declared a cash dividend of $26 on December 15, 2017to stockholders of record, January 5, 2018 and payable January 26, 2018. This company uses an account called DIVIDENDS DECLARED to record the declaration of dividends. This means that your debit would be to Dividends Declared. Do not debit retained earnings.

THE FOLLOWING ADJUSTMENTS WERE MADE ON DECEMBER 31, 2016:

p. For the interest on notes receivable.

q. For current fire insurance policy and the prepaid insurance of December 31, 2016, has expired too. See account # 52 on the opening trial balance.

r. For reclassification of the note receivable. This is necessary because the notes become payable the following year.

s. For depreciation:depreciation expense for the year is $30.

t. Wages earned but UNPAID, at December 31, 2017, $15.

u. Total income tax expense for 2017is $20, computed as 40% of pretax income of $50. Note: part of the 2016 income tax has already been recorded and paid, as indicated by transaction [n]. This is a MAJOR HINT: You must arrive at $50 as your Net Income before Income Tax Expense, if you DONOT, there is a problem with your journal entries and/or postings.

You are the unfortunate accountant who must record all of the transactions listed above because the bookkeeper was fired for stealing from the store.

Therefore, you must do the following to close the books:

1. Post all balances as shown on the trial balance of 12/31/16 to T ACCOUNTS and indicate that they are opening balances for 1/1/17. Then journalize all of the transactions from a. to u. For any accounts not shown in the trial balance establish new accounts and USE ACCOUNT NUMBERS IN THE 300 SERIES.

2. Post all transactions that you have journalized to the T ACCOUNTS. All postings must contain posting references to the transaction codes, i.e., the letters a. - u.

3. Prepare a trial balance as of December 31, 2017.

4. Journalize and post the closing entries to CLOSE THE BOOKS

5. Prepare a multi step income statement as of December 31, 2017.

6. Prepare a statement of retained earnings as of December 31, 2017.

7. Prepare a classified comparative balance sheet for December 31, 2016 and December 31, 2017.

NOTE:

ALL WORK MUST BE PREPARED IN EXCEL OR WORD.

Additional notes:

1. The ending cash balance as of December 31, 2017must be 40

2. The trial balance number for debits = credits is 1,607

3. Total assets on the December 31, 2017 balance sheet are 589.

Solution Preview :

Prepared by a verified Expert
Financial Accounting: Prepare a classified comparative balance sheet
Reference No:- TGS02117716

Now Priced at $40 (50% Discount)

Recommended (94%)

Rated (4.6/5)