gb 519 unit 3 homework

profileneel
unit03_assignment.xlsx
Home>Business & Finance homework help>Accounting homework help>gb 519 unit 3 homework

Instructions

The Template is provided to help you complete your assignment successfully. Enter you Name here ======>
There are hints and guidance within the templates. For Example,
some fields will have a note attached - as designated by the red triangle in the
upper right corner of the cell.
Some final cell totals or answers will give you a notice if the answer is correct.
For example, if you have gotten the right answer, you may see a note "Correct",
or "Good!" appear beneath or to the side of that cell.
But, not all exercises or problems will provide feedback. So, be sure you do your
best on all of the assignments. And, if you have any questions, please do not
hesitate to bring your questions to me. The preferred way to communicate
your assignment related questions will be in the Virtual Office.
However, please remember that we do not discuss solutions in the Virtual
Office. So, do not post partially completed template files, and do not
post your solutions. But DO ask as specific a question as possible without
giving away an answer.
One final note - in almost every template, the cells that allow you to enter something
will be background highlighted using = Yellow.
In each assignment, you will be able to enter you name in the designated cell here
in the "Instructions sheet". Please be sure to input you name in the template, and
name the file according to the assignment instructions when you save it.
Thank you and I look forward to working with you on your assignments.

BTN 4-9

GB 518 Unit 03 Assignment
Student Name: 0
Global Decision — BTN 4-9
Part 1:
(in millions) Nokia Research In Motion Apple
Revenues
Cost of sales
Gross margin
Gross margin ratio
Company Gross Margin % Rank
1
2
3
Click in the text box to enter you response to Part 2, below:
Part 2 -->

Given P04-03A

Given Data P04-03A:
REX COMPANY
Unadjusted Trial Balance
January 31, 2011
Cash $ 2,200
Merchandise inventory 11,500
Store supplies 4,800
Prepaid insurance 2,300
Store equipment 41,900
Accumulated depreciation-Store equipment $ 15,000
Accounts payable 9,000
Common stock 5,000
Retained earnings 27,000
Dividends 2,000
Sales 104,000
Sales discounts 1,000
Sales returns and allowances 2,000
Cost of goods sold 37,400
Depreciation expense-Store equipment -
Salaries expense 31,000
Insurance expense -
Rent expense 14,000
Store supplies expense -
Advertising expense 9,900
Totals $ 160,000 $ 160,000
Additional information:
Store supplies on hand at year-end $ 1,650
Expired insurance for year $ 1,500
Depreciation expense for year $ 1,400
Ending inventory $ 11,100
Check figures:
(2) Gross profit $ 63,200
(3) Total expenses $ 98,750
Net income $ 2,250

SP04-03A

Student Name: 0
Class: GB 518 Unit 03 Assignment
Problem 04-03A
REX COMPANY
General Journal
Trans.
Date Account Titles no. Debit Credit
Adjusting Entries:
Jan. 31 Store Supplies Expense

x: Enter appropriate data in yellow cells. Your Credit entries will be verified.		 Store Supplies - 0 «- Try again!
To record store supplies expense.
31 Insurance Expense
Prepaid Insurance - 0 «- Try again!
To record expired insurance.
31 Depreciation Expense, Store Equipment
Accumulated Depreciation, Store Equipment - 0 «- Try again!
To record depreciation expense.
31 Cost of Goods Sold
Merchandise Inventory - 0 «- Try again!
To adjust inventory for shrinkage.
REX COMPANY
Income Statement
For Year Ended January 31, 2011
Sales
Less: Sales discounts
Sales returns and allowances - 0
Net sales - 0
Cost of goods sold
Gross profit - 0
Expenses:
Selling expenses
Depreciation expense, Store equipment - 0
Sales salaries expense
Rent expense-Selling space
Store supplies expense
Advertising expense
Total selling expenses - 0
General and administrative expenses
Insurance expense
Office salaries expense
Rent expense-Office space
Total general and administrative expenses
Total expenses - 0
Net income $ - 0
Try again!
REX COMPANY
Income Statement
For Year Ended January 31, 2011
Net sales $ - 0
x: Enter appropriate data in yellow cells. Your answer for "Net income" will be verified.

x: Enter appropriate data in yellow cells. Your answer for "Net income" will be verified.		 Expenses
Cost of goods sold - 0
Selling expenses - 0
General and administrative expense - 0
Total expenses - 0
Net income $ - 0
Try again!
REX COMPANY
Ratios
Current ratio:
Current assets:
Cash

x: Enter appropriate data in yellow cells. Your answers for "Ratios" will be verified.		 Merchandise inventory
Store supplies
Prepaid insurance
Total current assets $0
Current liabilities
Current ratio ERROR:#DIV/0! ERROR:#DIV/0!
Acid-test ratio:
Quick assets: Cash $0
Current liabilities $0
Acid-test ratio ERROR:#DIV/0! ERROR:#DIV/0!
Gross margin ratio:
Net sales $ - 0
Cost of goods sold - 0
Gross margin $ - 0
Gross margin ratio ERROR:#DIV/0! ERROR:#DIV/0!

Problem 6-4A, Part 1 ONLY

GB518 Unit 03 Assignment
Student Name:
0
Part 1
CLARK COMPANY
Bank Reconciliation
31-Jul-11
Bank statement balance
Add:
Deposit of July 31
0
Deduct:
Checks No. 3031
3065
3069 0
Adjusted bank balance $0 Try again.
Book balance
Add:
Proceeds of note less
collection charge
0
Deduct:
NSF check
Service charge
Error (Check 3056) $ -
Adjusted book balance $0 Try again.