I need help with questions 6,7,8,9 and 10. Thanks!

VTTAVIATIA SIIT H CASE 1 5 sido relatos DEERPARK CASH BUDGETING loth rado Dino "Slogan and wooooo o Wood solo bueno My instincts tell me that we could have cash flow problems sometime in the next six months, Patrick Harding the manager of Deerpark, a West Virginia resort, says to Lambert Purcell, the assistant manager. "I need to know now what we're dealing with and I think I'd better redo the forecast." sode vosodo A CASH FLOW CONCERNS bo lilor 0 0 Three months ago Harding had prepared a cash flow forecast for the period qum 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 OTO most, if not all, of these months. However, the cash surplus generated during 903 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 9 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. 1 0 PART III FINANCIAL PLANNING THE ALTERNATIVES Ti "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. 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 w 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 bat should be rolling in cash by early summer. In any event, we've got to do to another forecast. I must know how bad the situation is. Do I ask them to post- 10000 pone 50 percent of what we purchase, 75 percent, 100 percent? I'm not even sure d a complete deferment will be enough." Harding then asks Purcell to prepare a cash budget for October through 10 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. CASE 15 DEERPARK 91 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? ol o b 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. moho SOFTWARE QUESTION 11. Patrick Harding, the resort's manager, is convinced that the estimates used to develop the October-March cash budget are as accurate as he can make them. Thus, he intends to ask the resort's purveyors for an extension of $285,700. He intends to pay COD (cash on delivery) effective April and will use any surplus monthly cash to repay the purveyors. The purveyors have indicated in preliminary conversations that they are willing to cooperate. In order to help their planning, however, they would like Harding to estimate how much of the $285,700 will be paid in April, how much in May, etc. 92 PART II FINANCIAL PLANNING Harding was going to do this anyway, and has compiled the following sales estimates Salem April Mary July 520 615 August September 650 Past experience, though, indicates that actual sales could be as low as 90 of these estimates or as high as 1.1. He also expects purveyor expenses to equal between 24 and 28 of sales, p with a best-guess (most likely) estimate of .26. Past experience indicates that .70 of sales are paid in the month the sale is made, and .30 in the first month after the sale. Harding thinks, however, that come April the hotel's collection procedures may be relaxed a bit. He believes the historical .707.30 proportions are slightly optimistic. His best guess esti- mate is that .60 will be paid in the month of the sale, 30 in the following month, and .10 two months after the sale. A pessimistic scenario is proportions of .50/.407.10. 13 Harding decides to develop a cash budget for April-September for the fol- lowing scenarios in order to get an idea of how quickly he can repay the $285,700. n oldhathogromant SCENARIO So (Base-Case) Most Likelyt Worst- Case ot r oci Optimist 1.1 Sales, proportion of base-case estimate Proportion Collected in month=0 106 A608 in month + 1 in month + 2 10 Purveyor expenses/sales Note: All scenarios assume the purveyors are paid COD come April. The existing credit terms involve paying half one month after an expense is incurred and half in two months. For all scenarios, set "payroll expenses at 28 ot 26 Perform the appropriate analysis. When do these results suggest that the Purveyors will be repaid? Do these results suggest that Harding will need more than the $285,700 originally estimated? CASE 15 DEERPARK 93 EXHIBIT 1 Sales Forecast: October-March Monch Sales (000) October 1995 November December January 1996 February March S6095 370.3 257.4 178.2 2024 298.2 Note: September sales were $448(000). EXHIBIT 2 Forecast of Payroll and Purveyor Expenses Month Payroll (000s) Pueveyor (000s) October 1995 November December January 1996 February March 163.3 120.7 1122 82.5 85.8 99.0 103.5 96.6 506 572 82.5 105.6 Note: Purveyor expenses were $140(000) in August and $120(000) in September