Business Plan Worksheets

Instructions: Enter your Company Name in this cell.

Instructions: Enter the date (as MM/DD/YYYY) all below figures are reported as of.

Instructions: Enter the total amount of cash sales to customers.

Instructions: Enter the total amount of cash collections from customers on credit payment terms (Accounts Receivable).

Instructions: Enter the total amount of Loans or other Cash Injections received.

Instructions: Enter the total Interest Expense payments. This is the cost of financing and includes any interest the Restaurant pays on loans, car payments, mortgages, revolving credit etc.

Instructions: Enter the total Income Tax Expense payments. This includes any federal, state or local taxes.

Instructions: Enter the total interest income received each month.

Instructions: Enter the total Misc. Cash received each month.

Instructions: Enter the total Income Tax Refund received. This includes any federal, state or local taxes.

Instructions: Enter the total Cash Disbursements to Owners.

Instructions: Enter the Current Period amounts for each line item in this column's cells.

Instructions: Enter the Prior Period amounts for each line item in this column's cells.

Instructions: Enter the dates or timeframe the Current Period figures will cover. (e.g. "07/01/2014 to 09/30/2014")

Instructions: Enter the dates or timeframe the company's prior period figures will cover. (e.g. "07/01/2014 to 09/30/2014") Please note that for the best comparison to the Current Period, the prior period time frame should cover the same number of days as the Current Period.

Instructions: Enter the total amount of Product/Service Cost of Goods Sold. This would include costs directly related to producing the product or providing the service. Enter the appropriate Row label for your Product/Service if desired.

Instructions: Insert the total Direct Labor costs. Direct Labor is labor costs for the employees that are directly involved in producing a product or providing a service.

Instructions: Insert the total Direct Labor Payroll Tax and Benefit costs. Direct Labor is labor costs for the employees that are directly involved in producing a product or providing a service.

Instructions: Insert the total costs of Supplies used to produce a product or provide a service.

Instructions: Enter the Other Costs not previously specified.

Instructions: Enter the total Advertising and Promotion expenses.

Instructions: Enter the total Automobile/Transportation expenses. If the company offers delivery, all delivery related expenses will go here.

Instructions: Enter the total Bank Service Charges expenses.

Instructions: Enter the total Business Licenses and Permits expenses.

Instructions: Enter the total Charitable Contribution expenses.

Instructions: Enter the total Computer and Internet Expenses.

Instructions: Enter the total Continuing Education expenses. This includes expenses for classes, seminars, or symposiums the company's staff attends.

Instructions: Enter the total Dues and Subscriptions. Dues and Subscriptions include magazines, trade subscriptions, organizations etc.

Instructions: Enter the total Insurance Expenses .

Instructions: Enter the total Meals and Entertainment expenses. This includes any meals or entertainment the company paid for on behalf of its employees or as part of conducting business.

Instructions: Enter the total costs of Merchant Account Fees. Merchant Account Fees are any fees administered by merchants or wholesalers used by the company, such as delivery fees & credit card services.

Instructions: Enter the total Miscellaneous Expenses. This is any expense that has not been otherwise specified.

Instructions: Enter the total Office Supplies expenses. This includes printers, copy machines, pens, pencil, notepads, etc.

Instructions: Enter the total Payroll Processing Expenses. This includes fees associated with administering the company's payroll.

Instructions: Enter the total Postage and Delivery expenses.

Instructions: Enter the total Printing and Reproduction expenses.

Instructions: Enter the total expenses for professional services, such as legal fees and accounting fees.

Instructions: Enter the total Rent and or Mortgage Expenses (excluding interest expense) and any Property Tax expenses.

Instructions: Enter the total Rentals expense. Rentals can include equipment, office equipment etc. Rentals payments are for items not owned by the company.

Instructions: Enter the total Indirect Salaries costs. This typically includes labor for employees that do not directly produce a product or provide a service.

Instructions: Enter the total Indirect Payroll Taxes and Benefits costs. This typically includes labor for employees that do not directly produce a product or provide a service.

Instructions: Enter the total Subcontractor expenses.

Instructions: Enter the total Telephone Expenses.

Instructions: Enter the total Travel Expenses. This includes any employee travel expenses the company has paid for.

Instructions: Enter the total Utility expenses. This includes electricity, gas, water & sewer.

Instructions: Enter the total Website Development expense. This includes development and hosting costs.

Statement of Cash Flows

TIP: Sheet 2 (Example) Has a filled out example TIP: Hover over column & Row headers for more instructions

Notes on Preparation: Note: You may want to print this information to use as reference later. To delete these instructions, click the border of this text box and then press the DELETE key. Note: Understanding a company's Cash Flows is critical to managing cash in order to ensure a positive cash position is sustained. It is important to understand the key cash drivers for your company's operations as well as understanding how the Current Period compares to the Prior Period. This template is intended to help you outline those drivers and compare the Current Period to the Prior Period in detail. Note: Enter data into cells beneath column headers and to the right of rows headers that contain comments (red triangle in upper right corner of cell). Explanations of what type of data should be entered into each row are outlined in the row header's comments. Steps for Preparation: Step 1: Enter your Company’s name and the Date all figures are reported as of in the report header. Step 2: Enter the ‘Start Date to End Date’ as MM/DD/YYYY in the Current Period and Prior Period column headers. Please note that for the best comparison to the Current Period, the Prior Period time frame should cover the same number of days as the Current Period. Typically, the prior period is the same timeframe but for the previous year. However, you can use whatever timeframe you would like to compare the Current Period to, such as the previous quarter or month. Step 3: Enter the BEGINNING CASH ON HAND for the Current and Prior Periods. Step 4: Enter the expected cash receipts for each line item and for the Current and Prior Periods. Step 5: Enter the expected cash payments for each line item and for the Current and Prior Periods. Note: The ending cash balance (Cash Position) will automatically calculate based on the imbedded formulas and the figures you have entered. Step 6: If additional rows are required in order to best reflect your company, click on a Column A cell below the row you would like to add and right click your mouse, click Insert, select Entire Row and click OK (repeat as many times as necessary in order to add multiple rows). Then copy any existing row into the newly inserted rows by selecting an entire previously existing single row (click on the row number to the left of Column A), click the right mouse button and select Copy and then highlight the Row numbers for the rows just added, then right click the mouse again and select Paste (be sure the mouse pointer is located on the highlighted range). Repeat as necessary. Overwrite the Row headers with the description you are adding.

Statement of Cash Flows

TIP: Sheet 2 (Example) Has a filled out example TIP: Hover over column & Row headers for more instructions

Notes on Preparation: Note: You may want to print this information to use as reference later. To delete these instructions, click the border of this text box and then press the DELETE key. Note: Understanding a company's Cash Flows is critical to managing cash in order to ensure a positive cash position is sustained. It is important to understand the key cash drivers for your company's operations as well as understanding how the Current Period compares to the Prior Period. This template is intended to help you outline those drivers and compare the Current Period to the Prior Period in detail. Note: Enter data into cells beneath column headers and to the right of rows headers that contain comments (red triangle in upper right corner of cell). Explanations of what type of data should be entered into each row are outlined in the row header's comments. Steps for Preparation: Step 1: Enter your Company’s name and the Date all figures are reported as of in the report header. Step 2: Enter the ‘Start Date to End Date’ as MM/DD/YYYY in the Current Period and Prior Period column headers. Please note that for the best comparison to the Current Period, the Prior Period time frame should cover the same number of days as the Current Period. Typically, the prior period is the same timeframe but for the previous year. However, you can use whatever timeframe you would like to compare the Current Period to, such as the previous quarter or month. Step 3: Enter the BEGINNING CASH ON HAND for the Current and Prior Periods. Step 4: Enter the expected cash receipts for each line item and for the Current and Prior Periods. Step 5: Enter the expected cash payments for each line item and for the Current and Prior Periods. Note: The ending cash balance (Cash Position) will automatically calculate based on the imbedded formulas and the figures you have entered. Step 6: If additional rows are required in order to best reflect your company, click on a Column A cell below the row you would like to add and right click your mouse, click Insert, select Entire Row and click OK (repeat as many times as necessary in order to add multiple rows). Then copy any existing row into the newly inserted rows by selecting an entire previously existing single row (click on the row number to the left of Column A), click the right mouse button and select Copy and then highlight the Row numbers for the rows just added, then right click the mouse again and select Paste (be sure the mouse pointer is located on the highlighted range). Repeat as necessary. Overwrite the Row headers with the description you are adding.