... P4-15 (similar to) Multiple cash budgetscenario analysis Brownston, Inc., expects sales of $100.000 during each of the next month will make monthly purchases $7.000 aring this time. Wege and we w 512.000 per months sales Brownistein expects to make a tax payment of $17.000 in the next month and a $18.000 purchase offresses in the second month and to receive 50.000 in cash from the sale of an asset in the third month Ales and purchase 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. Brownston is sure of the sales levels, but all other figures are certain. If the most pessimistic sales figure is $80.000 per month and the most optimistic is $120,000 per month, what are the monthly mun and maximum ending cash balances that the firm can expect for each of the month periods? c. Briefly discuss how the fnancial manager can use the data in parts and to plan for fnancing needs a. Construct a cash budget for the next 3 months Complete the Brownston, Inc.'s cash budget for the 1st month below. (Round to the nearest 8000) Brownstein, Inc. Cash Budget (5000) Most likely scenario 1st Month Sales $ Sale of asset $ Purchases $ Wages and salaries $ Taxes $ Purchase of fixed asset $ Net cash flow $ Add: Beginning cash $ Ending cash $ Enter any number in the edit fields and then click Check Answer. Check Answer Clear All parts remaining MacBook Pro