Question
In: Finance
Southwest Airlines Company Consolidated Statement of Income - USD ($) $ in Millions 12 Months Ended...
|
Southwest Airlines Company Consolidated Statement of Income - USD ($) $ in Millions |
12 Months Ended |
|||||
|
12/31/15 |
12/31/2014 |
12/31/2013 |
Please tell me Excel formula for %s in column below in BOLD!!!! | |||
|
OPERATING REVENUES: |
||||||
|
Passenger |
$ 18,299 |
$ 17,658 |
$ 16,721 |
103.6% |
105.6% |
|
|
Freight |
179 |
175 |
164 |
102.3% |
||
|
Special revenue adjustment |
172 |
0 |
0 |
|||
|
Other |
1,170 |
772 |
814 |
151.6% |
||
|
Total operating revenues |
19,820 |
18,605 |
17,699 |
106.5% |
||
|
OPERATING EXPENSES: |
||||||
|
Salaries, wages, and benefits |
6,383 |
5,434 |
5,035 |
117.5% |
||
|
Fuel and oil |
3,616 |
5,293 |
5,763 |
68.3% |
||
|
Maintenance materials and repairs |
1,005 |
978 |
1,080 |
102.8% |
||
|
Aircraft rentals |
238 |
295 |
361 |
80.7% |
||
|
Landing fees and other rentals |
1,166 |
1,111 |
1,103 |
105.0% |
||
|
Depreciation and amortization |
1,015 |
938 |
867 |
108.2% |
||
|
Acquisition and integration |
39 |
126 |
86 |
31.0% |
||
|
Other operating expenses |
2,242 |
2,205 |
2,126 |
101.7% |
||
|
Total operating expenses |
15,704 |
16,380 |
16,421 |
95.9% |
||
Solutions
Expert Solution
The percentages are indicating the 2015 values as a percentage of 2014 values
Hence formula is 2015 value/ 2014 value (Percentage format-One decimal place)
Formula for 105.6% is 2014 value/ 2013 value
jeff jeffy answered 2 years agoRelated Solutions
need the vertical and horizontal analysis Consolidated Statements of Earnings (USD $) 12 Months Ended In...
need the vertical and horizontal analysis
Consolidated Statements of Earnings (USD $)
12 Months Ended
In Millions, except Per Share data, unless otherwise
specified
Feb. 01, 2015
Vertical Analysis
Feb. 02, 2014
Vertical Analysis
Horizontal Analysis
Income Statement [Abstract]
NET
SALES
$83,176
$78,812
Cost of
Sales
54,222
51,422
GROSS
PROFIT
28,954
27,390
Operating Expenses:
Selling,
General and Administrative
16,834
16,597
Depreciation and Amortization
1,651
1,627
Total
Operating Expenses
18,485
18,224
OPERATING
INCOME
10,469
9,166
Interest and Other (Income) Expense:
Interest...
Medtronic plc Consolidated Statements of Income 12 Months Ended ($ millions) 2017 EST. Apr. 29, 2016...
Medtronic plc
Consolidated Statements
of Income
12 Months Ended ($ millions)
2017 EST.
Apr. 29, 2016
Net sales
$35,531
$28,833
Costs and expenses
Cost of products sold
11,151
9,142
Research and development expense
2,709
2,224
Selling, general, and administrative expense
11,538
9,469
Special charges (gains), net
-
70
Restructuring charges, net
218
290
Certain litigation charges, net
-
26
Acquisition-related items
352
283
Amortization of intangible assets
1,931
1,931
Other expense, net
107
107
Operating profit
7,525
5,291
Interest expense,...
($ Millions) JetBlue Airways Southwest Airlines Total liabilities, 2017 $ 4,947 $  
($ Millions)
JetBlue Airways
Southwest Airlines
Total liabilities, 2017
$
4,947
$
13,973
Total current liabilities, 2017
$
2,395
$
6,905
Total liabilities, 2016
$
5,310
$
14,845
Total current liabilities, 2016
$
2,214
$
6,844
Total assets, 2017
$
9,781
$
25,110
Total current assets, 2017
$
1,206
$
4,815
Total assets, 2016
$
9,323
$
23,386
Total current assets, 2016
$
1,403
$
4,498
Revenue, 2017
$
7,015
$
21,171
Net income, 2017
$
1,147
$
3,488
(Please...
($ Millions) JetBlue Airways Southwest Airlines Total liabilities, 2017 $ 1,108 $  
($ Millions)
JetBlue Airways
Southwest Airlines
Total liabilities, 2017
$
1,108
$
13,973
Total liabilities, 2016
$
1,444
$
14,845
Total assets, 2017
$
9,781
$
25,110
Total current assets, 2017
$
1,206
$
4,815
Total assets, 2016
$
9,323
$
23,386
Total current assets, 2016
$
1,403
$
4,498
Revenue, 2017
$
7,015
$
21,171
Net income, 2017
$
1,147
$
3,488
(Please show calculations so I know how to do it)
a.) Compute the return on equity ratio...
($ Millions) JetBlue Airways Southwest Airlines Total liabilities, 2017 $ 4,947 $  
($ Millions)
JetBlue Airways
Southwest Airlines
Total liabilities, 2017
$
4,947
$
13,973
Total current liabilities, 2017
$
2,395
$
6,905
Total liabilities, 2016
$
5,310
$
14,845
Total current liabilities, 2016
$
2,214
$
6,844
Total assets, 2017
$
9,781
$
25,110
Total current assets, 2017
$
1,206
$
4,815
Total assets, 2016
$
9,323
$
23,386
Total current assets, 2016
$
1,403
$
4,498
Revenue, 2017
$
7,015
$
21,171
Net income, 2017
$
1,147
$
3,488
(Please...
Document and Entity Information - USD ($) 12 Months Ended Feb. 03, 2018 Mar. 08, 2018...
Document and Entity Information - USD ($)
12 Months Ended
Feb. 03, 2018
Mar. 08, 2018
Jul. 29, 2017
Document and Entity
Information
Entity Registrant Name
TARGET CORP
Entity Central Index Key
0000027419
Document Type
10-K
Document Period End Date
Feb. 03, 2018
Amendment Flag
false
Current Fiscal Year End Date
--02-03
Entity Well-known Seasoned
Issuer
Yes
Entity Voluntary Filers
No
Entity Current Reporting
Status
Yes
Entity Filer Category
Large Accelerated Filer
Entity Public Float
$ 30,595,914,184
Entity Common Stock,...
Use Southwest Airlines’ 2016 financial statement information,below to answer the following:Calculate Southwest Airlines’return...
Use Southwest Airlines' 2016 financial statement information,
below to answer the following:Calculate Southwest Airlines’
return on assets (ROA) for the year ending December 31, 2016.Disaggregate Southwest
Airlines' ROA into profit margin (PM) and asset turnover (AT).
Explain what each ratio measures.($
millions)Total operating
revenues$20,425Net income2,244Total assets,
beginning of year21,312Total assets,
end of year23,286Equity, end of
year8,441
Consolidated Statements of Income Years ended December 31 ($ millions) 2010 2009 2008 Net sales $26,662...
Consolidated Statements of Income
Years ended
December 31 ($ millions)
2010
2009
2008
Net sales
$26,662
$23,123
$25,269
Operating expenses
Cost of sales
13,831
12,109
13,379
Selling, general and administrative expenses
5,479
4,907
5,245
Research, development and related expenses
1,434
1,293
1,404
Loss/(gain) from sale of business
--
--
23
Total operating expenses
20,744
18,309
20,051
Operating income
5,918
4,814
5,218
Interest expenses and income
Interest expense
201
219
215
Interest income
(38)
(37)
(105)
Total interest expense
163
182...
12) ? (Most recent 12? months) Dell 2007 Apple 2007 Net Income? ($ millions) ?$3,572 ?$3,130...
12)
? (Most recent 12? months)
Dell 2007
Apple 2007
Net Income? ($ millions)
?$3,572
?$3,130
Shares outstanding? (millions)
?2,300
869.16
Earnings per share? ($)
?$1.55
?$3.60
Price per share? (8/1/07)
?$27.76
?$133.64
? Price-to-earnings ratio? (PE ratio)
17.91
37.11
Book value of common equity? ($ millions)
?$4,129
?$9,984
Book value per share? ($)
?$1.80
?$11.49
? Market-to-book ratio
15.42
11.63
?(Analyzing market values using financial?
ratios) On August? 1, 2007 the Dell Computer?
Corporation's stock closed trading at $27.76...
ABC Company Income Statement For the 12 month period ended 12/31/2016 Net Sales Cost of Sales...
ABC Company Income Statement
For the 12 month period ended 12/31/2016
Net Sales
Cost of Sales
$ 450,000
Gross Profit
$ 500,000
Operating Expenses:
Depreciation
$ 75,000
Amortization
$ 25,000
Other Operating Expenses
Total Operating Expenses
$ 400,000
Income From Operations
Interest Expense
Net Income Before Taxes
$ 80,000
Taxes- 30%
Net Income
EBITDA
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What 2 things happen to the melting point of a solid when an impurity is present?
- How Can Hominin Evolution be characterized as " mosaic evolution" Use examples of species from the...
- Absorption and Variable Costing Income Statements for Two Months and Analysis During the first month of...
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
- What are the options that might be considered in relation to introducing flexible work practices? What...
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
ADVERTISEMENT