Week 3 Notes
xlsx
keyboard_arrow_up
School
Texas A&M University, Corpus Christi *
*We aren’t endorsed by this school
Course
5313
Subject
Arts Humanities
Date
Dec 6, 2023
Type
xlsx
Pages
9
Uploaded by arivalenzuela29
company
Ticker
2018 Revenue
2018 Net Income
2018 Assets
2017 Assets
Humana Inc.
HUM
$
66,832.00 $
11,603.00 $ 35,333.00 $
37,098.00
a. Return of equity (ROE) 2018
Return o
58%
b. PM
Sales= Revenue
c. Financial leverage (FL)
22% Tax rate
NOPAT=
$ 3,669.26 NOPAT=
$
3,669.26
EBIAT
Current assets
Cash and cash equivalents
$430
Short-term investments
183
Solution:
Merchandise inventory—net
10,570
Other current assets
789
Operating Assets=
$ 28,209.00
Total current assets
11,972
Property, less accumulated depreci
15,511
Long-term investments
215
Operating Liab=
$ 12,321.00
Deferred income taxes—net
247
Goodwill
255
Other assets
837
NOA=
$ 15,888.00
Total assets
$29,037
Current liabilities
Short-term borrowings
$608
Current maturities of long-term deb
934
Accounts payable
6,967
Accrued compensation and employ
557
Deferred revenue
1,093
Other current liabilities
2,041
Total current liabilities
12,200
Long-term debt, excluding current m
12,110
Deferred revenue—extended prote
696
Other liabilities
967
Total liabilities
25,973
Shareholders’ equity
Preferred stock—$5 par value, non
-
Common stock—$0.50 par value
335
Capital in excess of par value
-
Retained earnings
2,905
Accumulated other comprehensive
-176
Total shareholders’ equity
3,064
Total liabilities and shareholders’ eq
$29,037
$ Millions
2018
2017
Solution:
Current assets
$
34,636.00
$28,716
Ratio:
Current liabilities
36,413
33,037
Current Ratio=
Total liabilities
382,308
376,200
Times Interest Earned=
Equity
52,522
44,687
Liab-to-Equity Ratio=
Earnings before interest and taxes
22,278
26,328
Interest expense, gross
4,640
4,733
Net cash flow from operating activit
34,339
23,345
Current Yr Net Operating Asset
Prior Yr Net OA
Average NOA
$1,167.30
$1,252.30
$1,209.80
$4,627.00
$4,489.30
$4,558.15
RNOA= NOPAT/AVG NOA
NOPM=NOPAT/REVENUE
NOAT=REVENUE/AVG NOA
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
2018 SE
2017 SE
$ 20,081.00 $ 19,762.00
2018
2017
0.95
0.87
4.80
5.56
7.28
8.42
Free Cash Flows to the firm (FCFF)=
$ 4,851.00 million
Terminal Period growth rate
2%
Discount rate (WACC)
7.63%
Common shares outstanding
517.80
Net nonoperating obligations
$12,273.00
Discount Factor=
0.92910898 0.86324351 0.8020472963 0.745189349
Increase in NOA
627
1760
720
1884
FCFF (NOPAT - Increase in NOA)
3325
1812
3581
2055
Present value of horizon FCFF
$ 3,089.29 $ 1,564.20 $
2,872.13 $
1,531.36
Cum. present value of horizon FCFF
$
9,056.98
Present value of terminal FCFF
$
60,316.66 TV=4557/(0.0763-0.02)
$
80,941.39
Discount Factor=
Total firm value
$
69,373.64
TV*factor=
$
60,316.66
PV of terminal FCFF
NNO
$12,273.00
Firm equity value
$
57,100.64
Shares outstanding (millions)
517.80
Stock price per share
$
110.28
1.Purchased 6,000 common shares of Liu, Inc., at $12 cash per share.
6000 $
12.00
2.Received a cash dividend of $1.10 per common share from Liu.
$
1.10
3. Year-end market price of Liu common stock is $11.25 per share
$
11.25
4.Sold all 6,000 common shares of Liu for $66,300.
6000
$ 66,300.00
Solution:
Cash Asset
Noncash Asset
Liabilites
Contributed Capit
Earned Capital
-72000 $
72,000.00 $
-
0
$
-
a.
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
$
6,600.00
0
0
0 $
66,000.00 b.
0
$
(4,500.00)
0
0
$
(6,750.00) c.
$
66,300.00 $
(67,500.00)
0
0
$
(1,200.00) d.
a. Purchased 12,000 common shares of Bakersfield Co. at $11 per share; the shares represent 30% ownership in Bakersfield.
c. Bakersfield reported annual net income of $120,000.
d. Sold all 12,000 common shares of Bakersfield for $152,000.
Solution:
Cash Asset
Noncash Asset
Liabilites
Contributed Capit
Earned Capital
-132000
$
132,000.00 $
-
0
$
-
a.
$
21,000.00
-21000
0
0
$
-
b.
0 $
36,000.00
0
0 $
36,000.00 c.
$
152,000.00 $ (147,000.00)
0
0 $
5,000.00 d.
Cash Asset + Noncash Assets = Liabilities + contributed Capital + Earned Capital
b. Received a cash dividend of $1.75 per common share from Bakersfield.
10
4557
0.745189349
F
Revenue
Expenses
Net Income
$
-
$
-
$
-
$
6,600.00 $
-
$
6,600.00
$
-
$
4,500.00 $
(4,500.00)
$
-
$
1,200.00 $
(1,200.00)
12000
$
11.00
30%
$
1.75
$ 120,000.00
12000
$ 152,000.00
Revenue
Expenses
Net Income
$
-
$
-
$
-
a.
$ 132,000.00
$
-
$
-
$
-
b.
$
21,000.00
$ 36,000.00 $
-
$
36,000.00 c=30% of 120000
$
36,000.00
$
5,000.00 $
-
$
5,000.00
Revenue -
Expenses =
Net Income
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