978-0078025587 Chapter 5 Excel

subject Type Homework Help
subject Pages 4
subject Words 327
subject Authors Barbara Chiappetta, John Wild, Ken Shaw

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
Student Name:
Class:
Trans.
Date Account Titles no. Debit Credit
Jan. 31 4,050
4,050 «- Correct!
31 1,400
31 1,525
1,525 «- Correct!
31 1,600
1,600 «- Correct!
111,950$
2,000$
2,200 4,200
107,750
40,000
67,750
17,500
7,500
4,050
9,800
40,375
7,500
26,400
66,775
975$
Instructor
To adjust inventory for shrinkage.
To record depreciation expense.
To record expired insurance.
To record store supplies expense.
NELSON COMPANY
Problem 05-03A
McGraw-Hill/Irwin
General Journal
For Year Ended January 31, 2013
Income Statement
NELSON COMPANY
Adjusting Entries:
Store Supplies Expense
Store Supplies
Sales returns and allowances
Insurance Expense
Depreciation Expense - Store Equipment
Accumulated Depreciation - Store Equipment
Cost of Goods Sold
Merchandise Inventory
Sales
Less: Sales discounts
Total selling expenses
Net sales
Cost of goods sold
Gross profit
Expenses
Selling expenses
Sales salaries expense
Rent expense - Selling space
Store supplies expense
Advertising expense
General and administrative expenses
Rent expense - Office space
Total general and administrative expenses
Total expenses
Net income
page-pf2
Student Name:
Class:
Instructor
Problem 05-03A
McGraw-Hill/Irwin
Correct!
page-pf3
Student Name:
Class:
Instructor
Problem 05-03A
McGraw-Hill/Irwin
107,750$
40,000
40,375
26,400
106,775
975$
Correct!
$1,000
10,900
1,750
1,000
$14,650
$10,000
1.47 «- Correct!
$1,000
$10,000
0.10 «- Correct!
107,750$
40,000
67,750$
0.63 «- Correct!
Ratios
NELSON COMPANY
For Year Ended January 31, 2013
Income Statement
NELSON COMPANY
Selling expenses
Net sales
Expenses
Cost of goods sold
Quick assets: Cash
General and administrative expense
Total expenses
Net income
Current ratio:
Current assets:
Cash
Merchandise inventory
Store supplies
Prepaid insurance
Total current assets
Current liabilities
Current ratio
Gross margin ratio
Current liabilities
Acid-test ratio
Net sales
Cost of goods sold
Gross margin
Gross margin ratio:
page-pf4
J. Nelson, Capital
January 31, 2013
Unadjusted Trial Balance
NELSON COMPANY
Given Data P05-03A:
Cash
Merchandise inventory
Store supplies
Prepaid insurance
Store equipment
Accumulated depreciation - Store equipment
Accounts payable
Totals
J. Nelson, Withdrawals
Sales
Sales discounts
Sales returns and allowances
Cost of goods sold
Depreciation expense - Store equipment
Salaries expense
Insurance expense
Rent expense
Store supplies expense
Advertising expense
Net income
Additional information:
Store supplies on hand at year-end
Expired insurance for year
(3) Total expenses

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.