Terrel Manufacturing expects stable sales through the summer months of June, July, and August of $500,000 per month. The firm will make purchases of $350,000 per month during these months. Wages and salaries are estimated at $60,000 per month plus 7 percent of sales. The firm must make a principal and interest payment on an outstanding loan in June of $100,000. The firm plans a purchase of a fixed asset costing $75,000 in July. The second quarter tax payment of $20,000 is also due in June. All sales are for cash. Construct a cash budget for June, July, and August, assuming the firm has a beginning cash balance of $100,000 in June. The sales projections may not be accurate due to the lack of experience by a newly-hired sales manager. If the sales manager believes the most optimistic and pessimistic estimates of sales are $600,000 and $400,000, respectively, what are the monthly net cash flows and required financing or excess cash balances?
Terrel Manufacturing expects stable sales through the summer months of June, July, and August of $500,000 per month. The firm will make purchases of $350,000 per month during these months. Wages and salaries are estimated at $60,000 per month plus 7 percent of sales. The firm must make a principal and interest payment on an outstanding loan in June of $100,000. The firm plans a purchase of a fixed asset costing $75,000 in July. The second quarter tax payment of $20,000 is also due in June. All sales are for cash. Construct a cash budget for June, July, and August, assuming the firm has a beginning cash balance of $100,000 in June. The sales projections may not be accurate due to the lack of experience by a newly-hired sales manager. If the sales manager believes the most optimistic and pessimistic estimates of sales are $600,000 and $400,000, respectively, what are the monthly net cash flows and required financing or excess cash balances?
Chapter15: Managing Short-term Assets
Section: Chapter Questions
Problem 1PROB
Related questions
Question
Terrel Manufacturing expects stable sales through the summer months of June, July, and August of $500,000 per month. The firm will make purchases of $350,000 per month during these months. Wages and salaries are estimated at $60,000 per month plus 7 percent of sales. The firm must make a principal and interest payment on an outstanding loan in June of $100,000. The firm plans a purchase of a fixed asset costing $75,000 in July. The second quarter tax payment of $20,000 is also due in June. All sales are for cash.
- Construct a cash budget for June, July, and August, assuming the firm has a beginning cash balance of $100,000 in June.
- The sales projections may not be accurate due to the lack of experience by a newly-hired sales manager. If the sales manager believes the most optimistic and pessimistic estimates of sales are $600,000 and $400,000, respectively, what are the monthly net cash flows and required financing or excess cash balances?
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 with 3 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning