Following are comparative balance sheets for Millco Inc. at January 31 and February 28, 2020:  MILLCO INC. Balance Sheets February 28 and January 31, 2020   February 28   January 31 Assets               Cash $ 29,400     $ 25,900   Accounts receivable   44,800       37,100   Merchandise inventory   56,700       65,800   Total current assets $ 130,900     $ 128,800   Plant and equipment:               Production equipment   116,200       106,400   Less: Accumulated depreciation   (16,800 )     (14,700 ) Total assets $ 230,300     $ 220,500   Liabilities               Accounts payable $ 25,900     $ 28,700   Short-term debt   30,800       30,800   Other accrued liabilities   14,700       16,800   Total current liabilities $ 71,400     $ 76,300   Long-term debt   23,100       32,200   Total liabilities $ 94,500     $ 108,500   Stockholders' Equity               Common stock, no par value, 28,000 shares authorized, 21,000 and 19,600 shares issued, respectively $ 72,800     $ 67,200   Retained earnings:               Beginning balance $ 44,800     $ 30,100   Net income for month   25,200       20,300   Dividends   (7,000 )     (5,600 ) Ending balance $ 63,000     $ 44,800   Total stockholders' equity $ 135,800     $ 112,000   Total liabilities and stockholders' equity $ 230,300     $ 220,500           Calculate the change that occurred in cash during the month. You may assume that the change in each balance sheet amount is due to a single event (for example, the change in the amount of production equipment is not the result of both a purchase and sale of equipment). Because the retained earnings section of the balance sheet is, in and of itself, an analysis of the change in the retained earnings account for the month, the row for net income and dividends should be entered as the February amount and not the change. Use the space to the right of the January 31 data to enter the difference between the February 28 and January 31 amounts of each balance sheet item. Show less         MILLCO INC. Balance Sheets January 31 and February 28, 2020   February 28 January 31 Change Assets       Cash $29,400 $25,900 3,500 Accounts receivable 44,800 37,100 7,700 Merchandise inventory 56,700 65,800 (9,100) Total current assets $130,900 $128,800   Plant and equipment:       Production equipment 116,200 106,400 9,800 Less: Accumulated depreciation (16,800) (14,700) (2,100) Total assets $230,300 $220,500           Liabilities       Accounts payable $25,900 $28,700 (2,800) Short-term debt 30,800 30,800 .00 Other accrued liabilities 14,700 16,800 (2,100) Total current liabilities $71,400 $76,300   Long-term debt 23,100 32,200 (9,100) Total liabilities $94,500 $108,500   Stockholders’ Equity       Common stock $72,800 $67,200 5,600 Retained earnings:       Beginning balance $44,800 $30,100   Net income for month 25,200 20,300 25,200 Dividends (7,000) (5,600) (7,000) Ending balance $63,000 $44,800   Total stockholders’ equity $135,800 $112,000   Total liabilities and stockholders’ equity   $220,500     Prepare a statement of cash flows that explains above changes?

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter16: Financial Statement Analysis
Section: Chapter Questions
Problem 4PB
icon
Related questions
icon
Concept explainers
Topic Video
Question

Following are comparative balance sheets for Millco Inc. at January 31 and February 28, 2020:
 

MILLCO INC.
Balance Sheets
February 28 and January 31, 2020
  February 28   January 31
Assets              
Cash $ 29,400     $ 25,900  
Accounts receivable   44,800       37,100  
Merchandise inventory   56,700       65,800  
Total current assets $ 130,900     $ 128,800  
Plant and equipment:              
Production equipment   116,200       106,400  
Less: Accumulated depreciation   (16,800 )     (14,700 )
Total assets $ 230,300     $ 220,500  
Liabilities              
Accounts payable $ 25,900     $ 28,700  
Short-term debt   30,800       30,800  
Other accrued liabilities   14,700       16,800  
Total current liabilities $ 71,400     $ 76,300  
Long-term debt   23,100       32,200  
Total liabilities $ 94,500     $ 108,500  
Stockholders' Equity              
Common stock, no par value, 28,000 shares authorized, 21,000 and 19,600 shares issued, respectively $ 72,800     $ 67,200  
Retained earnings:              
Beginning balance $ 44,800     $ 30,100  
Net income for month   25,200       20,300  
Dividends   (7,000 )     (5,600 )
Ending balance $ 63,000     $ 44,800  
Total stockholders' equity $ 135,800     $ 112,000  
Total liabilities and stockholders' equity $ 230,300     $ 220,500  
 

 

 

 

Calculate the change that occurred in cash during the month. You may assume that the change in each balance sheet amount is due to a single event (for example, the change in the amount of production equipment is not the result of both a purchase and sale of equipment). Because the retained earnings section of the balance sheet is, in and of itself, an analysis of the change in the retained earnings account for the month, the row for net income and dividends should be entered as the February amount and not the change. Use the space to the right of the January 31 data to enter the difference between the February 28 and January 31 amounts of each balance sheet item.

Show less
 
 
 
 
MILLCO INC.
Balance Sheets
January 31 and February 28, 2020
  February 28 January 31 Change
Assets      
Cash $29,400 $25,900 3,500
Accounts receivable 44,800 37,100 7,700
Merchandise inventory 56,700 65,800 (9,100)
Total current assets $130,900 $128,800  
Plant and equipment:      
Production equipment 116,200 106,400 9,800
Less: Accumulated depreciation (16,800) (14,700) (2,100)
Total assets $230,300 $220,500  
       
Liabilities      
Accounts payable $25,900 $28,700 (2,800)
Short-term debt 30,800 30,800 .00
Other accrued liabilities 14,700 16,800 (2,100)
Total current liabilities $71,400 $76,300  
Long-term debt 23,100 32,200 (9,100)
Total liabilities $94,500 $108,500  
Stockholders’ Equity      
Common stock $72,800 $67,200 5,600
Retained earnings:      
Beginning balance $44,800 $30,100  
Net income for month 25,200 20,300 25,200
Dividends (7,000) (5,600) (7,000)
Ending balance $63,000 $44,800  
Total stockholders’ equity $135,800 $112,000  
Total liabilities and stockholders’ equity   $220,500  
 
  • Prepare a statement of cash flows that explains above changes?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning