\n \n
BOOK US

With over 25 years of frontline experience Tom Shay is America's leading small business management expert. He's a "Must Have" for your next event.

60 day Projectionary Cashflow Calculator from Profits Plus

Your profit and loss statement is a reflection of what has happened in your business. It is valuable information, but what would be even more valuable to a business would be a profit and loss statement that was your expectation of what was going to happen in the upcoming months. That is what a projectionary cashflow calculator is.

Begin by entering the actual numbers from the past year for the two months you want to project. Then look at each row of information and make your best estimate of what you think is going to happen in those same two months for the coming year. As you enter the projectionary numbers, this calculator will tell you how much cash you should expect to have on hand at the end of each of those two months. The names of the months, and the titles for the rows of expenses can be changed to those for your business.

This 60 day projectionary cashflow calculator is a sample from the class that Tom Shay teaches. If you would like to listen to the class Tom teaches on cashflow management, "Black Ink: Cashflow Management Secrets Your Accountant Never Shared" you can click on this link.

That page will also have the powerpoint from the presentation and a PDF of the presentation notes. These presentation notes will have a step by step instruction for building a full accrual based or cash based projectionary cashflow chart for your business.

While this calculator allows you to do two months of projections, here are the templates utilized in the clas that Tom teaches.

EZ Cashflow cash basis accounting template

EZ Cashflow accrual basis accounting template

  A B C D E
1
EZ Cashflow (TM) Cash Basis
       
2          
3
For Month Ending:
 
4
         
5
Income Statement:
       
6
P
7
C
8
C
9
P
10
         
11
Operating Expenses
       
12
P
13
C
14
P
15
P
16
P
17
P
18
P
19
P
20
P
21
P
22
P
23
P
24
P
25
P
26
P
27
P
28
P
29
P
30
P
31
         
32
Total Operating Expenses
C
33
         
34
Operating Income
C
35
         
36
Other Income and Expenses:
       
37
P
38
P
39
P
40
         
41
Net Income Before Taxes
C
42
         
43
P
44
         
45
Net Income (Loss)
C
46
         
47
         
48
Cash Balance, Beginning of Month
P/C
49
         
50
Net Income (Loss)
C
51
         
52
Add:
       
53
C
54
         
55
Less:
       
56
P
57
C
58
P
59
         
60
C
 

APRIL 2024
Have the Small Business Conversations, Advisories and News sent to your inbox. Subscribe HERE

Small Business

AdvisorieS

"What's your score"? is the name of the April Small Business Advisory. This provides an introduction to our return on investment calculator. It is a great way to understand how well the investment you have in your small business is working for you.

Small Business

News

Top Story

We believe Thursday, April 25 is an important annual celebration for small businesses. While the name of the celebration has varied over the years, the focus is for us to take kids to work with us.

 

This is important for the kids to see what it is we do. They definitely are not going to learn about it in school. Reading the April Small Business News you will see an example from community pharmacists that emphasizes it is up to us as small business owners to introduce kids to what we do.


Article of the Month

While titled, "If not price", the April Article of the Month is asking the question about the focus of your small business in attracting and keeping customers.

 

If there is not something very special about your business, then the only attraction to your businessis that of a low price.


Book of the Month

"The plan as you go business plan" is the April book of the month. The author is Tim Berry who has also created software on the same topic.

 

I do not agree with the concept of "fill in the blank" or "create the plan as you need it" because my experience has been that you do not have as strong as a connection and understanding to your business plan unless you do it yourself and you dedicate the time to create it.

BOOK US

With over 25 years of frontline experience Tom Shay is America's leading Small Business Management Expert. He's a "Must Have" for your next event.

Small Business

Advisories

"What's your score"? is the name of the April Small Business Advisory. This provides an introduction to our return on investment calculator. It is a great way to understand how well the investment you have in your small business is working for you.

Small Business

News

 

Top Story

We believe Thursday, April 25 is an important annual celebration for small businesses. While the name of the celebration has varied over the years, the focus is for us to take kids to work with us.

 

This is important for the kids to see what it is we do. They definitely are not going to learn about it in school. Reading the April Small Business News you will see an example from community pharmacists that emphasizes it is up to us as small business owners to introduce kids to what we do.


Article of the Month

While titled, "If not price", the April Article of the Month is asking the question about the focus of your small business in attracting and keeping customers.

 

If there is not something very special about your business, then the only attraction to your businessis that of a low price.


Book of the Month

"The plan as you go business plan" is the April book of the month. The author is Tim Berry who has also created software on the same topic.

 

I do not agree with the concept of "fill in the blank" or "create the plan as you need it" because my experience has been that you do not have as strong as a connection and understanding to your business plan unless you do it yourself and you dedicate the time to create it.