Edit Question 8 Please create a spreadsheet for the following question. You will need to...
90.2K
Verified Solution
Link Copied!
Question
Accounting
Edit Question 8 Please create a spreadsheet for the following question. You will need to save the spreadsheet on your computer and then upload/attach the file to this question. Selected financial statement information and additional data for Stanislaus Co. is presented below. Prepare a statement of cash flows for the year ending December 31, 2014 December 31 2013 2014 Cash $42,000 $65,000 Accounts receivable (net) 84,000 144,200 Inventory 168,000 206,600 Land 58,800 21,000 Equipment 504.000 588,000 TOTAL $856,800 $1.024.800 Accumulated depreciation $84,000 $115,600 Accounts payable 50,400 86,000 Notes payable - short-term 67,200 29,400 Notes payable - long-term 168,000 168,000 Common stock 420,000 420,000 Retained earnings 67 200 205.800 TOTAL $856 800 $1.024 800 Additional data for 2014 1. Net income was $220,200. 2 Depreciation was $31,600. 3 Land was sold at its original cost. 4. Dividends of $81,600 were paid. 5. Equipment was purchased for $84,000 cash
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!