Transcript Dec 2010 Forecast Report

Dec 2010 Forecast Report
Company 2
Sales
Working Capital
Free Cash Flow
Sales Ranges
P&L Current
Jan
2010
Feb
2010
Mar
2010
Apr
2010
May
2010
Jun
2010
Jul
2010
Aug
2010
Sep
2010
Oct
2010
Nov
2010
Dec
2010
Total
PROFIT AND LOSS
Sales
Cost of Goods Sold
Selling, General, and Administrative Expense
Operating Income Before Depreciation
918,326
547,615
236,054
134,657
923,383
525,066
219,650
178,667
842,662
481,234
190,188
171,240
859,955
538,682
194,449
126,824
874,258
494,517
226,054
153,687
931,106
528,885
220,993
181,228
896,527
525,107
230,286
141,134
797,254
471,655
216,501
109,098
757,255
417,863
187,500
151,892
815,249
462,722
204,802
147,725
658,053
380,747
203,724
73,582
705,773
426,761
201,585
77,427
9,979,801
5,800,854
2,531,786
1,647,161
Depreciation and Amortization
Interest Expense
Nonoperating Income (Expense) and Special Items
Pretax Income
49,559
184,216
6,439
185,106
12,091
183,331
(5,081)
121,743
4,424
158,111
6,844
188,072
2,417
143,551
(5,890)
103,208
2,567
154,459
3,791
151,516
2,823
76,405
21,498
98,925
101,482
1,748,643
Income Taxes - Total
Minority Interest
Net Income
184,216
185,106
183,331
121,743
158,111
188,072
143,551
103,208
154,459
151,516
76,405
98,925
1,748,643
Dividend
Accrued
184,216
185,106
183,331
121,743
158,111
188,072
143,551
103,208
154,459
151,516
76,405
98,925
1,748,643
P&L Forecast
Jan
2011
Feb
2011
Mar
2011
Apr
2011
May
2011
Jun
2011
Jul
2011
Aug
2011
Sep
2011
Oct
2011
Nov
2011
Dec
2011
Total
PROFIT AND LOSS
Sales
Cost of Goods Sold
Selling, General, and Administrative Expense
Operating Income Before Depreciation
754,658
450,017
191,450
113,191
845,852
480,979
214,585
150,288
859,515
490,859
218,051
150,605
877,154
549,456
222,526
105,172
891,743
504,407
226,227
161,109
949,728
539,463
240,938
169,328
914,458
535,609
231,990
146,859
813,199
481,088
206,301
125,810
772,400
426,220
195,951
150,229
831,554
471,976
210,958
148,620
671,214
388,362
170,281
112,571
719,888
435,296
182,629
101,963
9,901,364
5,753,732
2,511,887
1,635,744
Depreciation and Amortization
Interest Expense
Nonoperating Income (Expense) and Special Items
Pretax Income
49,559
162,750
6,439
156,727
12,091
162,696
(5,081)
100,091
4,424
165,533
6,844
176,172
2,417
149,276
(5,890)
119,920
2,567
152,796
3,791
152,411
2,823
115,394
21,498
123,461
101,482
1,737,226
Income Taxes - Total
Minority Interest
Net Income
162,750
156,727
162,696
100,091
165,533
176,172
149,276
119,920
152,796
152,411
115,394
123,461
1,737,226
Dividend
Accrued
162,750
156,727
162,696
100,091
165,533
176,172
149,276
119,920
152,796
152,411
115,394
123,461
1,737,226
B/S Current
Jan
2010
Feb
2010
Mar
2010
Apr
2010
May
2010
Jun
2010
Jul
2010
Aug
2010
Sep
2010
Oct
2010
Nov
2010
Dec
2010
2,188,845
522,391
131,178
2,842,414
2,376,787
671,338
132,748
3,180,873
2,358,745
748,833
161,682
3,269,260
2,381,876
764,054
508,125
3,654,055
2,050,618
727,116
526,593
3,304,327
2,018,521
804,337
727,036
3,549,894
1,958,286
851,529
758,988
3,568,803
1,730,394
785,954
964,371
3,480,719
2,313,961
736,957
966,704
4,017,622
1,831,745
734,494
1,270,923
3,837,162
2,049,386
645,405
1,288,430
3,983,221
1,960,952
610,755
1,567,501
4,139,208
Property, Plant, and Equipment, Gross
Depreciation, Depletion, and Amortization
(Accumulated)
Property, Plant, and Equipment, Net
1,830,731
1,843,613
1,849,839
1,853,412
1,854,150
1,862,137
1,870,099
1,874,080
1,875,096
1,876,025
1,876,622
1,811,047
1,539,800
290,931
1,539,800
303,813
1,539,800
310,039
1,539,800
313,612
1,539,800
314,350
1,539,800
322,337
1,539,800
330,299
1,539,800
334,280
1,539,800
335,296
1,539,800
336,225
1,539,800
336,822
1,553,918
257,129
Investments and Advances
Intangibles
Other Assets
TOTAL ASSETS
3,133,345
3,484,686
3,579,299
3,967,667
3,618,677
3,872,231
3,899,102
3,814,999
4,352,918
4,173,387
4,320,043
4,396,337
LIABILITIES
Accounts Payable
Accrued Expense
Other Current Liabilities
Current Liabilites
1,737,689
462,387
141,738
2,341,814
1,982,663
380,790
152,825
2,516,278
1,760,958
531,007
145,233
2,437,198
2,040,932
527,429
144,599
2,712,960
1,812,716
255,349
147,684
2,215,749
1,706,498
452,524
131,493
2,290,515
1,522,471
482,350
178,148
2,182,969
1,520,469
287,265
194,608
2,002,342
1,806,832
376,973
207,569
2,391,374
1,682,367
227,022
158,735
2,068,124
1,654,830
311,545
178,682
2,145,057
1,660,721
259,617
189,962
2,110,300
201,686
-
193,458
-
183,819
-
174,685
-
164,794
-
155,511
-
146,377
-
139,693
-
134,122
-
126,326
-
119,642
-
131,768
-
EQUITY
Common Stock
Capital Surplus
Distributions
Retained Earnings
Less: Treasury Stock
Total stockholders equity
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
140
140
140
140
140
140
140
140
140
140
140
(834,970) (834,970) (834,970) (834,970) (834,970) (834,970) (834,970) (834,970) (834,970) (834,970) (834,970)
1,472,675 1,657,780 1,841,112 1,962,852 2,120,964 2,309,035 2,452,586 2,555,794 2,710,252 2,861,767 2,938,174
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
589,845
774,950
958,282 1,080,022 1,238,134 1,426,205 1,569,756 1,672,964 1,827,422 1,978,937 2,055,344
2,000
140
(834,970)
3,037,099
50,000
2,154,269
TOTAL LIABILITIES AND EQUITY
3,133,345
4,396,337
ASSETS
Cash and Short-Term Investments
Receivables
Inventories - Total
Other Current Assets
Total Current Assets
Debt
Deferred Taxes
Minority Interest
Other Liabilities
3,484,686
3,579,299
3,967,667
3,618,677
3,872,231
3,899,102
3,814,999
4,352,918
4,173,387
4,320,043
B/S Forecast
Jan
2011
Feb
2011
Mar
2011
Apr
2011
May
2011
Jun
2011
Jul
2011
Aug
2011
Sep
2011
Oct
2011
Nov
2011
Dec
2011
2,966,761
650,559
680,890
4,298,210
3,163,363
729,173
763,170
4,655,706
3,314,374
740,952
775,498
4,830,823
3,411,857
756,157
791,413
4,959,427
3,576,505
768,734
804,576
5,149,815
3,750,739
818,720
856,893
5,426,352
3,923,220
788,315
825,070
5,536,604
4,011,814
701,024
733,709
5,446,548
4,155,440
665,853
696,898
5,518,191
4,275,231
716,847
750,270
5,742,348
4,338,806
578,625
605,603
5,523,034
4,505,430
620,585
649,520
5,775,535
Property, Plant, and Equipment, Gross
Depreciation, Depletion, and Amortization
(Accumulated)
Property, Plant, and Equipment, Net
1,826,026
1,860,614
1,865,796
1,872,486
1,878,020
1,900,012
1,886,635
1,848,230
1,832,755
1,855,191
1,794,378
1,826,957
1,539,800
286,226
1,539,800
320,814
1,539,800
325,996
1,539,800
332,686
1,539,800
338,220
1,539,800
360,212
1,539,800
346,835
1,539,800
308,430
1,539,800
292,955
1,539,800
315,391
1,539,800
254,578
1,553,918
273,039
Investments and Advances
Intangibles
Other Assets
TOTAL ASSETS
4,584,436
4,976,520
5,156,820
5,292,113
5,488,034
5,786,564
5,883,439
5,754,977
5,811,147
6,057,740
5,777,612
6,048,574
LIABILITIES
Accounts Payable
Accrued Expense
Other Current Liabilities
Current Liabilities
1,579,607
344,386
141,738
2,065,731
1,770,489
386,003
152,825
2,309,316
1,799,088
392,238
145,233
2,336,559
1,836,009
400,287
144,599
2,380,895
1,866,546
406,945
147,684
2,421,174
1,987,916
433,406
131,493
2,552,815
1,914,090
417,310
178,148
2,509,548
1,702,142
371,101
194,608
2,267,851
1,616,744
352,483
207,569
2,176,795
1,740,561
379,478
158,735
2,278,774
1,404,947
306,307
178,682
1,889,936
1,506,829
328,519
189,962
2,025,311
201,686
-
193,458
-
183,819
-
174,685
-
164,794
-
155,511
-
146,377
-
139,693
-
134,122
-
126,326
-
119,642
-
131,768
-
EQUITY
Common Stock
Capital Surplus
Distributions
Retained Earnings
Less: Treasury Stock
Total stockholders equity
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
140
140
140
140
140
140
140
140
140
140
140
(834,970) (834,970) (834,970) (834,970) (834,970) (834,970) (834,970) (834,970) (834,970) (834,970) (834,970)
3,199,849 3,356,576 3,519,272 3,619,364 3,784,896 3,961,068 4,110,344 4,230,263 4,383,059 4,535,470 4,650,864
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
50,000
2,317,019 2,473,746 2,636,442 2,736,534 2,902,066 3,078,238 3,227,514 3,347,433 3,500,229 3,652,640 3,768,034
2,000
140
(834,970)
4,774,325
50,000
3,891,495
TOTAL LIABILITIES AND EQUITY
4,584,436
6,048,574
ASSETS
Cash and Short-Term Investments
Receivables
Inventories - Total
Other Current Assets
Total Current Assets
Debt
Deferred Taxes
Minority Interest
Other Liabilities
4,976,520
5,156,820
5,292,113
5,488,034
5,786,564
5,883,439
5,754,977
5,811,147
6,057,740
5,777,612
Free Cash Flow
Jan
2011
FREE CASH FLOW (FCF)
Profit after tax
Add back depreciation
Change in net working capital
Increase in operating current assets
Add increase in operating current liabilities
Subtract capital expenditures
Subtract increase in other assets
Add back after-tax interest
FCF
Feb
2011
Mar
2011
Apr
2011
May
2011
Jun
2011
Jul
2011
Aug
2011
Sep
2011
Oct
2011
Nov
2011
Dec
2011
162,750
-
156,727
-
162,696
-
100,091
-
165,533
-
176,172
-
149,276
-
119,920
-
152,796
-
152,411
-
115,394
-
123,461
-
159,002
(44,569)
(40,821)
357,496
243,585
42,816
175,117
27,242
14,821
128,603
44,336
15,824
190,388
40,280
15,424
276,537
131,641
31,276
110,252
(43,267)
(4,243)
(90,057)
(241,697)
(31,721)
71,643
(91,056)
(9,903)
224,157
101,978
30,232
(219,314)
(388,838)
(54,130)
252,501
135,375
6,335