Free Cash Flow Calculation. Calculate each companys Free Cash Flow for each of the last 4 fiscal years. Use negative Provision for Income Tax (it will be a negative number if the company paid taxes) divided by Pretax Income as the tax rate for each year in the data below your Income Statements. Use a tax rate of zero for any year that the company didnt pay taxes or had a tax refund (positive Provision for Income Tax).
Comcast:
Charter:
10 14 2019 2018 2017 2016 2015 74,502,000,000 74,502,000,000 64,815,000,000 59,674,000,000 56,388,000,000 51,960,000,000 108,942,000,000 108,942,000,000 94,507,000,000 85,029,000,000 80,736,000,000 74,510,000,000 108,942,000,000 108,942,000,000 94,507,000,000 85,029,000,000 80,736,000,000 74,510,000,000 34,440,000,000 34.440,000,000 -29,692,000,000 -25,355,000,000 -24,348,000,000 22,550,000,000 -34,440,000,000 -34,440,000,000 -29,692,000,000 -25,355,000,000 -24,348,000,000 -22,550,000,000 -53,377,000,000 -53,377,000,000 45,806,000,000 41,656,000,000 -39,557,000,000 35,962,000,000 40,424,000,000 40,424,000,000 35,130,000,000 31,968,000,000 30,131,000,000 -27,282,000,000 32,807,000,000 -32,807,000,000 -28,094,000,000 -25,449,000,000 -23,840,000,000 -21,325,000,000 -7,617,000,000 -7,617,000,000 -7.036,000,000 -6,519,000,000 -6,291,000,000 -5,957,000,000 -12,953,000,000 -12,953,000,000 -11,017,000,000 -10,130,000,000 -9,426,000,000 -3,680,000,000 -12,953,000,000 -12.953,000,000 -11,017,000,000 -10,130,000,000 -9,426,000,000 -8,680,000,000 -8,663,000,000 -8,663,000,000 -8,281,000,000 -7.914,000,000 -7,464,000,000 -6,781,000,000 4,290,000,000 4,290,000,000 -2,736,000,000 -2,216,000,000 -1,962,000,000 -1,899,000,000 0 341,000,000 442,000,000 0 341,000,000 442,000,000 21,125,000,000 21,125,000,000 19,009,000,000 18,018,000,000 16,831,000,000 15,998,000,000 4,129,000,000 4,129,000,000 3,767,000,000 2,665,000,000 -2,505,000,000 -2,626,000,000 4,567,000,000 4,567,000,000 -3,542,000,000 3,086,000,000 -2,942,000,000 -2,702,000,000 4,567,000,000 4,567,000,000 3,542,000,000 3,086,000,000 -2,942,000,000 2,702,000,000 4,567,000,000 4,567,000,000 -3,542,000,000 -3,086,000,000 -2,942,000,000 -2,702,000,000 438,000,000 438,000,000 -225,000,000 421,000,000 437,000,000 -185,000,000 656,000,000 656,000,000 -187,000,000 -17,000,000 12,000,000 12,000,000 -505,000,000 -505,000,000 -364,000,000 107,000,000 -104,000,000 -325,000,000 287.000.000 287,000,000 326,000,000 331,000,000 529,000,000 13,000,000 115,000,000 15 Name: Comcast 2 Gross Profit 3 Total Revenue Business Revenue 5 Cost of Revenue 6 Cost of Goods and Services 7 Operating Income/Expenses Selling, General and Administrative Expenses General and Administrative Expenses Selling and Marketing Expenses 11 Depreciation, Amortization and Depletion 12 Depreciation and Amortization 13 Depreciation Amortization Other Income/Expense, Operating Other Income, Operating 17 Total Operating Profit/Loss 18 Non-Operating Income/Expenses, Total 19 Total Net Finance Income/Expense 20 Net Interest Income/Expense Interest Expense Net of Capitalized Interest 22 Net Investment Income 23 Gain/Loss on Investments and Other Financial Instruments Income from Associates, Joint Ventures and Other Participating Interests Other Investment Income 26 Dividend and Investment Income Gain/Loss on Derivatives Unrealized Gain/Loss on Derivatives 29 Irregular Income/Expenses Impairment/Write Off/Write Down of Other Assets Other Income/Expense, Non-Operating 32 Pretax Income 33 Provision for Income Tax 34 Net Income from Continuing Operations 35 Net Income after Extraordinary Items and Discontinued Operations 36 Non-Controlling/Minority Interests 37 Net Income after Non-Controlling/Minority Interests 38 Net Income Available to Common Stockholders 39 Diluted Net Income Available to Common Stockholders 40 Reported Total Revenue 41 Reported Total Operating Profit/Loss 42 Reported Effective Tax Rate 43 Reported Normalized EBITDA 44 Reported Normalized Income 45 Fiscal year ends in Dec 31 USD 46 21 24 25 27 28 30 31 16,996,000,000 16,996,000,000 3,673,000,000 3,673,000,000 13,323,000,000 13,323,000,000 13,323,000,000 13,323,000,000 -266,000,000 -266,000,000 13,057,000,000 13,057,000,000 13,057,000,000 13,057,000,000 13,057,000,000 13,057,000,000 108,942,000,000 108,942,000,000 21,125,000,000 21,125,000,000 15,242,000,000 3,380,000,000 11,862,000,000 11,862,000,000 -131,000,000 11,731,000,000 11,731,000,000 11,731,000,000 94,507,000,000 19,009,000,000 15,353,000,000 7,569,000,000 22,922,000,000 22,922,000,000 -187,000,000 22,735,000,000 22,735,000,000 22,735,000,000 85,029,000,000 18,018,000,000 14,326,000,000 -5,298,000,000 9,028,000,000 9,028,000,000 -350,000,000 8,678,000,000 8,678,000,000 8,678,000,000 80,736,000,000 16,831,000,000 -59,000,000 -59,000,000 320,000,000 13,372,000,000 4,959,000,000 8,413,000,000 8,413,000,000 -250,000,000 8,163,000,000 8,163,000,000 8,163,000,000 74,510,000,000 15,998,000,000 0 0 34,258,000,000 34,258,000,000 30,165,000,000 12,680,000,000 27,956,000,000 9,709,000,000 26,257,000,000 24,678,000,000 8,171,000,000 TTM 16,540,000,000 45,764,000,000 45,764,000,000 -29,224,000,000 -22,179,000,000 -7.045,000,000 -9.926,000,000 -9.926,000,000 -9,926,000,000 2019 16,540,000,000 45,764,000,000 45,764,000,000 -29,224,000,000 -22,179,000,000 -7.045,000,000 -9.926,000,000 -9.926,000,000 -9.926,000,000 E F 2018 2017 2016 2015 15,774,000,000 15,040,000,000 10,348,000,000 3,328,000,000 43,634,000,000 41,581,000,000 29,003,000,000 9,754,000,000 43,634,000,000 41,581,000,000 29,003,000,000 9,754,000,000 -27,860,000,000 -26,541,000,000 -18,655,000,000 -6,426,000,000 -21,007,000,000 -19,895,000,000 -13,808,000,000 4,993,000,000 -6,853,000,000 -6,646,000,000 4,847,000,000 -1,433,000,000 -10,318,000,000 -10,588,000,000 -6,907,000,000 -2,125,000,000 -10,318,000,000 -10,588,000,000 -6.907,000,000 -2,125,000,000 -10,318,000,000 -10,588,000,000 -6,907,000,000 -2,125,000,000 11 12 13 A Name: Charter 2 Gross Profit 3 Total Revenue 4 Business Revenue 5 Cost of Revenue Cost of Goods and Services Other Cost of Revenue 8 Operating Income/Expenses Depreciation, Amortization and Depletion 10 Depreciation and Amortization Selling, General and Administrative Expenses Staff Costs Pension and Other Employee Benefits Costs 14 Total Operating Profit/Loss 15 Non-Operating Income/Expenses, Total 16 Total Net Finance Income/Expense 17 Net Interest Income/Expense Net Investment Income 19 Gain/Loss on Investments and Other Financial Instruments Gain/Loss on Derivatives Irregular Income/Expenses 22 Asset Disposals Gain/Loss on Extinguishment of Debt Merger and Acquisition Income/Expense Other Irregular Income/Expenses 26 Other Income/Expense, Non-Operating 27 Pretax Income 28 Provision for Income Tax 29 Net Income from Continuing Operations 30 Net Income after Extraordinary Items and Discontinued Operations 31 Non-Controlling/Minority Interests 32 Net Income after Non-Controlling/Minority Interests 33 Net Income Available to Common Stockholders 34 Diluted Net Income Available to Common Stockholders 35 Reported Total Revenue 36 Reported Total Operating Profit/Loss 37 Reported Normalized EBITDA 38 Fiscal year ends in Dec 31 USD 39 6,614,000,000 4,183,000,000 -3,797,000,000 3,797,000,000 -54,000,000 -54,000,000 6,614,000,000 4,183,000,000 -3,797,000,000 3,797,000,000 -54,000,000 -54,000,000 5,456,000,000 3,770,000,000 -3,540,000,000 -3,540,000,000 -110,000,000 -110,000,000 4,452,000,000 3,424,000,000 -3,090,000,000 3,090,000,000 69,000,000 69,000,000 3,441,000,000 1,203,000,000 -2,621,000,000 -1,534,000,000 -2,499,000,000 -1,306,000,000 -2,499,000,000 -1,306,000,000 89,000,000 4,000,000 89,000,000 4,000,000 18 20 21 -235,000,000 -85,000,000 23 24 25 -128,000,000 42,000,000 -25,000,000 -10,000,000 -51,000,000 -204,000,000 2,431,000,000 -439,000,000 1,992,000,000 1,992,000,000 324,000,000 1,668,000,000 1,668,000,000 1,668,000,000 45,764,000,000 45 ZRA 6,511,000,000 16,855,000,000 -128,000,000 42,000,000 -25,000,000 -10,000,000 -51,000,000 -204,000,000 2,431,000,000 439,000,000 1,992,000,000 1,992,000,000 -324,000,000 1,668,000,000 1,668,000,000 1,668,000,000 45,764,000,000 6,511,000,000 16,855,000,000 -386,000,000 -16,000,000 40,000,000 351,000,000 21,000,000 -17,000,000 1,028,000,000 9,087,000,000 10,115,000,000 10,115,000,000 220,000,000 9,895,000,000 9,895,000,000 9,895,000,000 41,581,000,000 4,106,000,000 15,301,000,000 -97,000,000 -53,000,000 115,000,000 1,686,000,000 -180,000,000 1,506,000,000 1,506,000,000 276,000,000 1,230,000,000 1,230,000,000 1,230,000,000 43,634,000,000 5,221,000,000 16,059,000,000 -1,096,000,000 2,000,000 -111,000,000 -970,000,000 -17,000,000 885,000,000 $20,000,000 2,925,000,000 3,745,000,000 3,745,000,000 223,000,000 3,522,000,000 3,522,000,000 3,522,000,000 29,003,000,000 2,456,000,000 10,592,000,000 217.000.000 4,000,000 -128,000,000 -70,000,000 -15,000,000 -7,000,000 -331,000,000 60,000,000 -271,000,000 271,000,000 271,000,000 -271,000,000 271,000,000 9,754,000,000 1,114,000,000 3,406,000,000 40 41 10 14 2019 2018 2017 2016 2015 74,502,000,000 74,502,000,000 64,815,000,000 59,674,000,000 56,388,000,000 51,960,000,000 108,942,000,000 108,942,000,000 94,507,000,000 85,029,000,000 80,736,000,000 74,510,000,000 108,942,000,000 108,942,000,000 94,507,000,000 85,029,000,000 80,736,000,000 74,510,000,000 34,440,000,000 34.440,000,000 -29,692,000,000 -25,355,000,000 -24,348,000,000 22,550,000,000 -34,440,000,000 -34,440,000,000 -29,692,000,000 -25,355,000,000 -24,348,000,000 -22,550,000,000 -53,377,000,000 -53,377,000,000 45,806,000,000 41,656,000,000 -39,557,000,000 35,962,000,000 40,424,000,000 40,424,000,000 35,130,000,000 31,968,000,000 30,131,000,000 -27,282,000,000 32,807,000,000 -32,807,000,000 -28,094,000,000 -25,449,000,000 -23,840,000,000 -21,325,000,000 -7,617,000,000 -7,617,000,000 -7.036,000,000 -6,519,000,000 -6,291,000,000 -5,957,000,000 -12,953,000,000 -12,953,000,000 -11,017,000,000 -10,130,000,000 -9,426,000,000 -3,680,000,000 -12,953,000,000 -12.953,000,000 -11,017,000,000 -10,130,000,000 -9,426,000,000 -8,680,000,000 -8,663,000,000 -8,663,000,000 -8,281,000,000 -7.914,000,000 -7,464,000,000 -6,781,000,000 4,290,000,000 4,290,000,000 -2,736,000,000 -2,216,000,000 -1,962,000,000 -1,899,000,000 0 341,000,000 442,000,000 0 341,000,000 442,000,000 21,125,000,000 21,125,000,000 19,009,000,000 18,018,000,000 16,831,000,000 15,998,000,000 4,129,000,000 4,129,000,000 3,767,000,000 2,665,000,000 -2,505,000,000 -2,626,000,000 4,567,000,000 4,567,000,000 -3,542,000,000 3,086,000,000 -2,942,000,000 -2,702,000,000 4,567,000,000 4,567,000,000 3,542,000,000 3,086,000,000 -2,942,000,000 2,702,000,000 4,567,000,000 4,567,000,000 -3,542,000,000 -3,086,000,000 -2,942,000,000 -2,702,000,000 438,000,000 438,000,000 -225,000,000 421,000,000 437,000,000 -185,000,000 656,000,000 656,000,000 -187,000,000 -17,000,000 12,000,000 12,000,000 -505,000,000 -505,000,000 -364,000,000 107,000,000 -104,000,000 -325,000,000 287.000.000 287,000,000 326,000,000 331,000,000 529,000,000 13,000,000 115,000,000 15 Name: Comcast 2 Gross Profit 3 Total Revenue Business Revenue 5 Cost of Revenue 6 Cost of Goods and Services 7 Operating Income/Expenses Selling, General and Administrative Expenses General and Administrative Expenses Selling and Marketing Expenses 11 Depreciation, Amortization and Depletion 12 Depreciation and Amortization 13 Depreciation Amortization Other Income/Expense, Operating Other Income, Operating 17 Total Operating Profit/Loss 18 Non-Operating Income/Expenses, Total 19 Total Net Finance Income/Expense 20 Net Interest Income/Expense Interest Expense Net of Capitalized Interest 22 Net Investment Income 23 Gain/Loss on Investments and Other Financial Instruments Income from Associates, Joint Ventures and Other Participating Interests Other Investment Income 26 Dividend and Investment Income Gain/Loss on Derivatives Unrealized Gain/Loss on Derivatives 29 Irregular Income/Expenses Impairment/Write Off/Write Down of Other Assets Other Income/Expense, Non-Operating 32 Pretax Income 33 Provision for Income Tax 34 Net Income from Continuing Operations 35 Net Income after Extraordinary Items and Discontinued Operations 36 Non-Controlling/Minority Interests 37 Net Income after Non-Controlling/Minority Interests 38 Net Income Available to Common Stockholders 39 Diluted Net Income Available to Common Stockholders 40 Reported Total Revenue 41 Reported Total Operating Profit/Loss 42 Reported Effective Tax Rate 43 Reported Normalized EBITDA 44 Reported Normalized Income 45 Fiscal year ends in Dec 31 USD 46 21 24 25 27 28 30 31 16,996,000,000 16,996,000,000 3,673,000,000 3,673,000,000 13,323,000,000 13,323,000,000 13,323,000,000 13,323,000,000 -266,000,000 -266,000,000 13,057,000,000 13,057,000,000 13,057,000,000 13,057,000,000 13,057,000,000 13,057,000,000 108,942,000,000 108,942,000,000 21,125,000,000 21,125,000,000 15,242,000,000 3,380,000,000 11,862,000,000 11,862,000,000 -131,000,000 11,731,000,000 11,731,000,000 11,731,000,000 94,507,000,000 19,009,000,000 15,353,000,000 7,569,000,000 22,922,000,000 22,922,000,000 -187,000,000 22,735,000,000 22,735,000,000 22,735,000,000 85,029,000,000 18,018,000,000 14,326,000,000 -5,298,000,000 9,028,000,000 9,028,000,000 -350,000,000 8,678,000,000 8,678,000,000 8,678,000,000 80,736,000,000 16,831,000,000 -59,000,000 -59,000,000 320,000,000 13,372,000,000 4,959,000,000 8,413,000,000 8,413,000,000 -250,000,000 8,163,000,000 8,163,000,000 8,163,000,000 74,510,000,000 15,998,000,000 0 0 34,258,000,000 34,258,000,000 30,165,000,000 12,680,000,000 27,956,000,000 9,709,000,000 26,257,000,000 24,678,000,000 8,171,000,000 TTM 16,540,000,000 45,764,000,000 45,764,000,000 -29,224,000,000 -22,179,000,000 -7.045,000,000 -9.926,000,000 -9.926,000,000 -9,926,000,000 2019 16,540,000,000 45,764,000,000 45,764,000,000 -29,224,000,000 -22,179,000,000 -7.045,000,000 -9.926,000,000 -9.926,000,000 -9.926,000,000 E F 2018 2017 2016 2015 15,774,000,000 15,040,000,000 10,348,000,000 3,328,000,000 43,634,000,000 41,581,000,000 29,003,000,000 9,754,000,000 43,634,000,000 41,581,000,000 29,003,000,000 9,754,000,000 -27,860,000,000 -26,541,000,000 -18,655,000,000 -6,426,000,000 -21,007,000,000 -19,895,000,000 -13,808,000,000 4,993,000,000 -6,853,000,000 -6,646,000,000 4,847,000,000 -1,433,000,000 -10,318,000,000 -10,588,000,000 -6,907,000,000 -2,125,000,000 -10,318,000,000 -10,588,000,000 -6.907,000,000 -2,125,000,000 -10,318,000,000 -10,588,000,000 -6,907,000,000 -2,125,000,000 11 12 13 A Name: Charter 2 Gross Profit 3 Total Revenue 4 Business Revenue 5 Cost of Revenue Cost of Goods and Services Other Cost of Revenue 8 Operating Income/Expenses Depreciation, Amortization and Depletion 10 Depreciation and Amortization Selling, General and Administrative Expenses Staff Costs Pension and Other Employee Benefits Costs 14 Total Operating Profit/Loss 15 Non-Operating Income/Expenses, Total 16 Total Net Finance Income/Expense 17 Net Interest Income/Expense Net Investment Income 19 Gain/Loss on Investments and Other Financial Instruments Gain/Loss on Derivatives Irregular Income/Expenses 22 Asset Disposals Gain/Loss on Extinguishment of Debt Merger and Acquisition Income/Expense Other Irregular Income/Expenses 26 Other Income/Expense, Non-Operating 27 Pretax Income 28 Provision for Income Tax 29 Net Income from Continuing Operations 30 Net Income after Extraordinary Items and Discontinued Operations 31 Non-Controlling/Minority Interests 32 Net Income after Non-Controlling/Minority Interests 33 Net Income Available to Common Stockholders 34 Diluted Net Income Available to Common Stockholders 35 Reported Total Revenue 36 Reported Total Operating Profit/Loss 37 Reported Normalized EBITDA 38 Fiscal year ends in Dec 31 USD 39 6,614,000,000 4,183,000,000 -3,797,000,000 3,797,000,000 -54,000,000 -54,000,000 6,614,000,000 4,183,000,000 -3,797,000,000 3,797,000,000 -54,000,000 -54,000,000 5,456,000,000 3,770,000,000 -3,540,000,000 -3,540,000,000 -110,000,000 -110,000,000 4,452,000,000 3,424,000,000 -3,090,000,000 3,090,000,000 69,000,000 69,000,000 3,441,000,000 1,203,000,000 -2,621,000,000 -1,534,000,000 -2,499,000,000 -1,306,000,000 -2,499,000,000 -1,306,000,000 89,000,000 4,000,000 89,000,000 4,000,000 18 20 21 -235,000,000 -85,000,000 23 24 25 -128,000,000 42,000,000 -25,000,000 -10,000,000 -51,000,000 -204,000,000 2,431,000,000 -439,000,000 1,992,000,000 1,992,000,000 324,000,000 1,668,000,000 1,668,000,000 1,668,000,000 45,764,000,000 45 ZRA 6,511,000,000 16,855,000,000 -128,000,000 42,000,000 -25,000,000 -10,000,000 -51,000,000 -204,000,000 2,431,000,000 439,000,000 1,992,000,000 1,992,000,000 -324,000,000 1,668,000,000 1,668,000,000 1,668,000,000 45,764,000,000 6,511,000,000 16,855,000,000 -386,000,000 -16,000,000 40,000,000 351,000,000 21,000,000 -17,000,000 1,028,000,000 9,087,000,000 10,115,000,000 10,115,000,000 220,000,000 9,895,000,000 9,895,000,000 9,895,000,000 41,581,000,000 4,106,000,000 15,301,000,000 -97,000,000 -53,000,000 115,000,000 1,686,000,000 -180,000,000 1,506,000,000 1,506,000,000 276,000,000 1,230,000,000 1,230,000,000 1,230,000,000 43,634,000,000 5,221,000,000 16,059,000,000 -1,096,000,000 2,000,000 -111,000,000 -970,000,000 -17,000,000 885,000,000 $20,000,000 2,925,000,000 3,745,000,000 3,745,000,000 223,000,000 3,522,000,000 3,522,000,000 3,522,000,000 29,003,000,000 2,456,000,000 10,592,000,000 217.000.000 4,000,000 -128,000,000 -70,000,000 -15,000,000 -7,000,000 -331,000,000 60,000,000 -271,000,000 271,000,000 271,000,000 -271,000,000 271,000,000 9,754,000,000 1,114,000,000 3,406,000,000 40 41
