Join us in these
social media


E-ret@iler - retail management and merchandising in retail speaker Tom Shay's newsletter

Visit my blog for some interesting conversations on retailing
Social Links Myspace Social Media Plaxo Social Media Facebook Social Media Linkedin Socail Media Slideshare Twitter Social Media You Tube

Want to share or save this page?

Share/Save/Bookmark

 

 

 

Retail management seminars, Small Business expert, retail speaker
Retail Management, Retail expert, retail keynote speakers Sign up for e-ret@iler, small business help, small business advice
Retail Expert speakers Retail Management training seminars

60 day Projectionary Cashflow Calculator

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 and the book, EZ Cashflow, that he wrote. The book can be purchased by clicking on this link. Purchase EZ Cashflow.

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. This 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.

  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
 
 
 
 
 
Copyright Notice

Profits+Plus
P.O. Box 1577
St. Petersburg, Fl 33731
(727) 464-2182
Fax: (727) 898-3179