Calculate the npv and irr for the proposed project

Assignment Help Financial Management

Reference no: EM132049993

Vita-Juice Project Analysis

To show your work and to receive credit, please use Excel cell formulas,

financial functions or algebraic time value of money equations to answer these questions in your spreadsheet.

Vita-Juice is considering jumping on the pomegranate and acai bandwagon by producing Vita-Poma and Vita-Acai beverages in 2018 (t=1). New production equipment and facilities costing $30 million will be required in 2017 (t =0) and fall into the 5-year straight-line depreciation class. Additional net working capital of $5 million will also be needed in 2017. Here are sales projections for the proposed projects.

Year Expected New Sales

2018 $22 million

2019 $30 million

2020 $25 million

2021 $20 million

Projected operating costs (other than depreciation) are 73% of sales for the new beverages. However, Vita-Juice estimates that projected sales for other beverages will fall $5 million in 2018, $8 million in 2019, $7 million in 2020, and $4 million in 2021 if they introduce the new beverages.

Projected operating costs for these existing beverages are 68% of sales. At the end of 2021, the project will end and the production equipment and facilities could be sold for an estimated $10 million. At that point the increased net working capital will be recovered.

Vita-Juice's marginal tax rate is 40% and this is an average risk project for the company giving the project a WACC of 9%. Answer the following.

1. What is the initial cost of the project?

2. What are the expected operating cash flows for 2018 thru 2021?

3. What is the expected end of project termination cash flow at the end of 2021?

4. Calculate the NPV and IRR for the proposed project.

5. Should Vita-Juice go ahead with this project? Explain your answer.

Reference no: EM132049993

Questions Cloud

What single sum must be deposited in the bank : What single amount must be deposited in this account on January 1 of this year? (Round your answer to nearest whole dollar.)

Describe the information that you received from the quote : Describe the information that you received from the quote of the bond. You have to explain each number and symbol that appears in the bond quotation.

Number of boys being double the number of girls : Number of student in a college in 2005 was 510 . of these 480 were boys In 2010 the number of boys increased by 100%

How network standards such as the osi help : Discuss how network standards such as the OSI help to ensure interoperability between products made by different manufacturers.

Calculate the npv and irr for the proposed project : What is the initial cost of the project? What are the expected operating cash flows for 2018 thru 2021?

What will be the cost in dollars if you use the forward : While you were visiting London this past weekend, you purchased a Jaguar for 70,000 (pounds). The Jaguar will be delivered to you later.

Evaluate the vintages return on equity : Vintage, Inc. has a total asset turnover of 1.55 and a net profit margin of 3.65 percent. The total assets to equity ratio for the firm is 2.4.

Has apple made a gain or loss and by how much : By the end of the month, it had unexpectedly dropped to $1.00 to the Euro. Has Apple made a gain or loss and by how much?

Characteristics that identifies it as technical writing : Describe an example of technical writing that you have written or encountered in the past week at work, home or school

User Account

All Pages