Question

In: Finance

Delizzia, a family owned business, produces and delivers potato chips to supermarkets and mom & pop...

Delizzia, a family owned business, produces and delivers potato chips to supermarkets and mom & pop stores. Located in Buenos Aires, Argentina, Delizzia is planning to expand its operations to cover other major Argentinian cities such as Cordoba and Rosario. This expansion will require Delizzia to set up a new distribution center and acquire new vehicles for last-mile distribution. Due to budget constraints, the company will only be able to expand to one city at a time. Therefore, Delizzia needs to decide if investing in Cordoba or Rosario makes more economic sense. The company is considering a time horizon of five years to make the decision. Assume the tax rate is 40% and the discount rate for Delizzia is 15%. Ignore inflation.

The table below shows the projections (incremental sales, COGS, operating expenses and depreciation) anticipated for expanding Delizzia's operations to Cordoba in millions of Argentine pesos.

Cordoba's Incremental Income Statement (in millions of Argentine pesos)
Year 1 Year 2 Year 3 Year 4 Year 5
Sales 56 80 140 156 130
COGS 30 34 64 67 52
Gross Income 26 46 76 89 78
Operating Expenses 11 22 40 46 39
Operating Income (EBITDA) 15 24 36 43 39
Depreciation 6 6 6 6 6
Operating Income (EBIT) 9 18 30 37 33
Income Tax 3.6 7.2 12.0 14.8 13.2
Net Operating Profit After Taxes (NOPAT) 5.4 10.8 18 22.2 19.8

Expanding to Cordoba will require an investment of 30,000,000 Argentine pesos (to be paid in Year 0) to remodel the rented space for the distribution center and purchase the vehicles. Similarly, additional working capital will be required, but it comes in the second half of Year 1 after the remodeling is finished. That is why there is no working capital in Year 0. See table below:

Cordoba's Incremental Adjustments (in millions of Argentine pesos)
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Depreciation - 6 6 6 6 6
Net Capital Expenditures -30 - - - - -
Net Working Capital Investment - -19 -29 -16 -7 47
Free Cash Flows -30 -7.6 -12.2 8 21.2

Note.- A negative number for the capital expenditure and working capital represents a cash outflow. The positive working capital cash flow in the final period may not equal the sum of the previous investments due to accounting assumptions, such as not collecting all receivables.

The company uses straight-line depreciation over 5 years. The terminal value is zero.

What are the projected Free Cash Flows for year 5 associated with expanding to Cordoba?

What is the NPV for expanding Delizzia's operations to Cordoba?

Solutions

Expert Solution

Estimation of NPV for expanding to Cardoba and Free Cash Flows for year 5 associated with expanding to Cardoba

Step 1: Identifying Free cash flows for year 5  

Free cash flows at the end of year 5 shall comprise of two components:

Component 1: Operating cash flows

Component 2: Non operating cash flows (terminal year)

Let us first calculate component 1 for year 5 (All calculations are in Million Peso)

Operating Cash Flows (OCF)= EBIT (1-Tax Rate) + Depreciation

OCF Year 5= 33*(1-40%) + 6

OCF Year 5= 33*(0.6) + 6 = 19.8+6=25.8

Now let us calculate Component 2 for year 5

TNOCF Year 5 = Salvage Value + Net Working Capital changes (Terminal year) - Tax Rate (Salvage Value - Book Value)

As given in the information, Salvage Value is zero. Also, the entire asset/investment of Peso 30 Mn has been depreciated completely in 5 years. Accordingly book value of the asset at the end of 5th year is also zero.

Hence, TNOCF Year 5 = 0 + 47 - 40%*(0-0) = 47 - 40% * (0) = 47

Free Cash Flows in Year 5 = OCF year 5 + TNOCF Year 5 = 25.8+47=72.8 Mn Peso

Let us now compute the NPV for expansion decision to Cardoba

FCF1=-7.6

FCF2= -12.2

FCF3= 8

FCF4=21.2

FCF5=72.8

The free cash flows need to be discounted by discount rate of 15% to arrive at PV of FCFs at the end of Year zero

PV FCF1= -(7.6)/(1.15) =-6.61

PV FCF2 = -12.2/(1.15)^2= -9.22

PV FCF3 = 8/(1.15)^3 = 5.26

PV FCF4 = 21.2/(1.15)^4=12.12

PV FCF5=72.8/(1.15)^5=36.19

NPV= -(Initial Investment) + PV FCF1 + PV FCF2 + PV FCF3 + PV FCF4 + PV FCF5

= -(30) - 6.61 - 9.22 +5.26 + 12.12 + 36.19

= 7.74 Mn Peso

Hence, Delizzia's decision of expanding to Cardoba should result in a net positive NPV of 7.74 Mn Peso


Related Solutions

Delizzia, a family owned business, produces and delivers potato chips to supermarkets and mom & pop...
Delizzia, a family owned business, produces and delivers potato chips to supermarkets and mom & pop stores. Located in Buenos Aires, Argentina, Delizzia is planning to expand its operations to cover other major Argentinian cities such as Cordoba and Rosario. This expansion will require Delizzia to set up a new distribution center and acquire new vehicles for last-mile distribution. Due to budget constraints, the company will only be able to expand to one city at a time. Therefore, Delizzia needs...
A potato chip company advertises that their family sized bag of potato chips have an average...
A potato chip company advertises that their family sized bag of potato chips have an average weight of 10 oz. I want to know if the bags are overfilled. I randomly sampled 100 bags of chips and find that my sample has a mean weight of 10.1 oz and a standard deviation of 0.2 oz. The sample data was not strongly skewed. 1. Write the appropriate null and alternative hypothesis. 2. Calculate the t score. 3. use the t score...
As you consider small "Mom and Pop firms" like inner city grocery stores, or small family...
As you consider small "Mom and Pop firms" like inner city grocery stores, or small family owned restaurants, they often do not earn economic profits. How can this be explained? How and why might the decision be different in the short-run versus the long-run? Why is it important for a business to understand the different aspects of their production costs (fixed, variable, averages, and marginal) along with with the overall cost structure?
Catherine​'s Kettle Potato Chips produces gourmet chips distributed to chain sub shops throughout California. To ensure...
Catherine​'s Kettle Potato Chips produces gourmet chips distributed to chain sub shops throughout California. To ensure that their chips are of the highest quality and have taste​ appeal, Catherine has a rigorous inspection process. For quality control​ purposes, Catherine has a standard based on the pounds of chips inspected per hour and the number of pounds that pass or fail the inspection. Catherine expects that for every 6 comma 500 pounds of chips​ produced, 1 comma 300 pounds of chips...
IHRM in Action Case 2.1 Establishing a branch of a family business in China A family-owned...
IHRM in Action Case 2.1 Establishing a branch of a family business in China A family-owned carbon steel company from Germany has extended its business to Hong Kong. The owners bought a small traditional Chinese firm and decided to copy the successful structure they had developed at home. This struc- ture was headed by three general managers who equally shared the responsibilities for the business activities of the firm. The consequences were as follows. 1 Now the Chinese employees were...
1 Frito-Lay’s Quality-Controlled Potato ChipsFrito-Lay’s Quality-Controlled Potato Chips Frito-Lay, the multi-billion-dollar snack food giant, produces billions...
1 Frito-Lay’s Quality-Controlled Potato ChipsFrito-Lay’s Quality-Controlled Potato Chips Frito-Lay, the multi-billion-dollar snack food giant, produces billions of pounds of product every year at its dozens of U.S. and Canadian plants. From the farming of potatoes—in Florida, North Carolina, and Michigan—to factory and to retail stores, the ingredients and final product of Lay’s chips, for example, are inspected at least 11 times: in the field, before unloading at the plant, after washing and peeling, at the sizing station, at the fryer,...
ABC Limited is a family owned business that has been in operation for the past ten...
ABC Limited is a family owned business that has been in operation for the past ten years. The company based in Kabwe manufactures one product: desks. ABC limited Managing Director, Mr. Aubrey Bwalwa Chuungu has been away on a business trip to China for the past three months. He is worried that the current outbreak of the Corona virus and the subsequent restrictions imposed on commerce by the Zambian government may have had adverse financial consequences for the company. You...
            Kiko Ltd is a family owned Asian grocery business that specialises in selling a variety...
            Kiko Ltd is a family owned Asian grocery business that specialises in selling a variety of Japanese products. The company has recently started to receive orders from hotels across the state. It is now 1 October, and Mr Seike, the owner, is very pleased with his growing business. He compiled data on the business’ revenue and purchases for the past three months, and prepared forecasts for the upcoming three months as shown below: Sales Revenue Purchases Actual data: July...
Read the following scenario. A family-owned business can have special complications. The line separating family relationships...
Read the following scenario. A family-owned business can have special complications. The line separating family relationships and legal responsibilities can be unclear. It is important for directors, officers, and owners of a family-owned business to be aware of the issues to avoid misunderstandings and unintended liability and to preserve familial relationships. You are a consultant advising a "mom and pop" grocery store owned by Jeff and Joan, a married couple, and their two adult children, Martha and Henry. The grocery...
Magi Chen is the managing director of Sun Construction Pty Ltd, a family owned business that...
Magi Chen is the managing director of Sun Construction Pty Ltd, a family owned business that provides construction services. As Magi is interested in purchasing some new constructionequipment’s for her business, she has approached her local bank for finance. The bank has asked that Magi provide an audited financial statement to assist them in considering her loan application. Magi has approached your audit firm for this service and you have been allocated the task of auditing Sun Construction for the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT