Week 3 Notes

xlsx

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

Report
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