Scribd
Upload
6 views4 pages

2006-2008 Sales and Profit Analysis

1) The document contains financial information for 2006 and projected figures for 2007-2008, including sales, price per unit, number of units sold, costs of goods sold, gross profit, operating income, taxes, and net income. 2) Sales are projected to increase 114% from 2006 to 2007-2008, while price per unit is expected to decrease 57% and number of units sold is projected to increase 400%.

Uploaded by

Chirag Jain
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
6 views4 pages

2006-2008 Sales and Profit Analysis

1) The document contains financial information for 2006 and projected figures for 2007-2008, including sales, price per unit, number of units sold, costs of goods sold, gross profit, operating income, taxes, and net income. 2) Sales are projected to increase 114% from 2006 to 2007-2008, while price per unit is expected to decrease 57% and number of units sold is projected to increase 400%.

Uploaded by

Chirag Jain
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

2006

Sales 2666666.67
Price/unit 69.99
No of units sold 38101
COGS @ $30 1143020.43
Gross Profit 1523646.24
Gross Profit Margin 57%
SG&A 714000.00
S&W 197540.00
Operating Income 612106.24
Tax 214237.18
Net Income 397869.05

2006
Sales 2666666.66666667
Price/unit 69.99
No of units 38101
Gross profit @ 30% 800000

2006
Total Wholesale revenues 8000000
a) U.S retailer 2666666.67
% of total 33%
b) Rest 5333333.33
% of total 67%

Category 2006
Store 3000000
Wholesale 8000000
internet 200000
Total 11200000
2007-08 (Expected) % Change
Sales 5713197.12 114%
Price/unit 29.99 -57%
No of units sold 190503 400%
COGS @ $20 3810068.10496738 233%
Gross Profit 1903129.0184312 25%
Gross Profit Margin 33% -42%
SG&A 856800 20%
S&W 493850 150%
Operating Income 552479.018431204 -10%
Tax 193367.656450921 -10%
Net Income 359111.361980283 -10%

2007-08 (Expected) % Change


Sales 5713197.12 114%
Price/unit 29.99 -57%
No of units 190503 400%
Gross profit @ 15% 856979.568509787 7%

2007-08 (Expected)
11094530.46
5713197.12
51%
5381333.33
49%

2007-08 (Expected) % Change


3027000 1%
11094530.46 39%
201800 1%
14323330.4567319 28%
2006 2007 (Expected)
Sales 2666666.67 Sales 6937045.43
Price/unit 48.99 Price/unit 25.49
No of units sold 54430 No of units sold 272148
COGS @ $30 1632886.33 COGS @ $20 5442954.44
Gross Profit 1033780.34 Gross Profit 1494090.99
Gross Profit Margin 39% Gross Profit Margin 22%
SG&A 714000.00 SG&A 856800.00
S&W 197540.00 S&W 493850.00
Operating Income 122240.34 Operating Income 143440.99
Tax 42784.12 Tax 50204.35
Net Income 79456.22 Net Income 93236.65

2006 2007 (Expected)


Sales 3809523.80952381 Sales 8161710.18
Price/unit 69.99 Price/unit 29.99
No of units 54430 No of units 272148
Gross profit @ 30% 1142857.14285714 Gross profit @ 15% 1224256.53
% Change
160%
-48%
400%
233%
45%
-44%
20%
150%
17%
17%
17%

% Change
114%
-57%
400%
7%

You might also like