Assuming PepsiCola, Atlanta is considering of giving its main rival a strong competition, in the launch of a product (two-in-one beverage) for a new market. The company requires an amount of $15,000,000.00 as the initial cost of plant/equipment for the products developed by its R&D research group to cover the project life cycle of eight years. For each year, 500,000 units would be produced. The selling price of a unit of the new product is $5.50. It is expected that in year two (2), the selling price of a unit will increase by 25%; year three (3) the unit will be selling by a further increase by 10% from year two (2)s selling price. From year four (4), the selling price will decrease by 5% from year three (2)s selling price and the subsequent years will stabilize or remain till the end of the project life and further. The production department estimated cost of each unit for 1st year as $2.75, it will increase in 2nd year by 25%; In the 3rd year, will increase by 10% from the previous cost; In the 4th year, will decrease by 5% from the previous cost price; and for the subsequent years, the cost of each unit will stabilize till the end of the project life and further. Note: 1. Selling, General and Administration costs for the first year is $1,040,000.00 and for the rest of the period, it will increase by 10% from each previous year cost. 2. Fixed cost for each year is $1,600,000.00 3. Depreciation expense is $ 1,875,000.00 and remains same for the future years. 4. Interest expense is $625,000.00 for year one, for year two $650,000.00, for year three $615,000.00, for year four $600,000.00, for year five $525,000.00, for year six $415,000.00, for year seven $380,000.00 and for year eight $315,000.00 5. Tax rate 38% throughout the entire period. Calculate the flowing values for the investment proposal of PepsiCola, Atlanta Net present value - NPV, Payback period and Briefly discuss your findings in short notes and advise whether the proposal is financially attractive.
Assuming PepsiCola, Atlanta is considering of giving its main rival a strong competition, in the
launch of a product (two-in-one beverage) for a new market. The company requires an amount
of $15,000,000.00 as the initial cost of plant/equipment for the products developed by its R&D
research group to cover the project life cycle of eight years.
For each year, 500,000 units would be produced.
The selling price of a unit of the new product is $5.50. It is expected that in year two (2), the
selling price of a unit will increase by 25%; year three (3) the unit will be selling by a further
increase by 10% from year two (2)s selling price. From year four (4), the selling price will
decrease by 5% from year three (2)s selling price and the subsequent years will stabilize or
remain till the end of the project life and further.
The production department estimated cost of each unit for 1st year as $2.75, it will increase in 2nd
year by 25%; In the 3rd year, will increase by 10% from the previous cost; In the 4th year, will
decrease by 5% from the previous cost price; and for the subsequent years, the cost of each unit
will stabilize till the end of the project life and further.
Note:
1. Selling, General and Administration costs for the first year is $1,040,000.00 and for the
rest of the period, it will increase by 10% from each previous year cost.
2. Fixed cost for each year is $1,600,000.00
3. Depreciation expense is $ 1,875,000.00 and remains same for the future years.
4. Interest expense is $625,000.00 for year one, for year two $650,000.00, for year three
$615,000.00, for year four $600,000.00, for year five $525,000.00, for year six
$415,000.00, for year seven $380,000.00 and for year eight $315,000.00
5. Tax rate 38% throughout the entire period.
Calculate the flowing values for the investment proposal of PepsiCola, Atlanta
Step by step
Solved in 3 steps with 2 images
