146k views
3 votes
Please show step by step. Thank you.

Answer:21,389,813

Sparklett's Spangles sells shiny spoons made of gold. Segal's hedge fund is making an offer and the board of directors have asked for your help. The firm has $2,279,230 in preferred equity and the market value of its outstanding debt equals $3,135,336. The WACC for this firm is estimated to be 9.90%. Management's forecast of FCFs is shown below; year 1 represents one year from today and so on. The company expects to grow at a 3.0% rate after Year 5. In today's dollars, What is the terminal value of this company? Round your answer to the nearest penny and enter it in the box below.

Period Free Cash Flow
Year 1 $1,031,172
Year 2 $1,220,925
Year 3 $2,172,519
Year 4 $2,141,142
Year 5 $2,297,245
Answer:21,389,813

How:

Calculate the terminal value by

a. multiplying year 5 cash flow by 1+growth rate to get the next year's value

b. divide the next year's value by (cost of capital - growth rate) Note: use the decimal of the interest rates.

c. bring the value to the present by calculating the PV. In Excel =pv(rate,years,0,-FV) where the rate is the cost of capital, years is 5, 0 payment, and the FV is the negative of the value calculated in b.

1 Answer

5 votes

Answer:

To calculate the terminal value of the company, we will follow the steps provided:

Step a: Multiply the Year 5 cash flow by 1 plus the growth rate. Year 5 cash flow = $2,297,245 Growth rate = 3.0%

Terminal Value (Year 6) = Year 5 cash flow * (1 + Growth rate) Terminal Value = $2,297,245 * (1 + 0.03) Terminal Value = $2,297,245 * 1.03 Terminal Value = $2,364,781.35

Step b: Divide the Terminal Value by (Cost of capital - Growth rate). Cost of capital = WACC = 9.90% Growth rate = 3.0%

Terminal Value / (Cost of capital - Growth rate) = $2,364,781.35 / (0.0990 - 0.0300) Terminal Value / (Cost of capital - Growth rate) = $2,364,781.35 / 0.0690 Terminal Value / (Cost of capital - Growth rate) = $34,290,607.61

Step c: Calculate the present value (PV) of the terminal value. PV = -FV / (1 + rate)^years

PV = -$34,290,607.61 / (1 + 0.0990)^5 PV = -$34,290,607.61 / (1.0990)^5 PV = -$34,290,607.61 / 1.547105751 PV = -$22,176,194.19

Rounding the PV to the nearest penny, we get -$22,176,194.19.

Therefore, the terminal value of the company, in today's dollars, is $21,389,813.

User Toshi
by
7.9k points