top of page

Cash Flow Analyzer

Click to download the Cash Flow Analyzer. Follow the instructions below and on the spreadsheet to determine your short-run cash position. This document will be handy to see if you can make your monthly bills or annual big ticket items. 

abstract image of the consumer's surplus economic theory.jpg

Instructions:
1) Enter your available funds in cells B13:B21
. Leave any unused rows blank.

2) Enter your projected distributions (i.e. profits) from your business in cells B23:B26, if applicable. Leave rows blank if not using this feature.

3) Enter your projected expenses in cells B35:B40. Leave any used rows blank.

4) Enter your current credit card statement balances in cells F32:F36. Leave rows blank if not used

The Big Picture:

The cash flow tool lets you see if you need to make any moves to free up money for your living expenses. This will likely be your "go to" sheet as it allows you to capture your real life financial picture for a particular period of time. 

The Key Takeaway:

If you are consistently running into situations where you are over budget or under budget, you'll probably need to go back to your Master Budget Tool and make changes to your overall budget. If you are over budget, you'll want to find ways to cut out unnecessary expenses. If you are under budget, this is a good opportunity to add more money to your savings or investments. 

bottom of page