| ← Back to Cover |
|
|
|
|
|
|
|
| |
ERROR CHECK & MODEL INTEGRITY |
|
|
|
|
|
|
|
| |
Automated checks for model consistency and accuracy |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
Overall Model Status |
ALL CHECKS PASSED |
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
Check |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
Description |
|
| |
Balance Sheet Balances |
PASS |
PASS |
PASS |
PASS |
PASS |
Total Assets = Total Liabilities + Equity |
|
| |
Revenue is Positive |
PASS |
PASS |
PASS |
PASS |
PASS |
Projected revenue should be positive |
|
| |
EBITDA Margin 5%-50% |
PASS |
PASS |
PASS |
PASS |
PASS |
EBITDA margin should be within reasonable range |
|
| |
WACC 3%-25% |
PASS |
|
|
|
|
WACC should be within
reasonable range |
| |
Terminal Growth < WACC |
PASS |
|
|
|
|
Gordon Growth model requires g < WACC |
|
| |
Cash Balance Positive |
PASS |
PASS |
PASS |
PASS |
PASS |
Ending cash should not be negative |
|
| |
Free Cash Flow Positive |
PASS |
PASS |
PASS |
PASS |
PASS |
Unlevered FCF should be positive for DCF |
|
| |
TV as % of EV < 85% |
PASS |
|
|
|
|
Terminal value should
not dominate EV excessively |
| |
Net Debt / EBITDA < 5.0x |
PASS |
|
|
|
|
Leverage should be reasonable |
|
| |
Implied Share Price > $0 |
PASS |
|
|
|
|
DCF should produce
positive equity value |
| |
PP&E (Net) Positive |
PASS |
PASS |
PASS |
PASS |
PASS |
Net PP&E should remain positive |
|
| |
|
|
|
|
|
|
|
|
| |
Key Model Outputs Summary |
|
|
|
|
|
|
|
| |
Enterprise Value ($mm) |
3,348 |
|
|
|
|
|
|
| |
Equity Value ($mm) |
2,968 |
|
|
|
|
|
|
| |
Implied Share Price ($) |
$29.68 |
|
|
|
|
|
|
| |
Upside / (Downside) |
34.9% |
|
|
|
|
|
|
| |
WACC |
10.56% |
|
|
|
|
|
|
| |
Terminal Growth Rate |
2.5% |
|
|
|
|
|
|
| |
TV as % of Enterprise Value |
71.8% |
|
|
|
|
|
|
| |
Year 5 EBITDA Margin |
26.0% |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
Note: All checks are
automated and update dynamically. FAIL indicates a value outside expected
range. |
|
|
|
|
|
|
|
|
|
|
|
|
|