Cash Flow Analysis Model

January 8, 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

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
  1. 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
  1. Go to File > Save As > Download a Copy to download your own copy of the Excel spreadsheet