Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

With the numbers above Assignment Requirements: Prepare the 2020 financial statements using Excel, which includes: First, make an Income Statement (multi-step) Secondly, an Statement of

image text in transcribed

With the numbers above Assignment Requirements:

  1. Prepare the 2020 financial statements using Excel, which includes:
    1. First, make an Income Statement (multi-step)
    2. Secondly, an Statement of Stockholders Equity (NOT just Retained Earnings)
    3. Then, Make a Balance Sheet (classified; also show both the 2020 and 2019 numbers)
    4. Finally, the Statement of Cash Flow

These statements should be in proper form, including formatting.

Accounts Payable Accounts Receivable Accrued Liabilities Accumulated Depreciation - Buildings Accumulated Depreciation - Equipment Additional Paid in Capital Allowance for Doubtful Accounts Buildings Cash Common Stock, $1 Par Cost of Goods Sold Depreciation Expense Dividend Income Dividends Equipment Gain from Discontinued Operation, net of tax Gain on Sale of Equipment Goodwill Closing Trial Balance 70,500 90,000 154,500 45,000 16,500 243,000 3,000 180,000 123,000 27,000 135,000 Adjusted Trial Balance 68,500 104,000 196,000 51,000 18,000 256,500 4,500 220,500 148,500 28,500 585,000 19,500 1,500 45,000 148,000 87,500 3,000 60,000 25,000 12,000 12,500 4,000 133,000 24,000 45,000 15,000 135,000 10,000 93,500 66,000 1,184,000 31,500 372,000 60,000 Income Taxes 135,000 45,000 Insurance Expense Interest Expense Interest Income Inventory Investment in ABC Stock Land Loss from Discontinued Operation, net of tax Notes Payable (due in 4 years) Prepaid Rent Rent Expense Retained Earnings Sales Revenue Treasury Stock Wages Expense 150,000 7,500 66,000

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

Step: 3

blur-text-image

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

Sound Investing, Chapter 18 - Significant Accounting Policies And Changes In Them

Authors: Kate Mooney

3rd Edition

0071719407, 9780071719407

More Books

Students also viewed these Accounting questions

Question

What are the short- and long-term effects of stress on the body?

Answered: 1 week ago

Question

Why must in-service training or on-the-job education be continuing?

Answered: 1 week ago