2 Ratio Calculation On each data tab, use formulas to calculate the following financial indicators for each year of data o Current ratio o Debt equity ratio o Free cash flow o Earnings per share o Price earnings ratio o Return on equity o Net profit margin As Reported Annual Cash Flow Report Date 09 29 2018 Currency USD Audit Status Not Qualified Consolidated Yes Scale Thousands Cash cash equivalents, beginning of the year 20289000 Net income (loss) 59531000 Depreciation amortization 10903000 Share based compensation expense 5340000 Deferred income tax expense (benefit) 32590000 Other adjustments 444000 Accounts receivable, net 5322000 Inventories 828000 Vendor non trade receivables 8010000 Other current non current assets 423000 Accounts payable 9175000 Deferred revenue 44000 Other current non current liabilities 38490000 Net cash flows from operating activities 77434000 Purchases of marketable securities 71356000 Proceeds from maturities of marketable securities 55881000 Proceeds from sales of marketable securities 47838000 Payments made in connection with business acquisitions, net 721000 Purchases of non marketable securities 1871000 Proceeds from non marketable securities 353000 Payment for acquisition of property, plant equipment 13313000 Payment for acquisition of intangible assets Payments for strategic investments Other cash flow from investing activities 745000 Net cash flows from investing activities 16066000 Proceeds from issuance of common stock 669000 Excess tax benefits from equity awards Payments for taxes related to net share settlement of equity awards 2527000 Payments for dividends dividend equivalents 13712000 Repurchases of common stock 72738000 Proceeds from issuance of term debt, net 6969000 Repayments of term debt 6500000 Change in commercial paper, net 37000 Net cash flows from financing activities 87876000 Increase (decrease) in cash cash equivalents 5624000 Cash cash equivalents, end of the year 25913000 Cash paid (received) for income taxes, net 10417000 Cash paid during the year for interest 3022000

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

Question: 2. Ratio Calculation On each data tab, use formulas to calculate the following financial indicators for each year of data: o Current ratio o Debt/equity

2. Ratio Calculation On each data tab, use formulas to calculate the following financial indicators for each year of data: o Current ratio o Debt/equity ratio o Free cash flow o Earnings per share o Price/earnings ratio o Return on equity o Net profit margin

As Reported Annual Cash Flow
Report Date	09/29/2018
Currency	USD
Audit Status	Not Qualified
Consolidated	Yes
Scale	Thousands
Cash & cash equivalents, beginning of the year	20289000
Net income (loss)	59531000
Depreciation & amortization	10903000
Share-based compensation expense	5340000
Deferred income tax expense (benefit)	-32590000
Other adjustments	-444000
Accounts receivable, net	-5322000
Inventories	828000
Vendor non-trade receivables	-8010000
Other current & non-current assets	-423000
Accounts payable	9175000
Deferred revenue	-44000
Other current & non-current liabilities	38490000
Net cash flows from operating activities	77434000
Purchases of marketable securities	-71356000
Proceeds from maturities of marketable securities	55881000
Proceeds from sales of marketable securities	47838000
Payments made in connection with business acquisitions, net	-721000
Purchases of non-marketable securities	-1871000
Proceeds from non-marketable securities	353000
Payment for acquisition of property, plant & equipment	-13313000
Payment for acquisition of intangible assets	-
Payments for strategic investments	-
Other cash flow from investing activities	-745000
Net cash flows from investing activities	16066000
Proceeds from issuance of common stock	669000
Excess tax benefits from equity awards	-
Payments for taxes related to net share settlement of equity awards	-2527000
Payments for dividends & dividend equivalents	-13712000
Repurchases of common stock	-72738000
Proceeds from issuance of term debt, net	6969000
Repayments of term debt	-6500000
Change in commercial paper, net	-37000
Net cash flows from financing activities	-87876000
Increase (decrease) in cash & cash equivalents	5624000
Cash & cash equivalents, end of the year	25913000
Cash paid (received) for income taxes, net	10417000
Cash paid during the year for interest	3022000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Please see attached for assignment details. I have the balance sheet, income statement, and statement of cash flow data already - I need all the new ratios. I've tried and tried and I'm just not...

I NEEDTHIS ASSIGNMENT DONE i WILL TIP 30 Here is the assignment and my spread sheet so far The financial statements were given, I just need to do the calculations at the bottom of the first three...

1. Financial Data Using the same company you selected in Module Three, add another two years of financial statement data so that you have three years of annual data to review for historical analysis....

I just need someone to look over my work. It is completed just need someone to double check if I did it correctly. These are the instructions (below) and I am attaching my completed assignment. If...

This is for Procter and Gamble stock. I have attached the information needed. ii bb.snhuedu FIN 320 Module Four Excel Assignment Rubric This assignment builds on the work you did for the Excel...

Finance Excel ASS: Ratios 1. Financial Data Using the same company you selected in Module Three, add another two years of financial statement data so that you have three years of annual data to...

Directions: Ratio Calculation On each data tab, use formulas to calculate the following financial indicators for each year of data: o Current ratio o Debt/equity ratio o Free cash flow o Earnings per...

Using Netflix 1. Financial Data Using the same company you selected in Module Three, add another two years of financial statement data so that you have three years of annual data to review for...

FIN 320 Module Four- Walmart 2018,2019 and 2020 1. Financial Data Using the same company you selected in Module Three, add another two years of financial statement data so that you have three years...

Hi, can you please add on to the excel you did and build on the instructions in the attachments please? Attached is the excel you did and the instructions for the new work. I will give you a good tip...

State of Economy Bust Boom State of Economy Roll Bust Boom Ross Calculate the standard deviations for Roll and Ross by filling in the following table: (A negative value should be indicated by a minus...

Find the standard equation of a parabola that has a vertical axis and satisfies the given conditions. x-intercepts 2 and 10, highest point has y-coordinate 4

21. Hyundai Heavy Industries Co. is one of Koreas largest industrial producers. According to an article in Bloomberg BusinessWeek Online, the company not only is the worlds largest shipbuilder, but...

Select all that apply What are two factors that support the idea for political integration of nations through trade? Countries will have enhanced independent political power Countries can enhance...

The text discusses some of the many reasons to develop your networking skills (such as to get a job or a better position, to perform better at your current job, or to advance within your...

In Chapter 3 we discussed job satisfaction and its determinantsthe work itself, pay, growth and upward mobility, supervision, coworkers, and attitudes toward work. Which of these determinants can be...

A good negotiation tactic is to not make unilateral concessions during negotiations. Instead, experts advise that you should figure out the other sides hidden agenda, devise an alternative if you...