How do I calculate % of total revenue

Home Insert Page Layout Formulas Review View Help Search Share Comments & Cut Calibr Comma Comma [0] Currency AutoSum [B Copy 11 ~ A" A " 29 Wrap Text |Percentage Currency [0] O aste Fill Format Painter =EE EE Merge & Center v $ ~ % 9 68 28 Conditional Format as Percent Insert Delete Format Ideas Table Clear Filter ~ Select v Clipboard Font Alignment Number Styles Cells Editing Ideas Common Size Statements of Cash Flow 12 Months Ended Common Size Statements of Cash Flow Consolidated Statements of Cash Flow Dec. 31, 2018 % of Total Reven Dec. 31, 2017 %% of Total Reven Dec. 31, 2016 % of Total Revenue Consolidated Statements of Cash Flows - ($ in Millions) 12 Months Ended CASH FLOWS FROM OPERATING Dec. 31, 2018% of Total Reven Dec. 31, 2017%% of Total Reven Dec. 31, 2010%% of Total Revenue OPERATING ACTIVITIES $216,355,000 $122,327,000 5106,712,000 Net income $ 1,459 income to net cash provided by operating activities: Depreciation and amortization 6,680,000 6,996,000 Adjustments to reconcile to cash provided by operating activities: Depreciation, amortization, and other 284 159 marketing and reservation system 19,597,000 Franchise agreement acquisition 20,609,000 20,663,000 Share-based compensation 184 18. S 212 cost amortization 9,239,000 7,191,00 Income taxes (239) 887 103 Impairment of goodwill ,289,000 520 298 221 Gain on disposal of assets, net -56,000 -237,000 -571,00 Liability for guest loyalty program S Contract acquisition costs (152 (185 (76) Provision for bad debts, net 5,514,000 ,365,00 Merger-related charges 16 (124 200 Non-cash stock compensation and other charges 15,986,000 22,857,000 15,346,000 Working capital changes (76) (30 investment (income) loss 3,695,000 3,510,000 29,723,000 (Gain) loss on asset dispositions (194) 57,106,000 (687) Deferred income taxes Other 107 140 1 88 unconsolidated joint ventures, less distributions received 7,389,000 6,579,000 1,025,000 Net cash provided by operating activities $ 2,357 $ 1,619 cost, net of reimbursements -52,929,000 -30,638,000 -17,410,000 Change in working capital and INVESTING ACTIVITIES other, net of acquisition 2,031,000 40,158,000 38,150,000 Acquisition of a business, net of cash acquired Net cash provided by operating activities 242,896,000 257,374,000 152,035,000 Capital expenditures 5 (240 FLOWS FROM ACTIVITIES Dispositions 479 Investment in property and 1,418 211 equipment -23,437,000 25,191,000 Loan advances -2,517,000 (15 (93 Investment in intangible assets 1,803,000 -2,580,000 AR (32) 187 3,053,000 Loan collections Proceeds from sales of assets 1,000,000 11,462,000 Other (61 Asset acquisition, net of cash acquired 3,179,000 Business acquisition, net of cash 28,583,000 Net cash (used in) provided by investing activities S (52 1,211 S (2,346) acquired -231,317,000 -1,341,000 FINANCING ACTIVITIES Contributions to equity method investments 9,604,000 50,554,000 |Distributions from equity method 34,661,000 Commercial paper/Credit Facility, net 60 $ 1,373 investments 1,429,000 4,569,000 3,700,ODD Issuance of long-term debt Purchases of investments 5 1,646 1, 482 employee benefit plans -2,447,000 -1,661,000 Repayment of long-term debt (397) (310 (326) Proceeds from sales of investments, employee benefit 2,825,000 36,045, 000 2,245,000 19,738,000 1,911,000 32,604,000 Issuance of Class A Common Stock S 6 34 Issuance of notes receivable Dividends paid 4,997,000 (543) (482) (374 Collections of notes receivable 655,000 11,070,000 Purchase of treasury stock S (2,850) 5 (5,013) (568) Other items, net -1,040,000 109,000 11,000 5 (157 Net cash used in investing 321,252,000 90,115,000 98,467,000 Share-based compensation withholding taxes (105) (100) CASH FLOWS FROM FINANCING (24) ACTIVITIES |Proceeds from issuance of long Net cash (used in) provided by financing activities 5 (2,374) $ (3,896) term debt 9,037,000 DECREASE IN CASH, CASH EQUIVALENTS, AND RESTRICTED CASH (69) (458) 770 Instructions Income Statement Balance Sheet Cash Flow Cost and Investing Budget and Forecast + ady + 80%File Home Insert Page Layout Formulas Data Review View Help Search Share Comments X Cut CE Copy Calibri * 11 ~ A" A 22 Wrap Text Percentage Comma Comma [0] Currency Currency [0] AutoSum Paste Fill O Format Painter CE E Merge & Center Conditional Format as Percent nsert Delete Format Sort & Find & deas Formatting * Table v >Clear Filter ~ Select ~ Clipboard Font Alignment Number Styles Cells Editing Ideas D5 X V D E G K M O Q R 33 Other items, net -1,040,000 109,000 11,000 Share-based compensation withholding taxes (105) S (157) (100) Net cash used in investing -321,252,000 -90,115,000 -98,467,000 Other (24 ) 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 (69 (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 S 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 38 agreements 0 550,000 40 Debt issuance costs -2,590,000 284,00 41 Purchases of treasury stock -148,679,000 -9,807,000 48,651,000 -35,926,000 Dividends paid 48,715,000 -46,182,000 42 Proceeds from transfer of interest in notes receivable 173,000 24,237,000 43 Proceeds from exercise of stock options 41,360,000 14,107,000 12,951,000 Net cash used in financing -129,417,000 -135,777,000 -44,084,000 45 Net change in cash and cast equivalents -207,773,000 31,482,000 9,484,000 Effect of foreign exchange rate changes on cash and cash 46 equivalents -921,00 1,391,000 462,000 47 Cash and cash equivalents at 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 Cash payments during the year for: Income taxes, net of refund 77,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 56 unconsolidated joint venture o 2,350,000 Seller-financing to purchaser $2,000,000 SO 57 158 59 Questions: 60 61 1. What were the two largest cash outflows for each company over the 3-year period? 62 63 64 65 66 2. Why did Marriott have a cash inflow in 2017 from investing activities? Hint: See 10-K Report. 67 68 69 70 3. What are the most significant trends for both companies? Instructions Income Statement Balance Sheet Cash Flow Cost and Investing Budget and Forecast