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
-
Paragraphs 5-7 of PCAOB Auditing Standard No. 13. Comment about how your understanding of the inherent risks identified at Enron (in Question 13) would influence the nature, timing, and extent of...
-
Suppose a jar contains 3 pens: 1 red, 1 blue, and 1 green. Three people sign a document, one at a time. Each person selects a pen, signs the document, and then replaces the pen before the next person...
-
Explain the purpose of a business and describe how businesses are organised and structured.
-
Following are audit procedures that are normally conducted in the purchasing process and related accounts. 1. Test a sample of purchase requisitions for proper authorization. 2. Test transactions...
-
Limited partners try to get a better understanding of the distributions for the fund they invested in. Assume that they contributed $200 million in the first year to fund an investment and that the...
-
Henry Coupe, the manager of a metropolitan branch office of the state department of motor vehicles, attempted to analyze the drivers license-renewal operations. He had to perform several steps. After...
-
UOT Corp provides Just in Time printing and kitting services to many different clients. The kitting operations consisted of building COVID kits, containing personal protective equipment, to be sent...
-
Use the tables on the page for the following problems. What would a 150/300/75 liability insurance semiannual premium be in territory 4? If you were a 21 year old male who lives in territory 2...
-
Answer the following numerical questions based on the 1. What is the mean value of the resistance of the set of resistors? 2. What is the standard deviation of the resistance of the set of resistors?...
-
George and Martha Washington ask you to prepare their tax return for 2018. They give you the following information upon which to work. 1) George's social security number is 123-45-6789, while...
-
Superior Limited's total overhead costs at various levels of activity are presented below: Month March April May June Machine Hours Total Overhead Costs 60,000 $216,800 50,000 194,000 70,000 239,600...
-
The tab contains monthly holding period stock returns for International Business Machines Corp. (IBM), Microsoft Corp. (MSFT), and Caterpillar Inc. (CAT) for the months from January 2016 through...
-
A company provides the following information for the year 2018: Description Amount Description Mortgage payable Amount Cash $9,950 $17,500 (due 2021) Accounts payable $32,510 Unearned revenue $950...
-
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.
-
Wentworth Watches Ltd manufactures and sells watches with a 2-year warranty. The warranty provision account had a debit of \($2000\) before adjusting entries on 31 December 2018, which is Wentworth...
-
Which of the following is not a current liability? (a) Allowance for doubtful debts. (b) Revenue received in advance. (c) Current portion of long-term debt. (d) Payroll deduction not yet remitted.
-
In a recent year Kennedy Ltd had profit after tax of \($150\) 000, interest expense of \($30\) 000, and tax expense of \($20\) 000. What was Kennedy Ltds times interest earned for the year? (a) 5.00....
Study smarter with the SolutionInn App