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 $8.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 (3)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 from the previous year’s price till the end of the project life and further. Note: The cost of capital is 12%. Selling, General and Administration costs for the first year is $340,000.00 and for the rest of the period, it will increase by 10% from each previous year cost. Fixed cost for each year is $60,000.00 Depreciation expense is $1,875,000.00 and remains same for the future years. Interest expense is $462,000.00 for year one, for year two $400,000.00, for year three $361,500.00, for year four $150,000.00, for year five $125,000, for year six $120,000.00 for year seven $112,000.00 and for year eight $75,000.00 Tax rate 38% throughout the entire period. Calculate the flowing values for the investment proposal of PepsiCola, Atlanta Net present value - NPV and Payback period and intepret your findings 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 $8.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 (3)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 from the previous year’s price till the end of the project life and further.
Note: The cost of capital is 12%.
- Selling, General and Administration costs for the first year is $340,000.00 and for the rest of the period, it will increase by 10% from each previous year cost.
- Fixed cost for each year is $60,000.00
Depreciation expense is $1,875,000.00 and remains same for the future years.- Interest expense is $462,000.00 for year one, for year two $400,000.00, for year three $361,500.00, for year four $150,000.00, for year five $125,000, for year six $120,000.00 for year seven $112,000.00 and for year eight $75,000.00
- 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
can you explain further on your solution? Figures dont seem to match the figures in the question
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 $8.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 (3)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 from the previous year’s price till the end of the project life and further.
Note: The cost of capital is 12%.
- Selling, General and Administration costs for the first year is $340,000.00 and for the rest of the period, it will increase by 10% from each previous year cost.
- Fixed cost for each year is $60,000.00
Depreciation expense is $1,875,000.00 and remains same for the future years.- Interest expense is $462,000.00 for year one, for year two $400,000.00, for year three $361,500.00, for year four $150,000.00, for year five $125,000, for year six $120,000.00 for year seven $112,000.00 and for year eight $75,000.00
- Tax rate 38% throughout the entire period.
Calculate the flowing values for the investment proposal of PepsiCola, Atlanta