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:
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:
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Topic Video
Question
Karan
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.)
Cash balance, beginning
Add: Cash receipts
Total cash available
Hartz & Co.
Cash Budget
For November and December
Cash disbursements, prior to financing
Add: Minimum cash balance
Total cash needed
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
November
$
$
75,000
525,000
600,000
450,500
50,000
500,500
0
50,000
December
50,000
199,500 $
0
0
0
0
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education