Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

calculate the Operating Cycle and Cash (Conversion) Cycle for your company. Show all your work for each equation. Would your company improve its Cash Conversion

calculate the Operating Cycle and Cash (Conversion) Cycle for your company. Show all your work for each equation. Would your company improve its Cash Conversion Cycle by reducing or increasing the cash cycle? Explain your answer. List at least two ways that your company could achieve this improvement. Explain the possible risks your company may face if it follows your suggestions. please calculate and give me values. please it is so urgent

Financials

TTM

2016-01

2015-01

2014-01

2013-01

Revenue USD Mil

15,472

15,797

16,435

16,148

15,651

Gross Margin %

36.1

36.2

38.3

39

39.4

Operating Income USD Mil

1,245

1,524

2,083

2,149

1,942

Operating Margin %

8

9.6

12.7

13.3

12.4

Net Income USD Mil

670

920

1,262

1,280

1,135

Earnings Per Share USD

1.68

2.23

2.87

2.74

2.33

Dividends USD

0.92

0.92

0.88

0.7

0.5

Payout Ratio % *

54.7

37.3

30.8

22.3

23.9

Shares Mil

400

413

440

467

488

Book Value Per Share * USD

6.83

6.57

6.78

6.58

6.59

Operating Cash Flow USD Mil

1,660

1,594

2,129

1,705

1,936

Cap Spending USD Mil

-604

-726

-714

-670

-659

Free Cash Flow USD Mil

1,056

868

1,415

1,035

1,277

Free Cash Flow Per Share * USD

2.47

2.63

2.04

2.79

Working Capital USD Mil

1,450

2,083

1,985

1,788

Key Ratios -> Profitability

Margins % of Sales

TTM

2016-01

2015-01

2014-01

2013-01

Revenue

100

100

100

100

100

COGS

63.94

63.79

61.73

61.03

60.57

Gross Margin

36.06

36.21

38.27

38.97

39.43

SG&A

R&D

Other

28.01

26.56

25.59

25.66

27.02

Operating Margin

8.05

9.65

12.67

13.31

12.41

Net Int Inc & Other

-0.43

-0.34

-0.43

-0.35

-0.52

EBT Margin

7.62

9.31

12.25

12.96

11.89

Profitability

TTM

2016-01

2015-01

2014-01

2013-01

Tax Rate %

43.17

37.46

37.31

38.84

39.01

Net Margin %

4.33

5.82

7.68

7.93

7.25

Asset Turnover (Average)

1.96

2.08

2.12

2.11

2.1

Return on Assets %

8.47

12.13

16.24

16.71

15.24

Financial Leverage (Average)

2.94

2.94

2.58

2.56

2.58

Return on Equity %

25.12

33.29

41.75

42.98

40.18

Return on Invested Capital %

16.07

22.14

29.71

30.58

24.95

Interest Coverage

16.72

25.93

27.84

35.31

22.39

Key Ratios -> Growth

Latest Qtr

2016-01

2015-01

2014-01

2013-01

Revenue %

Year over Year

-1.53

-3.88

1.78

3.18

7.57

3-Year Average

0.31

4.15

3.27

3.3

5-Year Average

1.5

2.97

2.14

-0.14

10-Year Average

-0.14

0.1

0.18

0.8

Operating Income %

Year over Year

-6.04

-26.84

-3.07

10.66

35.05

3-Year Average

-7.76

13.15

2.98

2.28

5-Year Average

-4.99

2.79

6.78

8.11

10-Year Average

-1.35

-0.01

1.35

6.73

Net Income %

Year over Year

-27.1

-1.41

12.78

36.25

3-Year Average

-6.76

14.85

2.06

0.99

5-Year Average

-5.24

2.75

5.77

6.38

10-Year Average

-1.89

0.93

2.2

9.05

EPS %

Year over Year

-16.39

-22.3

4.74

17.6

49.36

3-Year Average

-1.45

22.53

13.38

13.82

5-Year Average

3.47

12.68

15.38

17.28

10-Year Average

6.04

9.02

9.66

15.74

Key Ratios -> Cash Flow

Cash Flow Ratios

TTM

2016-01

2015-01

2014-01

2013-01

Operating Cash Flow Growth % YOY

Free Cash Flow Growth % YOY

Cap Ex as a % of Sales

3.9

4.6

4.34

4.15

4.21

Free Cash Flow/Sales %

6.83

5.49

8.61

6.41

8.16

Free Cash Flow/Net Income

1.58

0.94

1.12

0.81

1.13

Key Ratios -> Financial Health

Balance Sheet Items (in %)

Latest Qtr

2016-01

2015-01

2014-01

2013-01

Cash & Short-Term Investments

19.01

18.33

19.7

19.24

20.21

Accounts Receivable

3.77

5.5

5.89

4.43

Inventory

29.95

25.06

24.56

24.56

23.53

Other Current Assets

9.38

6.16

6.37

6.75

7.14

Total Current Assets

58.34

53.33

56.14

56.44

55.31

Net PP&E

33.25

38.14

36.06

35.14

35.06

Intangibles

3.64

3.54

3.96

4.23

Other Long-Term Assets

8.42

4.9

4.27

4.46

5.39

Total Assets

100

100

100

100

100

Accounts Payable

17.65

14.88

15.25

15.82

15.31

Short-Term Debt

5.3

5.63

0.27

0.32

Taxes Payable

0.24

0.31

0.26

0.46

1.45

Accrued Liabilities

13.23

11.76

6.88

4.7

5.29

Other Short-Term Liabilities

1.34

6.38

9.85

9.33

Total Current Liabilities

36.41

33.92

29.05

31.15

31.38

Long-Term Debt

16.49

17.53

17.32

17.44

16.68

Other Long-Term Liabilities

13.06

14.49

14.84

12.4

13.2

Total Liabilities

65.95

65.94

61.21

60.99

61.26

Total Stockholders' Equity

34.05

34.06

38.79

39.01

38.74

Total Liabilities & Equity

100

100

100

100

100

Liquidity/Financial Health

Latest Qtr

2016-01

2015-01

2014-01

2013-01

Current Ratio

1.6

1.57

1.93

1.81

1.76

Quick Ratio

0.52

0.65

0.87

0.81

0.79

Financial Leverage

2.94

2.94

2.58

2.56

2.58

Debt/Equity

0.48

0.51

0.45

0.45

0.43

Key Ratios -> Efficiency Ratios

Efficiency

TTM

2016-01

2015-01

2014-01

2013-01

Days Sales Outstanding

6.43

8.18

8.96

7.32

Days Inventory

90.32

68.13

68.66

68.26

64.93

Payables Period

50.55

41.38

43.44

44.19

42.54

Cash Conversion Cycle

33.18

33.4

33.04

29.71

Receivables Turnover

56.72

44.6

40.73

49.84

Inventory Turnover

4.04

5.36

5.32

5.35

5.62

Fixed Assets Turnover

5.65

5.62

5.94

6.01

6.09

Asset Turnover

1.96

2.08

2.12

2.11

2.1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Real Estate Investment Strategies Structures Decisions

Authors: David Hartzell, Andrew E. Baum

2nd Edition

1119526094, 978-1119526094

More Books

Students explore these related Finance questions