Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What I need help is interpreting the qualitative and quantitative information found on the worksheet called Valuation Summary, which is the fourth screenshot in the

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

What I need help is interpreting the qualitative and quantitative information found on the worksheet called Valuation Summary, which is the fourth screenshot in the middle of this listing. Thank you very much!

It is because I cannot really find any online article or articles, which would help me be able to interpret the information that is on the worksheet called Valuation Summary that is related to Capitalization rate, Net Present value of expected (future) cash flows (profits) in the future, also called Terminal cash flow, in the Terminal Years and Capitalized terminal cash flow at the end of an investment, project, the series of cash flows, Implied Enterprise Value (Total Value of a business).

Can you all help me out sharing how you all would interpret the dollar amounts associated with Indicated value with voting rights expressed as a dollar amount, Discount for Lack of rights expressed as a percentage, and Discount for Lack of rights expressed as a dollar amount, Marketable, minority value, Discount for Lack of Marketability expressed as a percentage, Discount for Lack of Marketability expressed as a dollar amount, Nonmarketable, minority value expressed as a dollar amount, and Value of a one-percent interest (in millions), which you all see in the worksheet called Valuation Summary, please?

1 2 Company ABC Inc. 3 Discounted Cash Flow Method (in millions) 4 5 6 7 8 9 10 Projected for Years Ending December 31, Terminal Value 2018 2019 2020 2021 2022 $ 2,648 $ 2,714 $ 2,782 $ 2,852 5 2,924 16,682 16,720 16,744 17,100 17,100 19,311 (23.866 19,638 (17,188) 19,638 (14,982) 18,001 (12.649 18,001 (12,649) $ 14,775 $ 21,884 $ 24,182 $ 25,304 5 25,376 $ 11,551 5 15,127 $ 14,779 $ 13,673 11 Forecasted Net Income $ 2,584 12 Plus 13 Depreciation 17.403 14 Less: 15 Capital expenditures 18.121 16 Debt reduction (14,588) 17 18 Net Cash Flow $ 23,520 19 20 Present value of cash flows $ 20,796 21 22 Discount rate: 13.1% 23 24 25 Terminal period cash flows 26 Capitalization rate: 10.6% 27 28 Capitalized terminal cash flow 29 30 Net present value of terminal cash flow, discounted into perpetuity 31 s 25,376 10.6% s 239,396 129,400 31 32 s 75,900 129,400 33 Net present value - five years ending YE: 2022 34 Net present value of terminal cash flow 35 36 Total indication of value (rounded) $ 205,300 37 38 1 Company ABC Inc. 2 Final Computation of Value 3 As of December 31, 2018 4 5 Income Approach: Discounted Cash Flow Method 5 8 Indicated Value of Equity 9 Weight 205,300 100 % 10 $ 205,300 12 $ 205,300 (30,795) 14 15,0% SK N R S S G ; = - 11 Weighted Value (rounded) 13 Indicated value with voting rights Less DLOC (Discount for Lack of Control) 16 Marketable, minority value Less DLOM (Discount for Lack of Marketability) 19 Nonmarketable minority value 25.0% 174,505 (43,626) 17 18 $ 130,879 z3 Value of a one-percent interest (in millions) 1,309 24 income statement balance sheet ratios prospective analysis discount rate dcf valuation summary S205,300,000 is the-Net-Asset-Value of this business's real-estate and Total-Indication of value of this firm-and-Indicated-value of equity, or this company's stock:((F8, valuation summary, ACC-345-7-1 Final-Project-Submission (Business-Valuation Model (Verizon Communications Inc.)).- $205,300, or $205,300,000 is the Weighted value of equity, also called stockholders' equity, on the worksheet called Valuation Summary:((F11, valuation summary, ACC-345-7-1 Final Project Submission (Business Valuation-Model (Verizon Communications Inc.))--After the Indicated value of equity, or stockholders' equity, and the weight of 100% were multiplied together to equal-$20,530,000,000.--$20,530,000,000 was divided by 100 to equal S205,300.000, the Weighted value of equity. --Weight of indicated value of equity is 100%, it means company's capital structure is only equity-oriented and not having any debt. --For example, a company's enterprise value is $100,000-and-70%-weight of equity it means weighted value of equity is $70,000 ($100,000-x-0.70) -and-30% belongs to debt that is $30,000 ($100,000-x-0.30)... Weighted value is $205,300,000 because this is calculated by [(Step-1): $205,300,000-x-0.100= $20,530,000, (Step-2):= $20,530,000,000 =$205,300,000)]. --It simply means all value-belongs to equity-only-(F8, F9. F13, valuation summary, ACC-345-7-1 Final-Project Submission (Business Valuation Model (Verizon Communications Inc.)). --However, $205,300,000 is now-Indicated value with voting Tights. --$205,300,000, the Indicated value with voting rights, or this dollar amount represented the shareholders who owned and/or still own outstanding shares of this firm's common stock with voting rights (1.e., voting premium) (Gurun & Karakas, 2016).-- $205,300,000, the Indicated value with voting rights, and -15% is the Discount for Lack-of- Control (DLOC) expressed as a percentage, was multiplied together to equal $30,795,000, the Discount for Lack of Control (DLOC). 100 The Discount for Lack of Control decreased the amount of the transferred interest by 15% at the end of December 31, 2015 (Karlsen & -Scott: 2020). --Therefore, after $205,300,000, or $205,300, the Total-Indication of value-and-Indicated value of equity, and -15%, the Discount for Lack of Control (DLOC), were multiplied together to equal-$30,795,000, the-Discount for Lack of Control (DLOC) expressed as a dollar amount. $30,795,000 was subtracted (deducted) from $205,300,000 to equal $174,505.000.-or-$174,505, the value of the-Marketable, minority interest (F11, F14, F16, valuation-summary, ACC-345-7-1-Final-Project-Submission (Business Valuation Model (Verizon Communications Inc.)). --The monetary worth of the outstanding shares belonging to the minority-owners-decreased-by-$30.795,000-(F14, valuation-summary, ACC-345-7-1-Final-Project Submission (Business Valuation Model (Verizon Communications Inc.)). --As a result, the value of the Marketable minority interest was and/or is $174,505,000- (F16, valuation-summary, ACC-345-7-1-Final-Project-Submission (Business-Valuation-Model- (Verizon Communications Inc.)). --I-would-like to remind you, the reader, that the marketable: minority value is the monetary value (worth) of a minority interest in which the minority shareholders have the ability to buy and sell a security for cash quickly and with comparative ease in an active market and has no control over choosing or changing the managers, firm's board of-directors, and how much the managers are paid-(upcounsel.com, 2021, Mercer & Heinz, 2021).1 After $174.505,000, or $174,505, the Marketable, minority value and -25.0%, the Discount rate for Lack of Marketability represented as a percentage, were multiplied together to- equal $43,626,000, or S43,626, the Discount rate for-Lack-of-Marketability expressed as a dollar amount (F16, F17. valuation-summary, ACC 345-7-1-Final Project Submission (Business Valuation-Model (Verizon Communications Inc.)). - Once-$43,626,000, the-Discount rate for Lack-of-Marketability, expressed as a dollar amount. $43.626.000, -or-$43,626, was subtracted (deducted) from $174,505,000, the value of the Marketable, minority-interest, to equal $130,879,000, or $130,879, the Nonmarketable, minority value (F17, F19, valuation-summary ACC-345-7-1-Final Project Submission (Business Valuation-Model (Verizon-Communications- Inc.)). --The monetary worth of the outstanding shares belonging to the minority owners decreased-by-S43,626,000-((F17, valuation-summary, ACC-345-7-1-Final-Project Submission- (Business Valuation-Model (Verizon Communications Inc.)). Therefore, the value of the Nonmarketable, minority interest was and/or is $130.879,000 (F19, valuation-summary, ACC 345-7-1-Final Project Submission (Business Valuation-Model (Verizon Communications Inc.)). --I- would like to remind you, the reader, that the nonmarketable minority value is the monetary value-(worth) of a minority interest in which the minority shareholders has no control over choosing or changing the managers, firm's board of directors, and how much the managers are paid-and-lack the ability to buy and sell-a-security for cash with relative ease and speedily in an active market (upcounsel.com, 2021, Mercer & Heinz, 2021).--$1,309 is the-Value of a one- percent interest (in millions) (rosscompanycopa.com.-2012). --The fair market value of a-1- percent minority interest (in millions) in this firm (on-a-non-controlling, non-marketable basis)-as- of December 31, 2015 is $1,309, or $1,309,000, as shown on the worksheet called-Valuation Summary (F23, valuation-summary, ACC-345-7-1 Final-Project-Submission (Business Valuation Model (Verizon Communications Inc.)). 1 2 Company ABC Inc. 3 Discounted Cash Flow Method (in millions) 4 5 6 7 8 9 10 Projected for Years Ending December 31, Terminal Value 2018 2019 2020 2021 2022 $ 2,648 $ 2,714 $ 2,782 $ 2,852 5 2,924 16,682 16,720 16,744 17,100 17,100 19,311 (23.866 19,638 (17,188) 19,638 (14,982) 18,001 (12.649 18,001 (12,649) $ 14,775 $ 21,884 $ 24,182 $ 25,304 5 25,376 $ 11,551 5 15,127 $ 14,779 $ 13,673 11 Forecasted Net Income $ 2,584 12 Plus 13 Depreciation 17.403 14 Less: 15 Capital expenditures 18.121 16 Debt reduction (14,588) 17 18 Net Cash Flow $ 23,520 19 20 Present value of cash flows $ 20,796 21 22 Discount rate: 13.1% 23 24 25 Terminal period cash flows 26 Capitalization rate: 10.6% 27 28 Capitalized terminal cash flow 29 30 Net present value of terminal cash flow, discounted into perpetuity 31 s 25,376 10.6% s 239,396 129,400 31 32 s 75,900 129,400 33 Net present value - five years ending YE: 2022 34 Net present value of terminal cash flow 35 36 Total indication of value (rounded) $ 205,300 37 38 1 Company ABC Inc. 2 Final Computation of Value 3 As of December 31, 2018 4 5 Income Approach: Discounted Cash Flow Method 5 8 Indicated Value of Equity 9 Weight 205,300 100 % 10 $ 205,300 12 $ 205,300 (30,795) 14 15,0% SK N R S S G ; = - 11 Weighted Value (rounded) 13 Indicated value with voting rights Less DLOC (Discount for Lack of Control) 16 Marketable, minority value Less DLOM (Discount for Lack of Marketability) 19 Nonmarketable minority value 25.0% 174,505 (43,626) 17 18 $ 130,879 z3 Value of a one-percent interest (in millions) 1,309 24 income statement balance sheet ratios prospective analysis discount rate dcf valuation summary S205,300,000 is the-Net-Asset-Value of this business's real-estate and Total-Indication of value of this firm-and-Indicated-value of equity, or this company's stock:((F8, valuation summary, ACC-345-7-1 Final-Project-Submission (Business-Valuation Model (Verizon Communications Inc.)).- $205,300, or $205,300,000 is the Weighted value of equity, also called stockholders' equity, on the worksheet called Valuation Summary:((F11, valuation summary, ACC-345-7-1 Final Project Submission (Business Valuation-Model (Verizon Communications Inc.))--After the Indicated value of equity, or stockholders' equity, and the weight of 100% were multiplied together to equal-$20,530,000,000.--$20,530,000,000 was divided by 100 to equal S205,300.000, the Weighted value of equity. --Weight of indicated value of equity is 100%, it means company's capital structure is only equity-oriented and not having any debt. --For example, a company's enterprise value is $100,000-and-70%-weight of equity it means weighted value of equity is $70,000 ($100,000-x-0.70) -and-30% belongs to debt that is $30,000 ($100,000-x-0.30)... Weighted value is $205,300,000 because this is calculated by [(Step-1): $205,300,000-x-0.100= $20,530,000, (Step-2):= $20,530,000,000 =$205,300,000)]. --It simply means all value-belongs to equity-only-(F8, F9. F13, valuation summary, ACC-345-7-1 Final-Project Submission (Business Valuation Model (Verizon Communications Inc.)). --However, $205,300,000 is now-Indicated value with voting Tights. --$205,300,000, the Indicated value with voting rights, or this dollar amount represented the shareholders who owned and/or still own outstanding shares of this firm's common stock with voting rights (1.e., voting premium) (Gurun & Karakas, 2016).-- $205,300,000, the Indicated value with voting rights, and -15% is the Discount for Lack-of- Control (DLOC) expressed as a percentage, was multiplied together to equal $30,795,000, the Discount for Lack of Control (DLOC). 100 The Discount for Lack of Control decreased the amount of the transferred interest by 15% at the end of December 31, 2015 (Karlsen & -Scott: 2020). --Therefore, after $205,300,000, or $205,300, the Total-Indication of value-and-Indicated value of equity, and -15%, the Discount for Lack of Control (DLOC), were multiplied together to equal-$30,795,000, the-Discount for Lack of Control (DLOC) expressed as a dollar amount. $30,795,000 was subtracted (deducted) from $205,300,000 to equal $174,505.000.-or-$174,505, the value of the-Marketable, minority interest (F11, F14, F16, valuation-summary, ACC-345-7-1-Final-Project-Submission (Business Valuation Model (Verizon Communications Inc.)). --The monetary worth of the outstanding shares belonging to the minority-owners-decreased-by-$30.795,000-(F14, valuation-summary, ACC-345-7-1-Final-Project Submission (Business Valuation Model (Verizon Communications Inc.)). --As a result, the value of the Marketable minority interest was and/or is $174,505,000- (F16, valuation-summary, ACC-345-7-1-Final-Project-Submission (Business-Valuation-Model- (Verizon Communications Inc.)). --I-would-like to remind you, the reader, that the marketable: minority value is the monetary value (worth) of a minority interest in which the minority shareholders have the ability to buy and sell a security for cash quickly and with comparative ease in an active market and has no control over choosing or changing the managers, firm's board of-directors, and how much the managers are paid-(upcounsel.com, 2021, Mercer & Heinz, 2021).1 After $174.505,000, or $174,505, the Marketable, minority value and -25.0%, the Discount rate for Lack of Marketability represented as a percentage, were multiplied together to- equal $43,626,000, or S43,626, the Discount rate for-Lack-of-Marketability expressed as a dollar amount (F16, F17. valuation-summary, ACC 345-7-1-Final Project Submission (Business Valuation-Model (Verizon Communications Inc.)). - Once-$43,626,000, the-Discount rate for Lack-of-Marketability, expressed as a dollar amount. $43.626.000, -or-$43,626, was subtracted (deducted) from $174,505,000, the value of the Marketable, minority-interest, to equal $130,879,000, or $130,879, the Nonmarketable, minority value (F17, F19, valuation-summary ACC-345-7-1-Final Project Submission (Business Valuation-Model (Verizon-Communications- Inc.)). --The monetary worth of the outstanding shares belonging to the minority owners decreased-by-S43,626,000-((F17, valuation-summary, ACC-345-7-1-Final-Project Submission- (Business Valuation-Model (Verizon Communications Inc.)). Therefore, the value of the Nonmarketable, minority interest was and/or is $130.879,000 (F19, valuation-summary, ACC 345-7-1-Final Project Submission (Business Valuation-Model (Verizon Communications Inc.)). --I- would like to remind you, the reader, that the nonmarketable minority value is the monetary value-(worth) of a minority interest in which the minority shareholders has no control over choosing or changing the managers, firm's board of directors, and how much the managers are paid-and-lack the ability to buy and sell-a-security for cash with relative ease and speedily in an active market (upcounsel.com, 2021, Mercer & Heinz, 2021).--$1,309 is the-Value of a one- percent interest (in millions) (rosscompanycopa.com.-2012). --The fair market value of a-1- percent minority interest (in millions) in this firm (on-a-non-controlling, non-marketable basis)-as- of December 31, 2015 is $1,309, or $1,309,000, as shown on the worksheet called-Valuation Summary (F23, valuation-summary, ACC-345-7-1 Final-Project-Submission (Business Valuation Model (Verizon Communications Inc.))

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

Step: 3

blur-text-image

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

The Practice Of Modern Internal Auditing

Authors: Lawrence B Sawyer

1st Edition

B0006C58OA, 978-0894130120

More Books

Students also viewed these Accounting questions