Case 20: PEPSICO CHANGCHUN
JOINT VENTURE
Capital Expenditure Analysis
Study Questions
Q1. Use the information in the case to construct two sets of NPV and IRR analysis from joint venture view and
Pepsico. Based on the results, what would be your decision on the proposed Changchun joint venture?
Q2. Comment on the financial projections that PepsiCo used in its capital budgeting exercise, especially the
NOPBT Cap, foreign exchange rate projection and the discount rate.
Q3. What differences might there be as to how the PRC partners do the analysis (or look at the future cash flows) versus PepsiCo?
Case Summary(案例)
In mid-June 1994, Andre Hawaux, vice-president finance for PepsiCo East Asia (PepsiCo), was about to put together the
…show more content…
Bad Debt Write Off
NOPBT
NOPBT Cap @ 11%
Adjusted NOPBT
Tax Expense
NOPAT
Statutory Reserve
Net Income
Exhibit 7
Adjust NOPBT-NOPBT
NOPBT down to 11% of revenue
Compute
Adjust NOPBT-Tax Expense
Compute
NOPAT-Statutory Reserve
Results of the NPV and IRR
• Non-Cash Expenses: Exhibits 4 and 9 depreciation, amortization, the bottle and shell deposit and breakage
• Cash Outflow: Exhibit 4 and 8
Capital expenditure and increase in working capital • Terminal value(constant dividend growth model,5% growth rate): USD 55.9 million
Cash flow * (1 + growth rate) 5857 * (1 + 0.05)
Terminal value =
=
= 55,913
16% − 5% discount rate - growth rate
TN-2(NPV and IRR from Joint Venture)
Net Income
Depreciation(+)
Amortization(+)
Bottle Deposit(+)
Capital Expenditure(-)
Working Capital(-)
Net Cash Flow
Terminal Value
Net Cash Flow with TV
Discount Rate
NPV
IRR
TN-1
Exhibit 4
Exhibit 4
Exhibit 9
Exhibit 4
Exhibit 8
Compute
Compute
Compute
16%
Without TV With TV
(12868.8) (4748.8)
2.40%
12.90%
Sensitivity Analysis
•
•
•
•
Revenue growth rate
Profit margin
Exchange rate(Exhibit 6)
The timing of capital investment
How realistic are the predictions?
Other Point of View
• JV from PepsiCo’s Point of View: TN-3
- The sales of concentrate to the bottling JV
50% of COGS
- The net contribution margin of concentrate sales 17% of sales
TN-3(NPV and IRR from PepsiCo)
Net Cash Flow with TV
PepsiCo's Share of Joint Venture
First, the projected cash flows range from $21.2 million in 2007 to $29.5 million in 2011 as shown in the data exhibit ‘DCF model.’ To generate these numbers Liedtke’s base case performance projections are used for the projected 2007 – 2011 net revenue numbers and the estimated depreciation and then his projections for Balance sheet accounts were used to determine the current net working capital and capital expenditure as in the exhibit ‘Financial statements.’ These projections were based by Liedtke under the following assumptions, women’s casual footwear would be wound down within one year and the historical corporate overhead-revenue ratio would conform to historical averages. These annual cash flows give us a PV (Cash flows) of $96.15 million over the next 5 years.
Our estimated cost of capital, 20.81%, is lower than Ricketts’ expected return, 30%-50%, thus the investment is worthy. However, it’s higher than other pessimistic members’ expected return, 10%-15%, making the decision more complex and requiring further valuation。
The analysis of a company's financial statements helps in the determination of both the weaknesses and strengths of the concerned entity. Further, such an analysis helps in the determination of the future viability of firms. There are a wide range of techniques utilized in the analysis of financial statements. In that regard, it is important to note that the relevance of a horizontal, vertical as well as ratio analysis of a company's financial statements cannot be overstated. This is more so the case when it comes to the interpretation of the various dollar amounts presented in both the balance sheet and the income statement. In this text, I carry out a horizontal, vertical as well as ratio analysis of both The Coca-Cola Company and PepsiCo, Inc. The analysis' results will be critical in the evaluation of each company's performance. Findings will be used as a basis for recommendations on how each company can improve its financial status.
The Conch Republic is an organization which produces reputable electronics is seeking to advance one of their current production lines to stay abreast to changing technology. The company is seeking to introduce a new smart phone with the hopes of boosting the company’s revenue and reputation as a smart phone producer. As a person hired to assess the financial undertaking of Conch Republic an overview of the projects planned expense must be generated. However, in order to accomplish this task a capital investment analysis must be conducted in order to determine the projects viability. This will be done by analyzing several things. Those things that must be understood are the projects payback period, the net present value (NPV), internal
2. Forecast the firm’s financial statements for 2002 and 2003. What will be the external financing requirements of the firm in those years? Can the firm repay its loan within a reasonable period? In order to forecast the financial statements of 2002 and 2003, the following assumptions need to be made. The growth of sales is 15%, same as 2001, which is estimated by managers. The rate of production costs and expenses per sales is constant to 50%. Administration and selling expenses is the average of last 4 years. The depreciation is $7.8 million per year, which is calculated by $54.6 million divided by 7 years. Tax rate is 24.5%, which is provided. The dividend is $2 million per year only when the company makes profits. Therefore, we assume that there will be no dividend in 2003. Gross PPE will be $27.3 million (54.6/2) per year. We also assume there is no more long term debt, because any funds need in the case are short term debt, it keeps at $18.2 million. According to the forecast, Star River needs external financing approximately $94 million and $107 million in 2002 and 2003, respectively. In order to analysis if the company can repay the debt, we need to know the interest coverage ratio, current ratio and D/E ratio. The interest coverage ratios through the forecast were 1.23 and 0.87 respectively, which is the danger signal to the managers, because in 2003, the profits even not
Based on the information in the case, Pepsi could invest US$360 million in exchange for 30% equity of Deltex. So we have to calculate the value of 30% equity of Deltex. First, we calculated the discount factor by using average unlevered beta of US independent bottlers, US 10 year Treasury bond as risk free rate and assuming market risk premium 10%. We came up with 9.83% of WACC. Next, we calculated Deltex free cash flow and terminal value and then converted them into US dollar value. Now with WACC and total cash flow, we had NPV of the company. So we deducted current debt from NPV and came up with the value of US$360M investment equal to 59.99% of
This paper focuses on a company analysis of Molson Coors Brewing Company. The second part of the project will give a better understanding of the company by analyzing their stock price, total cost of
5- The approach used to calculate the value of the Joint Venture was a DCF using the APV method. Since the two companies, Jersey and Prince, have distinct characteristics and costs of capital, they value the project differently. For Prince, the Joint Venture has a total
Coca-Cola is a leading beverage industry in the United States and many other countries in the world. PepsiCo is also a leading worldwide beverage company, but they are also the parent company of the Frito-Lay and Quaker Oats Companies. This makes PepsiCo a leader in the beverage, snack and cereal industries. As consumers, we have indulged in their products for many years. My personal preference has always been Pepsi over Coke, which is why I was very interested in conducting this analysis. Regardless of the results, I will always seek out a Diet Pepsi over a Diet Coke and so will many of my physician friends at Children’s Hospital who start their mornings with a Diet Pepsi. These personal preferences are what contributes to a company’s profits through net sales. However, the key performance measurement tools used are not based on sales alone. Calculating liquidity, solvency, and profitability ratios on a regular basis give us a better insight on the performance and overall health of a company.
In the case of Worldwide Paper Company we performed calculations to decide whether they should accept a new project or not. We calculated their net income and their cash flows for this project (See Table 1.6 and 1.5). We computed WPC’s weighted average cost of capital as 9.87%. We then used the cash flows to calculate the company’s NPV. We first calculated the NPV by using the 15% discount rate; by using that number we calculated a negative NPV of $2,162,760. We determined that the discount rate of 15% was out dated and insufficient. To calculate a more accurate NPV for the project, we decided to use the rate of 9.87% that we computed. Using this number we got the NPV of $577,069. With the NPV of $577,069 our conclusion is to accept this
Comparing financial data from statements can help determine whether or not it is a sound decision to invest in a company. This information can also help determine if a company is operating successfully and areas of risk within the company. This analyzing can help one company compare itself to another company and ensure that they are able to compete with other companies in their respective industries. PepsiCo and Coca-Cola are two major companies that make a majority of their money from producing and selling soft drinks. To compare these companies we are going to use vertical and horizontal analyses to see if these
4. Based on the information provided in the case, our group calculated the NPV for the project under both tax environment and tax-free condition, respectively, by using the excel spreadsheet and the NPV function. (For a detailed calculation of NPV, please refer to Appendix Under 15-yr.) According to our calculation, we have the following results: In the first case scenario, which the firm is in a tax environment (35% income tax), the NPV of the project equals to -$6,366,054.53
In year 1965, PepsiCo Inc. is founded by Donald M. Kendall and Herman Lay. PepsiCo Inc. was merged by Pepsi-Cola and Frito-Lay in 1965. PepsiCo is an American multination industry that selling food and beverage. PepsiCo Inc. is the second-largest organisation that produces food and beverage in the world.
Pepsi-Cola is a carbonated beverage that is produced and manufactured by PepsiCo. It is sold in stores, restaurants and from vending machines. The drink was first made in the 1890s by pharmacist Caleb Bradham in New Bern, North Carolina. The brand was trademarked on June 16, 1903. There have been many Pepsi variants produced over the years since 1903, including Diet Pepsi, Crystal Pepsi, Pepsi Twist, Pepsi Max, Pepsi Samba, Pepsi Blue, Pepsi Gold, Pepsi Holiday Spice, Pepsi Jazz, Pepsi X (available in Finland and Brazil), Pepsi Next (available in Japan and South Korea), Pepsi Raw, Pepsi Retro in Mexico, Pepsi One, and Pepsi Ice Cucumber in Japan .Pepsi cola is situated is an Industry that is dominator by two Competitors Coca
1.) Why do companies like Pepsi need to globalize? What are the various ways in which foreign companies can enter a foreign market? What hurdles and problems did Pepsi Face when it tried to enter India during the 1980s?