Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Multiple cash budgets-Scenario analysis Brownstein, Inc., expects sales of $102,000 during each of the next 3 months. It will make monthly purchases of $59,000 during
Multiple cash budgets-Scenario analysis Brownstein, Inc., expects sales of $102,000 during each of the next 3 months. It will make monthly purchases of $59,000 during this time. Wages and salaries are $16,000 per month plus 4% of sales. Brownstein expects to make a tax payment of $24,000 in the next month and a $17,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 $78,000 per month and the most optimistic is $120,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 1st Month Sale of asset Purchases $ Wages and salaries $ Taxes $ Purchase of fixed asset $ Net cash flow $ Add: Beginning cash $ Ending cash $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started