CommentaryHOW TO GO BROKE................WHILE MAKING A PROFIT1As the year started, Mr. Wily of the Wily Widget Company was on top of the world. His companymade, of course, widgets! Just what the customer wanted! Wily produced widgets for $0.75 each and soldthem for $1.00. In a given month, he produced enough widgets to satisfy the following month's expectedsales. He never wanted to "stock out" of widgets so that he could keep his customers happy. To takeadvantage of purchase discounts, he paid his raw materials suppliers during the month of production.Similarly, he paid his employees during the month they worked. In other words, Wily never had anyaccounts or wages payable. To meet competition, Wily billed his customers at the end of each month andgave them 30 days to pay. They paid right on time! Sales estimates had been very accurate. Salesforecasts were optimistic. Mr. Wily felt like this was his lucky year! He could finally take some time offand enjoy the fruits of his labor. The year began as follows (all dollar figures are in $1,000):January 1--CASH = $1,375; Receivables = $1,000; Inventory = $750 . Wily predicted $1,500 sales inFebruary and, just as expected in December, sold $1,000 in January. He collected on his December salesand paid his materials and labor expenses. For the month, he made a $250 tidy earnings-before-tax. ByFebruary 1, his books looked like this:February 1--CASH = $1,250; Receivables = $1,000; Inventory = $1,125. March sales were estimated at$2,000. Sales in February were right on target--$1,500. With a step-up in production to maintain a 30-dayinventory, he made 2,000 units at a cost of $1,500. All of January receivables were collected by the end ofFebruary. Profits so far, $625! Wily was very pleased!March 1--CASH = $750; Receivables = $1,500; Inventory = $1,500. March sales were just as expected,$2,000. April was expected to be even better--sales of $2,500. What a great business! Operating profitsfor the month, $500, for a total of $1,125.April 1--CASH = $375; Receivables = $2,000; Inventory = $1,875. May was expected to set new salesrecords--$3,000. Wily gave his sales manager a pat on the back. His customers were paying right on time.Production in April was adjusted to May's expected demand of $3,000. The month showed an EBT of$625 giving profits to date of $1,750. Mr. Wily took off for Hawaii feeling very good about life!May 1--CASH = $125; Receivables = $2,500; Inventory = $2,250. May sales were right on the estimate.Production was upped to meet June's expected sales of $3,500. The five-month operating profit totaled$2,500. Wily was surprised when his cellular phone woke him on the beach on June 1 with his accountantscreaming, "Help! Come Home! We need money!" Wily's success had caught up with him!June 1--CASH = $0; Receivables = $3,000; Inventory = $2,625. Wily caught the next plane for home andhollered for his banker!1 This teaching note was adapted from an article in Business Week by my colleague Ron Lease.1HOW TO GO BROKE................WHILE MAKING A PROFITCommentaryQuery: What is the moral of this story? The above analysis highlights the distinction between accounting profits and cash flows.Note the pleasing rise in assets, sales, and earnings-before tax. Looks great! Wily Widget is a real growth company! They make a product in highdemand. The profit margin is excellent ($1.00 - $0.75 = $0.25). Wiley pays bills promptly and its customers, in turn, pay Wiley promptly (30 daysnet). The company accurately forecasts sales and it maintains and adequate, but not excessive, inventory of 30 days. What could be better?However, rising sales and assets often implies liquidity problems even with inventory and accounts receivable management in control.What has happened to Mr. Wiley? As sales grow, accounts receivable are growing and, in order to maintain his inventory at 30 days, inventory mustgrow also. Although his sales forecasts are perfect and his profit margins are steady, he runs out of money. Why? Examine the following statements.WILEY WIDGET COMPANYBalance Sheet, Income Statement, and Cash Flow AnalysisDec. 31 Jan. 31 Feb. 28 Mar. 31 Apr. 30 May 31Cash $1,375$1,250$ 750 $ 375$ 125$ 0Accounts Receivable 1,000 1,000 1,500 2,000 2,500 3,000Inventory 750 1,12521,500 1,875 2,250 2,625Total Assets $3,125$3,375 $3,750$4,250$4,875 $5,625Sales$1,000$1,500 $2,000$2,500$3,000Cost of Goods Sold 750 1,125 1,500 1,875 2,250Earnings-Before-Tax $ 250$ 375$ 500 $ 625$ 750Cash Inflows$1,0003$1,000$1,500$2,000$2,500Cash Outflows 1,125 1,500 1,875 2,250 2,625Net Cash Flow($ 125) ($ 500)($ 375)($ 250) ($ 125)Jan. Feb.Mar.Apr. May Beginning Cash$1,375 $1,250$ 750$ 375 $ 125Net Cash Flow( 125) ( 500)( 375)( 250) ( 125)Ending Cash$1,250 $ 750$ 375$ 125 $ 0(You should be able to work through this example and replicate the above numbers while thinking about what is going on in this case!)In a nutshell, cash outflows exceed cash inflows. Cash is needed up front to fund growth. Wiley Widget captures one of the essential problems of4financial planning. It demonstrates the relationship among important asset accounts – cash, accounts receivable, and inventory. It indicates the needfor financial planning and it illustrates that a good sales forecast is not enough. We have to be able to use the forecast to develop a good plan ofaction and implement this plan. However, the plan cannot be developed in isolation from the rest of the business.The plan must integrate all aspects of the company’s operation. The production plans (capital expenditures and inventory), marketing plans (salesand credit policy), as well as external financing arrangements must all be included. All of these aspects are interrelated. The financial plan mustrecognize these interrelationships, which will be reflected in cash flows into and out of the business.The plan will show up as a set of projected income statements and balance sheets, but these will just be reflections of the plan. The plan will, in fact,be the set of policy decisions that the firm makes about operations and the implications of the decisions for our cash flows and funding needs. Oftenafter constructing a set of pro forma income statements and balance sheets the firm will decide that it must change some of the corporate policies.The projected financial statements will serve as