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
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 are the six steps of hypothesis testing? What does it mean if we reject the...
- Consider the following network of a project consisting of 7 activities with a scheduled project duration...
- In 1941, President Roosevelt spoke about the “four freedoms.” For many in the country, however, these...
- Your friend is looking for investors in a risky business venture. To convince you to participate,...
- Suppose you observe the following situation: State of Economy Probability of State Return if State Occurs...
- Merger Analysis TransWorld Communications Inc., a large telecommunications company, is evaluating the possible acquisition of Georgia...
- Journal Entries and Trial Balance Elite Realty acts as an agent in buying, selling, renting, and...
ADVERTISEMENT