Scribd
Upload
43 views2 pages

Bell Memory and Instruments Division Projections

The document provides projected financial information for Bell Memory and Bell Instruments Divisions from 2004-2009. It includes sales growth rates of 5% annually, consistent cost of sales and other ratios, and projected income statements, balance sheets and operating liabilities. Overall revenues and expenses are expected to increase each year in line with the 5% sales growth across both divisions.

Uploaded by

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

Bell Memory and Instruments Division Projections

The document provides projected financial information for Bell Memory and Bell Instruments Divisions from 2004-2009. It includes sales growth rates of 5% annually, consistent cost of sales and other ratios, and projected income statements, balance sheets and operating liabilities. Overall revenues and expenses are expected to increase each year in line with the 5% sales growth across both divisions.

Uploaded by

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

Initial Projections for Bell Memory Division (Millions of Dollars, Except for Percentages)

Actual Projected Projected Projected Projected Projected


2004 2005 2006 2007 2008 2009
Panel A: Inputs
Sales Growth Rate 5% 5% 5% 5% 5%
Costs / Sales 81% 81% 81% 81% 81% 81%
Depreciation / Net Plant 10% 10% 10% 10% 10% 10%
Acct. Rec. / Sales 8% 8% 8% 8% 8% 8%
Inventories / Sales 30% 30% 30% 30% 30% 30%
Net Plant / Sales 59% 59% 59% 59% 59% 59%
Acct. Pay. / Sales 5% 5% 5% 5% 5% 5%
Accruals / Sales 6% 6% 6% 6% 6% 6%
Tax rate 40% 40% 40% 40% 40% 40%

Panel 2: Partial Income Statement


2004 2005 2006 2007 2008 2009
Net Sales 1,000.00 1,050.00 1,102.50 1,157.63 1,215.51 1,276.28
Costs (except depreciation) 810.00 850.50 893.03 937.68 984.56 1,033.79
Depreciation 59.00 61.95 65.05 68.30 71.71 75.30
Total operating costs 869.00 912.45 958.07 1,005.98 1,056.27 1,109.09
Op. profit before int. & tax 131.00 137.55 144.43 151.65 159.23 167.19

Panel C: Partial Balance Sheets


Operating Assets 2004 2005 2006 2007 2008 2009
Accounts receivable 80.00 84.00 88.20 92.61 97.24 102.10
Inventories 300.00 315.00 330.75 347.29 364.65 382.88
Operating current assets 380.00 399.00 418.95 439.90 461.89 484.99
Net plant and equipment 590.00 619.50 650.48 683.00 717.15 753.01

Operating Liabilities
Accounts Payable 50.00 52.50 55.13 57.88 60.78 63.81
Accruals 60.00 63.00 66.15 69.46 72.93 76.58
Operating current liabilities 110.00 115.50 121.28 127.34 133.71 140.39
Intitial Projections for Bell Instruments Division (Millions of Dollars, Except for Percentages)
Actual Projected Projected Projected Projected Projected
2004 2005 2006 2007 2008 2009
Panel A: Inputs
Sales Growth Rate 5% 5% 5% 5% 5%
Costs / Sales 85% 85% 85% 85% 85% 85%
Depreciation / Net Plant 10% 10% 10% 10% 10% 10%
Acct. Rec. / Sales 5% 5% 5% 5% 5% 5%
Inventories / Sales 15% 15% 15% 15% 15% 15%
Net Plant / Sales 30% 30% 30% 30% 30% 30%
Acct. Pay. / Sales 5% 5% 5% 5% 5% 5%
Accruals / Sales 6% 6% 6% 6% 6% 6%
Tax rate 40% 40% 40% 40% 40% 40%

Panel B: Partial Income Statement


2004 2005 2006 2007 2008 2009
Net Sales 500.00 525.00 551.25 578.81 607.75 638.14
Costs (except depreciation) 425.00 446.25 468.56 491.99 516.59 542.42
Depreciation 15.00 15.75 16.54 17.36 18.23 19.14
Total operating costs 440.00 462.00 485.10 509.36 534.82 561.56
Earning before int. & tax 60.00 63.00 66.15 69.46 72.93 76.58

Panel C: Partial Balance Sheets


Operating Assets 2004 2005 2006 2007 2008 2009
Accounts receivable 25.00 26.25 27.56 28.94 30.39 31.91
Inventories 75.00 78.75 82.69 86.82 91.16 95.72
Operating current assets 100.00 105.00 110.25 115.76 121.55 127.63
Net plant and equipment 150.00 157.50 165.38 173.64 182.33 191.44

Operating Liabilities
Accounts Payable $25.0 $26.3 $27.6 $28.9 $30.4 $31.9
Accruals $30.0 $31.5 $33.1 $34.7 $36.5 $38.3
Operating current liabilities $55.0 $57.8 $60.6 $63.7 $66.9 $70.2

You might also like