You are a relatively recent hire to Hartz & Co., a local manufacturer of plumbing supply products. You have been asked to prepare, for a presentation to the company's management, a condensed cash-flow statement for the months of November and December 2010. Assume the cash balance at November 1 will be $75,000. It is the company's policy to maintain a minimum cash balance of $50,000 at the end of each month. Cash receipts (from cash sales and collection of accounts receivable) are projected to be $525,000 for November and $450,000 for December. Cash disbursements (sales commissions, advertising, delivery expense, wages, utilities, etc.) prior to financing activity are scheduled to be $450,500 in November and $550,000 in December. Borrowing, when needed, is done at the beginning of the month in increments of $1,000. The annual interest rate on any such loans is estimated to be 12 percent. Interest on any outstanding loans is paid in cash at the end of the month. Repayments of principal (if any) are assumed to occur at the end of the month. As of November 1, the company has a $50,000 short-term loan from the local bank. This loan is payable at the end of November.

Required

Use the preceding information to prepare the cash budget for November and December.

 

Cash balance, November 1st						$75,000
Minimum eom cash balance						$50,000
Budgeted cash receipts:
November						$525,000
December						$450,000
Budgeted cash disbursements:
November						$450,500
December						$550,000
Interest rate on borrowings						12.00%	per year
Short-term loan payable, as of November 1st						$50,000
Borrowings in increments of						$1,000