I need answers for ?The Tasks? 1, 2, 4, 6, 7, and 8 found on pp. 85 ? 86 in the attached cash budget assignment. Thanks!

79 CAPE CHEMICAL: CASH MANAGEMENT David Kunz, Southeast Missouri State University Benjamin L. Dow III, Southeast Missouri State University CASE DESCRIPTION The primary subject matter of this case concerns the development and use of a cash budget as a key component in a cash management system. The case also allows an examination of the difference between accounting profit (based on accrual accounting) versus cash flow. The case requires students to have an introductory knowledge of accounting, finance and general business issues, thus the case has a difficulty level of three (junior level) or higher. The case is designed to be taught in one class session of approximately 1.25 hours and is expected to require 3-4 hours of preparation time from the students. CASE SYNOPSIS Cape Chemical is a regional distributor of liquid and dry chemicals. Growth has been steady since its beginning, but cash to pay employees and vendors in a timely manner has frequently been a problem. While the company ended its last year with a healthy cash balance, there were many occasions during the year that it was necessary to delay vendor payments or obtain short-term bank loans in order to keep the company operating. On one occasion when a major vendor threatened to stop shipments until all outstanding balances were current and the bank credit was fully used, company credit cards were used to obtain $20,000 to pay (satisfy) the vendor. In an effort to resolve the cash problems, the company has developed a projected income statement, balance sheet and cash flow statement for the next year of operation. Cape Chemical's bank officer suggested the company prepare a monthly cash budget as another cash management tool and as an additional test of the adequacy of the current $200,000 line of credit. CAPE CHEMICAL BACKGROUND Cape Chemical is a relatively new, regional distributor of liquid and dry chemicals, headquartered in Cape Girardeau, Missouri. The company, founded by Ann Stewart, has been serving southeast Missouri, southern Illinois, northeast Arkansas, western Kentucky and northwest Tennessee for three years and has developed a reputation as a reliable supplier of industrial Journal of the International Academy for Case Studies, Volume 14, Number 7, 2008 80 chemicals. Stewart's previous business experience provided her with a solid understanding of the chemical industry and the distribution process. As a general manager for a chemical manufacturer Stewart had Profit & Loss (P&L) responsibility, but until beginning Cape Chemical she had limited exposure to company accounting and finance decisions. To improve management of the accounting and finance area, Stewart hired Kathy Ford, an accountant who had worked with the accounting firm that conducted Cape's first audit. Ford was hired near end of the second year of operation. CHEMICAL DISTRIBUTION A chemical distributor is a wholesaler. Operations may vary but a typical distributor purchases chemicals in large quantities (bulk - rail or truckloads) from a number of manufacturers. Bulk chemicals are stored in "tank farms", a number of tanks located in an area surrounded by dikes. Tanks can receive and ship materials from all modes of transportation. Packaged chemicals are stored in a warehouse. Other distributor activities include blending, repackaging, and shipping in smaller quantities (less than truckload, tote tanks, 55-gallon drums, and other smaller package sizes) to meet the needs of a variety of industrial users. In addition to the tank farm and warehouse, a distributor needs access to specialized delivery equipment (specialized truck transports, and tank rail cars) to meet the handling requirements of different chemicals. A distributor adds value by supplying its customers with the chemicals they need, in the quantities they desire, when they need them. This requires maintaining a sizable inventory and operating efficiently. Distributors usually operate on very small profit margins. THE SITUATION While the company ended its last year with a healthy cash balance, there were many occasions during the year that it was necessary to delay vendor payments or obtain short-term bank loans in order to keep the company operating. On one occasion when a major vendor threatened to stop shipments until all outstanding balances where current and the bank credit was fully used, Ann Stewart used her company credit cards to obtain $20,000 to pay (satisfy) the vendor. During the first three years of operations, the company operated with a sales forecast and a few operating budgets but a complete set of pro forma statements were not prepared. In an effort to resolve the cash problems, Stewart, with the help of Ford, developed a projected income statement, balance sheet and cash flow statement for the next year of operation (tables one, two and three). Ford thought the statements indicated the company's cash problems were solved. \"Look Ann, if our forecasts are correct, and our forecast should be accurate, since our assumptions were Journal of the International Academy for Case Studies, Volume 14, Number 7, 2008 81 based on historical data and current market conditions, we are in a very good financial position. We begin the year with a cash balance of $226,350 and our projections indicate an ending cash balance of $85,645, well above our target of a minimum balance of $20,000. The income statement projects our highest profit ever and while our ending cash balance is lower than our beginning cash balance, we will not have used any of the $200,000 bank line of credit. Our cash problems should be history.\" Stewart agreed the projected performance looks good, but she was still not ready to agree that cash problems were history. When Stewart and Ford were reviewing the projections with Cape Chemical's bank officer, he suggested the company prepare a monthly cash budget as another cash management tool and as an additional test of the adequacy of the current $200,000 line of credit. Stewart liked the idea. Later when Stewart and Ford discussed preparing a cash budget, Stewart indicated she had no experience in preparing or using a cash budget. Ford stated that she also had limited experience preparing and using a monthly cash budget but she thought it was similar to preparing forecasted financial statements. The big difference is that monthly rather than annual projections would be needed. The Ford stated the first step would be to prepare a list of monthly operating assumptions. ASSUMPTIONS The assumptions used to develop the pro forma financial statements were used by Stewart and Ford as a starting point. Historical information and current market conditions were also used in developing the cash budget assumptions. 1. A minimum $20,000 cash balance will be maintained. 2. The company has negotiated a $200,000 line of credit for short-term cash needs. Cash Inflows 3. Ford stated that the primary cash inflow will be the collection of accounts receivables. Projected revenue for the year is $6,000,000 and monthly sales forecasts were provided by the marketing department. Journal of the International Academy for Case Studies, Volume 14, Number 7, 2008 82 Revenue 2006 (actual) $ Revenue Revenue 2007 (projected) $ 2008 (projected) $ November 260,000 January 240,000 January 280,000 December 326,000 February 300,000 February 350,000 March 360,000 April 360,000 May 420,000 June 480,000 July 540,000 August 600,000 September 660,000 October 720,000 November 720,000 December 600,000 Total 4. 6,000,000 Ford indicated that last year receivables were collected as follows: % of sales Current Month 20.0 Month following the sale 50.0 Second month following the sale 30.0 Ford thought the new credit policy implemented by the new credit manager should allow an acceleration of collections in the coming year. The projected collection schedule for 2007 is: % of sales Current Month 25.0 Month following the sale 60.0 Second month following the sale 15.0 Journal of the International Academy for Case Studies, Volume 14, Number 7, 2008 83 Stewart suggested they use the 2007 collection assumptions for the cash budget. For example, 25% of January sales will be collected in January, 60% of January sales will be collected in February and 15% of January sales will be collected in March. Note: 15% of 2006 November sales and 60% of 2006 December sales will be collected in January and 15% of December 2006 sales will be collected during February. Ford stated there would a small amount of bad debts in 2007 but for planning purposes these would be ignored. Cash Outflows 5. The purchase of inventory represents the largest cash outflow. Inventory is typically purchased two months prior to expected sales and is paid in the month of purchase. Example, inventory for January sales would be purchased in November and paid for in November. Inventory for February sales would be purchased and paid for in December, etc. Cost of Goods Sold in 2007 were 76% of sales, assume that 2008 cost of goods sold will also be 76% of sales. 6. Annual plant operating expenses were projected to total $688,500. Ford suggested that these expenses be distributed equally over the twelve months. She stated that in some cases this was probably an over simplification but a reasonable assumption. Stewart agreed. Example: One twelfth, or $4,375, of the annual manager salary and benefits of $52,500 will be distributed monthly. Plant Operating Expenses Manager (salary and benefits) Employees (wages and benefits) Annual Expense $ 52,500 225,000 Lease Expense 72,000 Utilities Expense 12,000 Repairs & Maintenance Expense 6,000 Supplies Expense 9,000 Delivery Expense 120,000 Miscellaneous Expense Total 7. 12,000 688,500 Selling Expenses were projected at $301,500 for the year. Ford stated that most could be spread evenly over the twelve months. The exceptions would be Commissions and Promotion and Advertising. Commissions are paid in the month following the end of a quarter and will be allocated based on sales for the previous quarter. Example: ($30,000 * Journal of the International Academy for Case Studies, Volume 14, Number 7, 2008 84 first quarter sales/annual sales). The accounts payable on the 2006 year end balance sheet represents the fourth quarter 2006 commissions that will be paid in January of 2007. One fourth of the annual promotion and advertising expense will be spent during the first month of each quarter. Selling Expenses Annual Expense $ Sales Representatives 105,000 T&E 36,000 Commissions 30,000 Auto Expense 24,000 Internal Sales Representatives 52,500 Promotion and Advertising 54,000 Total 8. 301,500 Annual general administrative expenses will be treated the same as plant operating expenses. These expenses will be distributed equally over the twelve months. General Administrative Expenses Annual Expense $ Officer's Salaries 83,700 T&E 24,000 Auto Expense 12,000 Administrative Staff 52,500 Utility Expense 12,000 Office Supplies 12,000 Insurance 36,000 Legal & Professional 6,000 Miscellaneous 6,000 244,200 9. Annual interest expense is forecasted to total $90,000 and interest payments are made in the third month of each quarter. Again for simplicity purposes, Ford suggested the $90,000 be spread evenly over the four quarters. 10. Capital expenditures for the year include a $40,000 expansion to the warehouse and $20,000 for new drum filling equipment. The warehouse expansion is scheduled for April and the Journal of the International Academy for Case Studies, Volume 14, Number 7, 2008 85 equipment acquisition for June. Assume the expenditures are paid for in the month of their installation. The depreciation expense associated with the projects is included in $180,000 projected for the year. 11. Income taxes are expected to total $34,740 and payments are made quarterly with the first payment of 2007 taxes to be made in April. The $34,740 will be spread evenly over the four quarters. The taxes payable on the year end 2006 balance sheet will be paid in January of 2007. THE TASK Prepare answers to the following questions: 1. Construct a monthly cash budget for Cape Chemical for the period January through December 2007. Assume that all cash flows occur on the 15th of each month. Is the current $200,000 line of credit sufficient to meet the needs of Cape Chemical during the year? Explain your answer. 2. The cash budget contains both cash inflows and cash outflows. Which do you feel are likely to be the most accurate? Explain your answer. 3. Stewart thought it would be beneficial to prepare an additional cash budget based on the 2006 collection schedule (a less optimistic assumption). 2006 Collection Schedule % of sales Current Month 20.0 Month following the sale 50.0 Second month following the sale 30.0 Will the $200,000 revolving credit agreement be sufficient? Explain your answer. Note: Assume $39,000 of November and $195,600 of December revenue will be collected in January. Assume $48,900 of December revenues will be collected in February. 4. Why is depreciation expense not part of the cash budget? Journal of the International Academy for Case Studies, Volume 14, Number 7, 2008 86 5. The monthly cash budget prepared assumes that all cash flows occur on the 15th of each month. Suppose most of Cape Chemical's outflows are at the beginning of the month, while its collections are toward the end of each month. How would this fact alter the cash budget? 6. Temporary excess cash can be invested in marketable securities. What are the characteristics of marketable securities? If excess cash is projected to be continuing rather than temporary, are marketable securities the appropriate investment? Explain your answer. 7. Once again assume all cash flows occur on the 15th of each month. How large of a line of credit would you recommend Stewart and Ford arrange with the bank? Defend your answer. 8. Suppose the bank refused to grant a larger line of credit what options are available to the company? SUGGESTED REFERENCES Brigham, Eugene F., and Phillip R. Davis, Intermediate Financial Management, 9th Edition, South-Western/ Thompson Learning. Journal of the International Academy for Case Studies, Volume 14, Number 7, 2008 87 Table One: Cape Chemical Company Projected Income Statement (For the Year Ending December 31) 2007 $ Revenue 6,000,000 Cost of Goods Sold 4,560,000 Gross Profit Product 1,440,000 Plant Operating Expenses 508,500 Depreciation Expense 180,000 Total Plant Operating Expenses 688,500 Gross Profit 751,500 Selling Expenses 301,500 General & Administration Expenses 244,200 Total Selling & G&A Expenses Total Operating Expenses Earnings Before Interest & Taxes 545,700 1,234,200 205,800 Total Interest Expense 90,000 Earnings Before Taxes 115,800 Income Tax Expense 34,740 Net Income 81,060 Journal of the International Academy for Case Studies, Volume 14, Number 7, 2008 88 Table Two Cape Chemical Company Actual and Projected Balance Sheets (As of December 31) 2006 2007 $ $ Assets Current Assets Cash 226,350 85,645 Accounts Receivables 283,500 558,000 Inventory 410,400 478,800 920,250 1,122,445 Plant, Property and Equipment 900,000 960,000 Less Accumulated Depreciation 120,000 300,000 780,000 660,000 1,700,250 1,782,445 Accounts Payable 9,300 10,200 Income Taxes Payable 8,450 8,685 100,000 100,000 117,750 118,885 300,000 300,000 417,750 418,885 1,000,000 1,000,000 282,500 363,560 1,282,500 1,363,560 1,700,250 1,782,445 Total Current Assets Fixed Assets Net Plant, Property and Equipment Total Assets Liabilities and Equity Current Liabilities Short-term Note Total Current Liabilities Long-term Bank Loan Total liabilities Shareholders' Equity Paid in Capital Retained Earnings Total Shareholders' Equity Total Liabilities and Equity Journal of the International Academy for Case Studies, Volume 14, Number 7, 2008 89 Table Three Cape Chemical Company Projected Cash Flow Statement for 2007 (For the Year Ending December 31) 2007 $ Cash Flow from operating activities Net income 81,060 Sources (Uses) of Cash Depreciation 180,000 (Increase) Decrease in A/R (Increase) Decrease in inventories (274,500) (68,400) (Increase) Increase in A/P 900 (Increase) Taxes Payable 235 Net cash flow from operating activities (80,705) Long-term investment activities Acquisition of fixed assets Financing activities (60,000) 0 Increase in Short-term Bank Loan 0 Increase in Long-term Bank Loan 0 Issue of Common Stock 0 Net cash flow from financing activities 0 Net increase (decrease) in cash Cash at beginning of year Cash at end of year (140,705) 226,350 85,645 Journal of the International Academy for Case Studies, Volume 14, Number 7, 2008