Multiple cash budgets-Scenario analysis Brownstein, Inc., expects sales of $96,000 during each of the next 3 months. It will make monthly purchases of $58,000 during this time. Wages and salaries are $12,000 per month plus 6% of sales. Brownstein expects to make a tax payment of $17,000 in the next month and a $20,000 purchase of fixed assets in the second month and to receive $8,000 in cash from the sale of an asset in the third month. All sales and purchases are for cash. Beginning cash and the minimum cash balance are assumed to be zero. a. Construct a cash budget for the next 3 months. b. Brownstein is unsure of the sales levels, but all other figures are certain. If the most pessimistic sales figure is $77,000 per month and the most optimistic is $124,000 per month, what are the monthly minimum and maximum ending cash balances that the firm can expect for each of the 1-month periode? c. Briefly discuss how the financial manager can use the data in parts a. and b. to plan for financing needs. a. Construct a cash budget for the next 3 months. Complete the Brownstein, Inc.'s cash budget for the 1st month below: (Round to the nearest $000.) Brownstein, Inc. Cash Budget ($000) Most likely scenario Sales Sale of asset Purchases $ $ $ 1st Month
Multiple cash budgets-Scenario analysis Brownstein, Inc., expects sales of $96,000 during each of the next 3 months. It will make monthly purchases of $58,000 during this time. Wages and salaries are $12,000 per month plus 6% of sales. Brownstein expects to make a tax payment of $17,000 in the next month and a $20,000 purchase of fixed assets in the second month and to receive $8,000 in cash from the sale of an asset in the third month. All sales and purchases are for cash. Beginning cash and the minimum cash balance are assumed to be zero. a. Construct a cash budget for the next 3 months. b. Brownstein is unsure of the sales levels, but all other figures are certain. If the most pessimistic sales figure is $77,000 per month and the most optimistic is $124,000 per month, what are the monthly minimum and maximum ending cash balances that the firm can expect for each of the 1-month periode? c. Briefly discuss how the financial manager can use the data in parts a. and b. to plan for financing needs. a. Construct a cash budget for the next 3 months. Complete the Brownstein, Inc.'s cash budget for the 1st month below: (Round to the nearest $000.) Brownstein, Inc. Cash Budget ($000) Most likely scenario Sales Sale of asset Purchases $ $ $ 1st Month
Chapter6: Managing Cash Flow
Section: Chapter Questions
Problem 1EP
Related questions
Concept explainers
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Question
Transcribed Image Text:Multiple cash budgets-Scenario analysis Brownstein, Inc., expects sales of $96,000 during each of the next 3 months. It will make monthly purchases of $58,000
during this time. Wages and salaries are $12,000 per month plus 6% of sales. Brownstein expects to make a tax payment of $17,000 in the next month and a $20,000
purchase of fixed assets in the second month and to receive $8,000 in cash from the sale of an asset in the third month. All sales and purchases are for cash. Beginning
cash and the minimum cash balance are assumed to be zero.
a. Construct a cash budget for the next 3 months.
b. Brownstein is unsure of the sales levels, but all other figures are certain. If the most pessimistic sales figure is $77,000 per month and the most optimistic is $124,000
per month, what are the monthly minimum and maximum ending cash balances that the firm can expect for each of the 1-month periods?
c. Briefly discuss how the financial manager can use the data in parts a. and b. to plan for financing needs.
a. Construct a cash budget for the next 3 months.
Complete the Brownstein, Inc.'s cash budget for the 1st month below: (Round to the nearest $000.)
Brownstein, Inc.
Cash Budget ($000)
Most likely scenario
Sales
Sale of asset
Purchases
Wages and salaries
Taxes
Purchase of fixed asset
Net cash flow
Add: Beginning cash
Ending cash
$
$
$
$
$
$
$
$
$
1st Month
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 4 images
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
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning