Get documents about "Excel Easy Profit and Loss
W
Description
Excel Easy Profit and Loss document sample
Document Sample
Profit and Loss Projection (12 Months)
Enter your Company Name here
Fiscal Year Begins Jun-05
Y
%
5
6
L
5
5
5
5
6
6
6
6
5
B/A
5
g-0
y-0
v-0
AR
c-0
p-0
n-0
b-0
r-0
n-0
r-0
t-0
l-0
.
IND
%
%
%
%
%
%
%
%
%
%
%
%
Ma
Ma
YE
Au
Oc
No
Ap
De
Se
Ju
Ju
Fe
Ja
%
Revenue (Sales)
Category 1 - - - - - - - - - - - - 0 -
Category 2 - - - - - - - - - - - - 0 -
Category 3 - - - - - - - - - - - - 0 -
Category 4 - - - - - - - - - - - - 0 -
Category 5 - - - - - - - - - - - - 0 -
Category 6 - - - - - - - - - - - - 0 -
Category 7 - - - - - - - - - - - - 0 -
Total Revenue (Sales) 0 0.0 0 0.0 0 0.0 Notes
0 0.0 on 0 0.0
Preparation
0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0 0 0.0
Cost of Sales
Category 1 - - - Note: You may want to- print this- information to use as reference later. To delete these -
- - - - - - - 0
Category 2 - - - instructions, click the border of this text box and then press - DELETE key. -
- - - - - - the - 0 -
Category 3 - - - - - - - - - - - - 0 -
Category 4 - - - - - - - - - - - - 0 -
Category 5 - - - You should change "category 1, -category- 2", etc. labels to the actual -names of your sales
- - - - - - 0 -
Category 6 - - - categories. Enter sales- for each -category -for each -month. The spreadsheet will add0 up -total
- - - - -
Category 7 - - - In
annual sales. - the "%" columns, the spreadsheet- will show the % of total sales contributed
- - - - - - - 0 -
Total Cost of Sales 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 -
by each category.
Gross Profit 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 -
Expenses COST OF GOODS SOLD (also called Cost of Sales or COGS): COGS are those expenses
Salary expenses - - - directly related to producing or buying your products or services. For -example, purchases of
- - - - - - - - 0 -
Payroll expenses - - - inventory or raw materials, as well as the -wages (and payroll taxes) of employees directly
- - - - - - - - 0 -
Outside services - - -
Supplies (office and
- - - - -
involved in producing your products/services, are included in COGS. -These expenses -
- - - 0
operating) - - - usually go up -
- and down along with the volume of production or sales. Study your records to
- - - - - - - 0 -
Repairs and determine COGS for each sales category. Control of COGS is the key to profitability for
maintenance - - - - - - -
most- businesses, so approach this part of your forecast with great care. For each category
- - - - 0 -
Advertising - - - - - - - - - - - - 0 -
Car, delivery and travel - - - of product/service, analyze the elements of COGS: how much for labor, for materials, for
- - - - - - - - - 0 -
Accounting and legal - - - packing, for shipping, for sales commissions, etc.?- Compare the Cost of Goods Sold and
- - - - - - - - 0 -
Rent - - - Gross Profit of your various sales categories. Which are most profitable, and which 0are -least
- - - - - - - - -
Telephone - - -
Utilities - - -
- - -
- and- why? Underestimating COGS can lead to under pricing, which can destroy your ability
- - - - - 0 -
- - - - - - - - - 0 -
Insurance - - - to earn a profit. Research carefully and be realistic. Enter the COGS -for each category -of
- - - - - - - - 0
sales for each month. In the "%" columns, the spreadsheet will show the COGS as a % of
Taxes (real estate, etc.) - - - - -
sales dollars for that category. -
- - - - - - 0 -
Interest - - - - - - - - - - - - 0 -
Depreciation - - - - - - - - - - - - 0 -
GROSS PROFIT: Gross Profit is Total Sales minus Total COGS. In the "%" columns, the
Other expenses (specify) - - - spreadsheet will show Gross Profit as a % of Total- Sales. -
- - - - - - - 0 -
Other expenses (specify) - - - - - - - - - - - - 0 -
Other expenses (specify) - - - - - - - - - - - - 0 -
Misc. (unspecified) - - - - - - - - - - - 0 -
Total Expenses 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 -
Net Profit 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 -
YL
AR
%
YE
You may want to print this information to use as reference later. To delete these
u should change "category 1, category 2", etc. labels to the actual names of your sales
egories. Enter sales for each category for each month. The spreadsheet will add up total
nual sales. In the "%" columns, the spreadsheet will show the % of total sales contributed
OST OF GOODS SOLD (also called Cost of Sales or COGS): COGS are those expenses
ectly related to producing or buying your products or services. For example, purchases of
entory or raw materials, as well as the wages (and payroll taxes) of employees directly
olved in producing your products/services, are included in COGS. These expenses
ually go up and down along with the volume of production or sales. Study your records to
termine COGS for each sales category. Control of COGS is the key to profitability for
ost businesses, so approach this part of your forecast with great care. For each category
product/service, analyze the elements of COGS: how much for labor, for materials, for
cking, for shipping, for sales commissions, etc.? Compare the Cost of Goods Sold and
oss Profit of your various sales categories. Which are most profitable, and which are least
nd why? Underestimating COGS can lead to under pricing, which can destroy your ability
earn a profit. Research carefully and be realistic. Enter the COGS for each category of
es for each month. In the "%" columns, the spreadsheet will show the COGS as a % of
ROSS PROFIT: Gross Profit is Total Sales minus Total COGS. In the "%" columns, the
Related docs
