American Express Business Class Logo
  • Videos
    Business Platinum Membership Rewards: Earn & Redeem
    1 min watch
    Business Platinum Travel Benefits
    1 min watch
    No Preset Spending Limit
    1 min watch
    Pay Over Time
    1 min watch
    Julie Pauly, The Able Baker, Maplewood, NJ
    3 min watch
    Articles
    How Using a Business Credit Card Can Help Your Small Business
    5 min read
    Safeguarding Security, Unlocking Innovation: Exploring The New Era In B2B Payments
    15 min read
    Getting More Back from What You Spend: Unlocking Value with Business Platinum
    4 min read
    Virtual Cards 101: What Is a Virtual Credit Card and Why Might You Need It?
    6 min read
    What Is a Business Line of Credit?
    12 min read
    Testimonials
    The Perfect Pairing: With American Express Business Blueprint™ and Resy, the Gourmet Brunch Potential is Bottomless
    9 min read
    Raising the Standard: How American Express Helps Power the Legacy of Electrolift Inc.
    10 min read
    How a Mother-Daughter Team Designed Their Dream Business with Help from American Express
    7 min read
    How Amex Business Products Helped Smart Birdy Take Flight
    5 min read
    Prescription for Progress: How Sree Gari Took His Pharmacy Further with Support from American Express
    6 min read
  • Cash Flow
    Accounting
    Critical Numbers
    Saving Money
    ROI
    Account Receivable Payable
    See All Cash Flow
    Financing
    Raising Capital
    Loans
    Alternative Financing
    Self-Financing
    Venture Capital
    See All Financing
    Growth Opportunities
    Business Expansion
    Innovation
    Franchising
    Partnerships
    Importing & Exporting
    See All Growth Opportunities
    Strategy
    Driving Business Efficiencies
    Product Development
    Business Plan
    See All Strategy
  • Celebs Talk Business
    Patti Labelle Talks Digital Transformation
    2 min watch
    Nick Offerman Talks Supply Chains
    3 min watch
    Patti Labelle Talks Expense Management
    2 min watch
    Nick Offerman Talks Spend Capacity
    3 min watch
    See All Celebs Talk Business
    Small Business Stories
    Pascal and Daneen Lewis, Harlem Wine Gallery, New York, NY
    3 min watch
    Julie Pauly, The Able Baker, Maplewood, NJ
    3 min watch
    Maria Christie, Christie’s Seafood & Steaks, Houston, TX
    7 min read
    Alex Magruder and Julia Schnabel, The Little, East Hampton, NY
    9 min read
    See All Small Business Stories
  • Small Business
    Membership Rewards
    1 min watch
    Employee Cards
    1 min watch
    Travel Benefits
    1 min watch
    No Preset Spending Limit
    1 min watch
    Pay Over Time
    1 min watch
    Corporate
    Common Business Expenses and the Credit Cards That Can Help You Manage Them
    5 min read
    What Is Corporate Travel Management and Why Do You Need It?
    8 min read
    Virtual Cards 101: What Is a Virtual Credit Card and Why Might You Need It?
    6 min read
    Product Videos
    Let’s Talk Business Travel: Airports
    1 min watch
    Let’s Talk Business Travel: Hotels
    1 min watch
    Employee Cards
    1 min watch
    Membership Rewards
    1 min watch
    Member Resources
    How to Engage With Online Communities
    7 min read
    Earning and Using Membership Rewards® Points with Business Platinum
    6 min read
    4 Ways to Optimize Corporate Travel Management
    5 min read
    How to Calculate Net Income
    6 min read
    American Express Membership Guide: Backing Your Business, Backing You
    6 min read
  • amexLogo
    • Getting More Back from What You Spend: Unlocking Value with Business Platinum

      1 min read
    • How Using a Business Credit Card Can Help Your Small Business

      5 min read
    • Business Platinum Travel Benefits

      4 min watch
    • Cash Flow
    • Financing
    • Growth Opportunities
    • Strategy
    • Celebs Talk Business
    • Small Business Stories
    • Earning and Using Membership Rewards® Points with Business Platinum

      6 min read
    • American Express Membership Guide: Backing Your Business, Backing You

      6 min watch
    • Let’s Talk Business Travel: Airports

      1 min watch
  • amexLogo
    • Getting More Back from What You Spend: Unlocking Value with Business Platinum

      1 min read
    • How Using a Business Credit Card Can Help Your Small Business

      5 min read
    • Business Platinum Travel Benefits

      4 min watch
    • Cash Flow
    • Financing
    • Growth Opportunities
    • Strategy
    • Celebs Talk Business
    • Small Business Stories
    • Earning and Using Membership Rewards® Points with Business Platinum

      6 min read
    • American Express Membership Guide: Backing Your Business, Backing You

      6 min watch
    • Let’s Talk Business Travel: Airports

      1 min watch

Cash Flow

How to Create Cash Flow Projections

How to Create Cash Flow Projections

Related Content

Loading...
Loading...
Loading...
Loading...
Summary
Email Icon
Facebook Icon
Twitter Icon
LinkedIn Icon

Learning how to create and use cash flow projections can help businesses take advantage of opportunities and sidestep misfortunes.

Mark Henricks American Express Business Class Freelance Contributor
August 27, 2020

      No business owner can be in business long without hearing “Cash is king” or “Cash is the lifeblood of a business.” Those sayings are rooted in the importance of cash flow projections. And, according to a recent survey of small-business owners’ experiences with cash flow, there are some worrisome statistics behind these ominous-sounding axioms. 

      In the Quickbooks 2019 State of Small Business Cash Flow report, 69 percent of respondents said "they have been kept up at night by ongoing concerns about their cash flow status." Furthermore 61 percent of respondents "struggle with cash flow" and 32 percent "are unable to either pay vendors, pay back pending loans, or pay themselves or their employees due to cash flow issues." (The study was based on 3,000 owners of companies with 100 or fewer employees. They were polled in the United States, United Kingdom, Australia, Canada and India in fall 2018.) 

      The solution isn’t necessarily making more accurate profit projections, says Rob Stephens, the founder of CFO Perspective, a small business financial consulting firm in Spokane Valley, Washington.

      Instead, it’s about making better cash flow projections.

      “Profit projections answer, ‘How much will I earn?’” Stephens, a CPA and former banker, explains. “Cash flow projections answer, 'When will I have the cash I need to make those profits?’ and ‘Where will I get that cash?’”

      Businesses use cash flow forecasts to track sources and timing as cash moves through a business, explains Levar Haffoney, managing principal of Vedere Consulting Group, a small business consulting firm in New York City.

      “Cash flow projections are used to predict the cash coming in and going out of their business,” he says. “They allow you to plan for variances and adjust accordingly.”

      The variances keeping business owners up at night are when there isn’t enough cash to pay bills, observes Karen Papazian, founder of  K Buildz Consulting in Los Angeles.

      “Small businesses are forecasting to make sure there are no periods where the cash expense total is higher than the forecasted revenue,” she says. 

      If a business owner has advance warning of a pending cash crunch, corrective action can be taken, Stephens points out. Effective solutions for cash shortages include pre-arranging for additional cash from sources such as bank loans, credit lines, cash advances from customers and extended terms from suppliers.

      “If your projected cash sources failed to materialize, do you have alternative sources you can tap to keep your business running at its potential?” Stephens asks. A worrisome cash flow forecast can move this question to the top of a business owner’s concerns.

      A robust cash flow projection, on the other hand, may cue a business owner to search for upcoming opportunities. These may include acquisitions, expansions and new hires. Excess cash can also be reinvested or distributed as income.

      So how does one do a cash flow projection?

      1. Find starting cash balance.

      The cash flow projection begins with the amount of cash in your business checking account. If additional cash is available in the form of cash or checks not yet deposited, include that as well. The starting cash balance includes all available cash, whether it came from sales revenue, loans or other sources. 

      2. Estimate cash in.

      The next part of preparing a cash flow projection consists of estimating future revenues.

      “By taking into consideration the business' invoicing cycle, frequency and terms, the company can predict when cash will be received and deposited,” Papazian says.  

      Cash flow projections should be done at a high level at least quarterly if you don't anticipate any cash flow constraints. Prepare cash flow projections monthly or weekly as cash becomes more of an issue.

      —Rob Stephens, founder, CFO Perspective

      To do the revenue part of a cash flow forecast, many business owners focus carefully on when they can expect credit card payments to process. Other considerations depend on the business, and may include processing fees and seasonal income fluctuations.

      Businesses can estimate when cash will arrive by examining customers' past payment history. A customer that normally pays within 30 days is likely to continue doing that.

      Business owners can affect how much cash will come in by offering customers discounts for faster payment. They can also increase cash flow by taking out loans and transferring the owner's personal money to the business. 

      3. Estimate cash out.

      After identifying how much cash is coming and when it will arrive, cash flow projections look for similar insight on expenses. Business owners do this by crafting estimates for fixed costs such as rent, utilities, taxes and loans based on past bills. Variable expenses such as payroll, supplies and materials can be estimated by projecting sales and then extrapolating the amount of labor and other constituents required to produce the needed goods and services. 

      “Payroll and rent are the two largest and most common expenses that require cash to be available on specific due dates,” Papazian says. Payroll taxes for Social Security and Medicare need to be factored in as well as salaries and wages, she notes.

      Insurance premiums for health, liability, auto, worker’s compensation and unemployment coverage are also expenses that must be paid in cash by a certain date, Papazian says. Similarly, payments on existing loans, credit cards, credit lines, mortgages, equipment leases and the like similarly demand precisely timed outflows of cash.

      Just as not all businesses will have these expenses, some businesses will have others.

      “Additional expense items to include can be gathered from a review of the previous quarter or year's financial statements,” Papazian says.

      4. Sum for your cash projection.

      When dates and amounts of all cash inflows and outflows have been gathered, they’re entered on their projected due dates. By looking at the resulting cash plan, business owners can tell at a glance whether they’ll have enough funds to pay essential bills when they're due.

      For the entire month or other period, simply subtract all cash expenses from starting cash on hand. This will be the starting cash balance for the next period's cash flow projection.

      5. Save and track your projections to revise your forecasts.

      Once a business owner knows how to make cash flow projections, it should become a regular task. The frequency will depend on the situation.

      “Cash flow projections should be done at a high level at least quarterly if you don't anticipate any cash flow constraints,” Stephens says. “Prepare cash flow projections monthly or weekly as cash becomes more of an issue."

      Technology can make forecasting cash flow less time consuming and more accurate. Templates for general-purpose spreadsheet software are perhaps the most popular aid. Dedicated cash flow planning software can integrate with popular accounting packages to further increase speed and precision, Haffoney says.  

      No matter how projections are calculated, business owners should retain the worksheets used to create them. Since a projection may not match reality, it is often necessary to make adjustments during the period to account for seasonality and other business factors. As time goes by and business owners get a better sense of when cash income and outflows are likely to actually occur, it can help make future projections more accurate. 

      While projecting and managing cash flow are important activities that come steeped in a measure of dread, Stephens emphasizes that a cash flow forecast can point to opportunities as well as obstacles.

      “As a bank CFO, I saw many small-business owners enter the Great Recession maximizing their profits but ignoring cash flow,” Stephens noted. “The recession drained their cash flow. They lost their profits and some lost their businesses. Business owners who managed cash flow well scooped up business opportunities at steep discounts from those who didn't manage cash well.”

      Read more articles on cash flow.

      Photo: Getty Images

      The information contained herein is for generalized informational and educational purposes only and does not constitute investment, financial, tax, legal or other professional advice on any subject matter. THIS IS NOT A SUBSTITUTE FOR PROFESSIONAL BUSINESS ADVICE. Therefore, seek such advice in connection with any specific situation, as necessary. The views and opinions of third parties expressed herein represent the opinion of the author, speaker or participant (as the case may be) and do not necessarily represent the views, opinions and/or judgments of American Express Company or any of its affiliates, subsidiaries or divisions. American Express makes no representation as to, and is not responsible for, the accuracy, timeliness, completeness or reliability of any such opinion, advice or statement made herein.

      American Express Business Class Logo
      Share This Story
      Email Icon
      Facebook Icon
      Twitter Icon
      LinkedIn Icon

      Published: March 19, 2020

      Updated: August 27, 2020


      Want to Dig Deeper?


      Trending Content