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

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter12: Balanced Scorecard And Other Performance Measures
Section: Chapter Questions
Problem 12MC: The cost of equity is _______. A. the interest associated with debt B. the rate of return required...
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning