*Exercise 21-16 The controller of Trenshaw Company wants to improve the company\

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. $44,000 13,800 36,500 June 30, 2017, cash balance Dividends to be declared on July 15* Cash expenditures to be paid in July for operating expenses Amortization expense in July Cash collections to be received in July Merchandise purchases to be paid in cash in July Equipment to be purchased for cash in July 4,900 85,600 55,200 20,500 * 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 $27,000. (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. TRENSHAW COMPANY Cash Budget

Explanation / Answer

TRENSHAW COMPANY Cash Budget For the Month ended July 31,2017 Cash Balance at Beginning 44000 Add: Cash Collection during the Months 85600 Total Available Cash 129600 Less: Cash Expenses during the Month For Operating Expense 36500 For Merchandise Purchases 55200 For Equipment Purchases 20500 Total Cash Expenditure during the Month 112200 Excess Cash 17400 Add: Borrowing Taken 9600 (27000-17400) Cash Balance at End 27000 Note: Since the Dividend is declared, it will be paid in Aug, it is not taken above

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.