Question

Ravenna Company is a merchandiser that uses the indirect method to prepare the operating activities section of its statement of cash flows. Its balance sheet for this year is as follows: Ending Balance Beginning Balance Cash $130,000 $156,500 Accounts receivable 102,000 110,000 Inventory 137,000 125,000 Total current assets 369,000 391,500 Property, plant, and equipment 360,000 350,000 Less accumulated depreciation 120,000 87,500 Net property, plant, and equipment 240,000 262,500 Total assets $609,000 $654,000 Accounts payable $80,000 $142,000 Income taxes payable 62,000 86,000 Bonds payable 150,000 125,000 Common stock 175,000 150,000 Retained earnings 142,000 151,000 Total liabilities and stockholders’ equity $609,000 $654,000 During the year, Ravenna paid a $15,000 cash dividend and it sold a piece of equipment for $7,500 that had originally cost $18,000 and had accumulated depreciation of $12,000. The company did not retire any bonds or repurchase any of its own common stock during the year.
What is the amount of the net increase or decrease in cash and cash equivalents that would be shown on the company’s statement of cash flows?

Answer 1

Answer:

Ravenna Company reports a Net Decrease in Cash and Cash Equivalents of $ 26,500 in Statement of Cash flows.

Explanation:  

                                                        Ravenna Company  

                                                    Statement of Cash flows  

 

Net Profit                                                                  $6,000  

Adjustment of Non Cash Expenses    

Depreciation                                                                  $20,500  

Gain on Sale of Equipment                                          $(1,500)

 

Working Capital Changes  

Increase in Inventory                                                   $(12,000)

Decrease in Accounts Receivables                          $8,000  

Decrease in Accounts Payables                                  $(62,000)

 

Net cash from operating activities                           $(41,000)

 

Cash flows from Investing Activities  

Proceeds from sale of equipment                           $7,500  

Purchase of Equipment                                                   $(28,000)

 

Net cash from investing activities                           $(20,500)

 

Cashflow from Financing Activities  

Proceeds from issue of shares                                   $25,000  

Proceeds from issue of Notes Payables                   $25,000  

Dividends paid                                                           $(15,000)

 

Net cash from Financing Activities                           $35,000  

 

Net decrease in cash and cash equivalents          $(26,500)

Opening cash and cash equivalents                          $156,500  

Closing cash and cash equivalents                           $130,000  

Please note that:

• figures in brackets represent negative figures
• complete solution is attached in excel file
• Operating Activities section of Statement of Cashflow begins by ''Net Profit before Taxes''. However, the question data does not provide any information on the amount of Tax charged during the year, so, 'Net Profit for the year' is used instead.

Download xlsx

Answer 2

Answer:

Net decrease is $26,000.

Explanation:

The net increase or decrease in cash flow can easily be calculated by subtracting the opening cash balance from closing cash balance. However, detail method of how it is calculated is given below.

Profit After Tax                                        $6,000                      

(142,000-151,000+15,000 (dividend))

Cash dividend                                         ($15,000)  

Account Receivable                                $ 8,000 (110,000-108,000)

Inventory                                                  ($12,000) (137,000-125,000)

Property, Plant and equipment               ($28,000)

(350,000-360,000-18,000)

Depreciation                                             $44,500

(120,000-87,500+12000)

Cash from Asset Sale                               $7,500

Profit on Asset Sale                                  ($1,500)    

(7,500-6000)        

Bond Payable                                           $25,000    (150,000-125,000)

Common Stock payable                          $25,000    (175,000-150,000)      

Income taxes payable                              ($24,000)  (62,000 - 86,000)

Accounts payable                                     ($62,000)  (80,000 -142,000)

Net decrease                                            ($26,000)