FINANCIAL DATA FOR QUESTIONS IN THE WEB LINK BELOW http www zonebourse com DR PEPPER SNAPPLE GROUP 3017910 pdf 813894 Dr 20Pepper 20Snapple 20Group SEC Filing 10K pdf Instructions Use the financial statements from the annual report for the year ended 12 31 2017 for Dr Pepper Snapple Group (DPSG) The Annual Report is on MOODLE Answer the questions after each question Use a different font to distinguish your answer from the question All answers should be in your own words Do not cut and paste from the annual report Answers will be graded for content and written communication skills Use complete sentences in answering questions MAKE A NOTATION HERE IF THE DOLLAR AMOUNTS ARE STATED IN MILLIONS Who are the external auditors for DPSG What does their Report of Independent Registered Public Accounting firm indicate about the amounts represented in the companys financial statements What specific title does DPSG use for its income statement What type of income statement does General Mills issue ( multi step, singlestep, or condensed ) Explain Did they disclose EPS as discussed in class Explain What about the EPS presentation How does DPSG define Cash Equivalents Is this consistent with the textbook What is the amount of cash and cash equivalents reported for the year ended at 12 31 2016 and 12 31 2017 By how much has cash and cash equivalents increased decreased Show calculations Create a table illustrating the amount DPSG for net cash flows from operating, investing, and financing activities in its statement of cash flow for the year ended 12 31 2017 (Note Include any effect of exchange rates on cash and cash equivalents ) Show calculations Compare your answers to question 5 What is DPSGs policy for valuing inventory both in the US and outside of the US How much reserve for excess and obsolete inventory did DPSG have for year ended 12 31 2017 How are reserves for excess and obsolete inventory determined How did this impact the financial statements What of their total FIFO inventory is raw materials, spare parts, work in process, and finished goods as of 12 31 2017 What is the balance of their LIFO reserve account December 31, 2017 There was no change in the LIFO reserve account from 2016 2017 However, there was a change from 2015 1016 Below is the financial information What impact (dollar amount and increase or decrease) did the LIFO Reserve adjustment have on Cost of Goods Sold December 31, 2016 December 31, 2016 December 31, 2015 Inventories at FIFO cost 234 246 Reduction to LIFO cost(LIFO Reserve) (32) (37) Inventories at LIFO cost 202 209 Which depreciation method is used for PP E What estimates are made for the useful life of assets What was total depreciation expense in 2017 Where were these amounts reported in the financial statements What was the major component of total PP E What was its amount and what was it of the total What of total PP E has been depreciated Did DPSG capitalize any interest during 2017 If so, what was the amount In 2017, what was the total amount of interest paid and income tax paid as indicated in the Supplemental Cash Flow Information What amount of total dividends was paid for the year ended 12 31 2017 Did DPSG purchase any property, plant and equipment during the year ended 12 31 2017 If so, what were the dollar amount When does DPSG review impairment for long lived assets What is DPSGs measurement of an impairment loss based on for long lived assets Create a table to show the components of Comprehensive Income that was attributable to DPSG for the year ending 12 31 2017 Create a table to show the components and amounts of DPSGs Accumulated Other Comprehensive income(loss) for the year ending 12 31 2017 and 12 31 2016 What is the amount of DPSGs goodwill Did they have an impairment loss on Goodwill during fiscal year ended 12 31 2017 What are the standards for testing goodwill (How often and how is it tested) Does DPSG have any other indefinite life intangibles If so, please list them Did they have any impairment loss What three Accounting Standards Updates will be adopted for the quarter ending March 31, 2018 (List the number and the Name Example ASU 2017 07 Impairment of Goodwill) What is the expected impact of these new standards to the financial statements When does DPSG recognize revenue Why do they have deferred revenue (unearned revenue) Do they handle consistently with the material presented in ACC 3100 In regards to fair value, does DPSG use the three level hierarchy for disclosure What level are the majority of their assets and liabilities that are measured at fair value on a recurring basis Did DPSG have any acquisitions fiscal year 2017 If so, what was the acquisition Did it include any goodwill What was DPSGs current ratio and working capital as of 12 31 2017 In a two detailed paragraph, indicate a couple of interesting items you learned while reading this annual report

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 31, 2024

FINANCIAL DATA FOR QUESTIONS IN THE WEB LINK BELOW http://www.zonebourse.com/DR-PEPPER-SNAPPLE-GROUP-3017910/pdf/813894/Dr%20Pepper%20Snapple%20Group_SEC-Filing-10K.pdf Instructions: Use the financial statements from the annual report for the year ended 12/31/2017 for

FINANCIAL DATA FOR QUESTIONS IN THE WEB LINK BELOW

http://www.zonebourse.com/DR-PEPPER-SNAPPLE-GROUP-3017910/pdf/813894/Dr%20Pepper%20Snapple%20Group_SEC-Filing-10K.pdf

Instructions: Use the financial statements from the annual report for the year ended 12/31/2017 for Dr. Pepper Snapple Group (DPSG). The Annual Report is on MOODLE. Answer the questions after each question. Use a different font to distinguish your answer from the question. All answers should be in your own words. Do not cut and paste from the annual report. Answers will be graded for content and written communication skills. Use complete sentences in answering questions.

MAKE A NOTATION HERE IF THE DOLLAR AMOUNTS ARE STATED IN MILLIONS.

Who are the external auditors for DPSG? What does their Report of Independent Registered Public Accounting firm indicate about the amounts represented in the companys financial statements?

What specific title does DPSG use for its income statement? What type of income

statement does General Mills issue? (multi-step, singlestep, or condensed) Explain.

Did they disclose EPS as discussed in class? Explain. What about the EPS presentation

How does DPSG define Cash Equivalents? Is this consistent with the textbook?

What is the amount of cash and cash equivalents reported for the year ended at 12/31/2016 and 12/31/2017? By how much has cash and cash equivalents increased/decreased? Show calculations.

Create a table illustrating the amount DPSG for net cash flows from operating, investing, and financing activities in its statement of cash flow for the year ended 12/31/2017 (Note: Include any effect of exchange rates on cash and cash equivalents. ) Show calculations. Compare your answers to question 5.

What is DPSGs policy for valuing inventory both in the US and outside of the US?

How much reserve for excess and obsolete inventory did DPSG have for year ended 12/31/2017? How are reserves for excess and obsolete inventory determined? How did this impact the financial statements?

What % of their total FIFO inventory is raw materials, spare parts, work in process, and finished goods as of 12/31/2017

What is the balance of their LIFO reserve account December 31, 2017?

There was no change in the LIFO reserve account from 2016-2017. However, there was a change from 2015-1016. Below is the financial information. What impact (dollar amount and increase or decrease) did the LIFO Reserve adjustment have on Cost of Goods Sold December 31, 2016?

	December 31, 2016	December 31, 2015
Inventories at FIFO cost	234	246
Reduction to LIFO cost(LIFO Reserve)	(32)	(37)
Inventories at LIFO cost	202	209

Which depreciation method is used for PP& E?What estimates are made for the useful life of assets?

What was total depreciation expense in 2017?Where were these amounts reported in the financial statements?

What was the major component of total PP&E?What was its amount and what % was it of the total?

What % of total PP&E has been depreciated?

Did DPSG capitalize any interest during 2017? If so, what was the amount?

In 2017, what was the total amount of interest paid and income tax paid as indicated in the Supplemental Cash Flow Information

What amount of total dividends was paid for the year ended 12/31/2017?

Did DPSG purchase any property, plant and equipment during the year ended 12/31/2017?If so, what were the dollar amount?

When does DPSG review impairment for long-lived assets?What is DPSGs measurement of an impairment loss based on for long-lived assets?

Create a table to show the components of Comprehensive Income that was attributable to DPSG for the year ending 12/31/2017?

Create a table to show the components and amounts of DPSGs Accumulated Other Comprehensive income(loss) for the year ending 12/31/2017 and 12/31/2016.

What is the amount of DPSGs goodwill? Did they have an impairment loss on Goodwill during fiscal year ended 12/31/2017?What are the standards for testing goodwill (How often and how is it tested)?

Does DPSG have any other indefinite life intangibles?If so, please list them.Did they have any impairment loss?

What three Accounting Standards Updates will be adopted for the quarter ending March 31, 2018 (List the number and the Name-Example: ASU 2017-07 Impairment of Goodwill)?What is the expected impact of these new standards to the financial statements?

When does DPSG recognize revenue?Why do they have deferred revenue (unearned revenue)?Do they handle consistently with the material presented in ACC 3100?

In regards to fair value, does DPSG use the three-level hierarchy for disclosure?What level are the majority of their assets and liabilities that are measured at fair value on a recurring basis?

Did DPSG have any acquisitions fiscal year 2017?If so, what was the acquisition? Did it include any goodwill?

What was DPSGs current ratio and working capital as of 12/31/2017?

In a two detailed paragraph, indicate a couple of interesting items you learned while reading this annual report.