Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

You are a relatively recent hire to Hartz & Co., a local manufacturer of plumbing supply products. You have been asked to prepare a condensed

image text in transcribed You are a relatively recent hire to Hartz \& Co., 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 nanagement. 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 he end of each month. Cash receipts (from cash sales and collection of accounts receivable) are projected to be $520,000 for November and $443,000 for December. Cash disbursements (sales commissions, advertising, delivery expense, wages, utilities, etc.) orior to financing activity are scheduled to be $442,500 in November and $552,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 orincipal (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 ocal bank. This loan, including interest (at 12% per year) for the month of November, is payable at the end of November. Required: Jse the preceding information to prepare the cash budget for November and December. (Hint: The December 31 cash balance should be $50,420.) (Amounts to be deducted should be entered with a minus sign.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started