You are a relatively recent hire to Hartz & Company, a local manufacturer of plumbing supply...

Transcribed Image Text:

You are a relatively recent hire to Hartz & Company, a local manufacturer of plumbing supply products. You have been asked to prepare a condensed statement of cash flows for the months of November and December of the current year for presentation to the company's management. 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. Short-term 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%. Interest on any outstanding short-term 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 long-term loan from the local bank. This loan, including interest (at 12% per year) for the month of November, is payable at the end of November. Required: Use the preceding information to prepare the cash budget for November and December. (Hint: The December 31 cash balance should be $50,480.) (Enter financing and interest payments as negative amounts.) equired: se the preceding information to prepare the cash budget for November and December. (Hint: The December 31 cash balance should $50,480.) (Enter financing and interest payments as negative amounts.) Hartz & Co. Cash Budget For November and December Cash balance, beginning November December $ 75,000 525,000 450,000 Total cash available 600,000 450,000 Cash disbursements, prior to financing 450,500 550,000 Add. Minimum cash balance 50,000 50,000 Total cash needed 500,500 600,000 Excess (deficiency of) cash, before financing effects Financing Short-term borrowing, beginning of month Repayments (long-term loan principal), end of month Cash interest, end of month Total effects of financing Ending cash balance - 0 0 $ 149,500 $ (100,000) You are a relatively recent hire to Hartz & Company, a local manufacturer of plumbing supply products. You have been asked to prepare a condensed statement of cash flows for the months of November and December of the current year for presentation to the company's management. 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. Short-term 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%. Interest on any outstanding short-term 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 long-term loan from the local bank. This loan, including interest (at 12% per year) for the month of November, is payable at the end of November. Required: Use the preceding information to prepare the cash budget for November and December. (Hint: The December 31 cash balance should be $50,480.) (Enter financing and interest payments as negative amounts.) equired: se the preceding information to prepare the cash budget for November and December. (Hint: The December 31 cash balance should $50,480.) (Enter financing and interest payments as negative amounts.) Hartz & Co. Cash Budget For November and December Cash balance, beginning November December $ 75,000 525,000 450,000 Total cash available 600,000 450,000 Cash disbursements, prior to financing 450,500 550,000 Add. Minimum cash balance 50,000 50,000 Total cash needed 500,500 600,000 Excess (deficiency of) cash, before financing effects Financing Short-term borrowing, beginning of month Repayments (long-term loan principal), end of month Cash interest, end of month Total effects of financing Ending cash balance - 0 0 $ 149,500 $ (100,000)