Cash Flow Projection Worksheet in Excel

This cash flow projection worksheet will help you to record your estimates of cash receipts and expenditures.

by Matt Evans
Retired consultant in Washington D.C.Follow 51

5 reviews580 views|Start the discussion!|Bookmark download for free

Description
This cash flow projection worksheet will provide you with a systematic method so that you can record your estimates of cash receipts and expenditures, which you can then compare with actual expenditures and receipts as you become aware of them.

The items that have been listed in this spreadsheet may not apply to every business, and you may find that things have not been included that are pertinent to some. However you are welcome to adapt the spreadsheet to suit your needs, and make the appropriate modifications as you need.

Before you can complete the cash flow projection and establish a pricing structure, you need to know or estimate various factors of the business, e.g.

-What are the yearly/monthly costs of the operation?
-What are the direct costs of the services or products per unit?
-What is the price of sales per unit of the service or product?

Determine that the pricing structure will provide this business with realistic breakeven goals when conservative sales goals have been met.

What are the sources of cash that are available to you? This is except for income from sales. e.g. equity capital, loans, rent, or other sources?

This Best Practice includes
1 Cash Flow Projection Worksheet in Excel