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 dates or timeframe the company's current income 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 1 Sales. Enter the appropriate Row label for your Product/Service.

Instructions: Enter the total amount of Other Revenue, not covered by the above categories.

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 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: Insert the total Depreciation Expense for indirect assets. Depreciation Expense is when the company buys equipment that will last greater than one (1) year but its cost is spread out over a span of several years (usually the useful life of the asset).

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 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 Interest Expenses. This is the cost of financing and includes any interest the company pays on loans, car payments, mortgages, revolving credit etc.

Instructions: Insert the total Depreciation Expense for assets used directly to produce a product or provide a service. Depreciation Expense is when the company buys equipment that will last greater than one (1) year but its cost is spread out over a span of several years (usually the useful life of the asset).

Instructions: Enter the Current Period's Revenue and Cost amounts for each category in this column's cells.

Instructions: Enter the Prior Period's Revenue and Cost amounts for each category in this column's cells.

Instructions: Enter the total Bad Debt/Losses and Thefts expenses. Bad Debts are uncollected cash receivables.

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 Website Development expense. This includes development and hosting costs.

Instructions: Enter the total Interest Income. This includes any interest earned by bank or investment accounts.

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

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 amount of Product/Service 2 Sales. Enter the appropriate Row label for your Product/Service.

Instructions: Enter the total amount of Product/Service 3 Sales. Enter the appropriate Row label for your Product/Service.

Instructions: Enter the total amount of Product/Service 1 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.

Instructions: Enter the total amount of Product/Service 2 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.

Instructions: Enter the total amount of Product/Service 3 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.

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: 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.

Income Statement

TIP: Sheet 2 (Example) Has a filled out example TIP: Hover over column titles 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 profitability is vital to ensuring it will deliver necessary profits and ultimately ensuring its success. In addition to reporting a company's profitability for a past period of time, comparing its profitability to a prior period of time is equally important. The owner/manager can gain a view of whether the company's sales and profits have increased over time. This can be an important tool in making informed business decisions to ensure required profitability and ultimately cash flow. 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 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 amounts in each cell of the Current and Prior Period columns that represents your company's operations. Note: Amounts in the Increase (Decrease) column will automatically populate with values based on the imbedded formulas. Please note negative numbers represent a decrease in the Current Period compared to the Prior Period. Amounts in the rows that do not have comments in the row header will also automatically populate with values based on the imbedded formulas. Step 4: If additional rows are required 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.

Income Statement

TIP: Sheet 2 (Example) Has a filled out example TIP: Hover over column titles 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 profitability is vital to ensuring it will deliver necessary profits and ultimately ensuring its success. In addition to reporting a company's profitability for a past period of time, comparing its profitability to a prior period of time is equally important. The owner/manager can gain a view of whether the company's sales and profits have increased over time. This can be an important tool in making informed business decisions to ensure required profitability and ultimately cash flow. 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 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 amounts in each cell of the Current and Prior Period columns that represents your company's operations. Note: Amounts in the Increase (Decrease) column will automatically populate with values based on the imbedded formulas. Please note negative numbers represent a decrease in the Current Period compared to the Prior Period. Amounts in the rows that do not have comments in the row header will also automatically populate with values based on the imbedded formulas. Step 4: If additional rows are required 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.