In: Finance
You are valuing Soda City Inc. It has $104 million of debt, $89 million of cash, and 154 million shares outstanding. You estimate its cost of capital is 12.6%. You forecast that it will generate revenues of $703 million and $797 million over the next two years. Projected operating profit margin is 21%, tax rate is 29%, reinvestment rate is 23%, and terminal exit value multiple at the end of year 2 is 15. What is your estimate of its share price? Round to one decimal place. [Hint: Compute projected FCFF for years 1 and 2 based on info provided, compute terminal value using the exit multiple method, discount it all to find EV, walk the bridge to Equity, divide by number of shares outstanding.]
Please see the table below. Please be guided by the second column titled “Linkage” to understand the mathematics. The last row highlighted in yellow is your answer. Figures in parenthesis, if any, mean negative values. All financials are in $ million except share price which is in $.
Year, n | Linkage | 1 | 2 |
Revenue | A | 703.00 | 797.00 |
Projected operating profit margin | B | 21% | 21% |
EBIT | C = A x B | 147.63 | 167.37 |
Tax rate | D | 29% | 29% |
Reinvestment rate | E | 23% | 23% |
FCF | F = C x (1 - D) x (1 - E) | 80.71 | 91.50 |
Terminal exit value multiple | G | 15.00 | |
Exit value | H = F of year 2 x G | 1,372.52 | |
Discount rate | I | 12.60% | |
Discount factor | J = (1 + I)^(-n) | 0.8881 | 0.7887 |
PV of FCF | K = F x J | 71.68 | 72.17 |
PV of exit value | L = H x J | 1,082.53 | |
Value of the firm | M = Sum of all K + L | 1,226.38 | |
[-] Debt | N | 104 | |
[+] Cash | O | 89 | |
Value of the equity | P = M - N + O | 1,211.38 | |
Number of shares | Q | 154 | |
Estimated share price (in $) | P / Q | 7.87 |