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.
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Sales | 51 | 87 | 142 | 155 | 126 |
COGS | 22 | 40 | 65 | 63 | 51 |
Gross Income | 29 | 47 | 77 | 92 | 75 |
Operating Expenses | 14 | 27 | 41 | 44 | 37 |
Operating Income (EBITDA) | 15 | 20 | 36 | 48 | 38 |
Depreciation | 6 | 6 | 6 | 6 | 6 |
Operating Income (EBIT) | 9 | 14 | 30 | 42 | 32 |
Income Tax | 3.6 | 5.6 | 12.0 | 16.8 | 12.8 |
Net Operating Profit After Taxes (NOPAT) | 5.4 | 8.4 | 18 | 25.2 | 19.2 |
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:
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 | - | -12 | -20 | -12 | -10 | 46 |
Free Cash Flows | -30 | -0.6 | -5.6 | 12 | 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.
Part 1)
The table below shows the projections (incremental sales, COGS, operating expenses and depreciation) anticipated for expanding Delizzia's operations to Rosario in millions of Argentine pesos.
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Sales | 58 | 88 | 147 | 154 | 127 |
COGS | 29 | 31 | 70 | 66 | 57 |
Gross Income | |||||
Operating Expenses | 6 | 18 | 40 | 38 | 26 |
Operating Income (EBITDA) | |||||
Depreciation | 10 | 10 | 10 | 10 | 10 |
Operating Income (EBIT) | |||||
Income Tax | |||||
Net Operating Profit After Taxes (NOPAT) |
They company uses straight-line depreciation over 5 years. Assume terminal value of zero.
Calculate the projected NOPAT (Net Operating Profit After Tax) for years 1-5.
Be sure to enter all of you answers in Argentine pesos without commas or currency signs. Round your answers to the closest hundred thousands (e.g. if your answer is 32.6 million then you would enter 32.6 and if your answer is -24.1 million you would enter -24.1)
What would be the projected NOPAT for year 1 associated with expanding to Rosario?
What would be the projected NOPAT for year 2 associated with expanding to Rosario?
What would be the projected NOPAT for year 3 associated with expanding to Rosario?
What would be the projected NOPAT for year 4 associated with expanding to Rosario?
What would be the projected NOPAT for year 5 associated with expanding to Rosario?
Part 2)
Expanding to Rosario will require an investment of 50,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:
Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Depreciation | - | 10 | 10 | 10 | 10 | 10 |
Net Capital Expenditures | -50 | - | - | - | - | - |
Net Working Capital Investment | - | -11 | -26 | -19 | -4 | 41 |
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.
Calculate the projected Free Cash Flows immediately and for years 1-5.
Be sure to enter all of you answers in Argentine pesos without commas or currency signs. Round your answers to the closest hundred thousands (e.g. if your answer is 32.6 millions then you would enter 32.6 and if your answer is -24.1 millions you would enter -24.1.)
What are the projected Free Cash Flows immediately associated with expanding to Rosario?
What are the projected Free Cash Flows for year 1 associated with expanding to Rosario?
What are the projected Free Cash Flows for year 2 associated with expanding to Rosario?
What are the projected Free Cash Flows for year 3 associated with expanding to Rosario?
What are the projected Free Cash Flows for year 4 associated with expanding to Rosario?
What are the projected Free Cash Flows for year 5 associated with expanding to Rosario?
Part 3)
To prepare a convincing presentation on the initiatives' feasibility, you have been asked to calculate the Net Present Value (NPV) for both initiatives.
Be sure to enter all of you answers in Argentine pesos without commas or currency signs. Round your answers to the closest hundred thousands (e.g. if your answer is 32.6 million then you would enter 32.6 and if your answer is -24.1 millions you would enter -24.1)
What is the NPV for expanding Delizzia's operations to Cordoba?
What is the NPV for expanding Delizzia's operations to Rosario?
Part 4)
Which city should the company choose for expanding its operations? Cordoba or Rosario?
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...
Elmdale Enterprises is deciding whether to expand its production facilities. Although long-term cash flows are difficult to estimate, management has projected the following cash flows for the first two years (in millions of dollars): Yoar 2 D 152.1 Revenues COGS and Operating Expenses (other than depreciation) Depreciation Increase in Net Working Capital Capital Expenditures Marginal Corporate Tax Rate Year 1 128.4 40.8 20.7 2.7 25.8 35% 55.9 25.3 8.8 39.6 35% a. What are the incremental earnings for this project...
Need help with this finance question. Both
part a and b
Elmdale Enterprises is deciding whether to expand its production facilities. Although long-term cash flows are difficult to estimate, management has projected the following cash flows for the first two years (in millions of dollars): 2 Year 1 124.3 45.7 29.5 2.4 26.8 35% Year 2 167.8 63.3 37.9 Revenues COGS and Operating Expenses (other than depreciation) Depreciation Increase in Net Working Capital Capital Expenditures Marginal Corporate Tax Rate 8.6...
deciding whether to expand its production facilities. Although long-term cash flows are difficult to estimate, management has projected the following cash flows for the first two years (in millions of Elmdale Enterprises dollars) Year 1 Year 2 160.7 64.7 Revenues 111.8 COGS and Operating expenses (other than depreciation) Depreciation Increase in working capital Capital expenditures Corporate tax rate 43.7 28.3 33.3 5.1 8.5 34.1 44.2 20 % 20% a. What are the incremental eamings for this project for years 1...
Elmdale Enterprises is deciding whether to expand its production facilities. Although long-term cash flows are difficult to estimate, management has projected the following cash flows for the first two years (in millions of dollars): Year 1 Year 2 Revenues 112.3112.3 153.8153.8 COGS and Operating expenses (other than depreciation) 49.649.6 55.555.5 Depreciation 29.729.7 37.437.4 Increase in working capital 5.45.4 8.38.3 Capital expenditures 28.328.3 40.240.2 Corporate tax rate 20 %20% 20 %20% a. What are the incremental earnings for this project...
Elmdale Enterprises is deciding whether to expand its production facilities. Although long-term cash flows are difficult to estimate, management has projected the following cash flows for the first two years (in millions of dollars): Year 1 118.1 46.9 28.7 Revenues COGS and Operating expenses (other than depreciation) Depreciation Increase in working capital Capital expenditures Corporate tax rate Year 2 156.8 50.9 38.2 8.7 40.8 20% 3.7 28.3 20% a. What are the incremental earnings for this project for years 1...
9. Your pro forma income statement shows sales of $2.300,000, cost of goods sold as $980,000, depreciation expense of $600,000, and taxes of $216,000 due to a of 30%. What are your pro forma earnings? What is your pro tax rate forma free cash flow? 10. You are forecasting incremental free cash flows for Daily Enterprises. Based on the associated information in Problems 1 and 2, what are the incremental free cash flows with the new machine? software for video...
Please do this in excel and show work.
Also the numbers are in the millions.
= Merge & Center $ % 9 8 % Conditional Form Formatting Table Styles Clipboard Font Alignment Number A1 D м н о р о B a. What are the incremental earnings for this project for years 1 and 2? b. What are the free cash flows for this project for years 1 and 2? $ 160 Year Sales Operating Expenses (other than depreciation) Depreciation...
The 2021 income statement for Egyptian Noise Blasters shows that depreciation expense is $99 million, NOPAT is $296 million. At the end of the year, the balance of gross fixed assets was $745 million. The change in net operating working capital during the year was $89 million Egyptian's free cash flow for the year was $275 million Calculate the beginning of year balance for gross fixed assets. (Enter your answer in millions of dollars.) Gross fixed assets million
The 2021 income statement for Egyptian Noise Blasters shows that depreciation expense is $94 million, NOPAT is $281 million. At the end of the year, the balance of gross fixed assets was $720 million. The change in net operating working capital during the year was $84 million. Egyptian's free cash flow for the year was $250 million. Calculate the beginning-of-year balance for gross fixed assets. (Enter your answer in millions of dollars.) Gross fixed assets million