Questions
How to calculate in excel? Profit after tax? Balance sheet: COCA-COLA CO  (KO) CashFlowFlag BALANCE SHEET Fiscal...

How to calculate in excel?

Profit after tax?

Balance sheet:

COCA-COLA CO  (KO) CashFlowFlag BALANCE SHEET
Fiscal year ends in December. USD in millions except per share data. 2015-12 2016-12 2017-12 2018-12 2019-12
Assets
Current assets
Cash
Cash and cash equivalents 7309 8555 6006 8926 6480
Short-term investments 12591 13646 14669 7038 4695
Total cash 19900 22201 20675 15964 11175
Receivables 3941 3856 3667 3396 3971
Inventories 2902 2675 2655 2766 3379
Prepaid expenses 2752 2481 2000 1962 1886
Other current assets 3900 2797 7548 6546
Total current assets 33395 34010 36545 30634 20411
Non-current assets
Property, plant and equipment
Gross property, plant and equipment 22354 21256 16449 16245 18921
Accumulated Depreciation -9783 -10621 -8246 -8013 -8083
Net property, plant and equipment 12571 10635 8203 8232 10838
Equity and other investments 15788 17249 21952 20274 19879
Goodwill 11289 10629 9401 10263 16764
Intangible assets 12843 10499 7235 7007 10002
Deferred income taxes 2667 2412
Other long-term assets 4207 4248 4560 4139 6075
Total non-current assets 56698 53260 51351 52582 65970
Total assets 90093 87270 87896 83216 86381
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt 15806 16025 16503 18191 15247
Accounts payable 2795 2682 2288 2498 3804
Deferred income taxes 692
Taxes payable 775 679 757 693 856
Accrued liabilities 5485 4887 5259 5225 6045
Other current liabilities 2069 1567 2387 2616 1021
Total current liabilities 26930 26532 27194 29223 26973
Non-current liabilities
Long-term debt 28407 29684 31182 25364 27516
Deferred taxes liabilities 4691 3753 2522 1933 2284
Minority interest 210 158 1905 2077 2117
Other long-term liabilities 4301 4081 8021 7638 8510
Total non-current liabilities 37609 37676 43630 37012 40427
Total liabilities 64539 64208 70824 66235 67400
Stockholders' equity
Common stock 1760 1760 1760 1760 1760
Additional paid-in capital 14016 14993 15864 16520 17154
Retained earnings 65018 65502 60430 63234 65855
Treasury stock -45066 -47988 -50677 -51719 -52244
Accumulated other comprehensive income -10174 -11205 -10305 -12814 -13544
Total stockholders' equity 25554 23062 17072 16981 18981
Total liabilities and stockholders' equity 90093 87270 87896 83216 86381

Income statement:

COCA-COLA CO  (KO) CashFlowFlag INCOME STATEMENT
Fiscal year ends in December. USD in millions except per share data. 2015-12 2016-12 2017-12 2018-12 2019-12 TTM
Revenue 44294 41863 35410 31856 37266 34326
Cost of revenue 17482 16465 13256 11770 14619 13717
Gross profit 26812 25398 22154 20086 22647 20609
Operating expenses
Sales, General and administrative 16427 15262 12496 10307 12103 10971
Restructuring, merger and acquisition 1088 598 405
Other operating expenses 1657 1510 -857 -600 -394 167
Total operating expenses 18084 16772 12727 10305 12114 11138
Operating income 8728 8626 9427 9781 10533 9471
Interest Expense 856 733 841 919 946 932
Other income (expense) 1733 243 -1844 -512 1199 2180
Income before taxes 9605 8136 6742 8350 10786 10719
Provision for income taxes 2239 1586 5560 1623 1801 1511
Net income from continuing operations 7366 6550 1182 6727 8985 9208
Net income from discontinuing ops 101 -251
Other -15 -23 -35 -42 -65 -19
Net income 7351 6527 1248 6434 8920 9189
Net income available to common shareholders 7351 6527 1248 6434 8920 9189
Earnings per share
Basic 1,69 1,51 0,29 1,51 2,09 2,15
Diluted 1,67 1,49 0,29 1,5 2,07 2,12
Weighted average shares outstanding
Basic 4352 4317 4272 4259 4276 4287
Diluted 4405 4367 4324 4299 4314 4322
EBITDA 12431 10656 8843 10355 13097 13162

In: Finance

Can you please solve this problem in java lab 9b: MicroDB. In Lab9A, each method returned...

Can you please solve this problem in java

lab 9b: MicroDB. In Lab9A, each method returned an integer. In this part of the lab, all methods will have a void return type and take in an array of integers as a parameter. You’re going to write a program that creates a mini database of numbers that allows the user to reset the database, print the database, add a number to the database, find the sum of the elements in the database, or quit. In main, you will declare an array of 10 integers (this is a requirement). Then you will define the following methods: • printArray (int[ ] arr) – this takes in an array and prints it • initArray (int[ ] arr) – this initializes the array so that each cell is 0 • printSum (int[ ] arr) – this calculates the sum of the elements in the array and prints it • enterNum(int[ ] arr) – this asks the user for a slot number and value – putting the value into the array in the correct slot • printMenu (int[ ] arr) – prints the menu in the sample output (that’s it, nothing more) Note: C++ folks – if you want to pass the size of the array as a second parameter, you can. In main, create an array of 10 integers and immediately call initArray( ). Then, continuously looping, print the menu and ask the user what they want to do – calling the appropriate methods based on the user’s choice. Note that every time you call a method, you must pass the array that was created in main. If it makes it easier, we used a do-while loop and a switch statement in main. In our implementation, main was only 15 lines of code.

Page 3 of 4 Sample output #1 Would you like to: 1) Enter a number 2) Print the array 3) Find the sum of the array 4) Reset the array 5) Quit 1 Enter the slot: 5 Enter the new value: 76 Would you like to: 1) Enter a number 2) Print the array 3) Find the sum of the array 4) Reset the array 5) Quit 1 Enter the slot: 2 Enter the new value: 33 Would you like to: 1) Enter a number 2) Print the array 3) Find the sum of the array 4) Reset the array 5) Quit 2 |0|0|33|0|0|76|0|0|0|0 Would you like to: 1) Enter a number 2) Print the array 3) Find the sum of the array 4) Reset the array 5) Quit 3 109 Would you like to: 1) Enter a number 2) Print the array 3) Find the sum of the array 4) Reset the array 5) Quit 4 Would you like to: 1) Enter a number 2) Print the array 3) Find the sum of the array 4) Reset the array 5) Quit 2 |0|0|0|0|0|0|0|0|0|0 Would you like to: 1) Enter a number 2) Print the array 3) Find the sum of the array 4) Reset the array 5) Quit 5

In: Computer Science

Company XYZ owns a social network web site dedicated for wind surfers. They plan to launch...

Company XYZ owns a social network web site dedicated for wind surfers. They plan to launch a new online ad delivery and management service web site that will be coupled with their existing social network platform. The online ad management service will enable them to accept online orders for online ads from advertisers. The system will also deliver the ads to the main social network site. The ads will be displayed on the social network site but the content of the ads (the images and/or text objects containing the ad message) will be served by the new web site server. The company forecasts that the web site will receive an average of 10,000 visits from potential or current advertisers and 600 online ad purchase orders per week. They expect to have 30,000 registered online advertisers during the first month of the launch of the web site. Company XYZ dedicate a separate server and database for the new online service. The users of the ad management site and the users of the social network will be managed separately. The data of the two groups will be stored on separate databases. Similarly, web ad management site content and the social network site content will be hosted on separate servers. Company XYZ prefers to manage those two sites separately. The social network site will pull online ads from the database of the online ad management system. The users will experience a seamless presentation of ads within the social network pages without noticing the ads are fed from a different server.

Company XYZ awarded a contract to your company (Company ABC) to develop the web site, web service, and the database that will provide the capability of the online ad delivery and management service. You are the project manager of this project. Your task is to manage a team of three (one graphic designer, one database developer, and one software developer). As the project manager you are required to answer the following questions that provide insight about the project plan. Please respond to each question. There may be missing information. This is intentional. If you feel that there is missing information in any question, you are expected to make assumptions. Please state your assumptions clearly. You can use library and/or online information resources to address the questions. List all the information sources you use (use APA format for listing the references).

Using the drawing feature of Word or other software, create a site map of the online ad delivery service and management web site and the ad delivery web service. Show the hierarchy of pages and relationships between them. Include the database infrastructure in your depiction of your website. Explain each element. You can make any assumption about the specifics of the web site. Show the links between the social network site and the online ad management site that you will develop.

In: Computer Science

How do I cite IAS 2 inventories and FASB 330 topic? It needs to be in...

How do I cite IAS 2 inventories and FASB 330 topic? It needs to be in the Chicago style.

This is what I came up with:

IAS (International Accounting Standards). plus.com. 2015. IAS 2 — /ias/ias1>

IAS 2, "Inventories"

FASB (Financial Accounting Standards Board). (2015 July). Accounting Standards Update (ASU) No. 2015-11 Inventory (Topic 330)

In: Accounting

In regards to modern operating systems If you are asked to design a hotel check-in system...

In regards to modern operating systems If you are asked to design a hotel check-in system that has three steps, what would you like to propose? If you are asked to detail your previous design so that it has five steps, how would you update it and why? If you are asked to propose a hotel check-in system without any limitation in steps, what would it be and why?

In: Computer Science

Which of these statements about deadlock are true? (list all that are true.) a. If all...

Which of these statements about deadlock are true? (list all that are true.)

a. If all transactions use two-phase locking, they cannot deadlock.
b. Once two transactions deadlock, one of them must be aborted to maintain correctness.
c. Systems that support update locks (S, X and U modes) cannot deadlock.
d. Validation based concurrency control schemes cannot deadlock.

In: Computer Science

PC-Express is a computer retail store that sells desktops and laptops. The company earns $600 on...

PC-Express is a computer retail store that sells desktops and laptops. The company earns $600 on each desktop computer it sells and $900 on each laptop. The computers PCExpress sells are actually manufactured by another company. This manufacturer has a special order to fill for another customer and cannot ship more than 80 desktops and 75 laptops to PC-Express next month. The employees at PC-Express must spend about 2 hours installing software and checking each desktop computer the company sells. They spend roughly 3 hours to complete this process for laptop computers. PC-Express expects to have about 300 hours available for this purpose during the next month. The store’s management is fairly certain that they can sell all the computers they order but are unsure how many desktops and laptops they should order to maximize profits. For this model which one is true:

1. Alternate Optimal Solutions

2. Redundant constraints

3. Unbounded Solutions

4. infeasibility

In: Math

Lundin PLC Lundin plc operates a number of divisions, but the board of directors has been...

Lundin PLC

Lundin plc operates a number of divisions, but the board of directors has been considering closing those that no longer fit into the future plans of the company. On 30 November 2015 (year end is 31 December 2015), the board decided to close two of the Divisions (Division A and Division B), make the employees redundant and to realise the assets of the divisions as quickly as possible. A detailed plan for closing down Division A was published by the board on 12 December 2015, letters were sent out to customers and suppliers informing them of the closure and redundancy notes were posted to employees. In the case of Division B, although a detailed plan of closure had been agreed by the board on 30 November 2015, no action had been taken to effect the closure of the division and no notifications had been sent to business associates and employees.

Required

You are the auditor of Lundin plc. How would you expect these matters to be accounted for, and how would you audit any estimate of the amount of the obligation, if any?

In: Accounting

1)because some companies have been conducting have been conducting market research for many years on particular...

1)because some companies have been conducting have been conducting market research for many years on particular market they are interested in, they understand the characteristics of target customers. For this reason, when should marketing research not be undertaken?

a. when the actual costs are less than the forecasted benefits

b. when there is no secondary data in existence of guide the project definition

c. when the perceived costs are the same as the forecasted benefits

d. when the research would be redundant and waste of money

2) what specifies the research questions to be answered, how and when the data will be gathered, and how the data will be analyzed?

a. the research design

b. secondary data use plan

c. the sampling plan

d. the research collaborative plan

3) what can marketing managers use marketing research for?

a. to implement a sales promotion

b. to improve the quality of their decision making

c. to learn how to more efficiently respond to customers

d. to find out why a marketing plan failed to launch

In: Operations Management

1. What is goodwill, or in your experience what does Goodwill mainly represent? 2. Does the...

1. What is goodwill, or in your experience what does Goodwill mainly represent?

2. Does the benefit of the information provided by the current goodwill impairment model justify the cost of providing that information? Please explain why or why not in the context of costs and benefits.

3. On a cost-benefit basis, relative to the current impairment-only model, do you support (or oppose) goodwill amortization with impairment testing? Please explain why in your response.

4. If the board were to decide to amortize goodwill, which amortization period characteristics would you support? Please include all that apply in your response and explain why you did not select certain characteristics.

a. A default period

b. A cap (or max) on the amortization period

c. A floor (or minimum) on the amortization period

d. Justification of an alternative amortization period other than a default period

e. Amortization based on the weighted-average useful lives of the identifiable asset(s) acquired

f. Amortization based on weighted-average useful lives of the identifiable asset(s) acquired

g. Management reasonable estimate (based on expected synergies or cash flows as a result of the business combination, the use of acquired processes, or other management judgments)

5. Do your views on amortization versus impairment of goodwill depend on the amortization method and/or period? Please indicate yes or no and explain.

6. Regarding the goodwill amortization period, would equity investors receive decision-useful information when an entity justifies an amortization period other than a default period? If so, does the benefit of this information justify the cost (whether operational or other types of cost)? Please explain.

7. Do the amendments in update 2017-04 (eliminate step 2 of the goodwill impairment test) reduce the cost to perform the goodwill impairment test? Do the amendments in Update 2017-04 reduce the usefulness of financial reporting information for users? Please explain.

8. Do the amendments in Update 2011-08 (qualitative screen) reduce the cost to perform the goodwill impairment test? Do the amendments in Update 2011-08 reduce the usefulness of financial reporting information for users? Please explain and describe any improvements you would recommend to the qualitative screen.

9. Relative to the current impairment model how much do you support (or oppose) removing the requirement to assess goodwill (qualitative or quantitatively) for impairment at least annually? Please explain why in your response.

In: Accounting