HPL (NPV Analysis with Constant Growth) Operating Results:
Total Capacity (000's) Capacity Utilization Unit Volume
Selling Price Per Unit - Growing at
3.0%
Revenue
Production Costs:
Raw aterials Per Unit Growing at an!"act!ring #$erea& Growing at aintenance pense Growing at
3.0% 3.0% 3.0%
Salaried Labor Cost:
anagers $erage nn!al *!lly +oa&e& Cost
3.0%
Total Salaried Labor Cost
Hourly Labor Cost:
$erage *!lly +oa&e& ,o!rly Cost ,o!rs Per ear
3.0%
Cost Per Hourly Employee
!/er o" ,o!rly 1or2ers Total Hourly Labor Cost (000's)
Selling General 4 &/inistrati$e5Re$en!e Total Labor Cost
Less Ra! "aterials Costs Less Labor Cost Less "anu#a$turin% &veread Less "aintenan$e Epense Less Sellin% *eneral + ,dministrative
E-.T/, Less /epre$iation E-.T Less Taes &P,T
Un-levered Free Cash Flow:
60%
&P,T Plus /epre$iation (Less Can%e in et 1ied ,ssets) Less Can%e in et 2or3in% Capital
Un4levered 1ree Cas 1lo!
7.38%
Cost o# Capital Pre se n tVa l u eo#Un 4l e v e re d1 C1 Pre se n tVa l u eo#Re t u r no #2or 3i n %Ca p i ta l
56 7 8 9
5 6 7 8 9 9 : 5 ;
.n v e s t m e n t P(V P e rt e s eV na t lue )
5 6 00 0 5 05 0
or!ing Capital "ssu#ptions $%&:
9ays Sales #!tstan&ing 9ays Sales :n$entory 9ays Payale #!tstan&ing
'alance Sheet (ata: ,$$ounts Re$eivable .nventory ,$$ounts Payable + ,$$rued Liabilities 2 e tor 3 iC n %a p i ta l
: < 7 : ;
Pro p e r tyPl a n+ E t =ui pme nt
5 6 00 0
Tot.anl v e s t eCda p i t a l
6; 7: ;
"sset )**iciency:
R# T#
HPL (EVA Analysis with Constant Growth) +nvested Capital: -e%innin% -alan$e Plus Can%e in 2or3in% Capital Less /epre$iation Endin% -alan$e
)," "nalysis:
&P,T Less Capital Car%e EV,
7.38%
Cost o# Capital Pre se nV t a l uo eE # V, Pre se n tVa l u eo#Re t u r no #2or 3i n %Ca p i ta l L e sPs
:<; >>
: < ; > > 9 : 5 ; :: 7 ; 9 5 05 0
HPL (NPV Analysis Using Gates´ Assumptions) Operating Results:
Total Capacity (000's) Capacity Utilization Unit Volume
Selling Price Per Unit - Growing at
;.0%
Revenue
Production Costs:
Raw aterials Per Unit Growing at an!"act!ring #$erea& Growing at aintenance pense Growing at
<.0% 3.0% 3.0%
Salaried Labor Cost:
anagers $erage nn!al *!lly +oa&e& Cost
3.=%
Total Salaried Labor Cost
Hourly Labor Cost:
$erage *!lly +oa&e& ,o!rly Cost ,o!rs Per ear Cost Per Hourly Employee
!/er o" ,o!rly 1or2ers Total Hourly Labor Cost (000's)
Selling General 4 &/inistrati$e5Re$en!e Total Labor Cost
Less Ra! "aterials Costs Less Labor Cost Less "anu#a$turin% &veread Less "aintenan$e Epense
3.=%
Less Sellin% *eneral + ,dministrative
E-.T/, Less /epre$iation E-.T
60%
Less Taes &P,T
Un-levered Free Cash Flow: &P,T Plus /epre$iation (Less Can%e in et 1ied ,ssets) Less Can%e in et 2or3in% Capital
Un4levered 1ree Cas 1lo!
7.38%
Cost o# Capital Pre se n tVa l u eo#Un 4l e v e re d1 C1 Pre se n tVa l u eo#Re t u r no #2or 3i n %Ca p i ta l
5; 0 90
5 ; 09 0 < 8 5 :
.n v e s t m e n t P(V P e rt e s eV na t lue )
5 6 00 0 5 8 ; :
or!ing Capital "ssu#ptions $%&:
9ays Sales #!tstan&ing 9ays Sales :n$entory 9ays Payale #!tstan&ing
'alance Sheet (ata: ,$$ounts Re$eivable .nventory ,$$ounts Payable + ,$$rued Liabilities 2 e tor 3 iC n %a p i ta l
: < 7 : ;
Pro p e r tyPl a n+ E t =ui pme nt
5 6 00 0
Tot.anl v e s t eCda p i t a l
6; 7: ;
"sset )**iciency:
R# T#
HPL (EVA Analysis Using Gates´ Assumptions) +nvested Capital: -e%innin% -alan$e Plus Can%e in 2or3in% Capital Less /epre$iation Endin% -alan$e
)," "nalysis: &P,T Less Capital Car%e EV,
7.38%
Cost o# Capital Pre se nV t a l uo eE # V, Pre se n tVa l u eo#Re t u r no #2or 3i n %Ca p i ta l L e sPs
: 9 : 95
: 9 : 9 5 < 8 5 : :: : 0 5 5 8 ; :
<008
80000
<0:0
80000
<0::
80000
<0:<
80000
60.0%
65.0%
70.0%
75.0%
57000
6<000
6>000
>0000
1.82
1.88
1.93
8570:
:06:6>
::>057
1.77
758>0
0.76 37;0 ;;=0
0.7> 6038 ;3<8
<.00 6<=7 ;38>
<.03 6;83 ;6=7
<0:9
80000 80.0%
>5000 1.99
:<;587
<.0? 66<; ;=3;
<0:5
80000 85.0%
>7000 2.05
:98690
<.07 6=66 ;?08
6
6
?
?
?
?
160.0
164.8
169.7
174.8
180.1
185.5
>50?0
>68?<
:058?0
:070?6
:0:7?6
:::8
;0.00
;0.?0
;<.;;
;<.8=
;;.=<
;3.<7
2,000
2,000
2,000
2,000
2,000
2,000
50000
5:<00
5<59>
59;08
6=0
6>3
:7000?0
:85;>?5
>.8%
>.8%
>.8%
:7>50?0
<0:96?>
<<><<
=07
=6=
<:>09?7
<975:?9
>.8% <5780?9
>:>90
560<0
=8; <>:89?;
>.8% <;<;5?:
>;;::
5>9;:
?<8 <7>>6?;
>.8% <8;;7?>
56:<0
6095>
6675>
:7>50
<0:9>
<<><<
<5780
<;<;5
98<0
5097
5:68
5<79
55:<
5655
<<60
<9:7
<97;
<568
<69<
<>07
>685
;967
7:>:
800;
8786
:07<8
759>
:0>0>
::87:
:9;;8
5000
5000
5000
5000
5000
5000
559>
>>0>
;87:
8;;8
::>;9
:9>>8
:;;5 <>><
<>59 98>5
9:8< 5;78
98:: 67>;
5>>8 ;005
65>7 7<0:
:6>;9
;5:0: <8;;8
:;>>8
<>><
98>5
5;78
67>;
;005
7<0:
5000
5000
5000
5000
5000
5000
:<7:;
:687
( > : 6> )
> 9> >
; :8 5
7 :6>
8 < 05
:09:0
( 6 > <7 )
6 9<:
6 58 ;
6 > 8 7
6 7 ; 8
> 0 <:
6>.? 3>.? 36.;
6>.? 3>.? 36.;
6>.? 3>.? 36.;
6>.? 3>.? 36.;
6>.? 3>.? 36.;
6>.? 3>.? 36.;
:686
:;::
:;88
:78:
<008
<0:0
<0::
<0:<
<0:9
<0:5
::<<9
:<6<9
:978:
:69<8
:>75<
:759:
77>6
878<
:08;<
:<:07
:9909
;<;0
;888
776<
8;:>
:0><5
::6;7
:<7:;
:55:6
:>0:0
:;;<<
:86<:
<:5:<
5:000
9;000
99000
<8000
<6000
<:000
697:;
6:5:6
580:0
5>;<<
556<:
5<5:<
6.7% <.?
>.>% <.8
7.8% ;.<
<;.?% ;.=
<=.>% ;.7
:5668
<7.3% 3.3
<008
<0:0
<0::
<0:<
<0:9
<0:5
56000
697:;
6:5:6
580:0
5>;<<
556<:
:<7:; 5000
:687 5000
:686 5000
697:;
6:5:6
580:0
:;:: 5000 5>;<<
:;88 5000 556<:
:78: 5000 5<5:<
;??; 6;;0 (<==7)
( : 5 <6 )
<008
80000
37?6 =06> (<086)
( 8 0> )
<0:0
80000
6>87 68;; (33)
(<>)
<0::
80000
=8?> 6=7> <;><
77 7
<0:<
80000
60.0%
65.0%
70.0%
75.0%
57000
6<000
6>000
>0000
1.81
1.84
1.88
8977:
:09:<5
::<;00
1.77
758>0
0.76 37;0 ;;=0
0.7= 6038 ;3<8
0.7? 6<=7 ;38>
0.7> 6;83 ;6=7
>006 638; ;?;;
: > ;6
<0:9
80000 80.0%
>5000 1.92
:<<>:7
0.78 66<; ;=3;
8;0< 6<>= 60;?
< 9 6:
<0:5
80000 85.0%
>7000 1.95
:9<77;
0.77 6=66 ;?08
6
6
?
?
?
?
160.0
165.6
171.4
177.4
183.6
190.0
>50?0
>>5
:0>5?5
::0:?>
:0<7?5
::50?<
;0.00
;0.>0
;<.6;
;;.<>
;;.7=
;3.>=
2,000
2,000
2,000
2,000
2,000
2,000
50000
5:500
5<758
55958
6=0
6>3
:7000?0
:86;0?8
>.8%
>.8%
>.8%
:7>50?0
<0<99?9
<<755
56:<0
589>8
69>87
67:08
><>09
>;:7:
:7>50
<0<99
<<75<
<6<66
<;707
90607
98<0
5097
5:68
5<79
55:<
5655
<<60
<9:7
<97;
<568
<69<
<>07
=07
=6=
<:7:5?0
<5:80?<
>.8% <6<65?>
5680:
=8; <>;0>?0
>.8% <;70;?>
5;60;
?<8 <89>7?<
>.8% 90607?5
>685
;<7>
7005
7;5;
86:;
:09:5
759>
:0>9;
:<095
:9757
:6;5>
:;;9<
5000
5000
5000
5000
5000
5000
559>
>>9;
7095
8757
::;5>
:9;9<
:;;5
<>66
9<:5
9898
5>88
6589
<>><
987<
57<:
6808
;057
7<98
<>><
987<
57<:
6808
;057
7<98
5000
5000
5000
5000
5000
5000
:<7:;
:5;:
:550
:6<;
:679
:>5:
( > : 6> )
> 6: <
; 97 :
7 97 <
8 5>6
:0687
( 6 > <7 )
6 559
6 > 5 0
6 7 6 >
> 0 5>
> : 78
6>.? 3>.? 36.;
6>.? 3>.? 36.;
6>.? 3>.? 36.;
6>.? 3>.? 36.;
6>.? 3>.? 36.;
6>.? 3>.? 36.;
<008
<0:0
<0::
<0:<
<0:9
<0:5
::<<9
:<50:
:9><<
:577;
:>:8;
:;665
77>6
8;8>
:0;>0
::;68
:<;85
:97>6
;<;0
;808
7>65
898<
:0:65
:085:
:<7:;
:5<77
:6;<7
:;<66
:7797
<05;8
5:000
9;000
99000
<8000
<6000
<:000
697:;
6:<77
57;<7
5><66
59797
5:5;8
6.7% <.?
>.8% <.8
7.7% ;.<
<;.8% ;.6
.<% ;.8
<7.7% 3.;
<008
<0:0
<0::
<0:<
<0:9
<0:5
56000
697:;
6:<77
57;<7
5><66
59797
:<7:;
:5;:
:550
:6<;
:679
:>5:
5000
5000
5000
5000
5000
5000
697:;
6:<77
57;<7
5><66
59797
5:5;8
;??; 6;;0 (<==7)
378; =06> (<0?=)
( : 5 <6 )
(7 80)
68;< 68<0 <<
7
=707 6=>0 <337
8 96
>068 6338 ;><0
: ; 9:
8;37 6<<< 6<;8
<5:0
<0:6
80000
<0:>
80000
<0:;
80000
<0:7
80000
85.0%
85.0%
85.0%
85.0%
>7000
>7000
>7000
>7000
2.11
2.18
:59;:>
<.<; 6?8< ;?8>
:570<7
<. 68;< ;>?>
2.24
:6<5>7
<.<7 67?? ;8=0
2.31
:6;059
<.;3 =<<= ;73?
?
?
?
?
191.0
196.8
202.7
208.8
::5>?9
::70?;
:<:>?:
:<6>
;3.88
;6.?0
;=.36
;?.<0
2,000
2,000
2,000
2,000
5;;><
58:86
60>;:
?<8
?<8
?<8
<86<6?;
905::?5
9:9<9?7
>.8%
>.8%
>.8%
90>;:?8
9:68
9<698?8
;>9<5
;7>:5
708;<
7950:
90>;<
9:68<
9<650
996:>
6<:8:
?<8 9<<>9?6
>.8% 996:>?:
5>7:
57<:
58>>
<>7;
<;>;
<760
<89>
6::6
:::65
::578
::795
:<:78
:7:88
:7;56
:890;
5000
5000
5000
5000
:5:88
:5;56
:690;
:677>
6>70 76:8
6787 775;
>:<9 8:75
>966 869<
:877>
76:8
775;
8:75
869<
5000
5000
5000
5000
>5<
>><
>7:
;0<
:<790
::7;;
:<:76
:<609
>95:
6857
6670
6<96 ;;:5
6>.? 3>.? 36.;
6>.? 3>.? 36.;
6>.? 3>.? 36.;
6>.? 3>.? 36.;
<0:6
<0:>
<0:;
<0:7
:7875
:8665
<0:5:
<0;56
:5886
:6556
:6808
:>97>
::8<6
:<<79
<<066
<<;:>
<9987
<5:00
:;000
:9000
8000
6000
98066
96;:>
9<987
<8:00
;<.8% 3.>
;6.8% 6.<
;8.3% 6.>
:<>6:
:909:
3;.8% =.6
<0:6
<0:>
<0:;
<0:7
5<5:<
98066
96;:>
9<987
>5< 5000
>>< 5000
>7: 5000
;0< 5000
98066
96;:>
9<987
<8:00
8=<7 37>8 6=6;
<5<6
886> 3??3 =<86
<69:
7<86 33=0 =83=
<>05
7=3; 3038 ?673
<>58 ;;:5 <8:00
<0:6
80000
<0:>
80000
<0:;
80000
<0:7
80000
85.0%
85.0%
85.0%
85.0%
>7000
>7000
>7000
>7000
2.03
2.07
2.12
:5:0<:
:5975:
1.99
:96656
<.00 6?8< ;?8>
:97<6>
<.0< 68;< ;>?>
<.0; 67?? ;8=0
<.03 =<<= ;73?
?
?
?
?
196.7
203.6
210.7
218.1
::70?:
:<<:?5
:<>5?:
:907?5
;6.=7
;=.6=
;?.36
;>.;?
2,000
2,000
2,000
2,000
58:;0
6078:
6<>;<
?<8
?<8
9098>?:
656:>
?<8
?<8
9:5>0?0
9<6>:?:
99;00?;
>.8%
>.8%
>.8%
9:6;>?<
9<>7:?5
997<6?<
>;76<
>769:
>8<:>
>8807
9:6;>
9<>7:
997<6
96008
5>7:
57<:
58>>
<>7;
<;>;
<760
>.8% 96008?:
6::6 <89>
:06<0
:0;90
:0856
:::>5
:7<<8
:7;<6
:8<:7
5000
5000
5000
5000
:5<<8
:5;<6
:6<:7
:6;08
6>8<
6780
>07;
><75
769;
7796
8:9:
85<>
:8;08
769;
7796
8:9:
85<>
5000
5000
5000
5000
5<9
59:
597
55>
:<870
:<::5
:<505
:<>89
>5>7
>066
6>>6
6<8> ;<0;
6>.? 3>.? 36.;
6>.? 3>.? 36.;
6>.? 3>.? 36.;
6>.? 3>.? 36.;
<0:6
<0:>
<0:;
<0:7
:;806
:7<>9
:7><7
:800:
:5:59
:55<>
:5;:5
:6007
:::5>
::96>
<080<
<:99<
<:;;0
<<<:>
:;000
:9000
8000
6000
9;80<
9599<
90;;0
<;<:>
;;.=% 3.?
;=.>% 6.0
;7.>% 6.?
::6;<
::;89
36.?% =.3
<0:6
<0:>
<0:;
<0:7
5:5;8
9;80<
9599<
90;;0
5<9
59:
597
55>
5000
5000
5000
5000
9;80<
9599<
90;;0
<;<:>
8=3> 3870 6?6>
<57:
883= 3=== =;80
<6;;
7<3< 3;;0 =7<<
<>97
76;? ;88? ?=60
<>>7 ;<0; <;<:>