Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The first picture is the question and what is required, the second picture is what is needed to answer the question. Inc. has a 12/31

The first picture is the question and what is required, the second picture is what is needed to answer the question.
image text in transcribed
image text in transcribed
Inc. has a 12/31 fiscal year end. Provided below (on page 2) is the Adjusted Trial Balance for this company at 12/31/21. Prepare in good form in Excel, the following required fiscal yearend financial statements: multiple-step income statement; retained earnings statement; classified balance sheet. Work should be neat, well organized, accurate, and complete. REMINDER: In the stockholders' equity section of the balance sheet, the par value per share and the number of stock shares authorized, issued, and outstanding should be reported. Adjusted Trial Balance 31-Dec-21 Cash Petty Cash Accounts Receivable Allowance for doubtful accounts Notes receivable (due 10/31/22) Inventory Estimated Returns Inventory Supplies Prepaid Insurance Land Equipment Accumulated Depreciation Accounts Payable Salaries payable Customers refunds payable Income taxes payable Bonds payable, due 12/31/2030 Premium on bonds payable Common Stock, $2 par, 100,000 shares authorized Paid in capital in excess of par--Common Stock Treasury Stock--Common, 550 shares at cost Retained Earnings, 1/1/2021 Cash dividends Sales Cost of goods sold Selling expenses Administrative expenses Interest revenue Interest expense Income taxes expense 37,500 900 162,375 5,400 40,000 72,000 26,700 4,000 4,800 100,500 470,000 70,700 63,150 13,600 51,700 21,070 250,000 6,000 88,000 12,000 55,000 393,300 15,000 2,310,005 1,682,250 356,200 242,700 6,000 14,800 6,200 3.290.925 3.290.925

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

Principles Of Cost Accounting

Authors: Edward J. Vanderbeck

15th Edition

978-0840037039, 0840037031

More Books

Students also viewed these Accounting questions