Thursday, July 13, 2006

AMERICAN CHEMICAL CORPORATION

1. Executive Summary

Dixon, an American specialty chemical producer, wants to buy Collinsville plant from American Chemical Corporation, another typical chemical company in 1979. Dixon wants to diversify its product line buy acquiring the aforesaid plant, which produces sodium-chlorate to supply to paper producers in Southeastern part of the US. This plant initially cost 12 mln. USD and additional 2,25 mln. USD needed to buy laminate technology to increase efficiency and profitability of the plant in order.

Dixon has conducted thorough marketing research for the industry providing cash flow analysis on purchase of the plant. The cash flow analysis based with and without laminate technology cases, where the company should decide whether it should go on further to buy that plant and technology.

2. Calculating of WACC

2.1 Assumptions for calculations in the case:
l Plant life is 10 years (p.4)
l Salvage value of plant is 0 (p.4)
l Book value of plant at end of 1979 is 10.6 million (=12 million purchase price - 1.4 million working capital)
l Tax rate is 48% (calculated from Exhibit 7)
l For the period from 1980 to 1984: all data of sales, depreciation and manufacturing and other costs are given in the case (Exhibit 8)
l For the period from 1984 to 1989 we use the below assumption:
- Price growth rate is 8% (p.4)
- Power cost growth rate is 12% (p.4)
- Net working capital is always 9% of sales (Exhibit 8, current asset and liability items remain historical to sales)
- PPE and depreciation are based on historical data in 1980-1984 period (Exhibit 8)
- Capital investment are based on historical data in 1980-1984 period (Exhibit 8)
- Variable and fixed costs: we use 4-year average growth rates calculated based on Exhibit 8. So non-power variable cost growth rate is 11%, fixed cost growth rate is 6%, selling expenses growth rate is 7% and R&D expenses growth rate is at 5%
- To use this 4-year average growth rates, we assume that the scale of operations of this plant is constant so we need to adjust such cost growths to account for inflation. If the scale increases we should consider growths in costs on percentage of sale basis

2.2 Cost of capital:

a. Calculate beta β of sodium chlorate:

The β of Dixon is 1.06 (Exhibit 7). This beta may be irrelevant to the project to buy Collinsville plant because Dixon produces specialty chemical products but never produce sodium chlorate. The systematic risk of the project could be the risk of the production of sodium chlorate in the industry. Therefore, we calculate beta of the project based on the beta of the sodium chlorate industry.

We do not simply use the beta of Brunswick and Southern, 2 firms purely produce sodium chlorate, because they are small in the industry and their stocks might not be traded largely on the market. Hence, we decide to calculate the beta of all firms that produce sodium chlorate to see the trend of beta of all firms in the market since we believe that such trend can be a benchmark for calculating the beta of sodium chlorate for Dixon’s project.

The average beta is calculated from the formula: βasset = βequity / [1+ (1-t)*D/E], where D is debt, E is equity and t is tax rate. To simplify the calculation, we assume that all these firms have tax rate at 48% and βdebt is zero. The detailed calculation is provided in the Appendix 1. From the table, we notice that the betas of 3 diversified chemical producers American Chemical, Kerr-McGee and Int. Minerals and Chemicals (Ga is a paper company and Pennwalt is a large diversified chemical producer) is less than the market beta (1.00). We also observe that the two pure play firms (last 2 rows) have higher beta than the market beta. Thus, sodium chlorate may have higher beta than other chemical products. Because sodium chlorate is totally new to Dixon, we assume that Dixon plays the role of a pure sodium chlorate producer and consider the average of the beta of Brunswick and Southern as the beta for Dixon in this project. This beta is β=1.09. The beta 1.09 seems more reasonable as Dixon may have more risk to take the project than other companies who already produce this product for a long time.

Now, Dixon needs to re-lever this beta by using its own target capital structure (35%, p.4). The formula for re-levered beta is: βlevered equity = βasset * [1+ (1-t)*D/E] = 1.09*[1+(1-0.48) *0.35/0.65] = 1.40.

b. Weighted average cost of capital (WACC):

Cost of equity: in the case, the yield on Tbonds is 9.5% (p.4). We assume that it is the risk free rate. We use the historical equity risk premium 8.4% stated on the Table 9.2, page 247 of the textbook. According to the CAPM method, the cost of equity for this project is 9.5%+1.38*8.4% = 21.26%.

Cost of debt: because there is little information about Dixon’s debt provided on the case, we assume that all debt Dixon intends to borrow is used in the acquisition of Collinsville plant at 11.25%. We also assume that debt is issued at par. The after-tax cost of debt is (1-0.48)*11.25% = 5.85%.

WACC: we use Dixon’s 35% target level of debt-to-asset ratio in acquiring the plant to calculate cost of capital. WACC = D/V*After-tax cost of debt + E/V*Cost of equity = 0.35*5.85%+0.65*21.26% = 15.87% @ 16%. Therefore, the WACC for Collinsville’s plant cash flow is nearly 16%. We use this cost of capital to calculate NPV of the project.

3. Calculating NPV

To calculate the NPV for the project we have observed two cases during the investment: purchasing the plant without laminate technology and with laminate technology.

3.1 Without laminate technology
We have calculated NPV on the basis of the current cash flow provided in appendixes of the case and information provided in case material. So we have used the data in Exhibit 8 and projected cash flow from 1980 to 1984, and we have calculated cash flow to 1989 based on our assumptions aforesaid. For further details please refer to Appendix 2.

It had resulted on NPV being negative – 3,703 thousand USD.

3.2 With laminate technology
Case defines us some cost reductions and benefits such as graphite cost elimination, tax benefits and power cost savings, since 2,25 mln. USD worth of laminate technology is bought and installed. So we had calculated additional NPV, which has derived from cost savings and tax benefits we have out of buying the additional laminate technology. Our assumption is NPV with laminate technology = NPV without laminate + NPV additional savings.

From this approach we have calculated Additional NPV of 6,634 thousand USD in Appendix 3.

So NPV with laminate technology is -3,703+6,634=2,931 thousand USD.

4. Sensitive analysis

In order to see whether the project is viable in case of negative changes in variables, we have conducted sensitive analysis having one of major variables such as sales growth rate, which can be reflected by different reasons such as decrease in demand, production slowdown, economic recession and etc. We have tried other possible valuables, but they occasionally did not have much effect on the project outcomes.

We wanted to know what is the rate of growth rate should be in both cases (without and with laminate technology) so that the company will have Zero NPV. Using Solver function in Excel, we found that in case of Zero NPV without laminate technology sales growth rate should kept up around 14% and with laminated technology growth rate should not go down of around 2% level (Please see Appendix 4).

5. Strategic and economic benefits

Besides increasing shareholders wealth, company gets some strategic and economic benefits, such as:
- Increase in product range
- Larger market share in paper industry
- Opportunities to enter new market
- New market development and competition reduction
- Enhancement of relationships with current customers
- Development of new technology

By acquiring Collinsville plant, Dixon could complement its strategy of supplying chemicals products to the paper and pulp industry. It can use the existing sales force to market products to save selling costs. Dixon will add a new product in its existing product mix.

Laminate technology would allow company to considerably cut power cost and completely eliminate graphite costs. By gaining technological savvy, the company can use the same practices in other plants and reduce production costs.

Company has developed the relationships with Collinsville existing customers. It is 6 more times cheaper to retain existing customer than acquire a new one. Buying plant, company will not incur potential marketing costs in initial selling of new products.

The company is better off buying the plant than building from the scratch a new one. Usually, plants are costly to build. Also, the company can reduce competition in the market. Buying a plant would be the best entry strategy for company. Building a plant would take a year, and market is changing rapidly, so Dixon could lose market potential if it takes a long time to build a new plant.

Laminate technology makes the Collinsville plant acquisition attractive on economic grounds. In acquisition negotiation, Dixon should make a clause in the acquisition agreement, which protects the Dixon in the case that the laminate technology fails to produce the desired results. This clause should include that in the case the laminate technology fails, American Chemical Corporation should compensate Dixon for installation charges.  






6. Recommendations

Based on our analysis, we would like to make recommendations as follows:

Most fundamentally, a firm that is operating in the interests of its shareholders should try to accept all projects that increase the wealth of the shareholders. In case of Collinsville, we use NPV to approach to our recommendations.

Based on our calculation, without the laminate addition, the NPV of Collinsville turns out to be negative (-3,703 thousand USD). Under this circumstance, we recommend not to invest in this project since it is against shareholders interests.

But at the same time new Laminate Technology would allow company to considerably cut power cost and completely eliminate graphite costs. Additional $2.25 mln. USD is needed to install this new technology. We consider this technology as a subproject attached to Collinsville and calculate its NPV. The NPV of this new technology is 6,634 thousand USD. That means, by using laminate technology, NPV of Collinsville will change to 2,931 thousand USD. Under this new circumstances, our recommendation is to invest in Collinsville because it will not only increase the wealth of the shareholders, but also complement its strategy of supplying chemicals products to the paper and pulp industry.

105 comments:

Unknown said...

Very helpul. I never seen such a good explanation for the solutions of case study. Really appreciable!
Thank you a lot

Joe said...

hi,
could you please email the workings for the npv you did.

cheers,
Jan
dewolff_jan@yahoo.com

sonrisa said...

Would you like to send me the calculations for npv of both with laminate and W/O laminate tech. ?
my adress : best_forever_85@hotmail.com

Sanjana Kapoor said...
This comment has been removed by the author.
Sanjana Kapoor said...

thanks! very helpful. could you mail me the excel sheet how you worked out the FCF, Discount rates and WACC. thanks!
this.is.sanjana.kapoor@gmail.com

Juan Sebastian said...

Thankx for answers!!!
Could you help me with the calculations of the answers??

I have a quiz tomorrow!!!!

Send me to juanse3408@gmail.com

BB said...

Thankx for answers!!!
Could you help me with the calculations of the answers??

I have a report tomorrow!!!!

Send me to aids9632001@hotmail.com

thank you!!

Silverun430 said...

Hi can you please email me your calculations or excel worksheets. Your blog has been very helpful and I'm trying to follow your exact work to get a more in depth understanding.

my email is silversun430@gmail.com

Unknown said...

could you send me the excel sheet for your work too. Thanks a bunch.
hphan082@gmail.com

SoccerMom4U said...

I agree this has really cleared it up for me. If you can can you send my your calculations i am still a little confused on calculating the NPV. Thank You!!!
sweetcocoa87@aol.com

p.p said...

It's a great essay. Very helpful. I want to learn more about this case. Would you please email the appendix caculation to me? My address: 93307035@nccu.edu.tw
Thank you very much!

BigPapi34 said...

Could I please have the appendix and calculations sent to me? My email is thehunted87@aol.com...thanks alot!

BigPapi34 said...
This comment has been removed by the author.
paul said...

hi thanks for your job
could you please email me the Appendix and calculations to paulluyao@hotmail.com ?
it will be a big help for me! thanks a lot.

Unknown said...

Wow. Its such a valuable answer for the case. Could you send me your excel calculation, pls? My email is ministar1010@yahoo.com. Many thanks!

Unknown said...

I would also appreciate the appendix. Thank you very much!

shmeir@gmail.com

Asad27 said...

ASAD said
very helpful can u send the working for NPV with failure and without failure and

fails with probability of 25% after the purchase
at this email address
ali.rahman2005@gmail.com

Unknown said...

Thanks for the solution.
Can you please email me the working for NPV and other spreadsheets..

Thanks again
email: dasser143@gmail.com

Reebs said...

I would also love your Excel calculations! This is incredible how you explained this case!

Thanks! Rebecca

rebeccas@propaganda-inc.com

Unknown said...

Extremely good explanation.
Could you please send me send me the calculations for FCF, npv of both with laminate and W/O laminate tech. ?
Thanks
aeckarth@gmail.com

Unknown said...

this explanation is great!!!could you send me the calculations of the NPV, FCF in both cases?thnx

Unknown said...

Excellent analysis, can you please e-mail me the appendix: advanimohnish@gmail.com

thanks in advance,

Mohnish

Anonymous said...

Very informative, though I would like to see the all the calculations you have for clarification purposes. I would appreciate it if you can email the excel sheet you have to jluvs454@gmail.com.
Thank you so much, John

Anonymous said...
This comment has been removed by the author.
Anonymous said...

Very informative, though I would like to see the all the calculations you have for clarification purposes. I would appreciate it if you can email the excel sheet you have to jluvs454@gmail.com.
Thank you so much, John

Unknown said...

Can I please get the Appendixes?

My E-mail

y0077@walla.com

10x

Unknown said...

Good evening. Thanks for your kindly help. Please can you send me the calculations made. I have a workgroup and I don´t manage to discover the solution of this case.

sousacarlos13@hotmail.com

Thanks for your help

Carlos Sousa (Portugal)

Unknown said...

Thank you so much, excellent job. This case has been a problem for me. You have cleared up few things for me.

Can you please email me the working for NPV and other spreadsheets.

Thank you again!

David

smithdavid726@gmail.com

J Thunder said...

Can you please send your excel solutions to jthunder20@gmail.com?

This is excellent work. Currently working on the case!

Daisy said...

Your analysis is very good !
Would you like to send me your calculations of appendix?
Thank you very much
My email address is
daisy_gapsy@hotmail.com

Unknown said...

Western Chemical Corporation\: Recognizing the Types and Roles of Information Systems
Western chemical uses the internet and an electronic commerce website to connect to its customers and suppliers, and to capture data and share information about sales orders and purchases. Sales order data are processed immediately, and inventory and other databases are updated. videoconferencing and e-mail services are also provided.
Data generated by a chemiocal refinery process are captured by sensors and processed by a computer that also suggests answers to complex refinery problem posed by an engineer. Managers and business professionals access reports on periodic, exception, and demand basis, and use computers to interactively asses the possible results of alternative decisions. Finally, top management can access text summaries and graphics displays that identify key elements of organizational performance and compare them to industry and competitor performance.
Western Chemical Corporation has started forming business alliances and using intranets, extranets and the internet to build a global electronic commerce website to offers their customers worldwide products and services. Western Chemical Corporation is in the midest of making fundamental changes to their computer-based systems to increase the efficiency of their e-business operations and their managers' ability to react quickly to changing business conditions.

Read the above case scenario carefully and provide the brief description for the following aspects:
a) Make an outline that identifies how information systems support
1. Business operations
2. Business Decision Making
3. Strategic advantages

b) There are many different types of information systems at Western Chemical Corporation. Identify as many IS as you can in the given case study above.
Explain the reasons for your choices.

Unknown said...

Thank you very much! Your answers have been very helpful! Would you be able to send me the excel spreadsheets by chance? I would like to see how you calculated some numbers. Thanks!

Unknown said...

Sorry! If you could send the excel spreadsheets to:

sharbertson@gmail.com

Thanks!!

Unknown said...

Could you send me the calculations?. . . my email is aguinaga_eduardo@hotmail.com

Thank you

Unknown said...

Hi,

Do you think you can send me the calculation/exhibits for your case analysis?

my e-mail address is serephina0228@gmail.com

Unknown said...

can you please send me the calculations for the cash flows?

Thank you!

Unknown said...

Can you please send me your cash flows you used to calculate the NPV? Thank you!

KristinRFrazier@gmail.com

Unknown said...

Can you send me the appendix for my email?

Thank you

thalynhow_87@hotmail.com
thalynhow@click21.com.br

Giggs said...

Sorry to disturb but i would like some help, what is the problem of this case and what is the result?
Could pls send me an e-mail "rungruang_yorsang@yahoo.com" Thank you very much.

kdwdavid said...

Your analysis is very good !
Would you like to send me your calculations of appendix?
Thank you very much!
My email address is
kdwdavid@hotmail.com

Unknown said...

Hi! a very good and helpful explanation. could you please email me the workings/excel sheet?
thanks a bunch!

Unknown said...

Great work! Very helpful!
Could you send me the sheets with your calculations? (NPVs)
@ giulio.reno@gmail.com

Thanks a lot!

Keer said...

Hi!

I just wanted to thank you for your clear explanations of the case. Very well executed and good job! I have some issues with the calculations, could you please please please send me yours? Thank you sooo much!

All the best,

Keer!

Keer said...

Sorry forgot my email address:
limhamngriffins@yahoo.se

THank you!

Unknown said...

Nice job, the NPV I caculated is different from yours. Could you please send me Appendixes caculation?
Address is
amandahh84@gmail.com
Thank you so much!

Unknown said...

Nice job, the NPV I caculated is different from yours. Could you please send me Appendixes caculation?
Address is
amandahh84@gmail.com
Thank you so much!

B.Allen said...

Hello, I was just wondering if you would mind emailing me the calculation for NPV for with and without. my email is allens.brandon@gamil.com thank you so much your article was a huge help.

B.Allen said...

Hello, I was just wondering if you would mind emailing me the calculation for NPV for with and without. my email is allens.brandon@gamil.com thank you so much your article was a huge help.

Unknown said...
This comment has been removed by the author.
Unknown said...

Hi,


thank you for your help.. can anybody send me the calculation appendix, please?!!!

thanks

dezsi.koppany@gmail.com

Tự học tiếng Đức said...

Thanks for instructions.
Please send me the calculation of NPV and appendix.
rosemary1307@gmail.com
Thank you!
Anyway, where are you now? In Hai Phong?
I'm from Vietnam too but now I study in Taipei
Thanks for the smart solution for many cases

bornwise said...

Could you please send the spreadsheet and appendix of the case.
It will help me understand the case and the integrities of valuation much better. A wonderful work done. Thanks a lot.

My email id :rajkiran.online@gmail.com

bornwise said...

Could you please send me the spreadsheets of the working and the appendix.

dwightschrute said...

Hi,

Could you please send me the Appendices and calculations?

My email is: rdanielkong@gmail.com

Thank you very much!!

Great job!

Unknown said...

Very helpful, can someone email me the excel spreadsheet shaw_maxine@hotmail.com. Thanks

Hank said...
This comment has been removed by the author.
Barcelona User said...

Hi
Thanks a lot !!!
can you please Email me your Excel (will save me a lot of work :) )

Thanks
Yonatan

nadav.orbach@intel.com

María Guadalupe said...

Hi: Thanks for your information it´s very useful for me, but I wonder if you could send me your apendix cause we need some data, please!!! my mail is lichtestalt@hotmail.com and
casb_1407@hotmail.com, I need it cause it´s my Economical Engineering´s exam please
Thank U!!!!

María Guadalupe said...

Hi!!! Congratulations for your information, It´s been very useful for me, and I wonder if you could send me your apendix cause I need some data, it´s for my Economical Engineering´s exam please please, my mail lichtestalt@hotmail.com
casb_1407@hotmail.com
Thanks!!!

carlos manuel said...

I agree this has really cleared it up for me. If you can, could you send me your calculations?? i am still a little confused on calculating the NPV. please i need your appendix and calculations. Thank You!!!
line_tol@hotmail.com

Jenny said...

Is there anyway I can get the calculations on this! I know this post is older but this case is still running strong!! This post is great!! Please let me know! Thanks!! jwestgate57@gmail.com

Pat said...

This is great! thanks a lot!
Could you please send the spreadsheet and appendix of the case.
It will help me understand the case beter. Thanks again

My email :pat19835@gmail.com

Victor said...

Hi. Your analysis was great. Will be great to see your excel calculations. Can you or anyone else please email me at gentleman1725@gmail.com

demil898 said...

Hi.

Could you send me the calculations for this case please?

ilya.demeshev@gmail.com

good sam said...

can i please get the appendix for the american chemical case

tzvika01@aol.com

kos said...

Thank you so much,
Could I also have the appendix please ?
Thanks a lot
kosoma3@hotmail.com

kos said...

Thanks for answers/
Could you send me the appendix please ?
Thanks so much

kosoma3@hotmail.com

kos said...

Thank you so much,
Could I also have the appendix please ?
Thanks a lot
kosoma3@hotmail.com

kos said...

Thank you so much,
Could I also have the appendix please ?
Thanks a lot
kosoma3@hotmail.com

Genji said...

Hi,
Thanks a lot for the case.
Could you please send me all the appendix with the calculation?

Thanks

alia_ashura@hotmail.com

Mikael said...

Hey!!!! Thanks for this information, can you please send me your excel calculations please!!!???? mikael.sandford@gmail.com
Thanks in advance
Mike

Mikael said...

Can you please send me your excel solutions, my email is mikael.sandford@gmail.com?

This is excellent work. Currently Im working on the case and have to give a solution tomorrow haha

Thanks in advance for your help!!
Mike

¬¬ said...

Would be amazing if you could send me your worksheets.

Thanks, alvazquezg@gmail.com

Feedo said...
This comment has been removed by the author.
Feedo said...
This comment has been removed by the author.
Feedo said...

Can you send me you excel work please?
Have final on it tomorrow.

Feedo_h48@hotmail.com

Thank you

MH said...

Hello. Your analysis is great.
I want to learn more about this case.

If you can, Could you send me your calculations for FCF, npv of both with laminate and without laminate tech. ?

My address:
hm19870903@gmail.com

Whitney Wright said...
This comment has been removed by the author.
Unknown said...

Your analysis is great. Thank you for your clear explanations of the case. Very well executed and good job!
I have some difficulty with the calculations, could you please send me the excel sheet how you worked out the FCF, Discount rates and WACC? thanks a lot for your help :)

ilivemydestiny said...

Your analysis is great.
I want to learn more about this case.

Could you send me your calculations for FCF, npv of both with laminate and without laminate tech. ?

My address: jcjitan@gmail.com

Unknown said...

Can you send me your calculations for the npv anf fcf.

Dude your awesome.

jmann2174@gmail.com

Unknown said...

Hey can you send me your calculations for npv anf fcf.

My email is jmann2174@gmail.com

Your awesome dude, this is so helpful

VicenteLeitao said...

thank you for your help! can anybody send me the calculation appendix, please?...

thanks

vicentericciardileitao@gmail.com

VicenteLeitao said...

thank you for your help.. can anybody send me the calculation appendix, please?!!!

thanks

vicentericciardileitao@gmail.com

VicenteLeitao said...

thank you for your help! can anybody send me the calculation appendix, please?...

thanks

vicentericciardileitao@gmail.com

VicenteLeitao said...

thank you for your help! can anybody send me the calculation appendix, please?...

thanks

vicentericciardileitao@gmail.com

VicenteLeitao said...

thank you for your help! can anybody send me the calculation appendix, please?...

thanks

vicentericciardileitao@gmail.com

VicenteLeitao said...

thank you for your help! can anybody send me the calculation appendix, please?...

thanks

vicentericciardileitao@gmail.com

VicenteLeitao said...

thank you for your help! can anybody send me the calculation appendix, please?...

thanks

vicentericciardileitao@gmail.com

Anonymous said...

Hey, thanks a lot for sharing it. I find it very helpful.
I want to learn more about this case.

Could you send me your calculations for FCF, npv of both with laminate and without laminate tech. along with the excel sheet where you did the appendix work.
it will be very happy if you can help me :)

email - manish.live.life@live.com

Anonymous said...

Excellent analysis!

Please send your calculations for the American Chemical Case to me!

pgreene064@gmail.com

Thanks!

Ashwini said...

Hello, excellent solution! Could you please e-mail me the appendices @ ashwini.n87@gmail.com

Unknown said...

Hi there,

If it's still possible could you please email me the appendix's / spreadsheets so I can look at your calculations?

p.george1991@hotmail.com

Thanks very much.

Unknown said...

Hi there,

If it's still possible, could you please send me the appendix's / spreadsheets so that I can look at your calculations?

p.george1991@hotmail.com

Thanks very much.

Unknown said...

Is it possible to get the appendix for this case study? It could be sent to latanyabhall@gmail.com.

Thanks!

sz said...

Great! Could you send me a detailed calculation to my email please? szho6030@uni.sydney.edu.au. Thank you very much

sz said...

Great! Could you send me a detailed calculation to my email please? szho6030@uni.sydney.edu.au. Thank you very much

John said...
This comment has been removed by the author.
John said...

Hey, can you please send me your calculations? The explanation is very helpful. Cheers

kolbenheyer@freemail.hu

Unknown said...

Hello. Your analysis is great.
I want to learn more about this case.

Can you please email me your calculations or excel worksheets for FCF, NPV of both with laminate and without laminate technology ?
Your blog has been very helpful and I'm trying to follow your exact work to get a more in depth understanding.

My address:
mail.antwerpen@gmail.com

hjbhai said...
This comment has been removed by the author.
Unknown said...

Amazing analysis! Thank you very much.

Would you send me your worksheets please?

baselarte@gmail.com

Gabriel said...

Amazing analysis! Thank you very much.

Would you send me your worksheets please?

ga.sainz08@hotmail.com

Gabriel said...

Amazing analysis! Thank you very much.

Would you send me your worksheets please?

ga.sainz08@hotmail.com

Unknown said...

HI,

PLEASE CAN YOU SEND ME THE EXCEL ghizlane.benmoussa@gmail.com