In: Accounting
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 | $ | 1,000 | ||
Merchandise inventory | 12,500 | |||
Store supplies | 5,800 | |||
Prepaid insurance | 2,400 | |||
Store equipment | 42,900 | |||
Accumulated depreciation—Store equipment | $ | 15,250 | ||
Accounts payable | 10,000 | |||
J. Nelson, Capital | 32,000 | |||
J. Nelson, Withdrawals | 2,200 | |||
Sales | 111,950 | |||
Sales discounts | 2,000 | |||
Sales returns and allowances | 2,200 | |||
Cost of goods sold | 38,400 | |||
Depreciation expense—Store equipment | 0 | |||
Salaries expense | 35,000 | |||
Insurance expense | 0 | |||
Rent expense | 15,000 | |||
Store supplies expense | 0 | |||
Advertising expense | 9,800 | |||
Totals | $ | 169,200 | $ | 169,200 |
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 $1,750.
Expired insurance, an administrative expense, for the fiscal year is $1,400.
Depreciation expense on store equipment, a selling expense, is $1,525 for the fiscal year.
To estimate shrinkage, a physical count of ending merchandise inventory is taken. It shows $10,900 of inventory is still available at fiscal year-end.
Required:
1. Using the above information prepare adjusting journal entries:
2. Prepare a multiple-step income statement for fiscal year 2017.
3. Prepare a single-step income statement for fiscal year 2017.
4. current ratio, Acid test ratio, Gross margin ratio
Journal Entries | ||||||
Date | General Journal | Debit | Credit | |||
31-Jan | Store Supplies Expense | 4050 | ||||
To Store Supplies | 4050 | |||||
(5800-1750) | ||||||
31-Jan | Insurance Expense | 1400 | ||||
To Prepaid Insurance | 1400 | |||||
31-Jan | Depreciation Expense - Store Equipment | 1525 | ||||
To Accumulated Depreciation - Store Equipment | 1525 | |||||
31-Jan | Cost of Goods Sold | 1600 | ||||
To Merchandise Inventory | 1600 | |||||
2 | NELSON COMPANY | |||||
INCOME STATEMENT | ||||||
FOR YEAR ENDED JANUARY 31, 2017 | ||||||
Sales | $111,950 | |||||
Less : Sales Discounts | $2,000 | |||||
Sales Returns and Allowances | 2200 | $4,200 | ||||
Net Sales | $107,750 | |||||
Cost of Goods Sold | 40000 | |||||
Gross Profit | $67,750 | |||||
Expense | ||||||
Selling Expenses | ||||||
Depreciation Expense - Store Equipment | 1525 | |||||
Sales salaries expense | 17500 | |||||
Rent Expense - selling space | 7500 | |||||
Store Supplies expense | 4050 | |||||
Advertising Expense | 9800 | |||||
Total Selling Expenses | 40375 | |||||
General and administrative expenses | ||||||
Insurance expense | 1400 | |||||
Office salaries expense | 17500 | |||||
Rent Space - Office Space | 7500 | |||||
Total General and administrative expenses | 26400 | |||||
Total Expenses | 66775 | |||||
Net Income | $975 | |||||
3 | NELSON COMPANY | |||||
INCOME STATEMENT | ||||||
FOR YEAR ENDED JANUARY 31, 2017 | ||||||
Net Sales | $107,750 | |||||
Expenses | ||||||
Cost of Goods Sold | $40,000 | |||||
Selling Expenses | 40375 | |||||
General and administrative expenses | 26400 | |||||
Total Expenses | $106,775 | |||||
Net Income | $975 | |||||
4 | Current Ratio = Current Assets/Current Liabilities | |||||
(1000+10900+1750+1000)/(10000) | ||||||
1.47 | ||||||
Acid test Ratio = (1000)/10000 | 0.10 | |||||
Gross Margin Ratio = 67750/107750 | 0.63 | |||||