In: Accounting
Problem 5-5A Preparing adjusting entries and income statements; computing gross margin, acid-test, and current ratios LO A1, A2, P3, P4
[The following information applies to the questions
displayed below.]
The following unadjusted trial balance is prepared at fiscal year-end for Nelson Company.
NELSON COMPANY Unadjusted Trial Balance January 31, 2017 |
|||||
Debit | Credit | ||||
Cash | $ | 3,000 | |||
Merchandise inventory | 14,000 | ||||
Store supplies | 5,700 | ||||
Prepaid insurance | 2,300 | ||||
Store equipment | 42,700 | ||||
Accumulated depreciation—Store equipment | $ | 17,700 | |||
Accounts payable | 12,000 | ||||
J. Nelson, Capital | 19,000 | ||||
J. Nelson, Withdrawals | 2,250 | ||||
Sales | 115,550 | ||||
Sales discounts | 1,950 | ||||
Sales returns and allowances | 2,150 | ||||
Cost of goods sold | 38,000 | ||||
Depreciation expense—Store equipment | 0 | ||||
Salaries expense | 26,900 | ||||
Insurance expense | 0 | ||||
Rent expense | 16,000 | ||||
Store supplies expense | 0 | ||||
Advertising expense | 9,300 | ||||
Totals | $ | 164,250 | $ | 164,250 | |
Rent expense and salaries expense are equally divided between selling activities and general and administrative activities. Nelson Company uses a perpetual inventory system.
Additional Information:
Store supplies still available at fiscal year-end amount to $2,750.
Expired insurance, an administrative expense, for the fiscal year is $1,600.
Depreciation expense on store equipment, a selling expense, is $1,575 for the fiscal year.
To estimate shrinkage, a physical count of ending merchandise inventory is taken. It shows $10,300 of inventory is still available at fiscal year-end.
Adjusting entries: | ||||||
S.no. | Accounts title and explanations | Debit $ | Credit $ | |||
a. | Store supplies expenses Dr. | 2950 | ||||
Store supplies | 2950 | |||||
b. | Insurance expense Dr. | 1600 | ||||
Prepaid insurance | 1600 | |||||
c. | Depreciation expense-Store equipment Dr. | 1575 | ||||
Accumulated depreciation-Store Equipment | 1575 | |||||
d. | Cost of goods sold Dr. | 3700 | ||||
Merchandise inventory | 3700 | |||||
Income Statement: | ||||||
Sales revenue | 115550 | |||||
Less: sales discount | 1950 | |||||
Less: sales returns and allowance | 2150 | |||||
Net sales revenue | 111450 | |||||
Less: Cost of goods sold (38000+3700) | 41700 | |||||
Gross Margin | 69750 | |||||
Less: Operating expenses | ||||||
Selling expenses: | ||||||
Depreciation | 1575 | |||||
Store supplies expense | 2950 | |||||
Salaries expense (26900/2) | 13450 | |||||
Rent expenses(16000/2) | 8000 | |||||
Advertisement expense | 9300 | 35275 | ||||
Admin expenses: | ||||||
Salaries expenses (26900/2) | 13450 | |||||
Rent expenses (16000/2) | 8000 | |||||
Insurance expense | 1600 | 23050 | ||||
Net Income | 11425 | |||||
Gross Margin: Gross Margin / Sales revenues *100 | 4 | |||||
69750 / 111450 *100 = 62.58% | ||||||
Current Ratio: | ||||||
Current assets (3000+10300+2750+700) | 16750 | |||||
Divide: Current Liabilities | 12000 | |||||
Current ratio | 1.396 | |||||
Acid Test ratio: | ||||||
Quick assets (only cash) | 3000 | |||||
Divide: Current liabilities | 12000 | |||||
Acid Test ratio: | 0.25 | |||||