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

Other questions asked by students

Physics
1.2K views

How does the center of mass velocity of the two objects which collide change during an...

Basic Math
1.2K views

Data for the mean mass of various animal species and their corresponding metabolic rate is provided...

General Management
1.2K views

What are creative ways that you can retain your first employee and ensure you are meeting...

Basic Math
1.2K views

K Solve for m F m p 2

Basic Math
1.2K views

Catherine throws a stone that moves through the air in a parabolic path due to...

Basic Math
1.2K views

A student scores 56 on a geography test and 264 on a mathematics test. The...

Statistics
1.2K views

Perine Company has 1 640 pounds of raw materials in its December 31 2019 ending...

Calculus
1.2K views

Use the graph given above to find the slope and equation for the line Give...

Accounting
1.2K views

4 points) Jardon Painting paints the interiors and exteriors of homes and commercial buildings. The...

Accounting
1.2K views

Samson Company aplica la contabilidad de revaluacin a los activos de la planta con un...

Accounting
1.2K views

The key to incorporate of a company is that: A. A company is it's human...

Accounting
1.2K views

Coastal Brewers manufactures fruit infused beers for local as well as international consumption. The Beer...