hca
.xlsx
keyboard_arrow_up
School
University of Notre Dame *
*We aren’t endorsed by this school
Course
205
Subject
Finance
Date
Feb 20, 2024
Type
xlsx
Pages
18
Uploaded by JusticeTroutPerson976
2016
2015
2014
2013
2012
$44,747 $43,591 $40,087 $38,040 $36,783 3,257 3,913 3,169 3,858 3,770 Revenues
41,490 39,678 36,918 34,182 33,013 18,897 18,115 16,641 15,646 15,089 Supplies
6,933 6,638 6,262 5,970 5,717 7,508 7,103 6,755 6,237 6,048 (12)
(47)
(125)
(216)
(336)
(54)
(46)
(43)
(29)
(36)
EBITDA 8,218 7,915 7,428 6,574 6,531 1,966 1,904 1,820 1,753 1,679 1,707 1,665 1,743 1,848 1,798 (23)
5 (29)
10 (15)
4 135 335 17 -
(246)
249 78 -
175 36,680 35,721 33,437 31,236 30,119 4,810 3,957 3,481 2,946 2,894 Exhibit 1 Consolidated Income Statements and Selected Financial Data (millions of dol
Summary of Operations:
Revenues before provision for doubtful accounts
Provision for doubtful accounts
Salaries and benefits
Other operating expenses
Electronic health record incentive income
Equity in earnings of affiliates
Depreciation and amortization
Interest expense
Losses (gains) on sales of facilities
Losses on retirement of debt
Legal claim costs (benefits)
Total Expenses
Income before income taxes
1,378 1,261 1,108 950 888 Net income
3,432 2,696 2,373 1,996 2,006 542 567 498 440 401 $ 7.53 $ 5.14 $ 4.30 $ 3.50 $ 3.65 $ 7.30 $ 4.99 $ 4.16 $ 3.37 $ 3.49 $ - $ - $ - $ - $ 6.50 Assets
$33,758 $32,744 $30,980 $28,594 $27,785 Working capital
3,252 3,716 3,450 2,342 1,591 31,376 30,488 29,426 28,139 28,640 1,669 1,553 1,396 1,342 1,319 (5,633)
(6,046)
(6,498)
(6,928)
(8,341)
Provision for income taxes
Net income attributa
ble to non-
controlli
ng interests
Net income attributable to HCA Holdings, Inc.
$ 2,890
$ 2,129
$ 1,875
$ 1,556
$ 1,605
Per common share data:
Basic earnings per share
Diluted earnings per share
Cash dividends declared per share
Financial Position:
Long-
term debt, net, includin
g amount
s due within one year
Non-controlling interests
Stockholders’ deficit
Cash Flow Data:
(3,240)
(2,583)
(2,918)
(2,346)
(2,063)
(2,760)
(2,375)
(2,176)
(1,943)
(1,862)
(2,508)
(1,976)
(1,378)
(1,625)
(1,780)
Cash available f
$ 5,219
$ 4,239
$ 4,006
$ 3,245
$ 3,774
Cash used in investing activities
Capital expenditures
Cash used in financing activities
llars except per share amounts)
2016
2015
ASSETS
Current assets:
5,826
5,889
Inventories
1,503
1,439
Other
1,111
1,163
9,086
9,232
16,352
15,014
Other
1,616
1,767
6,704
6,731
Total assets
$33,758 $32,744 1,265
1,233
2,035
1,880
Exhibit 2 Consolidated Balance Sheets (December 31; millions of dollars)
Cash and cash equivalents
$ 646
$ 741
Accounts receivable, less allowance for doubtful accounts of $4,988 and $5,326
Total current assets
Net property and equipment
Goodwill and other intangibles
LIABILITIES AND STOCKHOLD
ERS’ DEFICIT
Current Liabilities:
Accounts payable
$ 2,318
$ 2,170
Accrued salaries
Other accrued expenses
216
233
5,834
5,516
31,160
30,255
1,148
1,115
1,249
1,904
4
4
-338
-265
Retained deficit
-6,968
-7,338
-7,302
-7,599
1,669
1,553
-5,633
-6,046
$33,758 $32,744 Long-term debt due within one year
Total current liabilities
Long-term debt, less net debt issuance costs of $170 and $167
Professional liability risks
Income taxes and other liabilities
Stockholders’ deficit:
Commo
n stock $0.01 par
Accumulated other comprehensive loss
Stockholders’ deficit attributable to HCA Holdings, Inc.
Non-controlling interests
Total stockholders’ deficit
Total Liabilities and Stockholders’ Deficit
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Am. 323.
arrow_forward
Sales Revenue
Cost of Goods Sold
Income from Operations
Selling and Administrative Expenses
Budgeted Income Statement
For the Year Ending December 31, 2022
Income from Operations
Interest Expense
Income before Income Taxes
Interest Expense
Not Income (Loss)
$
326,400
(166,380) i
160,020
88,500
i
71,520
(4,130
67,390
(13,478
53912
arrow_forward
Please dont provide solution image based answers thanku
arrow_forward
BC 266: EXCEL PROBLEM PR 17-2A:VERTICAL ANALYSIS
For 2016, Indigo Corp. initiated a sales promotion campaign that included an expenditure of $39,000 for advertising. At year end the company President is presented with the following condensed Comparative Income Statement:
20162015
Sales revenue $820,000 $600,000
COGS [Cost of Goods Sold]311,600240,000
Gross profit508,400360,000
Selling expenses 164,000 108,000
Administrative expenses 57,40054,000
Total operating expenses 221,400162,000
Income from operations [NOI] 287,000 198,000
Other income 65,600 48,000
Income before income tax 352,600 246,000
Income tax expense246,000180,000
Net Income [NI] 106,600 66,000
Prepare a Comparative Income Statement using Vertical Analysis for the two-year period. Present each item as a % of sales for the given year and round your values to one decimal place.
arrow_forward
Question 2 Following are some important figures from the budget of Jasmine, Inc., for the
year 2016: February March April Credit sales $289,000 $265,000 $378,000 Credit purchases $
89,000 $126,000 $187,000 Cash disbursements Wages, taxes, and expenses $46,000 $
41,000 $58,000 Interest $12,700 $12,700 $12, 700 Equipment purchases $67,000 $133,000 $
0 The company predicts that 3% of its credit sales will never be collected, 47% of its sales will
be collected in the month of the sale, and the remaining 50% will be collected in the following
month. Credit purchases will be paid in the month following the purchase. In Jan 2016, credit
sales were $245,000, and credit purchases were $95,000. The beginning cash balance of Feb
is $ 120,000. Prepare a cash budget for Jasmine, Inc., for the months of February, March and
April.
arrow_forward
Summary Data for April
Support Department
Support Departments
Production Departments
Information
Research and
Technology
Travel Service
Analysis
Audit
Tax
Consulting
Total
IT: Number of employees
TS: Number of trips
9
5
15
120
150
110
409
15
12
10
120
160
520
837
RA: Number of requests
Costs to Allocate
15
10
4
125
120
280
554
$ 810,000.00 $125,000.00 $1,280,000.00 $
$
$
$2,215,000.00
Question
Answer
1. Which of the following is the closest approximation of the sales forecast's upper confidence
bound for the 1/1/2028 quarter?
2. Based on the graph and the breadth of the confidence intervals, which seems easier to
predict, sales or income before extraordinary items?
3. What is the sales forecast's upper confidence bound for the 10/1/2027 quarter?
4. What is the forecast lower confidence bound for the 4/1/2027 quarter?
5. What is the forecast for income before extraordinary items for Nintendo for the quarter starting
10/1/2027?
arrow_forward
Provide correct solution
arrow_forward
14-19 Customer profitability, customer-cost hierarchy. Enviro-Tech has only two retail and two wholesale customers. Information relating to each customer for 2017 follows (in thousands):Wholesale Customers Retail CustomersNorth AmericaWholesalerSouth AmericaWholesaler Green Energy Global PowerRevenues at list prices $375,000 $590,000 $175,000 $130,000Discounts from list prices 25,800 47,200 8,400 590Cost of goods sold 285,000 510,000 144,000 95,000Delivery costs 4,550 6,710 2,230 2,145Order processing costs 3,820 5,980 2,180 1,130Cost of sales visit 6,300 2,620 2,620 1,575Enviro-Tech’s annual distribution-channel costs are $33 million for wholesale customers and $12 million forretail customers. The company’s annual corporate-sustaining costs, such as salary for top managementand general-administration costs are $48 million. There is no cause-and-effect or benefits-received relationship between any cost-allocation base and corporate-sustaining costs. That is, Enviro-Tech could…
arrow_forward
Required: Solve for the missing items in the partial income
statements given below:
E9-8
2015
2016
2012
2013
2014
Sales
100,000
120,000
150,000
160,000
Gross Profit
44,000
39,000
18,000
Beginning
80,000
70,000
85,000
75,000
Inventory
Net Purchases
90,000
80,000
120,000
165,000
Cost of goods sold 70,000
135,000
Sales ret & allow
6,000
18,000
Ending inventory
65,000
85,000
100,000
Net sales
117,000
144,000
150,000
arrow_forward
Ramos Company
Ramos Company included the following information in its annual report:
2011
2010
2009
Sales
$178,400
$162,500
$155,500
Cost of goods sold
115,000
102,500
100,000
Operating expenses
50,000
50,000
45,000
Net income
13,400
10,000
10,500
Refer to the information for Ramos Company. In a common size income statement for 2011, the operating expenses are expressed as:
Group of answer choices
100 %
50.6 %
30.3 %
28.0 %
arrow_forward
Sh11
arrow_forward
A1
arrow_forward
ILLUSTRATION 4. Following information is given.
2014
2015
$
$
75,000
50,000
1,50,000
75,000
Sales
Cost of goods sold
Gross profit on sales
25,000
75,000
During the year 2015, increase in quantity (or volume) was 20%. You are required to :
(i) calculate per cent change in selling price and cost of production.
arrow_forward
How do I figure out the pretax net nonoperating expense ?
(in thousands)
Dec. 29, 2016
Dec. 30, 2015
Revenues
Circulation
$ 880,543
$ 851,790
Advertising
580,732
638,709
Other
94,067
88,716
Total revenues
1,555,342
1,579,215
Production costs
Wages and benefits
363,051
354,516
Raw materials
72,325
77,176
Other
192,728
186,120
Total production costs
628,104
617,812
Selling, general and administrative costs
721,083
713,837
Depreciation and amortization
61,723
61,597
Total operating costs
1,410,910
1,393,246
Restructuring charge
14,804
0
Multiemployer pension plan withdrawal expense
6,730
9,055
Pension settlement charges
21,294
40,329
Early termination charge
0
0
Operating profit
101,604
136,585
Loss from joint ventures
(36,273)
(783)
Interest expense, net
34,805
39,050
Income from continuing operations…
arrow_forward
Management accounting assistance need ASAP
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Perform profitability analysis for the two quotas
arrow_forward
AN: Q6 Q7 Q8
The budget director of Birds and Beyond, Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January 2021:
Estimated sales for January:
Birdhouse 7.500 units at $66 per unit
Bird feeder 5,000 units at $82 per unit
Estimated inventories at January 1:
Direct Materials: Finished Products:
Wood: 198 ft. Birdhouse: 500 units at $28 per unit.
Plastic: 420 lbs. Bird feeder: 210 units at $40 per unit.
Desired inventories at January 31:
Direct Materials: Finished Products:
Wood: 220 ft. Birdhouse: 400 units at $28 per unit.
Plastic: 340 lbs. Bird feeder: 250 units at $40 per unit.
Direct materials used in…
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Perform vertical analysis of the two quotas
arrow_forward
13 What is the estimated cost of goods sold alnu
14. What is the estimated total selling and administrative expense IUI JUIŲI
15. What is the estimated net operating income for July?
12. What is the estimated FIIL
TOI
лу:
ises
Connect
Gerw
Hill
ACCOUNTING
All applicable exercises are available with McGraw-Hill's Connect® Accounting
EXERCISE 8-1 Schedule of Expected Cash Collections [LO8-2]
Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales 00
in May of each year, as shown in the company's sales budget for the second quarter given belou
April
May
June
Total
Budgeted sales (all on account)
$300,000
$500,000
$200,000 $1,000,000
arrow_forward
Shep Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the
first quarter of 2019, the following data are developed:
F2 -
2 @
W
S
1. Sales: 20,000 units; unit selling price:
2. Variable costs per dollar of sales:
Sales commissions
Delivery expense
Advertising
3. Fixed costs per quarter:
Sales salaries.
Office salaries
F3 +
3
E
D
Depreciation
#
Insurance
Utilities
Variable expenses
Sales commissions
Delivery expense
4
Instructions
Prepare a selling and administrative expense budget for the first quarter of 2019.
Advertising
F4 Ⓡ
$
R
F
F5
A
5 %
T
F6
G
H
F7 C
6 A
Y
H
$25
6%
$30,000
2%
18,000
4%
8,000
Selling and Administrative Expense Budget
For the Quarter Ended March 31, 2019
3,000
1,100
SHEP COMPANY
F8
7 &
Search L
U
J
F9
8
LG
-
F10 A
9
*
(
K
O
4
F11 -
0
L
)
O
F12 +
P
-
;
Prt Sc
Scrlk
=
Ins
+
I
11
Del
Backspace
PgUp
Home
Nu
Ente
arrow_forward
Please solve this question
arrow_forward
Wq.5
arrow_forward
Ma3.
arrow_forward
sd
subject-Accounting
arrow_forward
Refer to the following mentioned data.
Net sales
Cost of products sold
Gross margin
2017
2016
2015
Required:
a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2
decimal places.)
(In millions)
2016
2017
2015
$34,894
$30,411
$26,113
14,318
13,376
13,767
$20,576 $17,035 $12,346
Cost of goods sold
Gross profit
58.94 %
%
%
b. Assume that Campbell's net sales for the first four months of 2018 totaled $12.79 billion.
Calculate an estimated cost of goods sold and gross profit for the four months, using the gross
profit ratio for 2017. (Round Intermediate calculations to 2 decimal places. Enter your answers
in millions rounded to nearest whole number (1.e., 5,000,000 should be entered as 5).)
million
million
arrow_forward
please provide compulsory explanation , computation clearly for each parts and steps answer in text form
arrow_forward
2020
2021
Costs Incurred in
3,000
6,000
The Year
Estimated Costs
9,000
to Complete
Billings During
the Year
4,500
5,500
Cash Collections
3,500
6,000
Selling Price: $15,000
Calculate the revenue, cost of goods sold and
gross profit to be recognized in each year.
Calculate the ending balance in accounts
receivable in each year.
2020
2021
Revenue
Cost of Goods Sold
Gross Profit
Ending Accounts
Receivable
arrow_forward
FINA310 IP TEMPLATE FOR STUDENTS
Student name:
Date:
ACTUAL
FORECAST
Current Year
Next Year
Total Revenue
71,879
|Cost of Revenue
(51,125)
Gross Profit
20,754
Operating Expenses:
Selling, General, and Administrative
(14,248)
Research and Development
Special Income/Other Charges
(2,194)
Total Operating Expenses
(16,442)
Operating Income
4,312
Net Interest Income
(666)
edite
Pre-Tax Income
3,646
Provision for Income Tax (19.5%)
(711)
Net Income
2,935
Additionally, Tag-It's CEO has predicted a 12% increase in total
revenue next year. Utilizing the percentage of sales method, prepare
a forecast for next year in the correct section on the Excel
spreadsheet.
1. The total revenue numbers over the past 4 years for Tag-lt
Corporation were as follows (values in millions):
o 73,785
O 69,495
o 75,356
o 71,879
2. Determine whether you think Tag-It can hit the target of a 12%
increase in sales next year.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Financial & Managerial Accounting
Accounting
ISBN:9781285866307
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Related Questions
- Am. 323.arrow_forwardSales Revenue Cost of Goods Sold Income from Operations Selling and Administrative Expenses Budgeted Income Statement For the Year Ending December 31, 2022 Income from Operations Interest Expense Income before Income Taxes Interest Expense Not Income (Loss) $ 326,400 (166,380) i 160,020 88,500 i 71,520 (4,130 67,390 (13,478 53912arrow_forwardPlease dont provide solution image based answers thankuarrow_forward
- BC 266: EXCEL PROBLEM PR 17-2A:VERTICAL ANALYSIS For 2016, Indigo Corp. initiated a sales promotion campaign that included an expenditure of $39,000 for advertising. At year end the company President is presented with the following condensed Comparative Income Statement: 20162015 Sales revenue $820,000 $600,000 COGS [Cost of Goods Sold]311,600240,000 Gross profit508,400360,000 Selling expenses 164,000 108,000 Administrative expenses 57,40054,000 Total operating expenses 221,400162,000 Income from operations [NOI] 287,000 198,000 Other income 65,600 48,000 Income before income tax 352,600 246,000 Income tax expense246,000180,000 Net Income [NI] 106,600 66,000 Prepare a Comparative Income Statement using Vertical Analysis for the two-year period. Present each item as a % of sales for the given year and round your values to one decimal place.arrow_forwardQuestion 2 Following are some important figures from the budget of Jasmine, Inc., for the year 2016: February March April Credit sales $289,000 $265,000 $378,000 Credit purchases $ 89,000 $126,000 $187,000 Cash disbursements Wages, taxes, and expenses $46,000 $ 41,000 $58,000 Interest $12,700 $12,700 $12, 700 Equipment purchases $67,000 $133,000 $ 0 The company predicts that 3% of its credit sales will never be collected, 47% of its sales will be collected in the month of the sale, and the remaining 50% will be collected in the following month. Credit purchases will be paid in the month following the purchase. In Jan 2016, credit sales were $245,000, and credit purchases were $95,000. The beginning cash balance of Feb is $ 120,000. Prepare a cash budget for Jasmine, Inc., for the months of February, March and April.arrow_forwardSummary Data for April Support Department Support Departments Production Departments Information Research and Technology Travel Service Analysis Audit Tax Consulting Total IT: Number of employees TS: Number of trips 9 5 15 120 150 110 409 15 12 10 120 160 520 837 RA: Number of requests Costs to Allocate 15 10 4 125 120 280 554 $ 810,000.00 $125,000.00 $1,280,000.00 $ $ $ $2,215,000.00 Question Answer 1. Which of the following is the closest approximation of the sales forecast's upper confidence bound for the 1/1/2028 quarter? 2. Based on the graph and the breadth of the confidence intervals, which seems easier to predict, sales or income before extraordinary items? 3. What is the sales forecast's upper confidence bound for the 10/1/2027 quarter? 4. What is the forecast lower confidence bound for the 4/1/2027 quarter? 5. What is the forecast for income before extraordinary items for Nintendo for the quarter starting 10/1/2027?arrow_forward
- Provide correct solutionarrow_forward14-19 Customer profitability, customer-cost hierarchy. Enviro-Tech has only two retail and two wholesale customers. Information relating to each customer for 2017 follows (in thousands):Wholesale Customers Retail CustomersNorth AmericaWholesalerSouth AmericaWholesaler Green Energy Global PowerRevenues at list prices $375,000 $590,000 $175,000 $130,000Discounts from list prices 25,800 47,200 8,400 590Cost of goods sold 285,000 510,000 144,000 95,000Delivery costs 4,550 6,710 2,230 2,145Order processing costs 3,820 5,980 2,180 1,130Cost of sales visit 6,300 2,620 2,620 1,575Enviro-Tech’s annual distribution-channel costs are $33 million for wholesale customers and $12 million forretail customers. The company’s annual corporate-sustaining costs, such as salary for top managementand general-administration costs are $48 million. There is no cause-and-effect or benefits-received relationship between any cost-allocation base and corporate-sustaining costs. That is, Enviro-Tech could…arrow_forwardRequired: Solve for the missing items in the partial income statements given below: E9-8 2015 2016 2012 2013 2014 Sales 100,000 120,000 150,000 160,000 Gross Profit 44,000 39,000 18,000 Beginning 80,000 70,000 85,000 75,000 Inventory Net Purchases 90,000 80,000 120,000 165,000 Cost of goods sold 70,000 135,000 Sales ret & allow 6,000 18,000 Ending inventory 65,000 85,000 100,000 Net sales 117,000 144,000 150,000arrow_forward
- Ramos Company Ramos Company included the following information in its annual report: 2011 2010 2009 Sales $178,400 $162,500 $155,500 Cost of goods sold 115,000 102,500 100,000 Operating expenses 50,000 50,000 45,000 Net income 13,400 10,000 10,500 Refer to the information for Ramos Company. In a common size income statement for 2011, the operating expenses are expressed as: Group of answer choices 100 % 50.6 % 30.3 % 28.0 %arrow_forwardSh11arrow_forwardA1arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial & Managerial AccountingAccountingISBN:9781285866307Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial & Managerial Accounting
Accounting
ISBN:9781285866307
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning