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 1 year agoRelated Solutions
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
Cash Flow Flag INCOME STATEMENT Fiscal year ends in December. USD in millions except per share...
Cash Flow Flag INCOME STATEMENT
Fiscal year ends in December. USD in millions except per share
data.
2013-12
2014-12
2015-12
2016-12
2017-12
TTM
Revenue
220156
200494
129925
110215
134674
154945
Cost of revenue
148882
136464
90788
78778
95114
110718
Gross profit
71274
64030
39137
31437
39560
44227
Costs and expenses
Sales, General and administrative
4510
4494
4443
4684
4448
4358
Interest expense
201
307
731
Other operating expenses
30859
28334
29852
28712
25584
21980
Total costs and expenses
35369
32828...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Moreover, what is the impact of trade surplus (exporting more than importing) and trade deficit (importing...
- 1. The economy's income and expenditure The following diagram presents a circular-flow model of a simple...
- Due to the covid-19 pandemic, the US economy entered a downturn that would eventually lead to...
- According to one survey taken a few years ago, 32% of American households have attempted to...
- You attach a 1.50 kg block to a horizontal spring that is fixed at one end....
- Organizations are currently open systems. Why are organizations considered open systems as opposed to closed systems?...
- In 2010, Ticketmaster found out the hard way that the entertainment industry is not, in fact,...
ADVERTISEMENT