Question: Construct a new version of Table 4.7, assuming that competition drives down profitability (on existing assets as well as new investment) to 11.5% in year

Construct a new version of Table 4.7, 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?

TABLE 4.7

9 10 10.00 1120 12.54 1405 15.31 16.69 18.19 19.29 20.44 21.67 20 134 151 169 84 2.00 218 2.31 245 2.60 1.20 1.34 51 126 1.38 150 1.09 1.16 1.23 1.30 0.00 0.00 0.00 0.42 0.46 009 .16 1.23 10 1.20 12.54 14.05 15.31 16.69 18.19 19.29 20.44 21.67 22.97 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 012 0.12 0.12 0.12 0.12 0.09 0.09 0.09 006 0.06 0.06 0.06 0.12 0.12 0.12 0.09 0.09 0.09 0.06 0.06 0.06 7 Asset value, start of year Earnings Investment Free cash flow (FCF) Asset value, end of year Return on assets (ROA) Asset growth rate Earnings growth rate, from previous year

Step by Step Solution

★★★★★

3.39 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Given data Input variables Provide all the values sh... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

1084-B-C-F-P-V(708).xlsx

300 KBs Excel File

Students Have Also Explored These Related Corporate Finance Questions!

Construct a new version of Table, 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...

Construct a new version of Table 4.7, assuming that the concatenator division grows at 20%, 12%, and 6%, instead of 12%, 9%, and 6%. You will get negative early free cash flows. a. Recalculate the PV...

Suppose that one day, Gilligan (the castaway) eats a magical island plant that turns him into an expert at everything. In particular, it now takes him just half an hour to pick a quart of berries,...

27. Valuing a business (S4.6) Construct a new version of Table 4.8, assuming that competition drives down profitability (on existing assets as well as new investment) to 11.5% in year 6, 11% in year...

Construct a new version of Table 4.8, 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...

How would I find the PV in millions? Construct a new version of Table 4.8, assuming that competition drives down profitability (on existing assets as well as new investment) to 11.5% in year 6, 11%...

Construct a new version of Table 4 . 8 , assuming that competition drives down profitability ( on existing assets as well as new investment ) to 1 1 . 5 % in year 6 , 1 1 % in year 7 , 1 0 . 5 % in...

7. Valuing a business (S4.6) Construct a new version of Table 4.8 , assuming that competition drives down profitability (on existing assets as well as new investment) to 11.5% in year 6,11% in year...

Construct a new version of Table 4.7, assuming that competition drives down profitability (on existing assets as well as new investment) to ll.5% in year 6, ll% in year 7, 10.5% in year 8, and 8% in...

26. Construct a new version of Table 4.8 , 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...

A plane has the equation z = 18x-2y + 26. value of 2 making the vector A7+7+0.5% normal to the plane. (b) Find a value of a so that the point (a+1, a, a-1) lies on the plane. am Click if you would...

Let X, Y have joint density fX, Y(x, y) = x + y, for 0 x,y 1, and fx, y (x, y) = 0 otherwise. Find the joint CDF, i.e., Fx, y (x, y) = P(X x, Y y).

Identify qualification requirements for qualified plans.

Interpret the solutions to common LP problems

A gold-mining firm is concerned about short-term volatility in its revenues. Gold currently sells for $1,600 an ounce, but the price is extremely volatile and could fall as low as $1,520 or rise as...

"Northern Refineries does not avoid risk by selling oil futures. If prices stay above $3.20 a gallon, then it will actually have lost by selling oil futures at that price." Is this a fair comment?

Residents of the northeastern United States suffered record-setting low temperatures throughout November and December 2021. Spot prices of heating oil rose 25%, to over $7 a gallon. a. What effect...

Stat 1400 - Statistical Concepts for BusinessUnit 6 Normal Distributions Lab 6b Professors!Professors!Professors! 1.Suppose that you are deciding whether to take Professor Fisher's class or Professor...

Your cousin just got an offer from a start up, she will receive LE 2000 per month and the other part of her compensation is in the form of a stock grant of 500 shares of the companys stock....

Problem 4. Suppose X1, X2, ..... ,Xn ~ Poisson()\\). Given that the random variables are i.i.d, for 6 = exp()\\), 1. Find an unbiased estimator of 0? (Note that it may not be the best estimator. Any...