Answered step by step
Verified Expert Solution
Link Copied!

Question

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 management. Assume the cash balance at November 1 will be $76,000. It is the company's policy to maintain a minimum cash balance of $55,000 at the end of each month. Cash receipts (from cash sales and collection of accounts receivable) are projected to be $524,000 for November and $455,000 for December. Cash disbursements (sales commissions, advertising, delivery expense, wages, utilities, etc.) prior to financing activity are scheduled to be $446,450 in November and $556,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 $55,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 $55,410.) (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 to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Financial Accounting For Decision Makers

Authors: Eddie McLaney, Peter Atrill

4th Edition

9780273688471

More Books

Students also viewed these Accounting questions