Airline Analysis

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 20

International Airlines in the US

Key Statistics

IVA($m)

52,815.50

16,806.90

832

164

153,007

11,233.10

2007

57,879.80

18,380.10

841

165

155,636

12,213.90

2008

63,744.80

18,225.50

846

166

155,209

11,370.80

2009

50,905.30

15,985.00

832

164

146,137

10,460.00

2010

61,647.80

17,620.10

786

154

142,574

10,703.20

2011

65,406.80

18,115.00

756

149

144,979

11,234.20

2012

64,285.70

18,755.70

737

145

146,606

11,414.20

2013

64,249.60

21,528.50

711

140

143,506

12,199.50

2014

63,743.70

19,771.30

701

138

143,098

12,300.60

2015

66,246.00

21,062.90

708

139

146,421

12,466.20

2016

67,906.40

21,661.90

707

138

148,196

12,680.80

2017

68,976.50

21,807.80

706

138

149,404

12,823.50

2018

69,008.50

21,552.80

699

136

148,895

12,790.30

2019

68,232.50

20,935.90

691

135

147,472

12,649.40

2020

67,663.60

20,457.10

681

133

146,252

12,534.00

Year
2006

Establishment Enterprises
s(Units)
(Units)

Wages
Employment ($millions
(People)
)

Revenue
($millions)

Ratios
Revenue/
IVA/Revenue Employee
Year
(%)
($'000)
2006
31.8
345.2

Employees/
Wages/
Wages/
Establishmen Employee($
Revenue(%)
t
)
21.3

183.9

73,415.60

371.9

21.1

185.1

78,477.30

28.6

410.7

17.8

183.5

73,261.20

31.4

348.3

20.5

175.6

71,576.70

28.6

432.4

17.4

181.4

75,071.20

27.7

451.2

17.2

191.8

77,488.50

29.2

438.5

17.8

198.9

77,856.30

33.5

447.7

19

201.8

85,010.40

31

445.5

19.3

204.1

85,959.30

2015

31.8

452.4

18.8

206.8

85,139.40

2016

31.9

458.2

18.7

209.6

85,567.80

2017

31.6

461.7

18.6

211.6

85,831.00

2018

31.2

463.5

18.5

213

85,901.50

2019

30.7

462.7

18.5

213.4

85,774.90

2020

30.2

462.7

18.5

214.8

85,701.40

2007

31.8

2008
2009
2010
2011
2012
2013
2014

International
trips by US
residents
(Millions)
90
94
95
89
94
96
98
100
103
105
109
113
117
122
127

United Continental Holdings


Balance Sheet - Horizontal Analysis
In Millions of USD
As of 12-31-15As of 12-31-14Amount
%
Cash & Equivalents
3,006.00
2,002.00 $1,004.00
50%
Short Term Investments
2,190.00
2,382.00
$192.00
-8%
Cash and Short Term Investments
5,196.00
4,384.00
$812.00
19%
Accounts Receivable - Trade, Net
1,128.00
1,146.00
$18.00
-2%
Receivables - Other
Total Receivables, Net
1,128.00
1,146.00
$18.00
-2%
Total Inventory
738
666
$72.00
11%
Prepaid Expenses
740
774
$34.00
-4%
Other Current Assets, Total
26
577
$551.00 -95%
Total Current Assets
7,828.00
7,547.00
$281.00
4%
Property/Plant/Equipment, Total - Gross
30,917.00
27,432.00 $3,485.00
13%
Accumulated Depreciation, Total
-9,337.00
-7,965.00 $1,372.00
17%
Goodwill, Net
4,523.00
4,523.00
$0.00
0%
Intangibles, Net
4,136.00
4,284.00
$148.00
-3%
Long Term Investments
Other Long Term Assets, Total
2,794.00
774 $2,020.00 261%
Total Assets
40,861.00
36,595.00 $4,266.00
12%
Accounts Payable
1,869.00
1,882.00
$13.00
-1%
Accrued Expenses
2,350.00
1,818.00
$532.00
29%
Notes Payable/Short Term Debt
0
0
$0.00
Current Port. of LT Debt/Capital Leases
1,359.00
1,423.00
$64.00
-4%
Other Current liabilities, Total
6,836.00
7,385.00
$549.00
-7%
Total Current Liabilities
12,414.00
12,508.00
$94.00
-1%
Long Term Debt
9,673.00
9,953.00
$280.00
-3%
Capital Lease Obligations
727
571
$156.00
27%
Total Long Term Debt
10,400.00
10,524.00
$124.00
-1%
Total Debt
11,759.00
11,947.00
$188.00
-2%
Deferred Income Tax
0
1,000.00 $1,000.00 -100%
Minority Interest
Other Liabilities, Total
9,081.00
10,167.00 $1,086.00 -11%
Total Liabilities
31,895.00
34,199.00 $2,304.00
-7%
Redeemable Preferred Stock, Total
Preferred Stock - Non Redeemable, Net
Common Stock, Total
4
4
$0.00
0%
Additional Paid-In Capital
7,946.00
7,721.00
$225.00
3%
Retained Earnings (Accumulated Deficit)
3,457.00
-3,883.00 $7,340.00 -189%
Treasury Stock - Common
-1,610.00
-367 $1,243.00 339%
Other Equity, Total
-616
-580
$36.00
6%
Total Equity
8,966.00
2,396.00 $6,570.00 274%
Total Liabilities & Shareholders' Equity
40,861.00
36,595.00 $4,266.00
12%
Shares Outs - Common Stock Primary IssueTotal Common Shares Outstanding
364.61
374.53
$9.92
-3%

Delta Air Lines


Balance Sheet - Horizontal Analysis
In Millions of USD
As of 12-31-15As of 12-31-14Amount
%
Cash & Equivalents
1,972.00
2,088.00
$116.00
-6%
Short Term Investments
1,465.00
1,217.00
$248.00
20%
Cash and Short Term Investments
3,437.00
3,305.00
$132.00
4%
Accounts Receivable - Trade, Net
2,020.00
2,297.00
$277.00 -12%
Receivables - Other
Total Receivables, Net
2,139.00
3,222.00 $1,083.00 -34%
Total Inventory
697
852
$155.00 -18%
Prepaid Expenses
796
701
$95.00
14%
Other Current Assets, Total
1,987.00
1,078.00
$909.00
84%
Total Current Assets
9,056.00
9,158.00
$102.00
-1%
Property/Plant/Equipment, Total - Gross
33,910.00
31,269.00 $2,641.00
8%
Accumulated Depreciation, Total
-10,871.00
-9,340.00 $1,531.00
16%
Goodwill, Net
9,794.00
9,794.00
$0.00
0%
Intangibles, Net
4,861.00
4,603.00
$258.00
6%
Long Term Investments
Other Long Term Assets, Total
6,384.00
8,521.00 $2,137.00 -25%
Total Assets
53,134.00
54,005.00
$871.00
-2%
Accounts Payable
2,743.00
2,622.00
$121.00
5%
Accrued Expenses
4,501.00
4,393.00
$108.00
2%
Notes Payable/Short Term Debt
0
0
$0.00
Current Port. of LT Debt/Capital Leases
1,563.00
1,184.00
$379.00
32%
Other Current liabilities, Total
8,719.00
8,648.00
$71.00
1%
Total Current Liabilities
17,526.00
16,847.00
$679.00
4%
Long Term Debt
6,766.00
8,477.00 $1,711.00 -20%
Capital Lease Obligations
Total Long Term Debt
6,766.00
8,477.00 $1,711.00 -20%
Total Debt
8,329.00
9,661.00 $1,332.00 -14%
Deferred Income Tax
Minority Interest
Other Liabilities, Total
17,992.00
19,868.00 $1,876.00
-9%
Total Liabilities
42,284.00
45,192.00 $2,908.00
-6%
Redeemable Preferred Stock, Total
Preferred Stock - Non Redeemable, Net
Common Stock, Total
0
0
$0.00
Additional Paid-In Capital
10,875.00
12,981.00 $2,106.00 -16%
Retained Earnings (Accumulated Deficit)
7,623.00
3,456.00 $4,167.00 121%
Treasury Stock - Common
-373
-313
$60.00
19%
Other Equity, Total
-7,214.00
-7,295.00
$81.00
-1%
Total Equity
10,850.00
8,813.00 $2,037.00
23%
Total Liabilities & Shareholders' Equity
53,134.00
54,005.00
$871.00
-2%
Shares Outs - Common Stock Primary IssueTotal Common Shares Outstanding
778.78
825.26
$46.48
-6%

United Continenal Holdings


Income Statement - Horizontal Analysis
3 months ending 3 months ending
In Millions of USD
12/31/2015
12/31/2014
Revenue
9,036.00
9,313.00
Other Revenue, Total
Total Revenue
9,036.00
9,313.00
Cost of Revenue, Total
6,052.00
6,910.00
Gross Profit
2,984.00
2,403.00
Selling/General/Admin. Expenses, Total
Research & Development
Depreciation/Amortization
476
431
Interest Expense(Income) - Net Operating
Unusual Expense (Income)
131
179
Other Operating Expenses, Total
1,296.00
1,168.00
Total Operating Expense
7,955.00
8,688.00
Operating Income
1,081.00
625
Interest Income(Expense), Net Non-Operating
Gain (Loss) on Sale of Assets
Other, Net
-31
-443
Income Before Tax
905
23
Income After Tax
823
28
Minority Interest
Equity In Affiliates
Net Income Before Extra. Items
823
28
Accounting Change
Discontinued Operations
Extraordinary Item
Net Income
823
28
Preferred Dividends
Income Available to Common Excl. Extra Items
823
30
Income Available to Common Incl. Extra Items
823
30
Dilution Adjustment
0Diluted Weighted Average Shares
368
375
Diluted EPS Excluding Extraordinary Items
2.24
0.08
Diluted EPS Including Extraordinary Items
Dividends per Share - Common Stock Primary Issue
0
0
Gross Dividends - Common Stock
Net Income after Stock Based Comp. Expense
Basic EPS after Stock Based Comp. Expense
Diluted EPS after Stock Based Comp. Expense
Depreciation, Supplemental
Total Special Items
Normalized Income Before Taxes
Effect of Special Items on Income Taxes
Income Taxes Ex. Impact of Special Items
Normalized Income After Taxes
Normalized Income Avail to Common
Diluted Normalized EPS
2.56
0.39

Delta Air Lines


Income Statement - Horizontal Analysis
3 months ending 3 months ending
n Millions of USD
12/31/2015
12/31/2014
Revenue
9,502.00
9,647.00
Other Revenue, Total
Total Revenue
9,502.00
9,647.00
Cost of Revenue, Total
3,788.00
8,671.00
Gross Profit
5,714.00
976
Selling/General/Admin. Expenses, Total
2,682.00
2,508.00
Research & Development
Depreciation/Amortization
451
438
Interest Expense(Income) - Net Operating
Unusual Expense (Income)
0
72
Other Operating Expenses, Total
773
757
Total Operating Expense
7,785.00
10,480.00
Operating Income
1,717.00
-833
Interest Income(Expense), Net Non-Operating
Gain (Loss) on Sale of Assets
Other, Net
-82
-170
Income Before Tax
1,533.00
-1,140.00
Income After Tax
980
-712
Minority Interest
Equity In Affiliates
Net Income Before Extra. Items
980
-712
Accounting Change
Discontinued Operations
Extraordinary Item
Net Income
980
-712
Preferred Dividends
Income Available to Common Excl. Extra Items
980
-712
Income Available to Common Incl. Extra Items
980
-712
Dilution Adjustment
Diluted Weighted Average Shares
783
825
Diluted EPS Excluding Extraordinary Items
1.25
-0.86
Diluted EPS Including Extraordinary Items
Dividends per Share - Common Stock Primary Issue
0.14
0.09
Gross Dividends - Common Stock
Net Income after Stock Based Comp. Expense
Basic EPS after Stock Based Comp. Expense
Diluted EPS after Stock Based Comp. Expense
Depreciation, Supplemental
Total Special Items
Normalized Income Before Taxes
Effect of Special Items on Income Taxes
Income Taxes Ex. Impact of Special Items
Normalized Income After Taxes
Normalized Income Avail to Common
Diluted Normalized EPS
1.25
-0.81

Amount
%
$277.00

-3%

$277.00
$858.00
$581.00

-3%
-12%
24%

$45.00

10%

$48.00
$128.00
$733.00
$456.00

-27%
11%
-8%
73%

$412.00
$882.00
$795.00

-93%
3835%
2839%

$795.00

2839%

$795.00

2839%

$793.00
$793.00

2643%
2643%

$7.00
$2.16

-2%
2700%

$0.00 #DIV/0!

$2.17

556%

Amount
%
$145.00

-2%

$145.00
$4,883.00
$4,738.00
$174.00

-2%
-56%
485%
7%

$13.00

3%

$72.00
$16.00
$2,695.00
$2,550.00

-100%
2%
-26%
-306%

$88.00
$2,673.00
$1,692.00

-52%
-234%
-238%

$1,692.00

-238%

$1,692.00

-238%

$1,692.00
$1,692.00

-238%
-238%

$42.00
$2.11

-5%
-245%

$0.05

56%

$2.06

-254%

United Continental Holdings


Balance Sheet - Vertical Analysis
In Millions of USD (except for per share items)
Cash & Equivalents
Short Term Investments
Cash and Short Term Investments
Accounts Receivable - Trade, Net
Receivables - Other
Total Receivables, Net
Total Inventory
Prepaid Expenses
Other Current Assets, Total
Total Current Assets
Property/Plant/Equipment, Total - Gross
Accumulated Depreciation, Total
Goodwill, Net
Intangibles, Net
Long Term Investments
Other Long Term Assets, Total
Total Assets
Accounts Payable
Accrued Expenses
Notes Payable/Short Term Debt
Current Port. of LT Debt/Capital Leases
Other Current liabilities, Total
Total Current Liabilities
Long Term Debt
Capital Lease Obligations
Total Long Term Debt
Total Debt
Deferred Income Tax
Minority Interest
Other Liabilities, Total
Total Liabilities
Redeemable Preferred Stock, Total
Preferred Stock - Non Redeemable, Net
Common Stock, Total
Additional Paid-In Capital
Retained Earnings (Accumulated Deficit)
Treasury Stock - Common
Other Equity, Total
Total Equity
Total Liabilities & Shareholders' Equity
Shares Outs - Common Stock Primary Issue
Total Common Shares Outstanding

12/31/2015 12/31/2014
3,006.00
2,002.00
2,190.00
2,382.00
5,196.00
4,384.00
1,128.00
1,146.00
1,128.00
1,146.00
738
666
740
774
26
577
7,828.00
7,547.00
30,917.00
27,432.00
-9,337.00
-7,965.00
4,523.00
4,523.00
4,136.00
4,284.00
2,794.00
774
40,861.00
36,595.00
1,869.00
1,882.00
2,350.00
1,818.00
0
0
1,359.00
1,423.00
6,836.00
7,385.00
12,414.00
12,508.00
9,673.00
9,953.00
727
571
10,400.00
10,524.00
11,759.00
11,947.00
0
1,000.00
9,081.00
10,167.00
31,895.00
34,199.00
4
4
7,946.00
7,721.00
3,457.00
-3,883.00
-1,610.00
-367
-616
-580
8,966.00
2,396.00
40,861.00
36,595.00
364.61
374.53

Delta Air lines


Balance Sheet - Vertical Analysis
In Millions of USD (except for per share items)
Cash & Equivalents
Short Term Investments
Cash and Short Term Investments
Accounts Receivable - Trade, Net
Receivables - Other
Total Receivables, Net
Total Inventory
Prepaid Expenses
Other Current Assets, Total
Total Current Assets
Property/Plant/Equipment, Total - Gross
Accumulated Depreciation, Total
Goodwill, Net
Intangibles, Net
Long Term Investments
Other Long Term Assets, Total
Total Assets
Accounts Payable
Accrued Expenses
Notes Payable/Short Term Debt
Current Port. of LT Debt/Capital Leases
Other Current liabilities, Total
Total Current Liabilities
Long Term Debt
Capital Lease Obligations
Total Long Term Debt
Total Debt
Deferred Income Tax
Minority Interest
Other Liabilities, Total
Total Liabilities
Redeemable Preferred Stock, Total
Preferred Stock - Non Redeemable, Net
Common Stock, Total
Additional Paid-In Capital
Retained Earnings (Accumulated Deficit)
Treasury Stock - Common
Other Equity, Total
Total Equity
Total Liabilities & Shareholders' Equity
Shares Outs - Common Stock Primary Issue
Total Common Shares Outstanding

12/31/2015 12/31/2014
1,972.00
2,088.00
1,465.00
1,217.00
3,437.00
3,305.00
2,020.00
2,297.00
2,139.00
3,222.00
697
852
796
701
1,987.00
1,078.00
9,056.00
9,158.00
33,910.00
31,269.00
-10,871.00
-9,340.00
9,794.00
9,794.00
4,861.00
4,603.00
6,384.00
8,521.00
53,134.00
54,005.00
2,743.00
2,622.00
4,501.00
4,393.00
0
0
1,563.00
1,184.00
8,719.00
8,648.00
17,526.00
16,847.00
6,766.00
8,477.00
6,766.00
8,477.00
8,329.00
9,661.00
17,992.00
19,868.00
42,284.00
45,192.00
0
0
10,875.00
12,981.00
7,623.00
3,456.00
-373
-313
-7,214.00
-7,295.00
10,850.00
8,813.00
53,134.00
54,005.00
778.78
825.26

2015
7.4%
5.4%
12.7%
2.8%

2014
5.5%
6.5%
12.0%
3.1%

2.8%
1.8%
1.8%
0.1%
19.2%
75.7%
-22.9%
11.1%
10.1%

3.1%
1.8%
2.1%
1.6%
20.6%
75.0%
-21.8%
12.4%
11.7%

6.8%
100.0%
4.6%
5.8%

2.1%
100.0%
5.1%
5.0%

3.3%
16.7%
30.4%
23.7%
1.8%
25.5%
28.8%
0.0%

3.9%
20.2%
34.2%
27.2%
1.6%
28.8%
32.6%
2.7%

22.2%
78.1%

27.8%
93.5%

0.0%
19.4%
8.5%
-3.9%
-1.5%
21.9%
100.0%

0.0%
21.1%
-10.6%
-1.0%
-1.6%
6.5%
100.0%

2015
3.7%
2.8%
6.5%
3.8%

2014
3.9%
2.3%
6.1%
4.3%

4.0%
1.3%
1.5%
3.7%
17.0%
63.8%
-20.5%
18.4%
9.1%

6.0%
1.6%
1.3%
2.0%
17.0%
57.9%
-17.3%
18.1%
8.5%

12.0%
100.0%
5.2%
8.5%

15.8%
100.0%
4.9%
8.1%

2.9%
16.4%
33.0%
12.7%

2.2%
16.0%
31.2%
15.7%

12.7%
15.7%

15.7%
17.9%

33.9%
79.6%

36.8%
83.7%

0.0%
20.5%
14.3%
-0.7%
-13.6%
20.4%
100.0%

0.0%
24.0%
6.4%
-0.6%
-13.5%
16.3%
100.0%

United Continental Holdings


Income Statement - Vertical Analysis
3 months ending 3 months ending
In Millions of USD (except for per share items) 2015-12-31
12/31/2014
Revenue
9,036.00
9,313.00
Other Revenue, Total
Total Revenue
9,036.00
9,313.00
Cost of Revenue, Total
6,052.00
6,910.00
Gross Profit
2,984.00
2,403.00
Selling/General/Admin. Expenses, Total
Research & Development
Depreciation/Amortization
476
431
Interest Expense(Income) - Net Operating
Unusual Expense (Income)
131
179
Other Operating Expenses, Total
1,296.00
1,168.00
Total Operating Expense
7,955.00
8,688.00
Operating Income
1,081.00
625
Interest Income(Expense), Net Non-Operating Gain (Loss) on Sale of Assets
Other, Net
-31
-443
Income Before Tax
905
23
Income After Tax
823
28
Minority Interest
Equity In Affiliates
Net Income Before Extra. Items
823
28
Accounting Change
Discontinued Operations
Extraordinary Item
Net Income
823
28
Preferred Dividends
Income Available to Common Excl. Extra Items
823
30
Income Available to Common Incl. Extra Items
823
30
Dilution Adjustment
0Diluted Weighted Average Shares
368
375
Diluted EPS Excluding Extraordinary Items
2.24
0.08
Diluted EPS Including Extraordinary Items
Dividends per Share - Common Stock Primary Is
0
0
Gross Dividends - Common Stock
Net Income after Stock Based Comp. Expense Basic EPS after Stock Based Comp. Expense
Diluted EPS after Stock Based Comp. Expense Depreciation, Supplemental
Total Special Items
Normalized Income Before Taxes
Effect of Special Items on Income Taxes
Income Taxes Ex. Impact of Special Items
Normalized Income After Taxes
Normalized Income Avail to Common
Diluted Normalized EPS
2.56
0.39

Delta Air lines


Income Statement - Vertical Analysis
In Millions of USD (except for per share items) 3 months ending3 months ending
Revenue
9,502.00
9,647.00
Other Revenue, Total
Total Revenue
9,502.00
9,647.00
Cost of Revenue, Total
3,788.00
8,671.00
Gross Profit
5,714.00
976.00
Selling/General/Admin. Expenses, Total
2682
2508
Research & Development
Depreciation/Amortization
451
438
Interest Expense(Income) - Net Operating
Unusual Expense (Income)
0
72
Other Operating Expenses, Total
773.00
757.00
Total Operating Expense
7,785.00
10,480.00
Operating Income
1,717.00
-833
Interest Income(Expense), Net Non-Operating Gain (Loss) on Sale of Assets
Other, Net
-82
-170
Income Before Tax
1533
-1140
Income After Tax
980
-712
Minority Interest
Equity In Affiliates
Net Income Before Extra. Items
980
-712
Accounting Change
Discontinued Operations
Extraordinary Item
Net Income
980
-712
Preferred Dividends
Income Available to Common Excl. Extra Items
980
-712
Income Available to Common Incl. Extra Items
980
-712
Dilution Adjustment
Diluted Weighted Average Shares
783
825
Diluted EPS Excluding Extraordinary Items
1.25
-0.86
Diluted EPS Including Extraordinary Items
Dividends per Share - Common Stock Primary Is
0.14
0.09
Gross Dividends - Common Stock
Net Income after Stock Based Comp. Expense Basic EPS after Stock Based Comp. Expense
Diluted EPS after Stock Based Comp. Expense Depreciation, Supplemental
Total Special Items
Normalized Income Before Taxes
Effect of Special Items on Income Taxes
Income Taxes Ex. Impact of Special Items
Normalized Income After Taxes
Normalized Income Avail to Common
Diluted Normalized EPS
1.25
-0.81

2015

2014

100%
67.0%
33.0%

100%
74%
26%

5.3%

5%

1.4%
14.3%
88.0%
12.0%

2%
13%
93%
7%

-0.3%
10.0%
9.1%

-5%
0%
0%

9.1%

0%

9.1%

0%

9.1%
9.1%
0.0%
4.1%
0.0%

0%
0%
4%
0%

2015

2014

100%
39.9%
60.1%
28.2%

100%
90%
10%
26%

4.7%

5%

0.0%
8.1%
81.9%
18.1%

1%
8%
109%
-9%

-0.9%
16.1%
10.3%

-2%
-12%
-7%

10.3%

-7%

10.3%

-7%

10.3%
10.3%

-7%
-7%

8.2%
0.0%

9%
0%

Ratio Analysis
United Continental Holdings

Delta Air Lines

Liquidity Ratios

2015
2014
2015
Quick Ratio (Liquidity ratio, measures ability to pay current liabilities)
Cash
3,006.00
2,002.00
1,972.00
Cash Equiv
0
Short Term Investments
2,190.00
2,382.00
1,465.00
Current Receivables
1,128.00
1,146.00
2,139.00
Current Liabilities
12,414.00
12,508.00
17,526.00
Qucik Ratio
0.51
0.44
0.32
Total Current Assets
Inventory
Prepaid Expenses
Current Liabilities
Quick Ratio

7,828.00
738.00
740.00
12,414.00
0.51

7,547.00
666.00
774.00
12,508.00
0.49

9,056.00
697.00
796.00
17,526.00
0.43

Current Ratio
(Liquidity and efficiency ratio, measurements ability pay off short-term liabilities using cur
Current Assets
7,828.00
7,547.00
9,056.00
Current Liabilities
12,414.00
12,508.00
17,526.00
Current Ratio
0.63
0.60
0.52

Solvency Ratios
Debt to Equity Ratio (measures liquidity)
Total Liabilities
31,895.00
Total Equity
8,966.00
Debt to Equity Ratio
3.56

34,199.00
2,396.00
14.27

42,284.00
10,850.00
3.90

Efficiency Ratios
Accounts Receivable Turnover (how many times A/R is turned into cash during a period)
Net credit sales
37,864.00
38,901.00
40,704.00
Avg. Accounts A/R
1,137.00
2,560.00
5,361.00
A/R Turnover
33.30
15.20
7.59
Inventory Turnover (how many times the inventory is sold during a period)
Cost of Goods Sold
25,475.00
29,263.00
15,545.00
Avergare Inventory
702.00
1,333.00
774.50
Inventory Turnover
36.29
21.95
20.07

Profitability Ratios
Gross Margin
Gross Margin(gross profit)
Net Sales
Gross Margin Ratio

12,389.00
37,864.00
0.33

Profit Margin (Gross Profit Ratio)

9,638.00
38,901.00
0.25

25,159.00
15,545.00
1.62

Net Income
Net Sales
Profit Margin

7,340.00
37,864.00
0.19

1,132.00
38,901.00
0.03

4,526.00
15,545.00
0.29

7,340.00
8,966.00
0.82

1,132.00
2,396.00
0.47

4,526.00
10,850.00
0.42

7,340.00
8,966.00
0.82

1,132.00
2,396.00
0.47

4,526.00
###
10,850.00
0.42

54.09
0.82
66.07

54.09
0.47
114.49

42.90
0.42
102.84

7,340.00
-

1,132.00
-

280.20
4,526.00
0.06

54.09
-

54.09
-

0.14
42.90
0.003

Debt Ratio
Total Liabilities
Total Assets
Debt Ratio

31,895.00
40,861.00
0.78

34,199.00
36,595.00
0.93

42,284.00
53,134.00
0.80

Debt to Equity
Total Liabilities
Total Equity
Debt to Equity Ratio

31,895.00
8,966.00
3.56

34,199.00
2,396.00
14.27

42,284.00
10,850.00
3.90

Equity
Total Equity
Total Assets
Equity Ratio

8,966.00
40,861.00
0.22

2,396.00
36,595.00
0.07

10,850.00
53,134.00
0.20

Return on Equity
Net Income
Shareholders Equity
Return on Equity

Market Ratios
Earnings per share
Net Income
Preferred Dividends
Weighted Avg Common Share
Earnings per share
P/E
Market Value Price per Shar
Earnings per Share
P/E
Dividend Payout
Total Dividends
Net Income
Dividend Payout
Dividend Yield
Cash Dividends per Share
Market Value per Share
Dividend Yield

Financial Leverage Ratios

ir Lines
2014
2,088.00
0
1,217.00
3,222.00
16,847.00
0.39
9,158.00
852.00
701.00
16,847.00
0.45

ies using current assets)


9,158.00
16,847.00
0.54

45,192.00
8,813.00
5.13

a period)
40,362.00
4,834.00
8.35

25,080.00
957.50
26.19

15,282.00
25,080.00
0.61

659.00
25,080.00
0.03

659.00
8,813.00
0.07

659.00
8,813.00
0.07

39.24
0.07
573.71

435.60
659.00
0.66

0.09
39.24
0.002

45,192.00
54,005.00
0.84

45,192.00
8,813.00
5.13

8,813.00
54,005.00
0.16

You might also like