Question

In: Computer Science

The owner of Aurora Inc., Cindy Hickey, has come to you, a public accountant, for advice. “I am very worried about my business right now. My bank ..

The owner of Aurora Inc., Cindy Hickey, has come to you, a public accountant, for advice. “I am very worried about my business right now. My bank loan is at its maximum level, we have no cash, and my salary is backing up, unpaid. I don’t know what has gone wrong, and what I can do about it. Please provide some advice!”

Hickey’s company, Aurora, manufactures and distributes small, specialized boating items that have a good reputation and a stable market among pleasure boaters and fishers. She has been in business for ten years. Cindy reports, “The company showed a profit again this year. I hired a new part-time manager during the year so I could spend less day-to-day time on the operation. He has been building up our asset base. We sold some investments, but made no new ones. We replaced some inefficient machinery, and purchased a vehicle to save on rental expenses.
“We sold old machinery that would not be able to meet the demand that our new manager is projecting. It had a cost of $9,600, and net book value of $3,800. I think the amount I took out of the company was in line with that of previous years, although my salary is backing up, unpaid. I can’t afford that, I can tell you, but the company has no money to pay me.
“Our cash has dropped and we now owe a lot on a demand bank loan. I have some financial information for the year (Exhibit 1).”

 

“Can you explain what is happening with our cash flows? What should I do to get out of this hole?”


Required:

Respond to Cindy’s request.

Solutions

Expert Solution

Overview

 

The owner of Aurora, Cindy Hickey, has requested advice on cash flow issues. Aurora seems to be a small company, with a profitable history, but is currently in a cash crunch. Users of the financial statements include the bank, as there is a current demand loan, the owner of the company, The statements are presumably used for tax purposes.

 

Issues

 

1.      CFS

2.      Advice on cash flow issues

 

Analysis and recommendations

 

1.      CFS

 

A useful first step would be to prepare a Statement of Cash Flows. See Exhibit 1.

 

Although Aurora had $12,000 in net earnings, cash flows from day-to-day, or operating, activities translates into an outflow of $1,200. This was due in part to the increase in accounts receivable and inventory. 

 

The company sold investments during the year, a source of cash, but spent $16,000 on machinery and $27,500 on a vehicle. As a result, investing activities represented a cash outflow of $26,300.

 

In the financing area, the bank loan provided $30,000 in cash, but $8,000 of dividends were paid. 

 

2.      Advice on cash flow issues

 

There is a buildup in accounts receivable and inventory. Cindy should review these accounts to ensure that the receivables are collectible and the net realizable value of the inventory is not less than its carrying amount. There is also a major reduction in accounts payable, not consistent with the inventory buildup. Why was payment made so quickly? Are there valid business reasons as to why these balances are increasing? Could the increases to the assets have anything to do with the new manager and his practice of building up the asset base? How do accounts receivable turnover and inventory turnover compare to past years? This is a potential problem area to investigate.

 

The company has liquidity problem, but still has $20,000 of investments. If these were liquidated, the bank loan could be reduced and the cash flow problem would be addressed. Are there reasons that the investments are still held? This is a solution to investigate.

 

Acquisition of long-term assets should generally not be not financed with cash and demand loans. Financing of the vehicle and machinery should have been through debt that more closely matches the lives of the assets. Why was the machinery and equipment financed in such a way?

 

It might be more efficient for the company to own a vehicle as opposed to renting one, but the financial flexibility of the company has suffered. Using $43,500 to immediately pay for the vehicle and machinery limits Aurora’s cash flow flexibility in the future. In particular, the company has not owned a vehicle in the past. Who is driving the vehicle – Cindy or the new manager? This is a major investment for a small company. Perhaps the vehicle should be sold and another one leased?

 

A review of the Retained Earnings account indicates that $8,000 was taken in dividends during the year. (Net earnings were $12,000, while retained earnings increased by $4,000, so the difference would be attributable to dividends.) While the amount taken out of the company may be in line with past years, it represents a significant drain on Aurora’s cash. 

 

Conclusion

 

Aurora has been profitable, as is demonstrated by the relatively high amount of retained earnings. However, the company will need cash in order for the business to remain viable. Cindy should examine various existing financial statement elements with a view to solving the immediate cash problem. Cindy should develop a cash budget to plan for future asset acquisitions. 

 

All these issues should be discussed in conjunction with the new manager because Aurora’s liquidity has deteriorated during the year.

Exhibit 1

 

Aurora Inc.

   

Statement of Cash Flow

   

for the year ended December 31, 20XX

   
     

Operating activities:

   

Net earnings

 

12,000 

Depreciation expense

 

9,200 

Loss on sale of machinery

 

2,200 

Gain on sale of investments

 

(3,600)

Increase in accounts receivable

 

(6,500)

Increase in inventory

 

(7,500)

Decrease in accounts payable

 

(10,100)

Increase in salaries payable

 

3,100 

Cash from operating activities

 

(1,200)

     

Investing activities:

   

Sale of investments

 

15,600 

Sale of machinery

 

1,600 

Acquisition of machinery

 

(16,000)

Acquisition of vehicle

 

(27,500)

Cash used in investing activities

 

(26,300)

     

Financing activities:

   

Increase in demand bank loan

 

30,000 

Payment of dividends

 

(8,000)

Cash from financing activities

 

22,000 

     

Decrease in cash

 

(5,500)

Opening cash

 

6,000 

Closing cash

 

500 

     

Supplemental disclosures:

   

Cash received for interest

 

1,200 

Cash paid for interest

 

(2,200)

Cash paid for income taxes

 

(2,750)

Supporting calculations:

Cost of investments sold

 

12,000 

Gain on sale

 

3,600 

Proceeds from sale

 

15,600 

 

Book value of machinery sold

3,800 

Loss on sale

 

(2,200)

Proceeds from sale

 

1,600 

 

Machinery

   

Beginning

 

24,000 

Cost of machinery sold

 

(9,600)

New machinery purchased

 

16,000 

Ending

 

30,400 

 

Retained earnings

   

Beginning

 

45,300 

Net earnings

 

12,000 

Dividends

 

8,000 

Ending

 

49,300 

 


Related Solutions

ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT