Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following information is available from the accounting records of Christine's Company for the year ende January 31, 2019 Cost of goods sold................................. .... ........

image text in transcribed
The following information is available from the accounting records of Christine's Company for the year ende January 31, 2019 Cost of goods sold................................. .... ........ 4.500.000 Marketable securities ...... 600,000 Dividend declared and paid............. 25,000 Warranty payable......... 170,000 Bonds payable (matures 08/31/2028) 1,100,000 Merchandise inventory.... 608,000 Administrative expense...... 1,253,590 Dividend revenue .......... 60,000 Accounts receivables... 505,000 Accumulated depreciation-building... 550.000 Retained camnings.... 425,000 Payroll tax payable ..... 15.000 Income taxes ....... 46,410 Prepaid insurance... 17.000 Net Sales 7,445,000 Treasury stocks 91,000 Research and development expense........ 100,000 Interest payable .. 25,000 Common Stock. So.10 par value. 200,000 Loan payable ($70,000 due within the next year) 700,000 Interest expense.. 51,000 Cash 390,000 Land. 800,000 Allowance for bad debts. 70,000 Buildings... 1,600,000 Accounts payable... 440,000 Selling Expense. 1,393,000 Additional paid-in capital...... 780,000 Required: Use Microsoft Excel to prepare the following financial statements for Christine's Company: a. Multiple-step income statement for the year ended January 31, 2019 b. Statement of changes in stockholders' equity for the year ended January 31, 2019 c. Balance sheet as of January 31, 2019. INSTRUCTIONS: 4. This assignment must be completed in Excel. Handwritten work or late assignments will ne Attach your financial statements to this sheet in the order listed below Multiple-step Income Statement Statement of Changes in Stockholders' Equity Balance Sheet - Grading of this project will be based on: 1. Accuracy of your financial statements. 2. Use of formulas, neatness and formatting of your Excel financial statements OTE: new after aanh number or color your work

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

Accounting What the Numbers Mean

Authors: David Marshall, Wayne McManus, Daniel Viele

12th edition

007802529X, 1259969525, 978-1260565492

More Books

Students also viewed these Accounting questions