The controller of Trenshaw Company wants to improve the company’s control system

Question

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,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.

June 30, 2017, cash balance $45,000 Dividends to be declared on July 15* 12,000 Cash expenditures to be paid in July for operating expenses 40,800 Amortization expense in July 4,500 Cash collections to be received in July 90,000 Merchandise purchases to be paid in cash in July 56,200 Equipment to be purchased for cash in July 20,000

Explanation / Answer

Cash budget

July 31

Beginning cash balance

$    45,000.00

Cash Collections

$    90,000.00

Total cash available

$ 135,000.00

Less: Cash Disbursements

Cash Operating Expenses

$    40,800.00

Merchandise Purchase

$    56,200.00

Equipment purchase

$    20,000.00

Total cash Disbursements

$ 117,000.00

Excess of available cash over disbursements

$    18,000.00

Minimum Cash Balance

$    25,000.00

Borrowings required

$      7,000.00

Answer ---Borrowings required to maintain minimum balance is $7000.

Notes

1. Dividend is paid after 30 days of declaration it is declared in July but will be paid in august.

Cash budget

July 31

Beginning cash balance

$    45,000.00

Cash Collections

$    90,000.00

Total cash available

$ 135,000.00

Less: Cash Disbursements

Cash Operating Expenses

$    40,800.00

Merchandise Purchase

$    56,200.00

Equipment purchase

$    20,000.00

Total cash Disbursements

$ 117,000.00

Excess of available cash over disbursements

$    18,000.00

Minimum Cash Balance

$    25,000.00

Borrowings required

$      7,000.00

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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