Cash Accounts receivable Allowance for bad debts Inventory Long term investment Property, plant, and equipment Accumulated depreciation Accounts payable Accrued payables Unearned revenues Other long term liability Bonds payable Discount on bonds payable Deferred income tax Preferred stock Common stock Additional paid-in capital Retained earnings Dividends Treasury stock Operating revenues Cost of goods sold Selling and administrative expenses Depreciation expense Other expense Bad debt expense Rent expense Interest expense Income tax expense Totals $ Dr 3,755,264 2,240,000 2,880,000 697,600 3,200,000 341,440 256,000 2,432,000 3,840,000 1,600,000 320,000 512,000 28,800 640,000 283,136 192,000 23,218,240 S Cr 35,200 1,280,000 524,800 384,000 512,000 341,696 3,200,000 204,544 3,200,000 320,000 3,520,000 1,920,000 7,776,000 23,218,240

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

can you help on the preperation of excel

  1. The income statement.
  2. The statement of retained earnings.
  3. The balance sheet.
  4. Ratios that can be calculated from the data presented.
Cash
Accounts receivable
Allowance for bad debts
Inventory
Long term investment
Property, plant, and equipment
Accumulated depreciation
Accounts payable
Accrued payables
Unearned revenues
Other long term liability
Bonds payable
Discount on bonds payable
Deferred income tax
Preferred stock
Common stock
Additional paid-in capital
Retained earnings
Dividends
Treasury stock
Operating revenues
Cost of goods sold
Selling and administrative expenses
Depreciation expense
Other expense
Bad debt expense
Rent expense
Interest expense
Income tax expense
Totals
$ Dr
3,755,264
2,240,000
2,880,000
697,600
3,200,000
341,440
256,000
2,432,000
3,840,000
1,600,000
320,000
512,000
28,800
640,000
283,136
192,000
23,218,240
$ Cr
35,200
1,280,000
524,800
384,000
512,000
341,696
3,200,000
204,544
3,200,000
320,000
3,520,000
1,920,000
7,776,000
23,218,240
Transcribed Image Text:Cash Accounts receivable Allowance for bad debts Inventory Long term investment Property, plant, and equipment Accumulated depreciation Accounts payable Accrued payables Unearned revenues Other long term liability Bonds payable Discount on bonds payable Deferred income tax Preferred stock Common stock Additional paid-in capital Retained earnings Dividends Treasury stock Operating revenues Cost of goods sold Selling and administrative expenses Depreciation expense Other expense Bad debt expense Rent expense Interest expense Income tax expense Totals $ Dr 3,755,264 2,240,000 2,880,000 697,600 3,200,000 341,440 256,000 2,432,000 3,840,000 1,600,000 320,000 512,000 28,800 640,000 283,136 192,000 23,218,240 $ Cr 35,200 1,280,000 524,800 384,000 512,000 341,696 3,200,000 204,544 3,200,000 320,000 3,520,000 1,920,000 7,776,000 23,218,240
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Investments and Financial instruments
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.
Similar questions
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