In addition to the historical data provided in the GHC Free Cashflow Data workbook, you make the assumptions found in this file: GHC Assumptions (download the file by clicking the link and open it to answer this question). Question: What is the 2021 unlevered free cash flow? 161,288.2 186,438.3 O 190,140.5 0 221,312.7 O 578,479.5 IS-GHC-Free Cashflow-Buildup.xlsx Home Insert Draw Formulas Data Review View A ABC B I U ebe More Read Only - This is an older file format. Changes can only be saved to a copy of the file. x Free cash flow buildup Free cash flow buildiap 12/11/14 12/31/15 12/11/16 halar enddale Selection Start Date Revenue COGS, SGRA and other operating expenses Intestine interest expand Nonrecurring non-operating incomexpense) Provision for Income Taxes Memo Depreciation ametition (included in COGS, SG&A and other operating expenses 2.737 01200 2,504312.00 2136 35.51 7700 12 2,586,114.00 2.666,999.00 1.909.00 32.654.00 2,451 2,178,356 00 3,093.00 33,390.00 -12.947.00 81,200.00 20,500.00 249.457.00 438417.00 92.89400 Fhical read date Cash and equivalents Investments in marketable equity securities Working capitales Intangible anels including goodwill PPAR 12/31/15 774,952.00 379445.00 206,135.00 1,146 5900 231.12100 1281/16 670,816.00 443,24100 752.289.00 1,296,919.00 23366400 Working capitales Curre portion of long-term debe Long-Term Debt 938.429.00 0 390.00 100 101 6,10 485,719.00 12/30S 12/31/16 Fheall year end date |Cut fairame Capital expenditures and purchases of intangibles Common dividend 237,292.00 6114.00 13690.00 53,721.00 66612.00 27.335.00 Sheet1 In addition to the historical data provided in the GHC Free Cashflow Data workbook, you make the assumptions found in this file: GHC Assumptions (download the file by clicking the link and open it to answer this question). Question: What is the 2021 unlevered free cash flow? 161,288.2 186,438.3 O 190,140.5 0 221,312.7 O 578,479.5 IS-GHC-Free Cashflow-Buildup.xlsx Home Insert Draw Formulas Data Review View A ABC B I U ebe More Read Only - This is an older file format. Changes can only be saved to a copy of the file. x Free cash flow buildup Free cash flow buildiap 12/11/14 12/31/15 12/11/16 halar enddale Selection Start Date Revenue COGS, SGRA and other operating expenses Intestine interest expand Nonrecurring non-operating incomexpense) Provision for Income Taxes Memo Depreciation ametition (included in COGS, SG&A and other operating expenses 2.737 01200 2,504312.00 2136 35.51 7700 12 2,586,114.00 2.666,999.00 1.909.00 32.654.00 2,451 2,178,356 00 3,093.00 33,390.00 -12.947.00 81,200.00 20,500.00 249.457.00 438417.00 92.89400 Fhical read date Cash and equivalents Investments in marketable equity securities Working capitales Intangible anels including goodwill PPAR 12/31/15 774,952.00 379445.00 206,135.00 1,146 5900 231.12100 1281/16 670,816.00 443,24100 752.289.00 1,296,919.00 23366400 Working capitales Curre portion of long-term debe Long-Term Debt 938.429.00 0 390.00 100 101 6,10 485,719.00 12/30S 12/31/16 Fheall year end date |Cut fairame Capital expenditures and purchases of intangibles Common dividend 237,292.00 6114.00 13690.00 53,721.00 66612.00 27.335.00 Sheet1
