Make a two month cash budget for Martinez beginning in october.

CHAPTER 12 MANAGING CASH FLOW 459 You Be the Consultant In Search of a Cash Flow Forecast ril never make that mistake again, his banker, who had not a Douglas Martinez said to a lot of work to to. I've got a week to optimstk car. Martinez had just left a meeting with gether a cash budget to aupp apication. Ma been optimstk about the chances ot supply company getting the losn it needed prepared for the meetina. ho mut that consultant can hela me When he returned to his affice. Martinez gathered up the fe olders containng al of his fast- growng comroanys financial neports revenues ayd expenses using his computer caled the S8DC corsultant he had worked i should have been hetter tered, knowing that the could be angry only at himset Tat ard printed his projected ree af his consultant at the Smal Business Development Center iS8DCl was spreadsveet Tthent te right Bankers' primary concern when making kaans is cash fiwith when he was launchimg "At least I salvaged the meeting by teling him I was't ready ian. When he armived at the to afficialy apply for a loan yet," Martine thoughe. "But ve gotarted organizing the ima soffice that afternoon, they infarmstion, Here swhat they came up with Curent cash halance Sales pattern Colections of credit sales 58.7 71% on credit and 25% in cash 68% n the same month as the sale 19% in the first month after the sale 7% n the second month after the sale 6% new calectes ood debts) Sales forecasts Pessitmust Most Likely $18,750 July lactua) August factuall September factual) October November December January February March 17, 840 $17,500 $14,000 $14,000 $14,930 513,00 $9,900 $10,500 $13,500 $13,800 $19,900 $800 per month $1,200 per month 5317 per month Utiities expenses Truck loan The company's wages and salaries (induding payroll taxes) estimates are the following October November December lanuary February March 52,050 $1,725 $1,725 $1,950 $2,425 (continued)