Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the trial balance on the provided excel workbook for your company Almost Done Corporation, calculate and present all 4 of the required financial statements:

image text in transcribed

Using the trial balance on the provided excel workbook for your company Almost Done

Corporation, calculate and present all 4 of the required financial statements: Balance sheet

showing 2011 and 2012 balances, Income statement for 2012, Statement of Stockholders Equity

for 2012, and the Statement of Cash Flows for 2012. ADC uses a calendar year end.

ALMOST DONE CORPORATION TRIAL BALANCE FY 11 AND FY 12 DR/(CR) DECEMBER 31 2012 DR/(CR) DECEMBER 31, 2011 (5,500,000) 5,000,000 (1,500,000) (4,000,000) 3,000,000 (1,250,000) (4,437,500) (200,000) (3,750,000) (120,000) 4,000,000 (13,000,000) (500,000) 15,000,000 ACCOUNTS PAYABLE (none related to Inventory) ACCOUNTS RECEIVABLE ACCRUED LIABILITIES ACCUMULATED AMORTIZATION ACCUMULATED DEPRECIATION ALLOWANCE FOR DOUBTFUL ACCOUNTS AMORTIZATION EXPENSE BAD DEBT EXPENSE CASH COMMON STOCK COST OF GOODS SOLD DEFERRED INCOME TAX LIABILITY DEPRECIATION EXPENSE EQUITY INVESTMENT INCOME FIXED ASSETS GAIN ON SALE OF ASSETS GENERAL EXPENSES INCOME FROM RENTAL PROPERTY INCOME TAX EXPENSE INCOME TAXES PAYABLE INSURANCE EXPENSE INTANGIBLES INTEREST EXPENSE INTEREST PAYABLE INVENTORY INVESTMENT IN NSC LONG-TERM PORTION OF NOTES PAYABLE OTHER ASSETS PREPAIDS RETAINED EARNINGS SALES SELLING EXPENSE SHORT TERM PORTION OF NOTES PAYABLE WAGES PAYABLE 80,000 13,155,000 (17,200,000) 36,000,000 (500,000) 1,812,500 (160,000) 13,250,000 (80,000) 2,000,000 (100,000) 2,123,000 (123,000) 1,000,000 12,000,000 1,140,000 (800,000) 12,000,000 6,000,000 1,120,000 (12,500,000) 350,000 600,000 (3,480,000) (50,000,000) 3,000,000 (2,250,000) (600,000) 7,000,000 1,000,000 (12,000,000) 250,000 400,000 (4,480,000) (2,250,000) (500,000) BALANCING CHECK FIGURE ALMOST DONE CORPORATION TRIAL BALANCE FY 11 AND FY 12 DR/(CR) DECEMBER 31 2012 DR/(CR) DECEMBER 31, 2011 (5,500,000) 5,000,000 (1,500,000) (4,000,000) 3,000,000 (1,250,000) (4,437,500) (200,000) (3,750,000) (120,000) 4,000,000 (13,000,000) (500,000) 15,000,000 ACCOUNTS PAYABLE (none related to Inventory) ACCOUNTS RECEIVABLE ACCRUED LIABILITIES ACCUMULATED AMORTIZATION ACCUMULATED DEPRECIATION ALLOWANCE FOR DOUBTFUL ACCOUNTS AMORTIZATION EXPENSE BAD DEBT EXPENSE CASH COMMON STOCK COST OF GOODS SOLD DEFERRED INCOME TAX LIABILITY DEPRECIATION EXPENSE EQUITY INVESTMENT INCOME FIXED ASSETS GAIN ON SALE OF ASSETS GENERAL EXPENSES INCOME FROM RENTAL PROPERTY INCOME TAX EXPENSE INCOME TAXES PAYABLE INSURANCE EXPENSE INTANGIBLES INTEREST EXPENSE INTEREST PAYABLE INVENTORY INVESTMENT IN NSC LONG-TERM PORTION OF NOTES PAYABLE OTHER ASSETS PREPAIDS RETAINED EARNINGS SALES SELLING EXPENSE SHORT TERM PORTION OF NOTES PAYABLE WAGES PAYABLE 80,000 13,155,000 (17,200,000) 36,000,000 (500,000) 1,812,500 (160,000) 13,250,000 (80,000) 2,000,000 (100,000) 2,123,000 (123,000) 1,000,000 12,000,000 1,140,000 (800,000) 12,000,000 6,000,000 1,120,000 (12,500,000) 350,000 600,000 (3,480,000) (50,000,000) 3,000,000 (2,250,000) (600,000) 7,000,000 1,000,000 (12,000,000) 250,000 400,000 (4,480,000) (2,250,000) (500,000) BALANCING CHECK FIGURE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of External Auditing

Authors: Brenda Porter, Jon Simon, David Hatherly

4th Edition

0470974451, 9780470974452

More Books

Students also viewed these Accounting questions

Question

Explain the multicultural organization development (MCOD) process.

Answered: 1 week ago