Question

1 Approved Answer

Posted on Jul 10, 2024

For the next 5 questions, you have been tasked with building a stand-alone DCF valuation for Graham Holdings (GHC), a publicly traded company, using the

For the next 5 questions, you have been tasked with building a stand-alone DCF valuation for Graham Holdings (GHC), a publicly traded company, using the unlevered (two-stage) approach. You have collected the data found in this file: GHC Free Cashflow Data (download the file by clicking the link and open it to answer this question). Question: Using the data from the "GHC Free Cashflow Data" workbook, calculate 2016 unlevered free cash flows. Assume the tax rate = 2016 tax expense/pretax income. 241,530.0 268.855.0 O 270,976.7 Free cash flow buildup 12/31/2014 Focal year end date 12/31/2015 12/11/2016 Reve COS SOSA And other operating expenses t.com #terest experise Noring operating incomexpende 1 Provision for con Tees 2.734 03200 2.501312.00 1.136 15.30 17.010 320000 22556,114.00 2006.919.00 1.900.00 12.05100 -100 20.500.00 2.401.190.00 2:17.156.00 3.000 15.390.00 - 12.00 1.300.00 Depreciation & otion (included in COGS, SO&A and other operating expense) 209.15700 300 92.194.00 Fheal year ridae Casa equivalent estments in marketable equity sectis Womental Tititingihlemusets including goodwill 12/31/2015 794.95200 379500 706325.00 1.14,589.00 12/31/2016 670.816.00 24100 1.296.919.00 10 1 Fiscal year end date S hand equivalents Investments i rumitabile equity securities 7 Working capital assets Intangible assets (including goodwill PPOR 12/31/2015 374,952:00 379,415.00 706,325.00 1.140.589.00 231.123.00 12/31/2016 670 816.00 14241.00 752.289.00 1.296.919.00 213.661.00 938.429.00 1 Working capitullibilities 2 Current portion of long-term debt Ter Debt 1.008,743 00 6,128.00 185,719.00 309.800.00 12/31/2015 12/31/2016 Fiscal year end date Cathows from chines Capital expenditures and purchases of intests Common dividends 2:37.292.00 68,114.00 136.859.00 54,721.00 66,612.00 27,325.00 For the next 5 questions, you have been tasked with building a stand-alone DCF valuation for Graham Holdings (GHC), a publicly traded company, using the unlevered (two-stage) approach. You have collected the data found in this file: GHC Free Cashflow Data (download the file by clicking the link and open it to answer this question). Question: Using the data from the "GHC Free Cashflow Data" workbook, calculate 2016 unlevered free cash flows. Assume the tax rate = 2016 tax expense/pretax income. 241,530.0 268.855.0 O 270,976.7 Free cash flow buildup 12/31/2014 Focal year end date 12/31/2015 12/11/2016 Reve COS SOSA And other operating expenses t.com #terest experise Noring operating incomexpende 1 Provision for con Tees 2.734 03200 2.501312.00 1.136 15.30 17.010 320000 22556,114.00 2006.919.00 1.900.00 12.05100 -100 20.500.00 2.401.190.00 2:17.156.00 3.000 15.390.00 - 12.00 1.300.00 Depreciation & otion (included in COGS, SO&A and other operating expense) 209.15700 300 92.194.00 Fheal year ridae Casa equivalent estments in marketable equity sectis Womental Tititingihlemusets including goodwill 12/31/2015 794.95200 379500 706325.00 1.14,589.00 12/31/2016 670.816.00 24100 1.296.919.00 10 1 Fiscal year end date S hand equivalents Investments i rumitabile equity securities 7 Working capital assets Intangible assets (including goodwill PPOR 12/31/2015 374,952:00 379,415.00 706,325.00 1.140.589.00 231.123.00 12/31/2016 670 816.00 14241.00 752.289.00 1.296.919.00 213.661.00 938.429.00 1 Working capitullibilities 2 Current portion of long-term debt Ter Debt 1.008,743 00 6,128.00 185,719.00 309.800.00 12/31/2015 12/31/2016 Fiscal year end date Cathows from chines Capital expenditures and purchases of intests Common dividends 2:37.292.00 68,114.00 136.859.00 54,721.00 66,612.00 27,325.00