Dima, Inc., expects sales of US$100,000 during each of the next 3 months. It will make monthly purchases of US$60,000 during this time. Wages and salaries are US$10,000 per month plus 5 percent of sales. Dima expects to make a tax payment of US$20,000 in the next month and a US$15,000 purchase of fixed assets in the second month and to receive US$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. Dima is unsure of the sales levels, but all other figures are certain. If the most pessimistic sales figure is US$80,000 per month and the most optimistic is US$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.