Chapter6 - Managing Cash Flow
Chapter6 - Managing Cash Flow
Chapter6 - Managing Cash Flow
Finance
PART 3
PLANNING FOR THE FUTURE
Chapter 6
Managing Cash Flow
Table of contents
Financial
0 Planning
throughout the 0 Surviving in the 0 Short-Term Cash-
Short Run Planning Tools
1 Venture’s Life
Cycle 2 3
organized and operating. During this stage, implementing a financial (accounting) system to measure and evaluate
performance is crucial. Using that system to monitor cash burn rates and liquidity ratios is particularly important as the
venture moves from the startup stage through its survival stage.
We begin Part 3 by focusing on managing cash flow and a venture’s cash conversion cycle. While we emphasize short-
term financial planning in Chapter 6, longer-term financial planning is also important and is the subject of Chapter 9.
Chapter 7 covers the types and costs of financial capital. Chapter 8 introduces securities law concepts and restrictions
that entrepreneurs must consider when obtaining venture financing.
01. FINANCIAL PLANNING THROUGHOUT THE VENTURE’S
LIFE CYCLE
The Importance of Cash
“Everything is about cash – raising it,
conserving it, collecting it.” ~ Guy Kawasaki
Common cause of business failure: Cash
crisis!
It is possible for a business to earn a profit
and still go out of business by running out of
cash.
Valley of death
12 - 6
Copyright © 2016 Pearson Education, Inc.
The Valley of Death
12 - 7
Copyright © 2016 Pearson Education, Inc.
Cash Management
● A business can be earning a profit and be forced
to close because it runs out of cash!
● American Express OPEN Small Business
Monitor study:
○ 57% of small business owners
experience problems with cash flow.
○ Their biggest cash flow concern is
the ability to pay bills on time.
Small Business Owner’s Rating of Their
Companies’ Cash Flow
Cash Management
● Cash management – forecasting, collecting,
disbursing, investing, and planning for the cash a
company needs to operate smoothly.
● Young and growing companies
are “cash sponges.”
● Know your company’s
cash flow cycle.
The Cash Flow Cycle
Deliver
Goods
Order Receive Pay Sell Send Customer
Goods Goods Invoice Goods* Invoice Pays**
14 25 178 3 9 50
Inventory
Leakage
The Cash Budget
● A “cash map” that shows the amount and the
timing of a firm's cash receipts and cash
disbursements over time.
● Predicts the amount of cash a company will need
to operate smoothly.
● Helps to visualize a company’s cash receipts and
cash disbursements and the resulting cash
balance.
02. SURVIVING IN THE SHORT RUN
By moving in and out of short-term lending arrangements, the cash manager can hedge the cash flow impacts of
predictable and unexpected swings in a firm’s operations. For such firms, the joy of unexpected success, which almost
invariably involves materials and labor outflows before collections, is not replaced by the panic of a cash crunch.
Unfortunately, young and growing entrepreneurial ventures seldom, if ever, have access to these markets and cash
management techniques. Consequently, for early-stage ventures in their development stage, startup stage, survival stage,
or just entering their rapid-growth stage, short-term planning is critical to surviving financially. A young venture—
restricted in its access to bank credit lines, limited in its access (if any) to short-term lending markets, and faced with
months of preparation and negotiation before the next financing round—can easily choke on its own success. For many
new ventures, getting from one cash injection to the next will be more challenging than designing, developing, and
manufacturing a new product.
02. SURVIVING IN THE SHORT RUN
One of the distinguishing features of entrepreneurial finance is that chronic cash requirements tend to be treated with
acute cash injections. In a very young venture, when there is frequently no visible source of cash, a founder’s initial
funds are conserved by changing diet, losing sleep (working longer), and forgoing a salary.
Cash conservation through these and other measures makes the descent from the initial cash peak relatively gentle. After
an intense phase of attempting to preserve ownership and control by avoiding fundraising, many ventures realize hat
resistance is futile and involves an unacceptably high risk of missing a window of opportunity.
For many startups, seeking funds from family, friends, and acquaintances is a first choice for external financing. This
initial external financing creates the next cash peak, but the new cash is frequently spent more rapidly as the venture
surrenders the notion of complete independence through internal funding. For a high-growth venture, the descents from
cash peaks remain steep until the venture is a prominent player in the targeted market. This can happen long after the
venture becomes a public company.
02. SURVIVING IN For an early-stage venture, when a cash fix (a vertical line pushing the venture up
THE SHORT RUN from zero) is sought during a panic, the venture is at a distinct bargaining
disadvantage.
The financial terms offered and accepted will reflect this. In addition, the cash panic
seriously detracts from the venture’s primary and more long-term goal of creating
value through product innovation, development, manufacturing, and sales. Avoiding
cash panics is the primary goal of cash planning; the primary tool is the cash budget,
which we introduce below by way of example.
03. SHORT-TERM CASH-PLANNING TOOLS
Pamela, Dharma, and Constance, upon completing their undergraduate degrees,
decided to start their own venture. They were able to acquire exclusive North
American distribution rights for a new type of interior wall paint product, New-Age
Paint, which emits a light fragrance when interior temperature changes and conveys a
subtle color alteration as the mix of lighting changes from primarily solar to primarily
incandescent (as a day matures).
One of several different fragrances can be embedded in the paint; each fragrance has
an expected useful life of five years with annual wipe-down of a “revitalizer.” Pamela,
Dharma, and Constance have formed the PDC Company to own the distribution
rights. The founders believe they have a unique new product that can introduce a
recurring revenue business model where none has previously existed.
03. SHORT-TERM CASH-PLANNING TOOLS
PDC inventories New-Age Paint that it plans to sell shortly after having received the paint. It is currently March 31,
2020, and the sales force has provided the following projected sales:
April $115,000
May $184,000
June $138,000
July $115,000
August $92,000
Task 1: Budget PDC’s cash and borrowing position for the next four months (through July 31).
Implementation Plan:
(a) Use the sales forecast to determine the monthly cash collections from the current month’s cash sales and collections of receivables
on the previous month’s credit sales,
(b) use the inventory policy to determine the inventory expenses and schedule for their payments,
(c) schedule the wages payments according to the semimonthly pay arrangements,
(d) put these items together with the other assumptions and determine cash needs before financing,
(e) complete the cash budget by determining the necessary borrowing and repayment provisions, including interest payments,
ensuring that $23,000 is available in the checking account.
Forecast Sales
Example:
12 - 25
Copyright © 2016 Pearson Education, Inc.
03. SHORT-TERM CASH-PLANNING TOOLS
In Part A, we first prepare a sales schedule for each month that includes the sales forecast and cash collections. Cash
sales are collected in the month the sales occur. Credit sales are collected in the month after the sales occur. For
example, in April, cash sales are expected to be 60 percent of $115,000, or $69,000. Accounts receivable of $36,800 at
the end of March (from credit sales made during March) are added to the $69,000 in expected April cash sales for total
collections of $105,800 expected in April.
03. SHORT-TERM CASH-PLANNING TOOLS
Next, in Part B, we prepare a purchase schedule for each month that includes estimating the amount of purchases and
the payment or disbursement of funds to pay for the purchases. Paint inventory on hand at the end of March was
$110,400 and represents the beginning inventory for April. Target ending inventory for April is $149,040.
Maximum cash need of $30,935 arrived in April. The need for financing to cover it lasted only for a
few months with scheduled retirement of all new financing by July. In many, if not most, cases, the
retirement of new financing will only be evident with additional months of financial projections .
04. PROJECTED MONTHLY FINANCIAL STATEMENTS
Another common way to express the venture’s anticipated cash needs is to project the
balance sheet and income statement into the future and produce a statement of cash flows.
This is easiest to do when we have already calculated the interest expenses for the four
months.
Task 2: Prepare PDC’s pro forma income statement for the four months.
Implementation Plan: Use the summaries of the revenue and expense items to create four
months of income statements that include the interest expenses determined in Task 1.
04. PROJECTED MONTHLY FINANCIAL STATEMENTS
Another common way to express the venture’s anticipated cash needs is to project the balance sheet and income
statement into the future and produce a statement of cash flows. This is easiest to do when we have already calculated
the interest expenses for the four months.
Task 3: Prepare PDC’s pro forma balance sheet for July 31.
Implementation Plan:
(a) Adjust the initial balance sheet, excluding the cash account, for each of the four months of changes;
(b) make sure the equity account reflects each month’s net income;
(c) calculate the cash account balance, which is consistent with total assets 5 total liabilities 1 equity;
(d) verify that the resulting cash account balance agrees with that from the cash budget. Table 6.4 presents the projected
balance sheets.
Task 4: Prepare PDC’s statements of cash flows for the four-month period.
Implementation Plan:
(a) Refer to our discussion of the construction of the statement of cash flows in Chapter 4 and the presentation of
cash flow statements in Chapter 5;
(b) apply the cash flow from operations, investing activities, and financing activities to the data for PDC;
(c) verify that the resulting ending cash flow agrees with the cash budget and the cash account balance on the pro
forma balance sheets.
Table 6.5 presents the projected statements of cash flows. Cash flows from operations are projected to be $24,035
in April. This amount, coupled with cash flows from investing activities of $6,900, produces a total cash shortage
of $30,935 before financing activities in April. However, the required loan of $30,935 in April is projected to be
paid off in full by July. In addition to repaying the loan, PDC will accumulate $6,487 in surplus cash beyond the
target balance of $23,000.
As a result of this exercise, you should be convinced of the following:
Indirectly projecting cash balances (or deficits) through pro forma balance sheets and
income statements (and using a statement of cash flows) gives the same answer as direct
calculation of receipts and disbursements (as long as you have included the correct
amount of interest expense).
In fact, the adjustments made in the cash flow statement are exactly those necessary to
calculate the net impact on the cash account.
Delays in receipts and disbursements from the associated accounting revenues and
expenses are incorporated through changes in the associated accounts in the cash flow
statement.
To finalize this insight, try the fastest method of communicating cash projections.
05. CASH PLANNING FROM A PROJECTED MONTHLY BALANCE
SHEET
Task 5: Calculate the change in the cash account balance in a spreadsheet that uses only the
beginning and ending balance sheets and net income.
Implementation Plan:
(a)Create a spreadsheet with the balance sheets for March 31 and July 31 as columns;
(b) find the difference of the values in the columns and adjust the sign to reflect the change in cash
flow, placing these signed differences in a third column;
(c) add the values in the third column to calculate the change in PDC’s cash position directly.
When projecting a venture forward into the future, there are several ways to complete the exercise.
If the planner is not particularly concerned with maintaining a strategic level of cash, he or she can
let the cash account take up the slack to balance the balance sheets.
If the venture has overspent, the balance will be negative at an amount representing the
minimum level of cash necessary to function according to projections (excluding financing costs
on the funds used to offset the negative balance). This balancing cash must come from
somewhere, and the cash balance should not really be thought of as negative (unless, perhaps, the
plan is to overdraw the venture’s checking account).
If the venture must strategically hold a certain amount of cash, it is better to project the cash
account to contain that strategic amount of cash and then formally modify an existing, or add a
new, liability to provide the balancing cash inflow (including the financing expenses).
If the planner balances by increasing the liability and the cash, he should not forget that the
increase in the liability is not usually a done deal. Most early-stage ventures have serious
difficulties locating debt arrangements.
06. CASH PLANNING FROM A PROJECTED MONTHLY BALANCE
SHEET
Conversion period ratios measure the average time in days required for noncash current assets and
selected current liabilities to create or demand cash. The faster assets can be converted into cash, the
greater is the venture’s liquidity, other things being equal. Of course, the faster liabilities transform
into cash demands, the less liquid the venture is. All of this comes together in a venture’s operating
cycle, which measures the time it takes to purchase raw materials, assemble a product, book the sale,
and collect on it. The operating cycle for a simple manufacturing venture is as shown in Figure 6.3.
The cash conversion cycle (C3) is the amount of time taken to buy materials and produce a finished
good (the inventory-to-sale conversion period) plus the time needed to collect sales made on credit
(sale-to-cash conversion period) minus the time taken to pay suppliers for purchases on credit (the
purchase-to-payment conversion period).
We return to Chapter 5’s Medical Products Company (MPC) to illustrate conversion period ratios and
the cash conversion cycle..
The “Big Three”
of Cash Management
Big Three:
1. Accounts receivable
2. Accounts payable
3. Inventory
The Big 3 interact to create a company’s cash
conversion cycle:
The length of time required to convert
inventory and accounts payable into sales
and accounts receivable and finally back
into cash.
12 - 47
Copyright © 2016 Pearson Education, Inc.
Amazon’s Cash
Conversion Cycle
12 - 48
Copyright © 2016 Pearson Education, Inc.
MEASURING CONVERSION TIMES
Inventory-to-Sale Conversion Period When a venture can decrease the amount of time between the cash outlay for
materials and labor and the production of a salable good, fewer dollars get tied up in production costs. With continuing
production, there will always be materials in inventory. The cost of inventories is a cost of doing business. For example,
if the venture keeps average materials and work-in-progress inventories of $175,000, this is $175,000 that must be
financed and cannot be used elsewhere.
The cash tied up in these inventories is a deadweight cost of doing business. Decreasing this cost
allows the cash to be utilized elsewhere (or paid back to creditors and investors).
The inventory-to-sale conversion period is calculated by dividing average inventories by the venture’s
average daily cost of goods sold.
If the cost of goods sold for an average day’s sales is $100 and we have $5,000 in inventories, we say
that the venture has fifty days of cost of goods sold in inventory. Put differently, the next dollar put
into inventories won’t be subtracted from inventories and added to cost of goods sold until fifty days
from now.
As we mentioned before, the average of the beginning and ending levels usually provides a more
stable measure for a rapidly growing enterprise. For MPC in 2019, the inventory-to-sale conversion
period was:
Sale-to-Cash Conversion Period
The sale-to-cash conversion period measures the average days of sales committed to the extension of trade
credit. Cash sales impose the least financial burden on a venture because the immediate receipt minimizes
the time gap between the sales inflow and the previous outflow for product materials and labor. Of course,
it is unlikely that a venture will be able to have all sales paid in cash. If, for instance, competitors extend
credit, the venture will find it difficult not to follow suit. The vast majority of ventures will have accounts
receivable.
The purchase-to-payment conversion period is calculated by dividing the sum of average payables and operations-
related accrued liabilities by the venture’s cost of goods sold per day.
Thus, MPC had almost seventy-seven days of the costs of production financed by
trade credit and accrued wages and liabilities.
Cash Conversion Cycle
The cash conversion cycle (also known as C3) indicates the average time it takes a venture to complete its operating cycle
less a deduction for the days supported by trade credit and delayed payroll financing. It is the number of days of operation
that must be externally financed. It also represents the time from a dollar outlay on raw materials to a dollar receipt on sales
(because it includes the delay in the payment of the dollar through the purchase-to-payment delay and the delay in receipt
through the sale-to-cash delay).
As a target, the typical venture should try to keep its C3 as close to zero as possible. This would indicate that production was
fully internally financed. The typical venture, however, will not accomplish financing neutral operations. The cash tied up in
inventory and receivables will almost always exceed the cash supplied by creditors and accrued liabilities.
INTERPRETING CHANGES IN CONVERSION TIMES
The inventory-to-sale conversion period increased by almost nine days between 2018 and 2019. The time
required to produce finished goods could have increased due to production bottlenecks (e.g., skilled labor
shortages, materials order delays, or quality problems), or MPC may have carried finished-goods
inventories for longer periods. A change in the venture’s product mix toward more complex and time-
consuming products could also account for the longer inventory conversion period. (Ratio analyses rarely
provide answers; they suggest questions that need answers.)
While it is normal for inventories to increase with sales, inventories that increase more rapidly than sales
saddle the venture with the need for added financial capital. For example, the average inventories account
balance was $82,500 [($70,000 + $95,000)/2] in 2018 and $117,500 [($95,000 +$140,000)/2] in 2019. This
represents an increase of 42.4 percent [($117,500 -82,500)/$82,500]. At the same time, the venture’s cost of
goods sold increased by 33.3 percent [($380,000 - $285,000)/$285,000].
If the inventories account had increased by the same rate as cost of goods sold, the
inventories account balance would have been only $110,000 ($82,500 * 1.333).
This breakout allows us to separate the actual change in the average inventories account
balance into the portion due to a change in cost of goods sold and the portion due to a longer
inventory-to-sale conversion period:
We also could have seen the impact of a longer inventory-to-sale conversion period by using the
inventory-to-sale conversion period formula. Here we use the “daily cost of goods sold” information for
2019 but solve for what the average inventories account balance would have been, had the conversion
period remained at 105.7 days. This is done as follows. Because
The result is that MPC, even after correcting for growth, is carrying an extra $7,500 in inventories in
2019. At a financing cost of, say, 10 percent, this is an extra $750 of lost profit before taxes.
sale-to-cash conversion period increased slightly (0.8 days) between 2018 and 2019. This indicates slightly slower
average payment practices by MPC’s customers. Even though this is a small change, some ongoing monitoring of the
sale-to-cash conversion period would be in order to assure that future increases do not go unnoticed and that remedial
action, if appropriate, is taken.7
The purchase-to-payment conversion period shows a decrease of slightly less than one day and increases MPC’s C3
(other things being equal). MPC has most likely been slightly increasing the speed at which it pays suppliers. Faster
payment to suppliers means a longer C3, other things being equal. Payables credit is a particularly important source of
financial capital for growing ventures, and securing longer credit terms is an added benefit that frequently justifies the
cost of searching. An analysis of changes in receivables and payables could have been conducted in the same way that
we analyzed the impact of a change in the inventory-to-sale conversion period.
Overall, the C3 has increased by almost nine days. The result is an increased burden on external financing. As we have
seen, the primary reason for the increase was a longer inventory-to-sale conversion period.
Cash shortages
● Shortages of cash results in
○ creditors being unpaid
○ legal action for recovery of debt
○ inability to purchase stocks
○ refusal to supply more credit
○ disruption to production
○ resultant loss of sales
○ labour unrest through inability to pay wages
○ business failure
Surplus cash
● Cash rich businesses often fail to take advantage of a
cash surplus
● Surplus cash can be
○ spent on stock
○ used to purchase fixed assets
○ deposited in an interest bearing account
○ invested in R&D
○ used to finance acquisitions
○ invested in new products
○ lent in tax efficient ways
Causes of cash flow problems
● Over-investment in fixed assets
● Overtrading - rapid expansion with insufficient working capital
● Poor credit control - excessive credit, late payment by debtors,
bad debt
● Suppliers wanting quick payment
● Stock piling - excessive investment in stock
● Seasonal variations in sales and cash flow
● Over borrowing at high interest rates
● Changing tastes - decline in sales
● Management error-poor planning
Solution: increase inflow
● Sell idle fixed assets
● Sale and leaseback
● Stimulate sales by price discount
● Improve debtor control – chase debtors
● Discounts for prompt customer payment
● Tighter credit control
● Debt factoring
● Raise more capital
● Arrange overdraft facilities
Solution: reduce outflow
● Lengthen supplier credit terms
● Postpone investment
● Reduce stock holding-adopt lean production techniques (e.g. JIT)
● Purchase stock on credit
● Ask trade creditors for extended credit
● Spread the cost of purchases - lease or hire purchase
● Negotiate rescheduling of debt payments
● Diversify to avoid seasonal variations in cash flow
● Improve planning, monitoring and control
Homework
- Question7 from the end of the chapter question
Thanks!
Any questions?