Cash Budget

Myer Whittworth owns the local hardware store, Whittworth's Hardware. Mr. Whittworth wants a cash budget showing expected cash receipts and disbursements for the month of September, and cash balance expected as of September 30, 20X5.

•Planned cash balance, August 31, 20X5: $100,000

•Customer receivables as of August 31: $530,000 total, $80,000 from July sales, $450,000 from August sales

•Accounts Payable, August 31: $460,000

•Merchandise purchases for September: $450,000, 40% paid in month of purchase, 60% paid in next month

•Payrolls due in September: $90,000

•Other expenses for September, payable in November: $7,500

•Bank note due September 15: $90,000 plus $7,200 interest

•Depreciation for September: $2,100

•Three-year insurance policy due September 10 for renewal: $1,500, to be paid in cash

•Sales for September: $1,000,000, half collected in month of sale, 40% in next month, 10% in third month

1)Prepare the cash budget for the month ending September 30, 20X5. Be sure to include a proper heading for Whittworth's Hardware.

2) Analyze Whittworth's Hardware cash budget created in 1). What are the A/R terms? What are the A/P terms? What impact do these terms have on the ending cash balance?