How do I calculate % of total revenue?

File Home Insert Page Layout Formulas Review View Help 15 Share Comments Calibri ab Wrap Text Percentage Comma [0] Currency Currency [0 AutoSum Paste Fill Format Painter BIU~ ~ MAY BEE E E Merge & Center ~ $ ~ % 9 60 20 Conditional Format as Percent nsert Delete Format Clear Sort & Find & Ideas Formatting ~ Table v Filter ~ Select v Clipboard Font Alignment Styles Cells Editing Ideas D5 X v fx W N - S Common Size Statements of Cash Flow 12 Months Ended Consolidated Statements of Cash Flow Dec. 31, 2018 % of Total Reven Dec. 31, 2017 % of Total Reven Dec. 31, 2016 % of Total Revenue Common Size Statements of Cash Flow 12 Months Ended CASH FLOWS FROM OPERATING Consolidated Statements of Cash Flows - ($ in Millions) Dec. 31, 2018% of Total Reven Dec. 31, 2017% of Total Reven Dec. 31, 201% of Total Revenue ACTIVITIES $216,355,000 $122,327,000 OPERATING ACTIVITIES $106,712,000 Net income 808 ncome to net cash provided by operating activities: Depreciation and amortization 6,680,000 Adjustments to reconcile to cash provided by operating activities: 6,996,000 Depreciation, amortization, and other 284 279 159 Depreciation and amortization - 8 marketing and reservation system 19,597,000 Franchise agreement acquisition 20,609,000 Share-based compensation 184 181 212 10 cost amortization 9,239,000 7,191,000 Impairment of goodwill 4,289,000 6,423,000 Income taxes (239 887 S S 10 11 Liability for guest loyalty program 520 298 12 Gain on disposal of assets, net -56,000 221 Provision for bad debts, net 3,365,000 Contract acquisition costs (152) (185) 10,542,000 Merger-related charges 16 (124 S (76) 209 Non-cash stock compensation an 13 Lother charges 15,986,00 22,857,000 15,346,000 Working capital changes (30) (106 Non-cash interest and other 14 15 investment (income) loss 1,059,00 Gain) loss on asset dispositions S (194) 3,510,000 -29,723,00 107 687 Other 149 Equity in net losses from unconsolidated joint ventures, 16 less distributions received 7,389,000 6,579,000 Franchise agreement acquisition 1,025,000 Net cash provided by operating activities $ 2,357 $ 2,227 $ 1,619 17 52,929,00 30,638,000 17,410,000 INVESTING ACTIVITIES Change in working capital and 18 other, net of acquisition 2,031,000 40,158,000 38,150,000 S Net cash provided by operating Acquisition of a business, net of cash acquired 19 S CASH FLOWS FROM INVESTING 257,374,000 152,035,000 Capital expenditures (55 (240 (199 20 Dispositions 479 Investment in property and $ 1,418 21: 21 22 equipment 47,673,00 23,437,000 -25,191,000 23 Investment in intangible assets 1,803,000 -2,517,000 -2,580,000 Loan advances S (13 48 (93 187 (32 Proceeds from sales of assets ,053,000 1,000,000 11,462,000 Loan collections 67 Other (10 (61 24 Asset acquisition, net of cash acquired Business acquisition, net of cash -3,179,000 -28,583,000 Net cash (used in) provided by investing activities (52) S (2,346) 25 acquired -1,341,000 FINANCING ACTIVITIES 26 Contributions to equity method investments (129) $ 1,373 27 Distributions from equity method investments 1,429,00 3,700,000 ssuance of long-term debt 1,646 Purchases of investments 28 employee benefit plans 2,447,000 -1,661,000 Repayment of long-term debt (397) Proceeds from sales of (310) (326) 29 30 investments, employee benefit 2,245,000 1,911,000 Issuance of Class A Common Stock Issuance of notes receivable 9,738,000 Collections of notes receivable 4,997,000 -32,604,000 Dividends paid (543 Purchase of treasury stock 1482 (374) (568 ) -1,040,000 11,000 Net cash used in investing -321,252,000 (157 (100) -90,115,000 Share-based compensation withholding taxes (105) Other 34 CASH FLOWS FROM FINANCING -98,467,000 ACTIVITIES Proceeds from issuance of long Net cash (used in) provided by financing activities (3,896) 8/6/2019 Instructions Income Statement Balance Sheet Cash Flow Cost and Investing Budget and Forecast O Type here to search e 8/6/2019File Home Insert Page Layout Formulas Data Review View Help Search Share Comments & Cut Comma Comma [0] Currency Currency [0] TIX AutoSum ~ Ap Paste [ Copy Calibri 11 ~ A" A de Wrap Text Percentage Conditional Format as Percent nsert Delete Format Fill O BIU - MA. = = E Merge & Center Clear Sort & Find & Ideas Format Painter Formatting * Table Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas DS X v fx B D G M N P Q R S CASH FLOWS FROM FINANCING 34 ACTIVITIES Net cash (used in) provided by financing activities (2,374) $ (3,896) 1,497 Proceeds from issuance of long 35 term debt 9,037,000 DECREASE IN CASH, CASH EQUIVALENTS, AND RESTRICTED CASH S (69 S (458 S 770 Net (repayments) borrowings 36 pursuant to revolving credit 20,600,000 115,003,000 25,795,000 CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, beginning of pe S 429 887 117 Principal payments on long-term 37 debt -603,000 -660,000 -988,000 CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, end of period ( 360 429 887 Proceeds from other debt agreements 550,00 39 40 Debt issuance costs -2,590,000 -284,000 Purchases of treasury stock 148,679,00 -9,807,000 -35,926,00 Dividends paid -48,715,000 -48,651,000 -46,182,000 Proceeds from transfer of interest 42 in notes receivable 173,00 24,237,000 Proceeds from exercise of stock 43 options 12,951,000 44 41,360,000 14,107,000 Net cash used in financing -129,417,000 -135,777,000 -44,084,000 45 Net change in cash and cash equivalents -207,773,000 31,482,000 9,484,00 Effect of foreign exchange rate changes on cash and cash 46 equivalents 921,000 1,391,000 462,000 Cash and cash equivalents at 47 beginning of period 235,336,000 202,463,000 193,441,000 cash and cash equivalents at end 48 49 of period 26,642,000 235,336,000 202,463,000 50 Cash payments during the year for 51 Income taxes, net of refunds 17,357,000 39,181,000 65,683,000 Interest, net of capitalized 43,254,000 42,405,000 41,992,000 Non-cash investing and financing 52 53 activities: Dividends declared but not paid 11,977,000 12,185,000 12,112,000 Investment in property, equipment and intangibles 54 acquired in accounts payable and 5,949,000 1,099,000 3,648,000 Sale of investment in 55 unconsolidated joint venture 2,350,000 57 Seller-financing to purchaser so $2,000,000 SO 58 Questions: 60 61 1. What were the two largest cash outflows for each company over the 3-year period? 62 63 64 65 2. Why did Marriott have a cash inflow in 2017 from investing activities? Hint: See 10-K Report. 66 68 69 70 3. What are the most significant trends for both companies? 3:33 PM 8/6/2019 Instructions Income Statement Balance Sheet Cash Flow Cost and Investing Budget and Forecast +