a. Assuming that the firm has a cash balance of $23,000 at the beginning of November, determine the end-of-month cash balances for each month, November through April. b. Assuming that the firm wishes to maintain a $15,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April. c. If the firm were requesting a line of credit to cover needed financing for the period November to April, how large would this line have to be? Explain your answer.

Fundamentals Of Financial Management, Concise Edition (mindtap Course List)
10th Edition
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Eugene F. Brigham, Joel F. Houston
Chapter15: Working Capital Management
Section: Chapter Questions
Problem 10P: CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of...
icon
Related questions
icon
Concept explainers
Question
Cash budget-Advanced The actual sales and purchases for Xenocore, Inc., for September and October 2019, along with its forecast sales and purchases for the period
November 2019 through April 2020, follow. The firm makes 28% of all sales for cash and collects on 36% of its sales in each of the 2 months following the sale. Other
cash inflows are expected to be $11,000 in September and April, $13,000 in January and March, and $27,000 in February. The firm pays cash for 10% of its purchases. It
pays for 53% of its purchases in the following month and for 37% of its purchases 2 months later. Wages and salaries amount to 20% of the preceding month's sales. Rent of
$20,000 per month must be paid. Interest payments of $10,000 are due in January and April. A principal payment of $29,000 is also due in April. The firm expects to pay cash
dividends of $20,000 in January and April. Taxes of $79,000 are due in April. The firm also intends to make a $25,000 cash purchase of fixed assets in December.
a. Assuming that the firm has a cash balance of $23,000 at the beginning of November, determine the end-of-month cash balances for each month, November through April.
b. Assuming that the firm wishes to maintain a $15,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November
through April.
c. If the firm were requesting a line of credit to cover needed financing for the period November to April, how large would this line have to be? Explain your answer.
More info
(Click on the icon here
a spreadsheet.)
Year
2019
2019
2019
2019
2020
2020
2020
2020
in order to copy the contents of the data table below into
Month
September
October
November
December
January
February
March
April
Print
Sales
$213,000
250,000
174,000
161,000
142,000
180,000
205,000
254,000
Done
Purchases
$117,000
153,000
140,000
101,000
84,000
115,000
97,000
87,000
Transcribed Image Text:Cash budget-Advanced The actual sales and purchases for Xenocore, Inc., for September and October 2019, along with its forecast sales and purchases for the period November 2019 through April 2020, follow. The firm makes 28% of all sales for cash and collects on 36% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $11,000 in September and April, $13,000 in January and March, and $27,000 in February. The firm pays cash for 10% of its purchases. It pays for 53% of its purchases in the following month and for 37% of its purchases 2 months later. Wages and salaries amount to 20% of the preceding month's sales. Rent of $20,000 per month must be paid. Interest payments of $10,000 are due in January and April. A principal payment of $29,000 is also due in April. The firm expects to pay cash dividends of $20,000 in January and April. Taxes of $79,000 are due in April. The firm also intends to make a $25,000 cash purchase of fixed assets in December. a. Assuming that the firm has a cash balance of $23,000 at the beginning of November, determine the end-of-month cash balances for each month, November through April. b. Assuming that the firm wishes to maintain a $15,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April. c. If the firm were requesting a line of credit to cover needed financing for the period November to April, how large would this line have to be? Explain your answer. More info (Click on the icon here a spreadsheet.) Year 2019 2019 2019 2019 2020 2020 2020 2020 in order to copy the contents of the data table below into Month September October November December January February March April Print Sales $213,000 250,000 174,000 161,000 142,000 180,000 205,000 254,000 Done Purchases $117,000 153,000 140,000 101,000 84,000 115,000 97,000 87,000
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Budgeting
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,