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

Reviews

Write a Review

 

Financial Management Questions & Answers

  Calculate how much each building depreciates per year

Rick, CFO of a half way house, is planning a $26,000,000 acquisition of an unused hotel on January 1, 2014. It will be depreciated on a straight line basis over the next 26 years. Calculate how much each building depreciates per year and multiply thi..

  Regarding three investment opportunities

Assume CAPM holds and you have the following information regarding three investment opportunities:

  Using theta-how this out of the money option strategy

Explain, using Theta, how this out of the money option strategy is losing value from the poitn of purchase.

  Forecast wal-mart stores growth for the future

Financial analysts forecast Wal-Mart Stores (WMT) growth for the future to be 13.00 percent.

  What is the company competitive lease-rental rate

The Clarkton Company produces industrial machines, which have five-year lives. Clarkton is willing to either sell the machines for $30,000 or lease them at a rental that because of competitive factors yields an after-tax return to Clarkton of 6% (its..

  Explanations of the major differences in ratios and trends

Discuss the ratio trends of bank of America (stock companies )and compare/contrast these trends with those of another company. Provide explanations of the major differences in ratios and trends between the two companies and industry please try to ans..

  Future earnings at new market interest rate

she then decided to immediately sell all of her future earnings at the new market interest rate. Find her annual yield rate.

  What is the bond price

If the required return on the bond is 10%, what is the bond’s price?

  Outstanding bonds mature

Kholdy Enterprises' outstanding bonds mature in 6 years, have par value of $1,000, make annual coupon payment of $60. The market yield on bond is currently 10%.

  Features of compliance auditing and monitoring work plan

List five elements or features of a compliance auditing and monitoring work plan.

  Explain conceptually how bonds are priced

What is a bond? Explain conceptually how bonds are priced. Can bond prices be affected by interest rate? Why?

  Weighted average implied by the two outstanding debt issues

Assume the overall cost of debt is the weighted average implied by the two outstanding debt issues.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd