I JUST NEED HELP WITH QUESTION 2

CASH FLOW CONCERNS Three months ago Harding had prepared a cash flow forecast for the period October 1995 to May 1996. November through March is generally a slow period for the resort, and it is not unusual for the lodge to run cash deficits during most, if not all, of these months. However, the cash surplus generated during the peak period, from August through October, is typically sufficient to meet the shortfall. This is precisely what Harding had predicted would occur when he had made the cash budget projection in July. But now, in early October, he is having second thoughts about the forecast Three factors concern Harding. First, the renovations planned for January need to be more extensive than originally thought. Harding had estimated the cost to be $420,000, but it appears $500,000 of work is necessary. Second, the resort's long-time sales manager left unexpectedly in August and her replace ment does not seem to be as effective in obtaining convention business. Third, a recession has hit much of the area and Deerpark's sales are definitely sensi- tive to the state of the regional economy. All this suggests Harding's sales forecasts, which he had labeled "conservative" in July, are too high. "I can see indications of this now," he tells Purcell. "Revenue is off 10 percent for September and October, and our advance bookings for the rest of the year are also down. I'm sure we won't hit the levels we predicted." Harding has always been an advocate of cash budget forecasts and constantly revises an estimate in light of new information. There is no doubt a new projection is necessary. THIE ALTERNATIVES Wb. "What will you do in the event of a cash shortfall?" Purcell asks. Harding explains the options available. The resort could postpone or reduce the renovations, delay accounts payable, ask the owners for additional money, arrange a loan with the resort's bank, or use some combination of these options. There are problems with most of these alternatives, however. If the renova- tions are not made in January, sales will likely suffer in future months; the resort is showing signs of wear, and it is important to alter the hotel's decor periodi- cally. And, of course, the renovations are best made during an off-peak month like January. Further, the owners at a recent meeting had made it clear that it would be "extremely difficult, if not impossible for them to raise capital at this time. Nor is the prospect of a loan an appealing option. Relations with the bank have been strained since the resort nearly went bankrupt a few years ago, before Harding's arrival as manager. The bank, assuming it would grant a loan, is likely to impose severe restrictions on the operation of the resort. That would be interference that neither Harding nor the owners would welcome. Harding's most attractive option is to delay accounts payable with the other alternatives used if needed. He intends to call a meeting of all Deerpark's purveyors and explain the situation. CAPI L His strategy is to be completely open with the purveyors about Deerpark's financial plight and ask for a deferment of some, if not all, payments until April. In return he will promise to pay COD when business picks up. "They just might agree to this," he tells Purcell. "We've been a good customer, and it is in their interest to help us out. After all, it's not like we're in danger of bankruptcy. Reservations for next April through September are extremely strong, and we should be rolling in cash by early summer. In any event, we've got to do another forecast. I must know how bad the situation is. Do I ask them to post- pone 50 percent of what we purchase, 75 percent, 100 percent? I'm not even sure a complete deferment will be enough." Harding then asks Purcell to prepare a cash budget for October through March. He hands Purcell a revised estimate of sales (see Exhibit 1) and reminds Purcell that sales in September were $448,000. Typically, 70 percent of the resort's sales are paid in cash and 30 percent are paid using the resort's Deerpark Charge and collected in the month following the sale. Deerpark also incurs the following monthly expenses: mortgage, $50,000; utilities and maintenance, $70,000; and lease, rental, and miscellaneous expenses, $25,000. Property taxes of $107,000 are due in February, income taxes of $5,000 are due in December and March, and the renovations will be paid for in January. Exhibit 2 shows the resort's estimated payroll and purveyor expenses. Half of the purveyor expenses are paid one month after they are incurred and half in two months, Deerpark's required minimum cash balance at its bank is $100,000, and the current balance is $550,000. QUESTIONS 1. Should the resort's depreciation expense of $30,000 per month be consid- ered in your cash budget? Explain. 2. Prepare a cash budget for the period October through March. 3. Is there any advantage to extending the forecast through April and May? Explain. 4. Let's assume Deerpark's cash flow would not be sufficient to cover any shortfall occurring during the October-through-March period. What amount of payables must be deferred to get the resort through this period? 5. Harding in essence will be asking the firm's vendors for a loan. From Deerpark's point of view, the size of the loan is your answer to question 4. From the suppliers' point of view, however, the size of their investment in the loan is actually less than that amount. Explain why. (Hint: The price charged will reflect the suppliers' costs plus profit, and costs are the sum of fixed and variable costs). 6. Do Deerpark's purveyors have an incentive to cooperate? Explain. 7. If the purveyors are unable or unwilling to cooperate, how do you think Harding should proceed? 8. Which do you think is more likely to revise a cash budget: a firm like Deerpark or an electric utility? Explain. 9. What do you think is the most important variable in a cash budget forecast? Why? 10. Do you think that a cash budget is a more important financial tool for a small firm like Deerpark or a large firm like Exxon? Explain. CASE 15 DEERPARK 93 EXHIBIT 1 Sales Forecast: October-March Month Soles (000s) October 1995 November December January 1996 February March $609.5 370.3 257.4 178.2 202.4 288.2 Note: September sales were $448(000). EXHIBIT 2 Forecast of Payroll and Purveyor Expenses Month Payroll (000s) Purveyor (2008) 1633 120.7 112.2 October 1995 November December January 1996 February March 103.5 966 506 57.2 825 106.6 82.5 85.8 99.0 Note: Puuveyor expenses were $140(000) in August and $120,000) in September. QUESTIONS 1. Should the resort's depreciation expense of $30,000 per month be consid- ered in your cash budget? Explain. 2. Prepare a cash budget for the period October through March