Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

To answer this question, value Graham Holdings as of December 31, 2016 using all the data provided in the previous 2 questions (Files: GHC Free

image text in transcribedimage text in transcribed

To answer this question, value Graham Holdings as of December 31, 2016 using all the data provided in the previous 2 questions (Files: GHC Free Cashflow Data, GHC Assumptions) assuming all cash flows come at year end. Assume a WACC of 8.00%.
Question: What is the equity value using the FCFF (unlevered DCF) approach? Use exact dates and assume calendar year (January 1-December 31) and an ACTUAL/ACTUAL month/year basis.
Answer Selection
3,273,512.20
3,721,753.20
4,079,691.20
4,527,932.20
5,983,730.90
Free cash flow buildup 12/31/2014 12/31/2015 12/31/2016 Fiscal year end date Select Income Statement Data Revenue COGS, SG&A and other operating expenses Interest income Interest expense Nonrecurring non-operating income (expense) Provision for Income Taxes Memo: Depreciation & amortization (included in COGS, SG&A and other operating expenses) 2,737,032.00 2,504,312.00 2,136 35,533 778,010 312,300.00 2,586,114.00 2,666,939.00 1,909.00 32,654.00 -8.623.00 20,500.00 2.481,890.00 2,178,356.00 3,093.00 35,390.00 -12,642.00 81,200.00 249.457.00 428,437.00 92,894.00 Fiscal year end date Cash and equivalents Investments in marketable equity securities Working capital assets Intangible assets (including goodwill) PP&E 12/31/2015 774,952.00 379,445.00 706,325.00 1,146,589.00 231,123.00 12/31/2016 670,816.00 448,241.00 752,289.00 1,296,919.00 233,664.00 Working capital liabilities Current portion of long-term debt Long-Term Debt 928,429.00 0 399,800.00 1,008,743.00 6,128.00 485,719.00 12/31/2015 12/31/2016 Fiscal year end date Cash flows from investing activities Capital expenditures and purchases of intangible assets Common dividends 237,292.00 68,114.00 136,859.00 53,721.00 66,612.00 27,325.00 Assumptions, DCF valuation for Graham Holdings Growth of EBIAT(1) through 2021 Nonrecurring non-operating income/expense) 2017-2021 Growth of every other income statement item through 2021 Growth of cash and equivalents, marketable securities, working capital assets and liabilities, debt (current and long term) through 2021 Growth of common dividends through 2021 Capital expenditures and purchases of intangibles in 2017 (2) Growth of capital expenditures, intangible purchases 2018-2021(2) Terminal growth rate 5% 0% 5% 5% 5% Average of 2014-2016 5% 3% (1) Operating income x (1-tax rate) (2) Assume no asset sales for PP&E or intangible assets Free cash flow buildup 12/31/2014 12/31/2015 12/31/2016 Fiscal year end date Select Income Statement Data Revenue COGS, SG&A and other operating expenses Interest income Interest expense Nonrecurring non-operating income (expense) Provision for Income Taxes Memo: Depreciation & amortization (included in COGS, SG&A and other operating expenses) 2,737,032.00 2,504,312.00 2,136 35,533 778,010 312,300.00 2,586,114.00 2,666,939.00 1,909.00 32,654.00 -8.623.00 20,500.00 2.481,890.00 2,178,356.00 3,093.00 35,390.00 -12,642.00 81,200.00 249.457.00 428,437.00 92,894.00 Fiscal year end date Cash and equivalents Investments in marketable equity securities Working capital assets Intangible assets (including goodwill) PP&E 12/31/2015 774,952.00 379,445.00 706,325.00 1,146,589.00 231,123.00 12/31/2016 670,816.00 448,241.00 752,289.00 1,296,919.00 233,664.00 Working capital liabilities Current portion of long-term debt Long-Term Debt 928,429.00 0 399,800.00 1,008,743.00 6,128.00 485,719.00 12/31/2015 12/31/2016 Fiscal year end date Cash flows from investing activities Capital expenditures and purchases of intangible assets Common dividends 237,292.00 68,114.00 136,859.00 53,721.00 66,612.00 27,325.00 Assumptions, DCF valuation for Graham Holdings Growth of EBIAT(1) through 2021 Nonrecurring non-operating income/expense) 2017-2021 Growth of every other income statement item through 2021 Growth of cash and equivalents, marketable securities, working capital assets and liabilities, debt (current and long term) through 2021 Growth of common dividends through 2021 Capital expenditures and purchases of intangibles in 2017 (2) Growth of capital expenditures, intangible purchases 2018-2021(2) Terminal growth rate 5% 0% 5% 5% 5% Average of 2014-2016 5% 3% (1) Operating income x (1-tax rate) (2) Assume no asset sales for PP&E or intangible assets

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Institutions Management A Risk Management Approach

Authors: Anthony Saunders, Marcia Cornett

7th Edition

0073530751, 9780073530758

More Books

Students also viewed these Finance questions

Question

Were the payments to Allen protected by the business judgment rule?

Answered: 1 week ago