12 Month Cash Flow Projection
This is a spreadsheet that can yield an excellent 12 Month Cash Flow Projection, an inportant tool for managing your business or preparing a Business Plan.
It can be easily modified by additions or deletions to fit your case and it is useful in doing "what ifs" etc. This prepares you for understanding and developing your business or for shaping the verbal parts a BP. If your income and expenses come from more than one product group or service, it is wise to show those separately in the MCFP.
The second column from the left on this spreadsheet, Pre-startup Estimate, is where you enter the money you personally put into the business and the money others (bank etc.) put in. In that column you also show all the expenses and capital expenditures that must be made before the business is really going. Where capital expense are involved it is well to list these on a separate document and that total goes into row titled Capital Expenditures - as would any future capital expenditures in future months in the month column for the month you plan to spend that money. This sort of list listing later, with actual purchase date and cost, becomes your ledger for tracking your depreciation.
If you plan to use this in preparing a BP, this MCFP and capital register gives you the basis for Profit and Loss Statement and Balance Sheet projections with a few changes involving depreciation, loan principal payments etc. Also the info for Break Even charts.