Reference no: EM131310473
Capital Budgeting: Analyzing Project Cash Flows (Alexandria Chemical Products Company)
In early 1980s Alexandria Chemical Products started as a small firm between two friends to produce detergent products. By the end of 1997 the company became a shareholders corporation. Now it is a leading company in the chemical industry.
On July 20, 2011, Mr. Amro, the president of the company met with Mr. Ahmed, vice-president in charge of new product; Mr. Ali, the financial directors; and Dr. Sultan, the R&D director. The purpose of the meeting was to discuss and the capital budgeting decision with regarded the production of a new product. Mr. Amro gave a brief statement about the purpose of the meeting, and immediately gave the floor to Mr. Ahmed.
Mr. Ahmed started his presentation about the new product by providing information about this product, the relationship between the new product and the current products portfolio, as well as the competitive position of the company and the effect of the new products on this competitive position. Mr. Ahmed said that: "the new product requires a new production line which costs $8.5 million; useful life 10 years end with $0.5 million as salvage value." He added that "the new production line will increase cash because it will reduce the payables account by $0.5 million. On the another hand it generates $28.9 million during its useful life while it costs $8.5 million which means $20.4 million net cash. Therefore, I recommend to buy this production line because the new product will add value to the shareholders' wealth. To keep this clear he passed out copies of the projection annual cash flow of this project (table 1).
Mr. Amro thanked Mr. Ahmed and gave the floor to Mr. All who critiqued the approach used by Mr. Ahmed to analyze the project initial investment and the annual cost flow. In addition Mr. Ali said "the method of evaluating this project is not a scientific method." Mr. Ali proposed to use the NPV to evaluate this production line, where the hurdle rate is 18%.
Table 1 - New Product annual cash flow (million dollars)
|
Year
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
Sales
|
3.5
|
4.8
|
6.2
|
9.5
|
16.8
|
18.0
|
15.0
|
12.5
|
9.6
|
6.0
|
|
- COGS
|
2.1
|
2.9
|
3.7
|
5.7
|
10.1
|
10.8
|
9.0
|
7.5
|
5.8
|
3.6
|
|
GOI
|
1.4
|
1.9
|
2.5
|
3.8
|
6.7
|
7.2
|
6.0
|
5.0
|
3.8
|
2.4
|
|
- Annual Depreciation
|
0.8
|
0.8
|
0.8
|
0.8
|
0.8
|
0.8
|
0.8
|
0.8
|
0.8
|
0.8
|
|
NOI
|
0.6
|
1.1
|
1.7
|
3.0
|
5.9
|
6.4
|
5.2
|
4.2
|
3.0
|
1.6
|
|
- Interest
|
0.48
|
0.48
|
0.48
|
0.48
|
0.48
|
0.48
|
0.48
|
0.48
|
0.48
|
0.48
|
|
EBT
|
0.1
|
0.6
|
1.2
|
2.5
|
5.4
|
5.9
|
4.7
|
3.7
|
2.6
|
1.1
|
|
- Taxes (25%)
|
0.03
|
0.16
|
0.30
|
0.63
|
1.36
|
1.48
|
1.18
|
0.93
|
0.64
|
0.28
|
|
NI
|
0.1
|
0.5
|
0.9
|
1.9
|
4.1
|
4.4
|
3.5
|
2.8
|
1.9
|
0.8
|
|
+ Annual Depreciation
|
0.8
|
0.8
|
0.8
|
0.8
|
0.8
|
0.8
|
0.8
|
0.8
|
0.8
|
0.8
|
|
Annual Cash Flow
|
0.9
|
1.3
|
1.7
|
2.7
|
4.9
|
5.2
|
4.3
|
3.6
|
2.7
|
1.6
|
1. If you were Mr. Ali, the financial director, what are the mistakes Mr. Ahmed did when he analyzed the project cash flow?
2. Calculate the initial investment and the annual cash flow.
3. Calculate the NPV for this capital budgeting project.
4. According to NPV, Should the company buy this production line?
|
What is actual finance charge for the first three months
: Peg Gasperoni bought a $50,000 life insurance policy for $100 per year.- What is the actual finance charge for the first three months?
|
|
How much charge can the battery supply
: What must be the area of a parallel plate capacitor, with plates separated a distance d = 0.01 mm and relative permittivity of 4 for the dielectric between the plates to supply the same charge as the battery in (a)?
|
|
Explain the goals and objectives of the project
: Describe the goals and objectives of the project. Include a high-level overview of all project deliverables. Give a detailed, realistically estimated cost analysis of the entire project, including human capital.
|
|
Compare your company with the competitor financial statement
: Search for a competitor balance sheet , income statement, statement of cash flow.- Compare your company with the competitor financial statements.
|
|
Calculate the initial investment and the annual cash flow
: In early 1980s Alexandria Chemical Products started as a small firm between two friends to produce detergent products. If you were Mr. Ali, the financial director, what are the mistakes Mr. Ahmed did when he analyzed the project cash flow? Calculate ..
|
|
Develop a swot analysis on the viability of upgrading
: Develop a SWOT analysis on the viability of upgrading to Windows 8.1 for the organization as a whole. Provide a detailed upgrade plan for the organization, including the sales staff. At a minimum:
|
|
Provide justification for the proposed solution
: You will provide justification for the proposed solution based on the research results. Please see the attachment ip4_ref.doc; for example. You will also include a project plan for the proposed solution with a time line, required resources, and est..
|
|
Identify the digital signature schemes and mac schemes
: Identify the digital signature schemes and MAC schemes that are supported by Cryptool. For each scheme, determine the key sizes supported by Cryptool and which key sizes are recommended by NIST.
|
|
Calculate the current intercepting the globe
: During a solar Bare, the solar wind becomes much more intense. The velocity increases to 1000 km/s (typical) and the number of particles increases to about 107 protons/m3. Calculate the current intercepting the globe during a solar Bare.
|