978-0078025273 Chapter 14 Excel

subject Type Homework Help
subject Pages 7
subject Words 656
subject Authors John Price, M. David Haddock, Michael Farina

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
Student Name:
Class:
695,300$
44,800$
441,225
486,025
48,500
437,525
257,775
80,500
31,000
11,388
9,000
22,900
5,900
4,400
7,600
18,500
3,500
1,300
28,500
Total Operating Expenses 224,488
Net Income for Year 33,287$
Correct!
Problem 14.03A
McGraw-Hill
Instructor
Cost of Goods Sold
Sales (Note 1)
CORTEZ VIDEO CENTER
Income Statement
Year Ended December 31, 2013
Payroll Taxes Expense
Depreciation Expense (Note 3)
Office Expenses
Utility and Telephone Expense
Interest Expense (Note 5)
Insurance Expense
Legal and Audit Expense
Purchases (Note 2)
Merchandise Inventory, Jan. 1
Salaries Expense
Operating Expenses
Gross Profit on Sales
Cost of Goods Sold
Advertising and Other Selling Expenses
Less Merchandise Inventory, Dec. 31
Total Merchandise Available for Sale
Repairs Expense (Note 4)
Miscellaneous Expense
Uncollectible Accounts Expense
page-pf2
689,000$
33,000
722,000
26,700
695,300$
Correct!
435,000$
45,425
480,425
39,200
441,225$
Correct!
5,375$
6,013
11,388$
Correct!
Correct!
12,000$
4,400
Analyze: The gross profit percentage is: 37.07%
Correct!
Sales
Less Accounts Receivable, January 1
Note 1: Computation of Sales
Subtotal
Accounts Receivable, December 31
Cash Receipts for year
Computations
Subtotal
Accounts Payable, December 31
Payments to Suppliers
Note 2: Computation of Purchases
Purchases
Less Accounts Payable, January 1
Depreciation Expense
Building
Equipment
Note 3: Computation of Depreciation Expense
Note 4: Computation of Repairs Expense
Less Interest on Owner's Investment
Total Charged to Interest Expense
Note 5: Computation of Interest Expense
page-pf3
689,000$
72,000$
435,000
507,000
82,000 425,000
264,000
80,500
25,200
31,000
21,120
8,000
9,000
22,900
12,000
4,400
12,000
18,500
3,500
28,500
276,620
(12,620)
15,000
2,380$
26,700$
33,000$
1,300$
48,500$
44,800$
39,200$
45,425$
2,100$
4,400$
8,000$
64,500$
12
d. Owed to merchandise suppliers January 1, 2013
Accounts Receivable December 31, 2013
a. Accounts Receivable January 1, 2013
capital investment; charged to Interest Expense
f. Cash withdrawn by owner to pay himself interest on
to Salary of Owner
e. Monthly salary paid to himself by owner; charged
Owed to merchandise suppliers December 31, 2013
Given Data P14.03A
Cost of beginning inventory
Cost of ending inventory
c. Beginning and ending inventory were valued at selling price
b. Accounts determined to be uncollectible on Dec. 31, 2013
h. Depreciation on assets was calculated at 8% of gross profit
the previous year. Charged to Income Tax of Owner.
g. Check to cover owner's personal income tax for
Estimated useful life in years
Original cost of equipment and fixtures
Additional Information
CORTEZ VIDEO CENTER
Income Statement
December 31, 2013
page-pf4
-
150,330$
25
-
6,100$
qualified estate appraiser.
j. The increase in land value was based on an appraisal by a
Repairs Expense
i. Paid for new parking lot on December 22; charged to
Salvage value
Estimated useful life in years
Cost of building
Salvage value
page-pf5
Student Name:
Class:
10,200$
16,000
2,060
31,900
60,160$
30,000$
6,000 24,000
34,000
4,000 30,000
54,000
114,160$
Correct!
16,450$
9,600
26,050$
14,400
40,450$
73,710
114,160$
Correct!
31,900
3,200
34,000
-
10,000
9,600
Problem 14.04A
McGraw-Hill
Instructor
Notes
Balance Sheet
December 31, 2013
THE ART HAVEN
page-pf6
6,000
4,000
page-pf7
13,400$
16,000
40,000
30,000
198,000
2,060
30,000
329,460$
16,450$
12,000
102,000
199,010
329,460$
31,900$
3,200$
34,000$
-$
Family Auto
Accounts Receivable
Cash
Given Data P14.04A
Supplies
Personal Residence
Equipment (cost)
Inventory
THE ART HAVEN
Balance Sheet
December 31, 2013
Purchase price
c. Truck not included on Balance Sheet
b. Amount of owner's personal cash included cash figure
Original cost of inventory
a. Inventory listed at today's cost
Down payment
Additional Information
Assets
Liabilities and Owner's Equity
Total Liabilities and Owner's Equity
Arthur Martin, Capital
Mortgage on House
Note Payable on Family Car
Accounts Payable
Total Assets

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.