The Simplest Cash Flow Projections Template

Create the following four tabs in Excel:

  1. Payroll
  2. Expenses
  3. Cash In
  4. Cash Flow

Here we are going to create sheets where each row represents a cash in or out category and columns for each month. I recommend building out 18 to 24 months.

Payroll

Go to the second column and start building out your months by naming the first column with the current month. Keep going across the spreadsheet adding as many months as you want.

List out one employee per row. Go across and enter the monthly amount the employee will be paid.

Add a total line at the bottom of the list of employees. Sum each month.

Expenses

Copy and paste the months you typed out for the Payroll tab.

List one expense per row. Fill out each expense with the amount you will pay, entering in the month that you will pay it (doesn’t have to be the same month that you buy it).

Create a total line and sum each month.

Cash In

Copy and paste the months you typed out for the Payroll tab.

Create one line per client / prospect / partnership / etc. Enter the amount of money you expect to receive from the client in the month you expect to receive it. The key word here is receive, presumably from clients and partnerships. This is not sales.

Create a total line and sum each month.

Cash Flow Statement

Copy and paste the months you typed out for the Payroll tab

You need five rows here. Don’t worry about any of the fancy schmancy accounting vocabulary. Just make sure you put the right things in the right spot:

  • Cash In – This is all of the money that you collect. Link the cells in this row to the sums in the Cash In tab.
  • Cash Out –  This is all of the money that you spend. Link the cells in this row to the sums in the Expenses tab + Payroll tab.
  • Burn – Enter the formula in this cell = Cash In – Cash Out
  • Investment & Loans – This is cash received from investors or bank loans.
  • Cash on Hand – for the first month enter the amount of cash in the bank + Burn.

Your Cash Flow tab should look something like below. You can use it to create scenarios, for example if you secured a $250 thousand investment in May, how long would that take you?

 

 

Go ahead and try creating one for yourself. I’d be happy to give you my Excel template for free of course – just email me and ask.

 

For more insight or help managing cash contact me at me (at) katiebronnenkant.com.

Leave a Reply

Your email address will not be published. Required fields are marked *