PICTURE PERFECT COMPARATIVE BALANCE SHEETS DECEMBER 31, Increase Additional Information: 2010 30,000 (Decrease) 110,000 (11,000) O (20,000) O ASSETS 2011 Cash $ 24 140,000 79,000 2$ Accounts receivable 90,000 2$ 2$ Inventory Prepaid Insurance 90,000 16,000 130,000 510,000 110,000 14,000 210,000 410,000 Land I Land costing $100,000 sold for $90,000 Building purchased for cash Building Accumulated Depreciation I (105,000) $4 (100,000) 764,000 Total Assets 860,000 Liabilities & Owners' Equity Accounts payable Income tax payable Notes payable, long-term Bonds payable $ 24 32,600 50,000 130,000 460,000 70,000 87,400 860,000 30,000 35,000 30,000 60,000 110,000 410,000 60,000 59,000 764,000 Payment of $10,000 made Bonds issued@par in exchange for land $50,000 Par value stock issued @ $60,000 $50,000 Par value stock issued @ $60,000 Dividends of $15,000 declared & paid F Common stock F Paid-in capital F Retained earnings F & O Total Liabilities& Owners' Equity $4 2$ PICTURE PERFECT INCOME STATEMENT For the Year Ended December 31, 2011 Sales Revenue $250,000 Expenses: Cost of goods sold Salary expense Depreciation expense Interest expense $90,000 49,000 5,000 * 13,000 11,000 10,000 * 28,600 24 Insurance expense Loss on sale of land Income tax expense Total expenses 206,600 Net Income 24 43,400

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Need help filling out this excel 

PICTURE PERFECT
COMPARATIVE BALANCE SHEETS
DECEMBER 31,
Increase
Additional Information:
2010
30,000
(Decrease)
110,000
(11,000) O
(20,000) O
ASSETS
2011
Cash
$
24
140,000
79,000
2$
Accounts receivable
90,000
2$
2$
Inventory
Prepaid Insurance
90,000
16,000
130,000
510,000
110,000
14,000
210,000
410,000
Land
I
Land costing $100,000 sold for $90,000
Building purchased for cash
Building
Accumulated Depreciation
I
(105,000)
$4
(100,000)
764,000
Total Assets
860,000
Liabilities & Owners' Equity
Accounts payable
Income tax payable
Notes payable, long-term
Bonds payable
$
24
32,600
50,000
130,000
460,000
70,000
87,400
860,000
30,000
35,000
30,000
60,000
110,000
410,000
60,000
59,000
764,000
Payment of $10,000 made
Bonds issued@par in exchange for land
$50,000 Par value stock issued @ $60,000
$50,000 Par value stock issued @ $60,000
Dividends of $15,000 declared & paid
F
Common stock
F
Paid-in capital
F
Retained earnings
F & O
Total Liabilities& Owners' Equity
$4
2$
PICTURE PERFECT
INCOME STATEMENT
For the Year Ended December 31, 2011
Sales Revenue
$250,000
Expenses:
Cost of goods sold
Salary expense
Depreciation expense
Interest expense
$90,000
49,000
5,000 *
13,000
11,000
10,000 *
28,600
24
Insurance expense
Loss on sale of land
Income tax expense
Total expenses
206,600
Net Income
24
43,400
Transcribed Image Text:PICTURE PERFECT COMPARATIVE BALANCE SHEETS DECEMBER 31, Increase Additional Information: 2010 30,000 (Decrease) 110,000 (11,000) O (20,000) O ASSETS 2011 Cash $ 24 140,000 79,000 2$ Accounts receivable 90,000 2$ 2$ Inventory Prepaid Insurance 90,000 16,000 130,000 510,000 110,000 14,000 210,000 410,000 Land I Land costing $100,000 sold for $90,000 Building purchased for cash Building Accumulated Depreciation I (105,000) $4 (100,000) 764,000 Total Assets 860,000 Liabilities & Owners' Equity Accounts payable Income tax payable Notes payable, long-term Bonds payable $ 24 32,600 50,000 130,000 460,000 70,000 87,400 860,000 30,000 35,000 30,000 60,000 110,000 410,000 60,000 59,000 764,000 Payment of $10,000 made Bonds issued@par in exchange for land $50,000 Par value stock issued @ $60,000 $50,000 Par value stock issued @ $60,000 Dividends of $15,000 declared & paid F Common stock F Paid-in capital F Retained earnings F & O Total Liabilities& Owners' Equity $4 2$ PICTURE PERFECT INCOME STATEMENT For the Year Ended December 31, 2011 Sales Revenue $250,000 Expenses: Cost of goods sold Salary expense Depreciation expense Interest expense $90,000 49,000 5,000 * 13,000 11,000 10,000 * 28,600 24 Insurance expense Loss on sale of land Income tax expense Total expenses 206,600 Net Income 24 43,400
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Rules, Regulations and Schedules
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education