Edit Question 8 Please create a spreadsheet for the following question. You will need to...

90.2K

Verified Solution

Question

Accounting

image
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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students