1 Assumptions, DCF valuation for Graham Holdings 2 3 Growth of EBIAT through 2021 4 Nonrecurring...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1 Assumptions, DCF valuation for Graham Holdings 2 3 Growth of EBIAT through 2021 4 Nonrecurring non-operating income/(expense) 2017-2021 5 Growth of every other income statement item through 2021 6 Growth of cash and equivalents, marketable securities, working capital assets and liabilities, debt (current and long term) through 2021 7 Growth of common dividends through 2021 (2) 8 Capital expenditures and purchases of intangibles in 2017 Growth of capital expenditures, intangible purchases 2018-20212) o Terminal growth rate 1 _2 (8) (2) 3 Operating incomex (1-tax rate) 4567 Assume no asset sales for PP&E or intangible assets Average of 2014-2016 5.00% $0.00 5.00% 5.00% 5.00% 5.00% 3.00% 4:00 AM Wed Dec 1 5 fx IS-GHC-Free-Cashflow-Buildup.xlsx copy e Calibri (Body) A 1 2 3 Fiscal year end date 4 Select Income Statement Data Free cash flow buildup 14 5 Revenue 6 COGS, SG&A and other operating expenses 7 Interest income Interest expense 9 Nonrecurring non-operating income/(expense) 10 Provision for Income Taxes 14 Fiscal year end date 15 Cash and equivalents 16 Investments in marketable equity securities 17 Working capital assets 18 Intangible assets (including goodwill) 19 PP&E A 20 21 Working capital liabilities. 22 Current portion of long-term debt 23 Long-Term Debt 24 Sheet1 + Home BIUS 0 11 Memo: 12 Depreciation & amortization (included in COGS, SG&A and other operating expenses) 13 Insert Draw 25 Fiscal year end date 26 Cash flows from investing activities 27 Capital expenditures and purchases of intangible assets 28 Common dividends 29 30 Formulas Data Review View B 12/31/14 2,737,032,00 2,504,312.00 2,136 35,533 778,010 312,300.00 249,457.00 237,292.00 68,114.00 ABC 123 H 12/31/15 2,586,114.00 2,666,939.00 1,909.00 32,654.00 -8,623.00 20,500.00 428,437.00 12/31/15 774,952.00 379,445.00 706,325.00 1,146,589.00 231,123.00 928,429.00 0 399,800.00 12/31/15 136,859.00 53,721.00 8 а Σ v V D 23% @ LAI 12/31/16 2,481,890.00 2.178.356.00 3,093.00 35.390.00 -12,642.00 81,200.00 92,894.00 12/31/16 670,816.00 448,241.00 752,289.00 1,296,919.00 233.664.00 1,008,743.00 6,128.00 485,719.00 12/31/16 66,612.00 27,325.00 ... V 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 221,312.7 578,479.5 1 Assumptions, DCF valuation for Graham Holdings 2 3 Growth of EBIAT through 2021 4 Nonrecurring non-operating income/(expense) 2017-2021 5 Growth of every other income statement item through 2021 6 Growth of cash and equivalents, marketable securities, working capital assets and liabilities, debt (current and long term) through 2021 7 Growth of common dividends through 2021 (2) 8 Capital expenditures and purchases of intangibles in 2017 Growth of capital expenditures, intangible purchases 2018-20212) o Terminal growth rate 1 _2 (8) (2) 3 Operating incomex (1-tax rate) 4567 Assume no asset sales for PP&E or intangible assets Average of 2014-2016 5.00% $0.00 5.00% 5.00% 5.00% 5.00% 3.00% 4:00 AM Wed Dec 1 5 fx IS-GHC-Free-Cashflow-Buildup.xlsx copy e Calibri (Body) A 1 2 3 Fiscal year end date 4 Select Income Statement Data Free cash flow buildup 14 5 Revenue 6 COGS, SG&A and other operating expenses 7 Interest income Interest expense 9 Nonrecurring non-operating income/(expense) 10 Provision for Income Taxes 14 Fiscal year end date 15 Cash and equivalents 16 Investments in marketable equity securities 17 Working capital assets 18 Intangible assets (including goodwill) 19 PP&E A 20 21 Working capital liabilities. 22 Current portion of long-term debt 23 Long-Term Debt 24 Sheet1 + Home BIUS 0 11 Memo: 12 Depreciation & amortization (included in COGS, SG&A and other operating expenses) 13 Insert Draw 25 Fiscal year end date 26 Cash flows from investing activities 27 Capital expenditures and purchases of intangible assets 28 Common dividends 29 30 Formulas Data Review View B 12/31/14 2,737,032,00 2,504,312.00 2,136 35,533 778,010 312,300.00 249,457.00 237,292.00 68,114.00 ABC 123 H 12/31/15 2,586,114.00 2,666,939.00 1,909.00 32,654.00 -8,623.00 20,500.00 428,437.00 12/31/15 774,952.00 379,445.00 706,325.00 1,146,589.00 231,123.00 928,429.00 0 399,800.00 12/31/15 136,859.00 53,721.00 8 а Σ v V D 23% @ LAI 12/31/16 2,481,890.00 2.178.356.00 3,093.00 35.390.00 -12,642.00 81,200.00 92,894.00 12/31/16 670,816.00 448,241.00 752,289.00 1,296,919.00 233.664.00 1,008,743.00 6,128.00 485,719.00 12/31/16 66,612.00 27,325.00 ... V 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 221,312.7 578,479.5
Expert Answer:
Answer rating: 100% (QA)
The 2021 unlevered free cash flow is 2213127 CALCULATION Revenue in 2021 30398825 Cost of ... View the full answer
Related Book For
Applied Equity Analysis and Portfolio Management Tools to Analyze and Manage Your Stock Portfolio
ISBN: 978-1118630914
1st edition
Authors: Robert A.Weigand
Posted Date:
Students also viewed these accounting questions
-
When we say that two variables covary, we mean that the: A) variables are causally related. B) relationship between the variables is spurious. C) variables are unrelated to each other. D) variables...
-
Using the equations your derived in questions 59 and 62 for IS and LM, what will be the equilibrium interest rate (r) and equilibrium output (Y)? A) B) C) D) r = 8, Y = 900B r = 9, Y = 600B r = 10, Y...
-
Calculate UTX's return on invested capital (ROIC) for each year 2010-2012.
-
Consider the following function. def f(x): a = [] while x > 0: a.append(x) f(x-1) A new object of type list is created for each recursive invocation of f. True or False
-
A motor and load with negligible friction and a voltage- to-current amplifier Ka is used in the feedback control system, shown in Figure P12.7. A designer selects a PID controller where KP = 5, Kt =...
-
In relation to the previous example, assume now that Alice always let her Derby house when she was not resident there. Compute the chargeable gain. Data from Example 2 On 1 June 1995, Alice bought a...
-
Consider the following cash flow profile and assume MARR is 10 percent/year. a. What does Descartes' rule of signs tell us about the IRR(s) of this project? b. What does Norstrom's criterion tell us...
-
C-Cell Wireless needed additional capital to expand, so the business incorporated. The charter from the state of Georgia authorizes C-Cell to issue 50,000 shares of 7%, $50 par value cumulative...
-
In December of 2017, the US Government signed the Tax Cuts and Jobs Act (TCJA) into law. The TCJA had four goals; tax relief for middle-income families, simplification for individuals, economic...
-
Southwick Company uses normal costing in its job- costing system. Partially completed T- accounts and additional information for Southwick for 2012 are as follows: Required Additional information...
-
Beverly earns a salary of $47,000 per year and is paid semi-monthly. The current CPP rate is 5.25%, and the current El rate is 1.58%. Assuming her income tax rate is 19%, calculate her net pay for...
-
Assume a survey was sent out using the two-step cluster sampling method in #5. All surveys were sent out to 6,000 homes, and the survey yielded a response rate of 10%. 35% were in favor of the...
-
A Coffee Shop Consortium called High Star Cafeteria has hired your services as a manager to figure out what is happening to their revenue, given that in January 2010 their total revenue was...
-
In criminal law, when is ones 'condition' deemed to be incapacitating and how does this influence potential liability?
-
Why are criminal thought not penalized by criminal law ?
-
How do immune cells such as dendritic cells, macrophages, and B cells process and present antigens to T cells through major histocompatibility complex (MHC) molecules, and what are the implications...
-
1. Write a python program to implement the Crout (LU) Factorization for Tri-Diagonal linear systems. Use the method to solve the system: 2x1x2 = 1, - -21 +22-23 = 0, -22 +223 24 = 0, -23 +224 = 1...
-
A crop-dusting plane flies over a level field at a height of 25 ft. If the dust leaves the plane through a 30 angle and hits the ground after the plane travels 75 ft, how wide a strip is dusted? See...
-
You've been shopping for a car. You have $3000 for a down payment, and will need to finance the remainder of the purchase. You find something suitable at a local car dealer, and you think the sticker...
-
Calculate the Treynor ratios for Deere, Intel, Pfizer, the S&P 500 index and the 50/50 and 35/35/30 portfolios. Organize the Treynor ratios for all 5 investment options into a table that displays...
-
Calculate the expected return and variance of a portfolio comprised of 50% Chevron and 50% Yum! Brands.
-
Describe the car you, a friend, or family member had at age 20. a. What were the top two reasons this car was bought? b. What was the trigger for this purchase?
-
What do these stores do specifically to target you and people with similar needs (i.e., marketing)?
-
Describe the car you, a friend, or family member had at age 30. a. What were the top two reasons this car was bought? b. What was the trigger for this purchase?
Study smarter with the SolutionInn App