This is a very important aspect of the business plan and is really the business plan shown in dollar financial terms.  The rest of the written business plan is a description of how the values were determined.  You should change anything and everything to make the spreadsheet fit your business including the column and row titles. 

Ø      The first column is the entire cost of the project from now till the day you open the doors and then there are 12 columns for each months income and expenses.

Ø      Under labor cost do not include yourself if you are going to work in the business. Show your salary on the last line that is labeled "owners withdrawal".  This amount should be the amount you forecast that is needed from the business to support your family every month.

Ø      On the line principle and interest show your monthly payment as 1.5% of the total loan. ie. $1,500 payment for a $100,000 loan.  This will serve as an approximation until we get better information from a loan officer at a later date.

This cash flow projection should be completed even if not all the figures are known or accurate.  Use your best guess.  This should be considered a work in progress and it will be edited and reviewed every time we get better information or hear back from a supplier, contractor, land owner etc.