Cash Flow Analysis

How to Analyze a Pro Forma Cash Flow Statement:

Every investor pitch and loan application will include a subset of a pro forma cash flow statement for investors and lenders to review. Any investor or lender interested in performing due diligence will ask for a more detailed pro forma cash flow statement. Offtoa performs an analysis of the cash flow statement looking for the same properties that many investors and lenders look for; these are properties that often foretell a poor financial outcome for the company. In the case of the loan, the cash flow statement shows whether the company will be able to make make payments on the loan according to the terms of the loan. The primary reason for surfacing these issues is to find solutions early and to prevent problems. The primary reason for using a tool like Offtoa to find these issues is so you can either:

  • fix these problems rather than suffer the embarrassment of potential investors and lenders finding them, or
  • understand why the problem is not a problem, so you are better prepared to defend yourself if a potential investor or lender raises the issue. After all, you may not consider every problem that Offtoa raises to be a problem.

Here is a partial list of the kinds of problems that Offtoa looks for

  • Too Much Cash Burned By R&D in the First Few Years
  • Too Much Cash Burned By Large Purchases
  • Company Runs Out of Cash at End of a Fiscal Year
  • Company Runs Out of Cash in Middle of a Fiscal Year
  • Company's Operations Fail to Generate Enough Cash
  • Investment Used to Pay Off (non-Convertible) Loan
  • Cash on CFS and Balance Sheet Not Equal

Whenever Offtoa finds a potential problem, it highlights the symptom for you on the cash flow statement, and offers a list of suggested solutions, each of which describes exactly which assumptions you need to change to fix the problem. However, don't just “fix” the problem by blindly selecting one of the suggestions. That will result in you having a set of financial statements that look good but have no basis in reality. Instead, make changes to assumptions that you believe are feasible and then change your business strategy to reflect the new plan. If none of the suggestions are feasible in your mind, then perhaps you don't have a viable company :).

Questions:

What is so terrible about spending a lot on R&D in the first year?

Start-ups: Nothing at all! But very few traditional investors (i.e., angels and venture capitalists) are interested in investing in R&D. They are already taking huge risks by investing in already-built products that have not yet been proven to be “right” for the market. Why should they take on the even larger risk that the product may not even get built? On the other hand, smart, lean entrepreneurs will iterate constantly with minimally viable products, test marketing them and learning from the experiments. These companies are often funded, but they do not exhibit huge spikes in R&D dollars during their initial years. So, if you need to invest a lot of money building a product up front, you have only three choices: (1) do it on your own dime, (2) find a Government agency to support you with a grant, or (3) do it in very small increments as a lean start-up.

Ongoing Businesses: If you are a business with a history and looking for investment money or loans to fund a major R&D effort, a much better approach is to use the cash generated from your existing business to fund the R&D. If that is insufficient, then read the previous paragraph because they apply equally well to you.

What is so terrible about spending a lot on purchasing fixed assets in the first year?

Your company may need such infrastructure to succeed. In such cases, make sure you find investors attuned to your industry. Lease whenever you can. On the other hand, lenders will often lend companies money for the purchase of fixed assets. The fixed assets themselves serve as collateral.

What should I do if my cash flow statement analysis says I'll run out of cash?

The good news is it is better to know this while you are planning your company! The lowest point on your monthly cash flow statement tells you how much more cash you will need through some combination of:

  • More revenue (change your revenue assumptions, but make sure you can justify it)
  • Less expense (change your expense assumptions, but make sure this doesn't negatively impact revenue)
  • More loans (change your loan assumptions)
  • Extend the term of the loan (change your loan assumptions)
  • Lower the monthly loan payment, and expect to pay more when the loan matures (change your loan assumptions)
  • Change to a different type of loan, e.g., interest only (change your loan assumptions)
  • More investments (change your investment assumptions)

Why is it so bad for operations to not produce cash? After all, there are three sections to the cash flow statement.

The top third of the cash flow statement tells you how much cash is being generated by the business itself. You could consider the other two thirds to be like life support. If your business requires constant influx of cash from loans or investments (or selling fixed assets), it is not a viable business. In fact, it is precisely what Eric Ries would consider a company without a sustainable growth engine.


Site Tools