Enter a company's financials and your bear, normal and bull assumptions. The model values each case, then weights them by the probabilities you set.
Automatic lookup is coming soon. It will pull the latest statements, share price, diluted shares, beta and the 10-year Treasury yield, then fill in the manual sheet for you to adjust. For now, enter the numbers by hand.
Dollar amounts in millions. Use the latest fiscal year from the 10-K.
Growth and margin move in a straight line from year 1 to the final forecast year.
| Bear | Normal | Bull |
|---|
FCFF = EBIT × (1 − tax) + D&A − capex − increase in working capital. $ millions.
Value per share as WACC and terminal growth shift. The outlined cell is the normal case.