......FINANCE ONLY WHO HAS KNOWLEDGE IN FINANCE AND CALCULATION TO BID
So you have to look at my points looking at the report I wrote on what u have to focus as u sent me a revised paper changing only the number of debt and equity and they are also wrong
You have to focus more read better the report and put some theory as well that support some of the things that u wrote
References are so weak I asked between 12-14 not less so please you add more in the text and in the reference list
Appendix look at the example see what he put in the appendix and add
I gave u an example to follow yea but many sentences look similar
Please introduction to be changed is very similar to the example
International complexity I don’t know but are those really a complexities > as looking at the example his one looks better so please double check
In the table you put exchange rate via PPP YOU didn’t mention what is at all as the example used it as the international complexity so have a look if this apply to my company or not
Introduction
This paper analyzes the Coca Cola Company’s investment in South Korea, which includes establishing a manufacturing plant for production of beverages in South Korea. The profile consist an estimation of future cash flows for the next ten years and the net present value for the proposed project. The investment is analyzed from both the subsidiary perspective and the parent company to take into consideration the international aspects involved in the investment. The initial capital outlay is estimated at $50.50 million, which equals to 43,733.45 million South Korean won. The project is financially viable because of a net present value of $250.13 million. The investment is expected to meet the growing demand for beverages in the country and the neighboring nations.
You have to make the introduction different as look very similar to the example I sent so please change it …
COCA COLA INVESTMENT IN SOUTH KOREA 1
|
Subsidiary view (Amount in million Won) |
|
|
|
|
|
|
|
|
|
|
|
|
Item |
Year 0 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Year 6 |
Year 7 |
Year 8 |
Year 9 |
Year 10 |
|
Exchange rate via PPP |
866.009 |
852.69 |
866.009 |
852.69 |
866.009 |
852.69 |
866.009 |
852.69 |
866.009 |
852.69 |
866.009 |
|
Total Cash Inflow |
|
|
|
|
|
|
|
|
|
|
|
|
Sales |
249912.88 |
262408.52 |
275528.95 |
289305.39 |
303770.66 |
318959.20 |
350855.12 |
385940.63 |
424534.69 |
466988.16 |
513686.98 |
|
Sales* |
251412.35 |
263982.97 |
277182.12 |
291041.23 |
305593.29 |
320872.95 |
352960.25 |
388256.27 |
427081.90 |
469790.09 |
516769.10 |
|
Total Cash Outflow |
|
|
|
|
|
|
|
|
|
|
|
|
Investment |
-43733.45 |
|
|
|
|
|
|
|
|
|
|
|
Cost of sales |
|
97541.71 |
102418.79 |
107539.73 |
112916.72 |
118562.56 |
130418.81 |
143460.69 |
157806.76 |
173587.44 |
190946.18 |
|
Selling, general and administrative expenses |
84889.16 |
89133.61 |
93590.30 |
98269.81 |
103183.30 |
113501.63 |
124851.79 |
137336.97 |
151070.67 |
166177.74 |
|
|
Other operating expenses |
|
8895.65 |
9340.43 |
9807.45 |
10297.83 |
10812.72 |
11893.99 |
13083.39 |
14391.73 |
15830.90 |
17413.99 |
|
Operating income |
|
71082.01 |
74636.11 |
78367.91 |
82286.31 |
86400.62 |
95040.69 |
104544.76 |
114999.23 |
126499.15 |
139149.07 |
|
Interest expense South Korea (3.5%) |
|
290.83 |
290.83 |
290.83 |
290.83 |
290.83 |
290.83 |
290.83 |
290.83 |
290.83 |
290.83 |
|
Profit before tax |
|
70791.18 |
74345.28 |
78077.09 |
81995.48 |
86109.80 |
94749.86 |
104253.93 |
114708.40 |
126208.33 |
138858.24 |
|
Corporate tax South Korea (22%-25%) |
|
15574.06 |
16355.96 |
17176.96 |
20498.87 |
21527.45 |
23687.46 |
26063.48 |
28677.10 |
31552.08 |
34714.56 |
|
Local surtax (10%) |
|
5521.71 |
5798.93 |
6090.01 |
6149.66 |
6458.23 |
7106.24 |
7819.04 |
8603.13 |
9465.62 |
10414.37 |
|
Net Income |
|
49695.41 |
52190.39 |
54810.11 |
55346.95 |
58124.11 |
63956.15 |
70371.40 |
77428.17 |
85190.62 |
93729.31 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Parent View (Million $) |
|
|
|
|
|
|
|
|
|
|
|
|
Item (Amount in million $) |
|
|
|
|
|
|
|
|
|
|
|
|
Net Cash Flow (Won) |
-43733.45 |
49695.41 |
52190.39 |
54810.11 |
55346.95 |
58124.11 |
63956.15 |
70371.40 |
77428.17 |
85190.62 |
93729.31 |
|
Exchange rate via PPP |
0.001155 |
0.001173 |
0.001155 |
0.001173 |
0.001155 |
0.001173 |
0.001155 |
0.001173 |
0.001155 |
0.001173 |
0.001155 |
|
Repatriated profit ($) |
|
58.28 |
60.27 |
64.28 |
63.91 |
68.17 |
73.85 |
82.53 |
89.41 |
99.91 |
108.23 |
|
Corporate tax United States (19.4%) |
|
11.31 |
11.69 |
12.47 |
12.40 |
13.22 |
14.33 |
16.01 |
17.35 |
19.38 |
21.00 |
|
Profit After Tax |
-50.50 |
46.97 |
48.57 |
51.81 |
51.51 |
54.94 |
59.52 |
66.52 |
72.06 |
80.53 |
87.23 |
|
Dividends |
|
9.63 |
9.96 |
10.62 |
10.56 |
11.26 |
12.20 |
13.64 |
14.77 |
16.51 |
17.88 |
|
Net Cash Flow |
|
37.34 |
38.62 |
41.19 |
40.95 |
43.68 |
47.32 |
52.88 |
57.29 |
64.02 |
69.35 |
|
Discount Factor (9%) |
1 |
0.9174 |
0.8417 |
0.7722 |
0.7084 |
0.6499 |
0.5963 |
0.5470 |
0.5019 |
0.4604 |
0.4224 |
|
Discounted Cash Flow |
-50.50 |
34.26 |
32.50 |
31.81 |
29.01 |
28.39 |
28.22 |
28.93 |
28.75 |
29.47 |
29.29 |
|
NPV |
250.13 |
|
|
|
|
|
|
|
|
|
|
Financial Analysis
Invested Capital and Loan Repayments ( I invested 70% debt 30% equity you didn’t read the last paper and not even my chat so please change and change anything in the text that support this )
Coca Cola Company expects that the project in South Korea will cost $50.50 million, which is equal to 43,733.45 million South Korean won. The initial capital outlay will cover: construction cost; machineries; cost or raw materials; and selling, general and administration expenses. The Company will finance the initial capital outlay with 70 percent equity and 30 percent debt.The entire debt will be issued in South Korean won. The cost of capital for the South Korean project was estimated at 9.0 percent, after taking into account the international complexities that include high interest rate, increase in taxes and foreign currency flucations. Table 1 shows the percentages of debt and equity financing for the project
Table 1: Cost of Capital (the table is wrong you have to invest 70% debt and 30% equity according to part 2)
|
|
Total Amount ($ millions) |
Debt |
% |
Equity |
% |
|
Investment |
50.50 |
$15.15 million |
30% |
35.35 million |
70% |
The South Korean loan is expected to mature in 10 years, and it is assumed that the loan would be issued at a fixed annual rate of 2.14 percent. This is based on South Korea’s previous year’s loan interest rates, which the Organisation for Economic Co-operation and Development(2019) indicates stood at 3.5 percent. In light of this, the company will pay an interest of South Korean won 290.83 million, which is equivalent to $0.336 million. The figures were computed by multiplying $15.595 by 3.5 percent to get the interest rate in United States dollars. The resultant figure was multiplied by 866.009 in order to convert the value in South Korean won. The 866.009 is prevailing the purchasing power parity
Sales
The sales figures are based on the company’s annual return per region in the year 2018. Coca Cola’s consolidated net operating revenue for 2018 was $31,856 million, with the Asia Pacific region contributing 15.4% or $4,905.824 million. There region has 6 principal syrup plants, 11 distribution and storage warehouses. For this reason, each operating unit contributed $288.58 million. Hence, it is anticipated that the net sales for year 0 are then expected to be $288.58 million, which equals to 249,912.88 million won. Sales are expected to increase at a constant rate of 5% for the first five years and increase to a constant 10 percent for the remaining 5 years (see appendix 1.0). The rapid expansion is justified by increasing demand for beverages in the region. The other sales* values include the rate of inflation in South Korea, which Trading Economics (2019) observes increased to 0.6 percent in April 2019.
Costs
The costs have been computed as a percentage of sales based on Coca Cola Company’s annual result for 2018.The company’s cost of sales accounted for 36.95% of net sales. Selling, general and administrative expenses accounted for 32.35% of net sales. Other operating expenses constituted 3.39 percent of net revenue (SEC 2018). Assuming the company decided to follow the 2018’s trend then the cost of sales for the new project will be 36.95% of sales. Selling, general and administration expenses will be approximately 32.35 percent of the net revenue. Operating expenses is expected to account for 3.39 percent of net sales (see appendix 1.1).
Tax and Dividend Obligations
In South Korea, companies are always required to incur corporate tax expenses. The amount is based on net income organizations earn when conducting their business activity, usually within one financial year. Revenues from corporate tax are important source of revenue or income for the South Korean government (Trading Economics 2019). In South Korea the national corporate tax rate is 25%. The highest marginal rate rose from 22 percent as from January 2018. The corporate rate is 10 percent on the first South Korean won of 200 million of taxable income. The rate increases to 20 percent on income above 200 million won up to 20 billion won. The corporate tax rate for income above 20 billion won up to 300 billion won is 22 percent. The value increases to 25 percent for income over 300 billion won. Local surtax of 10 percent on corporate income tax due applies. Branches are subject to subsidiary profit tax ranging between 5 percent and 15 percent if permitted under tax treaty (Deloitte 2018).
Coca Cola Company will be subject to a national corporate tax of 22 percent for the first three years because the net incomes fall in the 20 billion won-300 billion won tax bracket. From the 4th year the company will be charged a corporate tax rate of 25 percent because the net incomes will be greater than 300billion won. Coca Cola Company will also pay local surtax rate of 10 percent on the corporate income tax due (see appendix 1.2). From the parent company perspective, the company will incur a corporate tax of 19.4 percent, which is the effective tax rate (SEC, 2018). The United States Securities Exchange and Commission (2018) indicate that Coca Cola paid more than $6,644 million in form of dividends in the financial year 2018. Therefore, it is anticipated that the new project will pay 20.5 percent of profit after tax as dividends (see appendix 1.3).
Cash Inflows and Net Present Value
Coca Cola Company’s net cash flow, after repatriation of profits to the United States, equals to $492.64 million. The net cash flow is obtained by subtracting dividends from profit after tax. By using 9 percent as the discount factor, the discounted cash flow amounts to $300.63 million. Net present value is $250.13 million, which is the difference between the discounted cash flow and the initial capital outlay of $50.50 million (see Appendix 1.4).While the project seems to be subject to high exchange risk effects when translating the profits from South Korean won to the United States dollars, it resulted in high net present value of $250.13 million. The project is, therefore, acceptable.
International Complexities (by looking at the example I see that what he used are more relevant for international complexity please have a look an make sure that what you wrote are related to international complaexity )
As of December 31, 2018, Coca Cola Company had 292 operating units located in 6 operating segments: Europe, Middle East and Africa; Latin America; North America, Asia Pacific, Bottling investments; and corporate. Hence, the company could be affected by changes in foreign exchange rates. The company earns revenues, pays its expenses, owns assets as well as incurs liabilities in other nations using currencies other than the United States dollars. In 2018, for instance, Coca Cola Company used 72 different currencies excluding the United States dollars and derived net revenue of $20.5 billion from international operations. The company always presents its consolidated financial statements in United States dollars (SEC 2018).
For this reason, it must translate assets, liabilities, revenues, income as well as expenses into United States dollars at the prevailing exchange. Therefore, an increase or a decrease in the value of the United States dollar against foreign currencies affect Coca Cola’s net operating revenues, the operating income plus the value items in balance sheet that are denominated in foreign currencies(SEC 2018). By investing in South Korea, Coca Cola is exposed to currency fluctuations between the United States dollar and South Korean won. At present, $1 is equivalent to 866.009 won (OECD, 2019). Hence, it is important to take into consideration the foreign exchange movements.
Increase in Interest Rates
Coca Cola Company maintains debt levels that it considers prudent based on its cash flows, debt to equity ratio and interest coverage ratio. It uses debt financing to lower cost of capital, thereby increasing return on shareholders’ equity. Nonetheless, this exposes the company to adverse changes in the interest rates. For instance, an increase in interest rates can negatively affect the company’s net income. Whenever appropriate the company uses derivative financial instruments to reduce the exposure to interest rate risks. Even so, the Coca Cola’s financial risk program may not reduce exposure to interest rate fluctuations. Coca Cola’s interest rate expense can also be affected by the company’s credit ratings (SEC 2018).
Increases in Corporate Tax Rates and Changes in Tax Laws
Coca Cola Company is subject to income tax in various jurisdictions in which it generates profits. Its overall effective tax rate is based on the applicable tax rates as well as the geographical mix of income from continuing operations before taxes. Consequently, any unfavorable movement in tax rates, foreign exchange rates plus geographic mix, would reduce the company’s after tax income. The company’s annual tax rate is based on its income and the applicable tax laws in various jurisdictions it operates. Effective judgment is necessary for determination of the annual income tax expense and evaluation of tax position. In as much as the company tries to have reasonable tax estimates, the tax audit determination could materially differ from its historical income tax provisions as well as accruals (SEC 2018).
Reference List
Deloitte Inc., 2018, Corporate tax rates: International tax, Available from. https://www2.deloitte.com/content/dam/Deloitte/global/Documents/Tax/dttl-tax- corporate-tax-rates.pdf
OECD 2019, PPPs and exchange rates. OECD National Accounts Statistics (database).Accessed from. https://doi.org/10.1787/data-00004-en
Trading Economics, 2019, South Korea inflation rate.Available from. https://tradingeconomics.com/south-korea/inflation-cpi
United States Securities and Exchange Commission, 2018, Form 10-k: Coca Cola Company, U.S. Government Printing Office, Washington, D.C.
Appendices
Appendix 1.0: Sales
|
Subsidiary view (Amount in million Won) |
|
|
|
|
|
|
|
|
|
|
|
|
Item |
Year 0 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Year 6 |
Year 7 |
Year 8 |
Year 9 |
Year 10 |
|
Exchange rate via PPP |
866.009 |
852.69 |
866.009 |
852.69 |
866.009 |
852.69 |
866.009 |
852.69 |
866.009 |
852.69 |
866.009 |
|
Total Cash Inflow |
|
|
|
|
|
|
|
|
|
|
|
|
Sales |
249912.88 |
262408.52 |
275528.95 |
289305.39 |
303770.66 |
318959.20 |
350855.12 |
385940.63 |
424534.69 |
466988.16 |
513686.98 |
|
Sales* |
251412.35 |
263982.97 |
277182.12 |
291041.23 |
305593.29 |
320872.95 |
352960.25 |
388256.27 |
427081.90 |
469790.09 |
516769.10 |
Appendix 1.1: Costs
|
Total Cash Outflow |
|
|
|
|
|
|
|
|
|
|
|
|
Investment |
-43733.45 |
|
|
|
|
|
|
|
|
|
|
|
Cost of sales |
|
97541.71 |
102418.79 |
107539.73 |
112916.72 |
118562.56 |
130418.81 |
143460.69 |
157806.76 |
173587.44 |
190946.18 |
|
Selling, general and administrative expenses |
84889.16 |
89133.61 |
93590.30 |
98269.81 |
103183.30 |
113501.63 |
124851.79 |
137336.97 |
151070.67 |
166177.74 |
|
|
Other operating expenses |
|
8895.65 |
9340.43 |
9807.45 |
10297.83 |
10812.72 |
11893.99 |
13083.39 |
14391.73 |
15830.90 |
17413.99 |
Appendix 1.2: Tax Obligations in South Korea
|
Operating income |
|
71082.01 |
74636.11 |
78367.91 |
82286.31 |
86400.62 |
95040.69 |
104544.76 |
114999.23 |
126499.15 |
139149.07 |
|
Interest expense South Korea (3.5%) |
|
290.83 |
290.83 |
290.83 |
290.83 |
290.83 |
290.83 |
290.83 |
290.83 |
290.83 |
290.83 |
|
Profit before tax |
|
70791.18 |
74345.28 |
78077.09 |
81995.48 |
86109.80 |
94749.86 |
104253.93 |
114708.40 |
126208.33 |
138858.24 |
|
Corporate tax South Korea (22%-25%) |
|
15574.06 |
16355.96 |
17176.96 |
20498.87 |
21527.45 |
23687.46 |
26063.48 |
28677.10 |
31552.08 |
34714.56 |
|
Local surtax (10%) |
|
5521.71 |
5798.93 |
6090.01 |
6149.66 |
6458.23 |
7106.24 |
7819.04 |
8603.13 |
9465.62 |
10414.37 |
Appendix 1.3: Tax Obligations in the United States
|
Net Cash Flow (Won) |
-43733.45 |
49695.41 |
52190.39 |
54810.11 |
55346.95 |
58124.11 |
63956.15 |
70371.40 |
77428.17 |
85190.62 |
93729.31 |
|
Exchange rate via PPP |
0.001155 |
0.001173 |
0.001155 |
0.001173 |
0.001155 |
0.001173 |
0.001155 |
0.001173 |
0.001155 |
0.001173 |
0.001155 |
|
Repatriated profit ($) |
|
58.28 |
60.27 |
64.28 |
63.91 |
68.17 |
73.85 |
82.53 |
89.41 |
99.91 |
108.23 |
|
Corporate tax United States (19.4%) |
|
11.31 |
11.69 |
12.47 |
12.40 |
13.22 |
14.33 |
16.01 |
17.35 |
19.38 |
21.00 |
Appendix 1.4: Cash Flows and NPV
|
Profit After Tax |
-50.50 |
46.97 |
48.57 |
51.81 |
51.51 |
54.94 |
59.52 |
66.52 |
72.06 |
80.53 |
87.23 |
|
Dividends |
|
9.63 |
9.96 |
10.62 |
10.56 |
11.26 |
12.20 |
13.64 |
14.77 |
16.51 |
17.88 |
|
Net Cash Flow |
|
37.34 |
38.62 |
41.19 |
40.95 |
43.68 |
47.32 |
52.88 |
57.29 |
64.02 |
69.35 |
|
Discount Factor (9%) |
1 |
0.9174 |
0.8417 |
0.7722 |
0.7084 |
0.6499 |
0.5963 |
0.5470 |
0.5019 |
0.4604 |
0.4224 |
|
Discounted Cash Flow |
-50.50 |
34.26 |
32.50 |
31.81 |
29.01 |
28.39 |
28.22 |
28.93 |
28.75 |
29.47 |
29.29 |
|
NPV |
250.13 |
|
|
|
|
|
|
|
|
|
|