Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Required: Use the preceding information to prepare the cash budget for November and December. (Hint: The December 31 cash balance should be $60,430.) (Enter financing

image text in transcribedimage text in transcribed

Required: Use the preceding information to prepare the cash budget for November and December. (Hint: The December 31 cash balance should be $60,430.) (Enter financing and interest payments as negative amounts.) Answer is complete but not entirely correct. 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 $74,000. It is the company's policy to maintain a minimum cash balance of $60,000 at the end of each month. Cash receipts (from cash sales and collection of accounts receivable) are projected to be $516,000 for November and $462,000 for December. Cash disbursements (sales commissions, advertising, delivery expense, wages, utilities, etc.) prior to financing activity are scheduled to be $439,400 in November and $548,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 $60,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 $60,430.) (Enter financing and interest payments as negative amounts.)

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

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

Recommended Textbook for

Business Finance 101 Monopolies Accounting Audits And Blockchain

Authors: Louis Bevoc

1st Edition

1791808182, 978-1791808181

More Books

Students also viewed these Accounting questions

Question

Conduct an effective performance feedback session. page 360

Answered: 1 week ago