12 month profit and loss projection by c4ball

VIEWS: 514 PAGES: 3

More Info
									Twelve Month Profit and Loss Projection
Enter your Company Name here
Fiscal Year Begins
IND .% Ju n-0 1 B/A

Jun-01
Au g-0 1 1 De c-0 1
0 -

Se p-0 1

Ju l-0 1

1

No v-0

Oc t-0

%

%

%

%

%

Revenue (Sales) Category 1 Category 2 Category 3 Category 4 Category 5 Category 6 Category 7 Total Revenue (Sales) Cost of Sales Category 1 Category 2 Category 3 Category 4 Category 5 Category 6 Category 7 Total Cost of Sales Gross Profit Expenses Salary expenses Payroll expenses Outside services Supplies (office and operating) Repairs and maintenance Advertising Car, delivery and travel Accounting and legal Rent Telephone Utilities Insurance Taxes (real estate, etc.) Interest Depreciation Other expenses (specify) Other expenses (specify) Other expenses (specify) Misc. (unspecified) Total Expenses Net Profit

%

0

0.0

0

0.0

0

0.0

Notes on
0

Note: You may want to print this information to use as referen press the DELETE key.

Preparation 0.0 0

0.0

0

0.0

0 0

-

0 0

-

0 0

-

You should change "category 1, category 2", etc. labels to the month. The spreadsheet will -add up total annual sales. In the category. COST OF GOODS SOLD (also called Cost of Sales or COGS 0 0 0 0 or services. For example, purchases of inventory or raw mate

-

-

-

producing your products/services, are included in COGS. The 0 0 0 0 sales. Study your records to determine COGS for each sales c approach this part of your forecast with great care. For each c for materials,-for packing, for -shipping, for sales commissions, categories. Which are most profitable, and which are least - -a ability to earn- a profit. Research carefully and be realistic. Ent spreadsheet will show the COGS as a % of sales dollars for -th
-

GROSS PROFIT: Gross Profit is Total Sales- minus Total COG Sales. -

OPERATING- EXPENSES (also called Overhead): These are your products/services. Rent, utilities, telephone, interest, and - of the Expense categories to su examples. Change the names some categories, however, to stay within the- 20 line limit of th -

0 0

0 0

0 0

0 0

0 0

0 0

0 0

%
0.0

YE AR L Y

Ma y-0 2

Ma r-0 2

-02

Ap r-0 2

Ja n- 0 2

Fe b

%

%

%

%

%

ant to print this information to use as reference later. To delete these instructions, click the border of this text box and then

0

0.0

0

0.0

0

0.0

0

0.0

%

0

0.0

0

0.0

e "category 1, category 2", etc. labels to the actual names-of your sales categories. Enter -sales for each ca tegory for each dsheet will add up total annual sales. In the "%" columns, the spreadsheet- will show the % of total sales con tributed by each S SOLD (also called Cost of Sales or COGS): COGS are those expenses -directly related - producing or -buying your products to 0 0 0 0 0 xample, purchases of inventory or raw materials, as well as the wages (and payroll taxes) -of employees dire ctly involved -in

%
0 0 0 0

oducts/services, are included in COGS. These expenses usually go 0 and down along with the volume of produc tion or up 0 0 0 0 records to determine COGS for each sales category. Control of COGS is the key to profitability for most bus inesses, so of your forecast with great care. For each category of product/service, analyze the elements of COGS: how much for labor, acking, for shipping, for sales commissions, etc.? Compare the Cost of Goods Sold and Gross Profit of you r various sales and why? Underestimating COGS can lead to under pricing, which can destroy your ofit. Research carefully and be realistic. Enter the COGS for each category of sales for each month. In t he "%" columns, -the how the COGS as a % of sales dollars for that category. Gross Profit is Total Sales minus Total COGS. In the "%" -columns, the spreadsheet will show Gross Profit as a % of Total -

PENSES (also called Overhead): These are necessary expenses which, however, are not -directly related -to making or buying vices. Rent, utilities, telephone, interest, and the salaries (and payroll taxes) of office and management e mployees are e the names of the Expense categories to suit your type of- business and your accounting system. You may need to combine however, to stay within the 20 line limit of the spreadsheet. Most operating expenses remain reasonably fixe d regardless- of -

0 0

0 0

0 0

0 0

0 0

%


								
To top