Consider the table given below to answer the following question.YearAsset valueEarningsNet investmentFree cash flowReturn on equityAsset growth rateEarnings growth rate19.001.441.440.000.160.16Present value210.441.671.670.000.160.160.16million34512.11 14.05 15.871.942.542.251.941.832.060.000.420.480.160.160.160.160.130.130.160.160.136717.94 20.272.782.330.450.1550.130.093.042.031.010.150.100.098922.30 24.533.232.942.232.451.000.490.1450.120.100.100.06 -0.09Assuming that competition drives down profitability (on existing assets as well as new investment) to 15.5% in year 6, 15% inyear 7, 14.5% in year 8, and 12% in year 9 and all later years. What is the value of the concatenator business? Assume 13% costof capital.Note: Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.1026.983.242.700.540.120.100.10

Present value refers to the method of capital budgeting used for evaluating the viability of the…

Answered: Consider the table given below to…

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter7: Corporate Valuation And Stock Valuation

Section: Chapter Questions

Problem 25SP: Start with the partial model in the file Ch07 P25 Build a Model.xlsx on the textbook’s Web site....

See similar textbooks

Similar questions

Consider the table given below to answer the following question. Asset value Earnings Year Net investment Free cash flow Return on equity Asset growth rate Earnings growth rate Present value 1 12.00 1.44 1.44 0.00 0.12 0.12 2 13.44 1.61 1.61 0.00 0.12 0.12 0.12 million 3 15.05 1.81 1.81 0.00 0.12 0.12 0.12 4 16.86 2.02 1.52 0.51 0.12 0.09 0.12 5 18.38 2.21 1.65 0.55 0.12 0.09 0.09 6 20.03 2.30 1.80 0.50 0.115 0.09 0.04 7 21.83 2.40 1.31 1.09 0.11 0.06 0.04 8 23.14 2.43 1.39 1.04 0.105 0.06 0.01 9 24.53 1.96 1.47 0.49 0.08 0.06 -0.19 Assuming that competition drives down profitability (on existing assets as well as new investment) to 11.5% in year 6, 11% in year 7, 10.5% in year 8, and 8% in year 9 and all later years. What is the value of the concatenator business? Assume 10% cost of capital. Note: Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places. 10 26.00 2.08 1.56 0.52 0.08 0.06 0.06
Consider the table given below to answer the following question. Asset value Earnings Net investment Free cash flow (FCF) Return on equity (ROE) Asset growth rate Earnings growth rate Present value 1 2 3 4 5 6 7 8 9.00 10.17 11.49 12.99 14.28 15.71 17.28 18.49 1.17 1.32 1.49 1.69 1.86 1.96 2.07 2.13 1.17 1.32 1.49 1.30 1.43 1.57 1.21 1.29 0.39 0.43 0.39 0.86 0.83 0.13 0.13 0.13 0.125 0.12 0.115 0.13 0.10 0.10 0.10 0.07 0.07 0.13 0.13 0.10 0.06 0.06 0.03 0.13 0.13 0.13 0.13 0.13 Year Assuming that competition drives down profitability (on existing assets as well as new investment) to 12.5% in year 6, 12% in year 7, 11.5% in year 8, and 9% in year 9 and all later years. What is the value of the concatenator business? Assume 12% cost of capital. (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.) million
The file Fortune500 contains data for profits and market capitalizations from a recent sample of firms in the Fortune 500 a. Prepare a scatter diagram to show the relationship between the variables Market Capitalization and Profit in which Market Capitalization is on the vertical axis and Profit is on the horizontal axis. Comment on any relationship between the variables. b. Create a trendline for the relationship between Market Capitalization and Profit. What does the trendline indicate about this relationship?
The analysis of Returned on Invested Capital is as follows: 2015: 3.77% 2016: 1.46% 2017: 2.90% 2018: 2.94% 2019: 2.24% a. What is the trend analysis for that Returned on Invested Capital and why it is increasing and decreasing?
Consider the table given below to answer the following question. Year 1 2 3 4 7 9. 10 Asset value 13.00 14.56 16.31 18.26 19.91 21.70 23.65 25.07 26.58 28.17 Earnings 1.56 1.75 1.96 2.19 2.39 2.50 2.60 2.63 2.13 2.25 Net investment 1.56 1.75 1.96 1.64 1.79 1.95 1.42 1.50 1.59 1.69 Free cash flow (FCF) 0.55 0.60 0.54 1.18 1.13 0.53 0.56 Return on equity (ROE) 0.12 0.12 0.12 0.12 0.12 0.115 0.11 0.105 0.08 0.08 Asset growth rate Earnings growth rate 0.12 0.12 0.12 0.09 0.09 0.09 0.06 0.06 0.06 0.06 0.12 0.12 0.12 0.09 0.04 0.04 0.01 -0.19 0.06 Assuming that competition drives down profitability (on existing assets as well as new investment) to 11.5% in year 6, 11% in year 7, 10.5% in year 8, and 8% in year 9 and all later years. What is the value of the concatenator business? Assume 11% cost of capital. (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.) X Answer is complete but not entirely correct. Present value 2$ 19.72 X million 6.
Please use the attached images as well... Compute the following: 4. For fiscal 2020: Free Cash Flow to Equity 5. Market Capitalization, Market to Book Value and the Price-Earnings Ratio as of year-end 2020 Stock Prices in 2018 = $68.98 2019 = $84.15 2020 = $107.82
Intro You've collected the following historical rates of return for stocks A and B: Year (t) FA,t FB,t 2016 0.02 0.01 2015 0.08 0.05 2014 0.17 0.07
Year U.S. Gov’t T-Bills U.K. Common Stocks 2015 0.063 0.150 2016 0.081 0.043 2017 0.076 0.374 2018 0.090 0.192 2019 0.085 0.106 a. Compute the geometric mean rate of return for each of these investments and compare the arithmetic mean return and geometric mean return for each investment and discuss the difference between mean returns as related to the standard deviation of each series.
Use the extended DuPont equation to provide a breakdown of Computrons projected return on equity. How does the projection compare with the previous years and with the industrys DuPont equation?
assuming the following ratios are constant, what is the growth rate? Total asset turnover 1.7 Profit margin0.072 Total assets/Equity = 2.15 Payout ratio0.42
Assume that the following ratios are constant. Total asset turnover 1.37, profit margin 6.9%, equity multiplier 1.7, payout ratio 57%. What is the sustainable growth rate?
Using the data in the table:, a. What was the average annual return of Microsoft stock from 2005-2017? b. What was the annual volatility for Microsoft stock from 2005-2017? a. What was the average annual return of Microsoft stock from 2005-2017? The average annual return is %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Realized Return for the S&P 500, Microsoft, and Treasury Bills, 2005-2017 S&P 500 Realized Return Microsoft Realized Return Dividends Paid* Year End 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 S&P 500 Index 1211.92 1248.29 3.00% 4.80% 1418.30 1468.36 903.25 4.70% 1.50% 0.10% 0.10% 1115.10 1257.64 1257.61 0.00% 1426.19 0.10% 1848.36 0.00% 0.00% 2058.90 2043.94 0.00% 0.20% 2238.83 2673.61 0.80% *Total dividends paid by the 500 stocks in the portfolio, based on the number of shares of each stock in the index, adjusted until the end of the year, assuming they were…

SEE MORE QUESTIONS

Recommended textbooks for you

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials of Business Analytics (MindTap Course …

Statistics

ISBN:

9781305627734

Author:

Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:

Cengage Learning

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials of Business Analytics (MindTap Course …

Statistics

ISBN:

9781305627734

Author:

Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS