Buz Logo

Discover Free Small Business Help in Pennsylvania
Train myBiz
Train myBiz

10 Step Venture eMentoring Program™
Session 6: Forecasting
Module 6f: Profit/Loss Forecast Worksheet

In 6.b, you started a listing of the sources you expect to generate revenues from, and a listing of the expenses you felt you were likely to incur. In this worksheet, you will refine these rough numbers even more, based on what you learned about the forecasting process from the above articles.

Instructions: This exercise is designed to help you understand the forecasting process and to identify all of the revenues and expenses you are likely to incur. If there are other categories that are not listed, add them. If there are categories that do not pertain to your operation, replace them. The main point here is to be as inclusive as possible. After responding to each of the points introduced below, submit the form to receive a copy via the email address(es) specified.

Line Revenue Categories Projected Example
1 Sales Revenues - Product 1 (Quantity x Unit Price) 166500
2 Sales Revenues - Product 2 (Quantity x Unit Price) 12300
3 Sales Revenues - Product 3 (Quantity x Unit Price) 200
4 Sales Revenues - Product 4 (Quantity x Unit Price) 0
5 Sales Revenues - Product 5 (Quantity x Unit Price) 0
6 Sales Revenues - Product 6 (Quantity x Unit Price) 0
7 Total Sales Revenues (Total Line 1 through 6) 0 $179,000
       
  Expense Categories Projected Example
8 I. Variable Costs (Costs that change with levels of output/sales)    
9 Cost of Goods/Materials 42350
10 Direct Labor 23400
11 Payroll Taxes 2340
12 Production Facilities; electricity, heat, water, etc. 1800
13 Health Insurance 4200
14 Freight-In 825
15 Truck Expense 2200
16 Equipment Maintenance 750
17 Workers Compensation Insurance 100
18 Miscellaneous or Other 65
19 Total Variable Costs (Total Line 9 through Line 18) 0 78030
20 II. Gross Profit (Total Line 7 minus Line 19) 0 78030
21 III. Fixed Costs (Costs that remain the same regardless of output/sales)    
22 Administrative Salaries 6000
23 Owner's Compensation 42300
24 Payroll Taxes 4200
25 Health Insurance 5400
26 Rent (or Mortgage Interest) 12500
27 Other Interest 750
28 Legal and Accounting 1650
29 Property Taxes 1875
30 Utilities (Power and Heat) 540
31 Postage and Shipping 250
32 General Insurance 950
33 Office Supplies and Equipment 1375
34 Depreciation 850
35 Telephone 550
36 Travel 1350
37 Miscellaneous or Other 250
38 Total Fixed Expenses (Total Line 22 through Line 37) 0 80815
39 Net Profit / Loss (Total Line 20 minus Line 38) 0 20155


Refine your entries and recalculate as needed.
When done check the box below, then
scroll down to mail yourself a copy of the form.
Form complete and ready to email

Submitting the form (* = required)
*Your email address
(to receive a copy of this form)
Send Copy To / eMentor
Your Name
(*required if sending a copy)

View our privacy policy

Now - on to 6g: Financial Calculators

Stay Buzzed ~ for FREE resource updates.

Buzgate.org is an award-winning public service initiative created to facilitate awareness, access and use of America's government and nonprofit small business assistance programs on a national scale.
Champions of small business & educational content underwriters. View All

All content is state specific requiring you to choose a state to view small business resources.
AK AL AR AZ CA CO CT DC DE FL GA HI IA ID IL IN KS KY LA MA MD ME MI MN MO MS MT NC ND NE NH NJ NM NV NY OH OK OR PA PR RI SC SD TN TX UT VA VT WA WI WV WY