Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please give an answer in excel, thanks. question

Please give an answer in excel, thanks. Question 6 (16 marks) (29 minutes)...

70.2K

Verified Solution

Question

Finance

image

Please give an answer in excel, thanks.

Question 6 (16 marks) (29 minutes) The following financial statements and information relate to White Inc. WHITE INC. Balance Sheet December 31 20x2 20x1 Assets Cash Accounts receivable Inventory Prepaid rent Property, plant and equipment Accumulated depreciation $ 9,000 50,000 15,000 2,500 950,000 (270,000) $ 756,500 $ 11,000 42,700 21,000 2,300 920,000 (225,000) $ 772,000 Liabilities and equity Accounts payable Salaries payable Bank loan payable Common stock Retained earnings $ 22,900 1,600 66,000 130,000 536,000 $ 756,500 $ 25,100 1,180 146,000 80,000 519,720 $ 772,000 WHITE INC. Income Statement year ended December 31, 20x2 Sales Cost of goods sold Other expenses Salary expense Depreciation expense Interest expense Loss on sale of equipment Net income $ 600,000 (195,000) (182,370) (90,000) (60,000) (3,350) (3,000) $ 66,280 Additional information The company sold equipment with an original cost of $20,000. The bank loan payable balance at Dec 31, 20x1 is due on Dec 31, 20x7. Required Prepare a statement of cash flow for the year ended December 31, 20x2. Show your supporting calculations

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!
Become a Member

Other questions asked by students

Q

1. Define res ipsa loquitur and discuss a specific case history example. Please provide the reference...

Medical Sciences
Q

1. Which organism is easier to grow in the laboratory, E. coli, or Neisseriae gonorrhea? 2. Describe...

Biology
Q

ANALYZING THE CORE TEACHING OF SOCRATES Socrates posed the following challenge to his fellow citizens: \"...are you...

Psychology
Q

If two identical charges are brought to within 35 m of each other experience an...

Physics
Q

Graph the following quadratic function.f(x) = 2x + 4x + 5Find the vertex of the...

Basic Math
Q

What is a bar graph What is a Pareto chart What is a bar graph...

Statistics
Q

Negative linear relationships are represented by values of the correlation r that are O greater...

Statistics
Q

The Cooper Company is considering investing in a recuperator. The recuperator will have an initial...

Accounting
Q

Cost Flow Methods The following three identical units of Item Alpha are purchased during April:...

Accounting
Q

I believe the last one is the correct answer but I'm not sure. Will leave...

Accounting
Q

Pique Corporation wants to purchase a new machine for $300,000. Management predicts that the machine...

Accounting
Q

Examine the dividend policy of Starbucks corporation and explain whether their dividend policy relates to...

Accounting