Understanding Your Cash Conversion Cycle

by

For small businesses, cash flow is one of the most important determinants of business success.  There are many metrics used to monitor cash flow, one of which is the Cash Conversion Cycle (CCC). We coach all of our clients to track CCC as a key metric.

The CCC measures a company’s effectiveness at converting its investment in inventory into cash. The cycle typically involves purchasing inventory inputs on credit (Accounts Payable), selling the inventory through sales on credit (Accounts Receivable), and converting inventory back into cash. The lower the number of days in the CCC, the more effective management is at generating cash flow from the sale of its product or service.

How the Cash Conversion Cycle Is Calculated

The formula is comprised of three figures.
•    Number of “Days Inventory On Hand” (DIO)
•    Number of “Days Sales Ooutstanding” (see article on DSO here)
•    Number of “Days Payable Outstanding” (DPO)

The formula for calculating the Cash Conversion Cycle (CCC) is:

CCC = DIO + DSO – DPO

DIO, DSO and DPO represent the three component stages of the conversion cycle.  For a service company the cycle would only include the DSO and the DPO metrics.

Breaking It Down

Let’s look at each stage of the CCC to understand the relationships:

  1. The DIO stage measures the time (in days) required to turn over one complete inventory.  DIO can be calculated using figures taken from the annual financial statements; Inventory from the balance sheet and Cost of Sales from the income statement. It is calculated as:
    DIO = Inventory /Cost of Sales x 365
    The idea is to minimize the DIO by turning over inventory as quickly as possible. Selling inventory converts the owner’s investment in inventory into Accounts Receivable, or directly into Cash in the case of cash sales at a retail store.
  2. The DSO stage measures the number of days needed to collect the Accounts Receivable. Using the Accounts Receivable figure from the year-end balance sheet and the Net Credit Sales from the annual Income Statement, it is calculated as:
    DSO = Accounts Receivable/Net Credit Sales x 365
    Like DIO, a business owner wants to minimize DSO. DSO measures how quickly the business is able to convert a credit sale into cash.
  3. The DPO stage measures the number of days it takes to pay vendors for the inventory purchased or expenses incurred to deliver your product or services. Using the Accounts Payable figure from the year-end balance sheet and the Cost of Sales from the Annual Income statement, it is calculated as:
    DPO = Accounts Payable/Cost of Sales x 365
    In contrast to the DIO and DSO stages, business owners want to maximize DPO. A business improves its cash position by holding onto cash longer. Cash flow benefits, of course, must be carefully measured against a company’s payment terms with vendors.  Its important to maintain good relationships with your vendors because they help you grow your business.

The Cash Conversion Cycle metric is most useful in comparing a company’s cash flow performance this year against the performance in previous years, or against competitors’ performance.   By monitoring the trends of the CCC metric, you can spot potential cash flow issues before they become a crisis.

Want More Cash Flow? Check your Accounts Payable Cycle

by

Understanding the levers that drive your company’s cash flow can be the difference between staying in the game or closing up shop. A business can have positive net income, but still come up short of the cash it needs to keep the doors open.

One of those metrics that can cause a lack of cash is your accounts payable collection cycle. It’s one of the four key pillars that drive cash flow.

Accounts Payable Cycle

Some company’s vendors offer the ability to buy their products or services and pay them later. Offering this credit is like getting a short-term interest free loan from the vendor. As part of the deal, your vendor will want to get paid back based on the payment terms they offered. Understanding how long it takes for you to pay vendors is critical to your cash flow.

How do you measure it? Below is a formula that calculates your accounts payable days to pay cycle. Like the accounts receivable collection cycle, this calculation is based on a “snapshot in time” and you will want to monitor it on a regular basis such as monthly.

Formula:

Total expenses / 365 days= daily expenses
Accounts Payable / daily expenses= days to pay cycle

Example:
$900,000 / 365 days= $2,465 daily expenses
$50,000 / $2,465= 20 days to pay cycle

In the above example it takes approximately 20 days for the company to pay its expenses. Some expenses are probably paid upon receipt and other expenses may offer up to 30 days or more to pay. If this metric could be stretched from 20 days to 30 days the company would retain approximately $24,000 in its bank account. This could give it more time to collect accounts receivable from its customers and allow it the cushion it needs to pay bills on time and feel comfortable meeting its obligations.

How could it stretch the days without upsetting its vendors? A couple of strategies:

  • Ask vendors for longer payment terms
  • Use a company credit card to “time” the payment to a vendor. Most credit card providers give you up to 30 days after your statement ending date to pay the outstanding balance. Depending on the timing of your payment, this can add up to 30 to 45 days more time to pay.

Know your accounts payable payment cycle. Monitor it on a regular basis and look at strategies to extend it while working with your vendors to pay within the agreed-upon time. The right accounts payable payment cycle could be the difference between positive or negative cash flow!

Preserving Cash In Uncertain Times

by

I’ve been watching the news and talking with colleagues and clients and wanted to share some strategies with you for preserving cash that may come in handy.

1. Research refinance options for any high interest loans and ask for some or all of the closing costs to be waived.
2. The Small Business Administration has created a program to fast track low interest loans under its Economic Injury Disaster Loan, visit: www.sba.gov/disaster
3. Reach out to your lenders about deferring payments, or reducing to interest only payments, on debt.
4. Ask your landlord if you can pay rent at the end of the month (in arrears) for the next 90 days.
5. Ask your landlord about reducing or deferring Common Area Maintenance (CAM) charges for the next 90 days.
6. Call clients to see who can pay faster/earlier.
7. Call vendors to see if you can get extended terms or defer some portion of invoices to a later date. 8. Ask vendors to take payment on a company credit card.  Ask the vendor to charge the amount just after the credit card statement drop date.  This can defer a payment from 15-45 days if timed correctly.
9. Reach out to your credit card company to ask for reduced or zero interest for the next 90-120 days. 10. Bill customers as quickly as possible.
11. Consider whether you have any customers who might pay now for future delivery of services.
12. Defer your personal tax return filing and payment to July 15th.  The IRS issued a recent ruling that is allowing a delayed 2019 tax filing until this date.  However, if you are owed a refund, file your return now to get the funds.

Congress is in the process of an enacting special legislation called the “CARES Act” which is in the Senate at this time.

If you think of other ideas, I’d love to hear them!  My belief is that we will come out of this stronger and definitely together.  Scientists around the world will find the path through for our collective well-being.

Stay well!  And if you have any questions, concerns or just want someone to talk through your ideas, don’t hesitate to reach out.    Mike

Your Best Tool for Understanding Short-Term Cash Flow

by

In a recent article, I shared ideas on how to positively position your company’s financials, even during a slowing economy.  The key is to ensure you have strong cash stores and credit availability.

Today, I will explain a management tool that helps you anticipate your near-future cash flow and identify any areas of weakness: Presenting the 13-Week Cash Flow Analysis. 

You may already use software that allows you to run regular cash flow analyses. These give a more accurate picture than net profit or bank statements.

Initiate your 13-week cash flow analysis by gathering the data needed to build an accurate report:

  • Current bank account and credit card balances
  • Upcoming mortgage or lease payments
  • Estimated cash receipts
  • Estimated payroll and taxes
  • Estimated operating expenses
  • Any other upcoming transactions that will impact cash flow.

The integrity of the report is dependent on the accuracy of the data as well as it being correctly entered or integrated into a spreadsheet or software. For the variable revenue and expenses you estimate, be sure to keep seasonal influences in mind. And remember, you only need to record and predict 13 weeks out – it’s a short-term tool.

A report with solid data and estimates is a good indication of your cash situation over the next 3 months (or, one full quarter). But check the output against your gut:  If the balance seems overly positive in any or all of the 13 weeks, review your estimates, especially sales and accounts receivable forecasts. Being overly optimistic won’t serve you well – if anything, conservative estimates will give you the padding needed to accommodate unpredictable changes.  If you have the time, run worst-, best- and average-case scenarios.

If the report indicates that your company will be cash poor at points during the next 13 weeks, it’s time to review your options:

  • Do you have unneeded equipment or inventory that can be sold to improve fluidity?
  • Are there expenses that can be eliminated, contracts that can be renegotiated or even dissolved, or payments negotiated or delayed?
  • Is it time to implement a collections push?
  • Is your billing and collections process quick and accurate?
  • Are there any loans available to the business?

Once it is set up, maintaining cash flow history and projections is easy. Monitor and update the report weekly, and review your historical projections against actuals to improve your modeling accuracy.

Cash and cash flow are critical to successful operations, and utilizing 13-week cash flow analyses will help you identify gaps and become better at anticipating your future cash needs to keep your business steady. So make proactive cash flow analysis one part of your flexible, resilient business, whether the economy and your customer demand are swinging up, down, or somewhere in between.

Could Cash Flow Be the Problem?

by

by Collette Parker

Did you know that almost half of businesses have their best-ever year right before they file for bankruptcy? They grow right out of business, and usually it’s not because of lack of sales – it’s poor management of cash.

“They may have had their best year on paper, but when you look at cash flow and working capital’ it’s going south real fast,” says Mike Iverson, CPA, and CEO of Trillium Financial.

The old adage is true: you can’t manage what you don’t measure. And even if sales are good, if you have vendors and employees asking for money, and customers who don’t have to pay for another 45 days – it’s a perfect storm for a cash crisis.

“Take the time to do a financial business plan every year,” Iverson says. Not 30 pages, but a simple two-pager with a financial forecast and a budget for 12 months. “That will give small businesses a leg up from those businesses who don’t write this out.”

Visuals help. It’s not enough to just go through a plan in your head. The process of examining your business closely enough to work out a model and a 12 month plan helps you to understand the flow of your business, including issues of seasonality. If you plan cash flow properly you can figure out how much money you can have in hand when you go into manufacturing season, and how much you’ll make in the selling season. “You can’t just set a $12 million goal, and divide the revenue figures by 12 for the year,” says Iverson.

One financial management tool that is useful in managing cash is a 12-month trailing budget. Once January closes, look at the last 12 months (including January) and chart the revenue. Then look at December and the 12 months prior. Are the numbers higher or lower? Look at the graph. Is it flattening out? Going down? “Graphing a trailing 12 month budget is a simple visual tool,” says Iverson, “and can be used for both sales and expenses.”

“If your management team sees a graph instead of a bunch of numbers, they can understand the concept. Hopefully you’re spotting a positive trend. Either way, you can understand what your cash trends are, and then have a budget that is detailed enough to effectively plan for the year.”

When planning the budget for healthy cash flow, be mindful of how much is invested in your working capital, and keep track of three key areas:

1. Accounts Receivables – Unless you are a cash business, chances are you extend credit to your customers. If your terms are 30 days, your customers should pay you within 30 days, not longer. If you begin to see a trend where customers are waiting 45–60 days to pay, you will probably begin to see cash flow problems. Don’t be a free bank for your customers.

Look at ways to reduce the time it takes customers to pay you: ask for advances from customers, or a down payment, installment, or some level of prepaid portion of the sale. If you’re in the situation where you really need the cash now, you can work with a factoring firm for receivables, or the bank for a loan.

2. Accounts Payable – Have favorable credit terms and solid partnerships with your vendors. In this area, you want to hold on to your money as long as you can. But, if vendors offer early payment discounts and you can afford to take it, go ahead. Sometimes, even if you have to borrow the money to pay early, it might make sense to do so. If you can borrow money at eight percent and take a two percent discount for 10 days early (2% 10 net 30) you are effectively earning 36 percent over a year. (If you do that, make sure the borrowing doesn’t put you at risk for running out of cash and not being able to pay your other bills.)

3. Inventory – Manage your inventory so that it doesn’t sit in a warehouse for too long. Once you’ve paid for the inventory, it should be sold and generate profit for you. Adjust your inventory for the seasonality of your industry so you’re never caught with too much.

An example of good management of these three factors would be to extend 30 day terms to customers, purchase inventory and turn it around in 15 days; and pay vendors in 30 days.

Financial planning doesn’t have to be complicated to be effective. Measuring the past 12 months of working capital performance, income statement performance, sales growth and profit, will give you a really good picture of your business and let you prepare for future sustainable growth.

Cash Flow Statement: The Best Starting Point for Business Planning

by

by Michael Iverson

Check out this sample Cash flow statement for Acme Company

It’s my observation that most business owners review their financial statements in the following order:

  1. Income Statement
  2. Balance Sheet
  3. Statement of Cash Flow

Why is that so? Perhaps the most likely reason is that business owners borrow money. The lenders from whom they borrow focus on Income Statements and Balance Sheets, so those reports naturally become important to business owners.

However, when it comes to business planning and improving business results, I encourage clients to first look at the Statement of Cash Flow. As I’ve stated in previous articles, cash flow is often the most challenging metric for a small business to master. Balancing growth against the availability of cash is one of the most critical issues for a small business. Getting it wrong can put the business in peril.

Components of the Report

Unlike the Income Statement and the Balance Sheet, the Statement of Cash Flow is not based on accrual accounting. Rather, the report shows how a company generates cash and how its cash is spent. The concept of accrual accounting is matching the expense to the period when the obligation occurs or revenue to the period when it is earned. The cash flow statement is only concerned when a bill is paid or revenue is received.

The report has three component parts:  Cash Flow from Operating Activities; Cash Flow from Investing Activities; and Cash Flow from Financing Activities.

  1. Cash Flow from Operating Activities includes cash receipts from customers less amounts paid to suppliers and employees. The company in the example is generating healthy cash flow from its core operations.
  2. Cash Flow from Investing Activities shows a net cash outflow due to equipment purchases, which could be expected for a growing company.
  3. Cash Flow from Financing Activities is a large net cash inflow due to capital contributions and proceeds from a sizeable loan.

Check out this example for the ACME Company:  Cash flow statement

Improving Business Results
In the space of one year, the ACME Company in the example cash flow statement markedly improved its cash position. The beginning cash balance of $22,000 increased to $176,000 by year’s end.

During the same time span, the company invested in new equipment and replacement equipment. The new equipment might have been necessary for a new product line. The replacement equipment ensures against any unplanned disruption of existing production capacity. It appears that the company has prepared for continued growth over the next few years. With healthy cash flow from its core operations, the company is poised for growth opportunities.
Of course, there are risks involved with any new initiative or product introduction. Perhaps the new product line won’t do well which could put pressure on repaying the loan. To help mitigate those risks, setting aside cash as a reserve affords some breathing room if new initiatives don’t work out.

What is your Statement of Cash Flow telling you about your business? Have you achieved a cash position that provides a reasonable cushion for unforeseen events? If an incredible growth opportunity presented itself today, would you be able to act decisively?

If you would like to discuss how your business is positioned, contact us.  We’re glad to help you create and interpret your Cash Flow Statement.

Know the Real Flow of Money Through Your Business During a Year

by

by Collette Parker

Did you know that almost half of businesses have their best-ever year right before they file for bankruptcy? They grow right out of business, and usually it’s not because of lack of sales – it’s poor management of cash.

“They may have had their best year on paper, but when you look at cash flow and working capital it’s going south real fast,” says Mike Iverson, CPA, and CEO of Trillium Financial.

The old adage is true: you can’t manage what you don’t measure. And even if sales are good, if you have vendors and employees asking for money – but customers who don’t have to pay for another 45 days – it’s a perfect storm for a cash crisis.

“Take the time to do a financial business plan every year,” Iverson says. Not 30 pages, but a simple two-pager with a financial forecast and a budget for 12 months. “That will give small businesses a leg up from those businesses who don’t write this out.”

Visuals help. It’s not enough to just go through a plan in your head. The process of examining your business closely enough to work out a model and a 12-month plan helps you to understand the flow of your business, including issues of seasonality. If you plan cash flow properly you can figure out how much money you can have in hand when you go into manufacturing season, and how much you’ll make in selling season.

“You can’t just set a $12 million goal, and divide the revenue figures by 12 for the year,” says Iverson.

12-Month Trailing Budget

One financial management tool that is useful in managing cash is a 12-month trailing budget versus actual. Once January closes, look at the last 12 months (including January) and chart the revenue. Then look at December and the 12 months prior. Are the numbers higher or lower? Look at the graph. Is it flattening out? Going down?

“Graphing a trailing 12-month is a simple visual tool,” says Iverson, “and can be used for both sales and expenses. If your management team sees a graph instead of a bunch of numbers, they can understand the concept. Hopefully you’re spotting a positive trend. Either way, you can understand what your cash trends are, and then have a budget that is detailed enough to plan.”

Three Key Elements of Budgeting

When planning the budget for healthy cash flow, be mindful of how much is invested in your working capital, and keep track of three key areas:

  1. Accounts Receivables – Unless you are a cash business, chances are you extend credit to your customers. If your terms are 30 days, your customers should pay you within 30 days, not longer. If you begin to see a trend where customers are waiting 45–60 days to pay, you will probably begin to see cash flow problems. Don’t be a free bank for your customers. Look at ways to reduce the time it takes customers to pay you: ask for advances from customers, or a down payment, installment, or some level of prepaid portion of the sale. If you’re in the situation where you really need the cash now, you can work with a factoring firm for receivables, or the bank for a loan.
  2. Accounts Payable – Have favorable credit terms and solid partnerships with your vendors. In this area, you want to hold on to your money as long as you can. But, if vendors offer early payment discounts and you can afford to take it, go ahead. Sometimes, even if you have to borrow the money to pay early, it might make sense to do so. If you can borrow money at eight percent and take a two percent discount for 10 days early (2% 10 net 30), you are effectively earning 36 percent over a year. (If you do that, make sure the borrowing doesn’t put you at risk for running out of cash and not being able to pay your other bills.)
  3. Inventory – Manage your inventory so that it doesn’t sit in a warehouse for too long. Once you’ve paid for the inventory, it should be sold and generate profit for you. Adjust your inventory for the seasonality of your industry so you’re never caught with too much.

An example of good management of these three factors would be to extend 30-day terms to customers, purchase inventory and turn it around in 15 days; and pay vendors in 30 days.

If you would like to discuss more creative ways to manage cash flow, contact us.  We’re glad to share our ideas!