Cash Flow Analysis Model

August 2020

The Cash Flow Analysis Model will help you:

  • Understand why a cash flow statement is important for small businesses to assess their company's performance
  • Determine your business's cash inflows and outflows, and create a basic breakeven analysis
  • Create an advanced cash flow model for a more in-depth understanding of your business's cash flows

Download the PDF workbook here. 

Initial Cash Flow Projections Model (Section 3 of workbook)
Image of the basic cash flow model spreadsheet.

After completing Activity 1 in the workbook, you can use the Basic Model below to see a basic breakeven analysis.

  1. Access the interactive Excel spreadsheet here
  2. Go to File > Save As > Download a Copy to download your own copy of the Excel spreadsheet
If you are interested in a more in-depth exploration of your company's cash flows, you can download the Advanced Model (Section 4 of workbook)
Image of the advanced cash flow analysis spreadsheet.
  1. Access the interactive Excel spreadsheet here
  2. Go to File > Save As > Download a Copy to download your own copy of the Excel spreadsheet