Microsoft Excel LibreOffice Calc

CSX Corp. (CSX)


Analysis of Liquidity Ratios

Difficulty: Beginner


Liquidity Ratios (Summary)

CSX Corp., liquidity ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 30, 2016 Dec 25, 2015 Dec 26, 2014
Current ratio 1.34 1.01 1.22 1.52 1.22
Quick ratio 1.11 0.73 0.96 1.24 0.99
Cash ratio 0.58 0.22 0.50 0.74 0.46

Based on: 10-K (filing date: 2019-02-06), 10-K (filing date: 2018-02-07), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-02-10), 10-K (filing date: 2015-02-11).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. CSX Corp.’s current ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. CSX Corp.’s quick ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. CSX Corp.’s cash ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Current Ratio

CSX Corp., current ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 30, 2016 Dec 25, 2015 Dec 26, 2014
Selected Financial Data (US$ in millions)
Current assets 2,565  1,915  2,487  2,966  2,572 
Current liabilities 1,915  1,894  2,040  1,952  2,107 
Liquidity Ratio
Current ratio1 1.34 1.01 1.22 1.52 1.22
Benchmarks
Current Ratio, Competitors2
FedEx Corp. 1.39 1.59 1.50 1.84 1.82
Union Pacific Corp. 0.90 1.02 0.99 1.29 1.24
United Parcel Service Inc. 1.15 1.22 1.18 1.23 1.37
Current Ratio, Sector
Industrial Transportation 1.20 1.29 1.26 1.43 1.45
Current Ratio, Industry
Industrials 1.30 1.46 1.43 1.38 1.64

Based on: 10-K (filing date: 2019-02-06), 10-K (filing date: 2018-02-07), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-02-10), 10-K (filing date: 2015-02-11).

1 2018 Calculation
Current ratio = Current assets ÷ Current liabilities
= 2,565 ÷ 1,915 = 1.34

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. CSX Corp.’s current ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Quick Ratio

CSX Corp., quick ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 30, 2016 Dec 25, 2015 Dec 26, 2014
Selected Financial Data (US$ in millions)
Cash and cash equivalents 858  401  603  628  669 
Short-term investments 253  18  417  810  292 
Accounts receivable, net 1,010  970  938  982  1,129 
Total quick assets 2,121  1,389  1,958  2,420  2,090 
 
Current liabilities 1,915  1,894  2,040  1,952  2,107 
Liquidity Ratio
Quick ratio1 1.11 0.73 0.96 1.24 0.99
Benchmarks
Quick Ratio, Competitors2
FedEx Corp. 1.22 1.46 1.35 1.59 1.58
Union Pacific Corp. 0.65 0.70 0.70 0.86 0.85
United Parcel Service Inc. 0.99 1.01 1.05 1.11 1.15
Quick Ratio, Sector
Industrial Transportation 1.02 1.08 1.08 1.22 1.19
Quick Ratio, Industry
Industrials 0.82 0.98 0.95 0.92 1.29

Based on: 10-K (filing date: 2019-02-06), 10-K (filing date: 2018-02-07), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-02-10), 10-K (filing date: 2015-02-11).

1 2018 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 2,121 ÷ 1,915 = 1.11

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. CSX Corp.’s quick ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Cash Ratio

CSX Corp., cash ratio calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 30, 2016 Dec 25, 2015 Dec 26, 2014
Selected Financial Data (US$ in millions)
Cash and cash equivalents 858  401  603  628  669 
Short-term investments 253  18  417  810  292 
Total cash assets 1,111  419  1,020  1,438  961 
 
Current liabilities 1,915  1,894  2,040  1,952  2,107 
Liquidity Ratio
Cash ratio1 0.58 0.22 0.50 0.74 0.46
Benchmarks
Cash Ratio, Competitors2
FedEx Corp. 0.34 0.50 0.44 0.63 0.55
Union Pacific Corp. 0.28 0.32 0.35 0.43 0.42
United Parcel Service Inc. 0.36 0.32 0.39 0.44 0.38
Cash Ratio, Sector
Industrial Transportation 0.35 0.37 0.41 0.52 0.44
Cash Ratio, Industry
Industrials 0.36 0.51 0.50 0.49 0.48

Based on: 10-K (filing date: 2019-02-06), 10-K (filing date: 2018-02-07), 10-K (filing date: 2017-02-14), 10-K (filing date: 2016-02-10), 10-K (filing date: 2015-02-11).

1 2018 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 1,111 ÷ 1,915 = 0.58

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. CSX Corp.’s cash ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.