Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need the exel part of this question please and Thank you! USE THE FOLLOWING INFORMATION TO ANSWER QUESTIONS 28 - 36: CROSS & ASSOCIATES

I need the exel part of this question please and Thank you! image text in transcribed
image text in transcribed
USE THE FOLLOWING INFORMATION TO ANSWER QUESTIONS 28 - 36: CROSS & ASSOCIATES COMPARATIVE BALANCE SHEET 12/31/2017 12/31/2018 *** CASH ACCOUNTS RECEIVABLE (NET). MERCHANDISE INVENTORY INVESTMENTS LAND EQUIPMENT ACCUMULATED DEPRECIATION $ 76,000 60,000 44,000 10,000 60,000 52,000 (18.000) $ 284,000 $ 95,000 40,000 62,000 59,000 40,000 80,000 (19.000) $ 357,000 ACCOUNTS PAYABLE. DIVIDENDS PAYABLE. MORTGAGE NOTE PAYABLE. COMMON STOCK, $5 PAR. PAID-IN CAPITAL IN EXCESS OF PAR-CS RETAINED EARNINGS. $ 15,000 7,000 25,000 100,000 42,000 95.000 $ 284,000 $ 26,000 8,000 19,000 130,000 64.000 110,000 $ 357.000 ADDITIONAL DATA FOR THE 2018 FISCAL YEAR: a. b. C d. Net Income was $25,000 Depreciation reported on the Income Statement was $10,000. Cash dividends declared were $10,000. Investments were purchased for cash. Land was sold for $35,000 Equipment with a book value of $3,000 (purchased @ $12K) was sold for $1,500. A mortgage note was paid in cash. Common stock was issued for cash. f. g h. CROSS & ASSOCIATES USES THE INDIRECT METHOD FOR CASH FLOW. E = = K48 A B G 1 (Write Up #1) D E Cross and Associates, Inc. 2 3 For the Year Ended 5 Cash Flows from Operating Activities 8 7 Plus: Non Cash Exp, Decr in CA, Inc. in CL, Loss oi 8 9 10 11 12 Less: Incr. in CA, Decr. In CL, Gain on Sale of FA 13 14 18 Net Cash Flow from Operating Activities 19 20 Cash Flows from Investing Activities 21 Plus: 22 24 Less: 25 26 Net Cash Flow from Investing Activities 27 28 Cash Flows from Financing Activities 29 Plus: 30 Less: 31 32 Net Cash Flow from Financing Activities 33 34 Total 35 36 37 38 39 40 41 Write Up #1

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

A Comprehensive Guide To Information Security Management And Audit

Authors: Rajkumar Banoth, Gugulothu Narsimha, Aruna Kranthi Godishala

1st Edition

ISBN: 1032344431, 978-1032344430

More Books

Students also viewed these Accounting questions