1. First, add these assumptions to the Income statement and balance. Then work through the discounted cash flow analysis.

2. The soft drink market in Mexico is growing at a compounded annual rate of 6.3% (4.5% CAGR from volume ↑ & 1.7% CAGR from price ↑). Bebida Sol will hope, and let’s assume, that if Hola-Kola is launched it will experience annual volume (liters) increases of 3.75% in years 2 through 5, and annual price (pesos) increases of 1.25% in years 2 through 5.

3. Bebida Sol will instead purchase new machinery with an all-in cost of 54 million pesos. The maximum production capacity of this new machinery is 775,000 liters per month. This machinery will be depreciated straight-line to zero value over 5 years, and at the end of year 5 this machinery is expected to sell for 4.4 million pesos.

4. The estimated annual increase in business space rental costs is 3.7% in years 2 through 5.

5. The estimated annual increase in operating costs in years 2 through 5 is 1.3% for raw materials, 2.5% for labor, and 2.6% for energy.

6. General, administrative, and selling expenses will experience an annual increase of 3.4% in years 2 through 5.

7. The cost allocation by the accounting department of 1.5% of sales is to create fully-burdened income statements for each product family. This allocation does not involve any expenditure of pesos.

8. Any erosion that Hola-Kola generates from Bebida Sol’s existing product lines will likely also increase every year. Our estimate is the annual increase in erosion is 3.3%.

9. All working capital accounts discussed in page 4 of the case text will increase in year 1 through 4, to maintain the same relationship to raw materials, sales revenue, and purchases from vendors (all for raw materials), as stated in the relevant paragraph. Remember NWC balances at the end of year 0 support year 1 operations. Year 1 support year 2 operations, and so on.

As you work through your discounted cash flow analysis of Hola-Kola, be sure to answer the following questions:

1. What are the investment cash outflows for Hola-Kola (years 0 through 4)?

2. What are the operating cash inflows for Hola-Kola (years 1 through 5)?

3. What are the terminal cash flows for Hola-Kola (year 5)?

4. What are the total incremental cash flows for Hola-Kola (years 0 through 5)?

5. What are the payback period, net present value, and internal rate of return from Hola-Kola?

6. Should owner/CEO Antonio Ortega accept or reject the Hola-Kola proposal?

7. Suppose another competitor in carbonated soft drinks, who competes in the same market niche as Bebida Sol, is also considering an investment in a zero-calorie carbonate. What impact should this knowledge have on the net present value of Hola-Kola? I am looking for a precise peso amount here. It should take you about 6 minutes to get your solution; 5 minutes to figure it out and 1 minute to calculate the precise peso amount.

8. 
    
    

Transcribed Image Text:

Appendix 1. Bebida Sol-Income Statements for the Year Ending December 31 (thousands of pesos) Income Item Sales COGS Gross margin Marketing & Selling Expenses General Administrative Expenses EBITDA Depreciation EBIT Interest EBT Taxes @ 30% Net Income Dividends Retained Earnings 2009 2010 832,341 100.0% 642,400 100.0% 349,884 54.5% 456,409 54.8% 292,516 45.5% 375,932 45.2% 120,359 18.7% 168,330 18.7% 150,322 18.1% 88,622 65,340 10.2% 10.6% 97,791 10.9% 106,817 16.6% 136,988 16.5% 146,960 16.3% 45,046 7.0% 61,771 9.6% 23,120 3.6% 38,651 6.0% 11,595 1.8% 27,056 4.2% 20,000 7,056 59.444 7.1% 65,985 7.3% 77,544 9.3% 80,975 9.0% 14.088 1.7% 63,456 7.6% 2011 900,101 100.0% 487,020 54.1% 413,081 45.9% 19,037 2.3% 44,419 5.3% 20,000 24,419 9,340 1.0% 71,635 8.0% 21,491 2.4% 50,145 5.6% 20,000 30,145 Appendix 1. Bebida Sol-Income Statements for the Year Ending December 31 (thousands of pesos) Income Item Sales COGS Gross margin Marketing & Selling Expenses General Administrative Expenses EBITDA Depreciation EBIT Interest EBT Taxes @ 30% Net Income Dividends Retained Earnings 2009 2010 832,341 100.0% 642,400 100.0% 349,884 54.5% 456,409 54.8% 292,516 45.5% 375,932 45.2% 120,359 18.7% 168,330 18.7% 150,322 18.1% 88,622 65,340 10.2% 10.6% 97,791 10.9% 106,817 16.6% 136,988 16.5% 146,960 16.3% 45,046 7.0% 61,771 9.6% 23,120 3.6% 38,651 6.0% 11,595 1.8% 27,056 4.2% 20,000 7,056 59.444 7.1% 65,985 7.3% 77,544 9.3% 80,975 9.0% 14.088 1.7% 63,456 7.6% 2011 900,101 100.0% 487,020 54.1% 413,081 45.9% 19,037 2.3% 44,419 5.3% 20,000 24,419 9,340 1.0% 71,635 8.0% 21,491 2.4% 50,145 5.6% 20,000 30,145

Answer rating: 100% (QA)

Investment Cash Outflows for HolaKola years 0 through 4 Year 0 54 million pesos in new machinery 27 million pesos in additional business space rental costs Year 1 28 million pesos in additional operat... View the full answer