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. You are required to calculate the Operating cash flow

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
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.

You are required to calculate the Operating cash flow 

 

Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
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
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education