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.

Corporate Fin Focused Approach
5th Edition
ISBN:9781285660516
Author:EHRHARDT
Publisher:EHRHARDT
Chapter11: Cash Flow Estimation And Risk Analysis
Section: Chapter Questions
Problem 1eM
icon
Related questions
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%.

  1. 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.
  2. Fixed cost for each year is $60,000.00
  3. Depreciation expense is $1,875,000.00 and remains same for the future years.
  4. 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
  5. 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. 

 

 

Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

can you explain further on your solution? Figures dont seem to match the figures in the question 

 

Solution
Bartleby Expert
SEE SOLUTION
Follow-up 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%.

  1. 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.
  2. Fixed cost for each year is $60,000.00
  3. Depreciation expense is $1,875,000.00 and remains same for the future years.
  4. 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
  5. 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. 

Solution
Bartleby Expert
SEE SOLUTION
Similar questions
Recommended textbooks for you
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,