Exercise 21-16 The controller of Trenshaw Company wants to improve the company’s

ID: 2542609 • Letter: E

Question

Exercise 21-16

The controller of Trenshaw Company wants to improve the company’s control system by preparing a month-by-month cash budget. The following information is for the month ending July 31, 2017.

*Dividends are payable 30 days after declaration to shareholders of record on the declaration date.

Trenshaw Company wants to keep a minimum cash balance of $25,400.

(a)

Prepare a cash budget for the month ended July 31, 2017, and indicate how much money, if any, Trenshaw Company will need to borrow to meet its minimum cash requirement.

June 30, 2017, cash balance $41,300 Dividends to be declared on July 15* 14,200 Cash expenditures to be paid in July for operating expenses 37,500 Amortization expense in July 4,400 Cash collections to be received in July 82,000 Merchandise purchases to be paid in cash in July 55,800 Equipment to be purchased for cash in July 20,900

Explanation / Answer

Answer

Beginning cash balance

$ 41,300.00

Add

Cash collections

$ 82,000.00

Total cash available

$ 1,23,300.00

Less:

Operating expenses

$ 37,500.00

Merchandise purchased

$ 55,800.00

Equipment purchased

$ 20,900.00

Total cash disbursement

$ 1,14,200.00

Excess of available cash over disbursement

$ 9,100.00

Add :

Borrowings

$ 16,300.00

Ending cash balance

$ 25,400.00