You have been hired as a consultant by Trader Joe's, a private American chain of grocery stores headquartered ten miles north of Whittier. The CEO is currently considering a project that would see Trader Joe's add in-store bakeries in its California locations. He has asked provide him with a thorough analysis so that he can make the right investment decision. The management team has also been approached by a potential buyer. Your second task is to value the firm. you to Here are some facts: Over the last few years, Trader Joe's' California stores have sold ten million bakery products annually. All analysis points to this volume remaining steady in the future. If the company were to have an in-house bakery, you estimate that the average cost per product would be $1.10. Trader Joe's will mark up these products by 15%. To add a bakery, Trader Joe's would have to shift things around in the store and to purchase bakery equipment for $15,080,000 which will last for a very long time but it would be depreciated to zero for tax purposes using a 10-year straight-line depreciation schedule. This project would be financed solely by equity. Trader Joe's currently pays tax at a rate of 32%. You have collected some information about capital market returns (see Exhibit 1). . . The CEO asks you to submit answers to following questions in a business memo format. He also wants to see the work behind your analysis, you need to also provide an Excel spreadsheet that supports your conclusions in the memo. Part I. Investment Decision a. What is the cost of capital that Trader Joe's should use for this project? b. Should Trader Joe's undertake this project? Part II. Valuation Suppose that Trader Joe's balance sheet shows that it has a debt ratio of 0.30 and a credit rating of BB. a. What is Trader Joe's weighted average cost of capital (WACC)? [The information provided in Table 12.3 in the textbook may be helpful here.] Suppose that Trader Joe's free cash flows (FCF) are forecasted to be as follows: Year FCF ($ millions) 2021 1,291 2022 1,355 2023 1,378 2024 1,506 2025 1,510 Starting in 2026 the company expects FCFs to grow at 2% indefinitely. b. Estimate the Trader Joes' enterprise value in 2020. c. How sensitive is your estimate of Trader Joes' enterprise value with respect to the choice of the discount rate and growth rate? Conduct a sensitivity analysis. Exhibit 1 Capital Market Return Data (Historical and Current) Prevailing Yields on U.S. Government Securities (December 2020) Annualized Yield to Maturity 3-Month T-Bills 1-Year Bonds 5-Year Bonds 10-Year Bonds 20-Year Bonds 30-Year Bonds 1.20% 1.40% 1.80% 2.30% 2.50% 2.90% Historic Average Total Annual Returns on U.S. Government Securities and Common Stocks (1950-2020) Standard Average Annual Return Deviation T-Bills Intermediate Bondsa Long-term Bondsb Large Company Stockse Small Company Stocksd 5.2% 6.4% 6.0% 14.0% 17.8% 3.0% 6.6% 10.8% 16.8% 25.6% Historic Average Total Annual Returns on U.S. Government Securities and Common Stocks (1929-2020) Standard Average Annual Return Deviation T-Bills Intermediate Bondsa Long-term Bondsb Large Company Stocksc Small Company Stocks 3.8% 5.4% 5.5% 12.7% 17.7% 3.3% 5.8% 9.2% 20.3% 34.1% You have been hired as a consultant by Trader Joe's, a private American chain of grocery stores headquartered ten miles north of Whittier. The CEO is currently considering a project that would see Trader Joe's add in-store bakeries in its California locations. He has asked provide him with a thorough analysis so that he can make the right investment decision. The management team has also been approached by a potential buyer. Your second task is to value the firm. you to Here are some facts: Over the last few years, Trader Joe's' California stores have sold ten million bakery products annually. All analysis points to this volume remaining steady in the future. If the company were to have an in-house bakery, you estimate that the average cost per product would be $1.10. Trader Joe's will mark up these products by 15%. To add a bakery, Trader Joe's would have to shift things around in the store and to purchase bakery equipment for $15,080,000 which will last for a very long time but it would be depreciated to zero for tax purposes using a 10-year straight-line depreciation schedule. This project would be financed solely by equity. Trader Joe's currently pays tax at a rate of 32%. You have collected some information about capital market returns (see Exhibit 1). . . The CEO asks you to submit answers to following questions in a business memo format. He also wants to see the work behind your analysis, you need to also provide an Excel spreadsheet that supports your conclusions in the memo. Part I. Investment Decision a. What is the cost of capital that Trader Joe's should use for this project? b. Should Trader Joe's undertake this project? Part II. Valuation Suppose that Trader Joe's balance sheet shows that it has a debt ratio of 0.30 and a credit rating of BB. a. What is Trader Joe's weighted average cost of capital (WACC)? [The information provided in Table 12.3 in the textbook may be helpful here.] Suppose that Trader Joe's free cash flows (FCF) are forecasted to be as follows: Year FCF ($ millions) 2021 1,291 2022 1,355 2023 1,378 2024 1,506 2025 1,510 Starting in 2026 the company expects FCFs to grow at 2% indefinitely. b. Estimate the Trader Joes' enterprise value in 2020. c. How sensitive is your estimate of Trader Joes' enterprise value with respect to the choice of the discount rate and growth rate? Conduct a sensitivity analysis. Exhibit 1 Capital Market Return Data (Historical and Current) Prevailing Yields on U.S. Government Securities (December 2020) Annualized Yield to Maturity 3-Month T-Bills 1-Year Bonds 5-Year Bonds 10-Year Bonds 20-Year Bonds 30-Year Bonds 1.20% 1.40% 1.80% 2.30% 2.50% 2.90% Historic Average Total Annual Returns on U.S. Government Securities and Common Stocks (1950-2020) Standard Average Annual Return Deviation T-Bills Intermediate Bondsa Long-term Bondsb Large Company Stockse Small Company Stocksd 5.2% 6.4% 6.0% 14.0% 17.8% 3.0% 6.6% 10.8% 16.8% 25.6% Historic Average Total Annual Returns on U.S. Government Securities and Common Stocks (1929-2020) Standard Average Annual Return Deviation T-Bills Intermediate Bondsa Long-term Bondsb Large Company Stocksc Small Company Stocks 3.8% 5.4% 5.5% 12.7% 17.7% 3.3% 5.8% 9.2% 20.3% 34.1%