Synlogic, Inc. (SYBX) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Synlogic, Inc. (SYBX) Bundle
Save time and improve precision with our [SYBX] DCF Calculator! Packed with real data from Synlogic, Inc. and customizable assumptions, this tool enables you to forecast, analyze, and value Synlogic, Inc. like a seasoned investor.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 2.2 | .5 | 1.8 | 1.2 | 3.4 | 4.1 | 5.1 | 6.3 | 7.7 | 9.5 |
Revenue Growth, % | 0 | -75.49 | 221.83 | -32.73 | 185.68 | 22.95 | 22.95 | 22.95 | 22.95 | 22.95 |
EBITDA | -47.3 | -57.8 | -58.1 | -63.6 | -55.2 | -4.1 | -5.1 | -6.3 | -7.7 | -9.5 |
EBITDA, % | -2125.9 | -10611.01 | -3313.34 | -5391.95 | -1636.34 | -100 | -100 | -100 | -100 | -100 |
Depreciation | 2.7 | 2.6 | 2.4 | 3.8 | 2.0 | 3.8 | 4.7 | 5.7 | 7.1 | 8.7 |
Depreciation, % | 121.49 | 483.67 | 139.28 | 321.53 | 58.08 | 91.62 | 91.62 | 91.62 | 91.62 | 91.62 |
EBIT | -50.0 | -60.5 | -60.6 | -67.4 | -57.1 | -4.1 | -5.1 | -6.3 | -7.7 | -9.5 |
EBIT, % | -2247.39 | -11094.68 | -3452.62 | -5713.47 | -1694.42 | -100 | -100 | -100 | -100 | -100 |
Total Cash | 127.1 | 100.4 | 136.6 | 77.6 | 47.7 | 4.1 | 5.1 | 6.3 | 7.7 | 9.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Accounts Payable | 2.2 | 2.0 | 1.9 | 1.8 | 1.5 | 3.7 | 4.5 | 5.5 | 6.8 | 8.3 |
Accounts Payable, % | 97.35 | 366.06 | 110.83 | 151.27 | 43.22 | 88.11 | 88.11 | 88.11 | 88.11 | 88.11 |
Capital Expenditure | -1.3 | -.4 | -.7 | -.7 | -.2 | -2.0 | -2.4 | -3.0 | -3.6 | -4.5 |
Capital Expenditure, % | -56.25 | -72.48 | -38.71 | -61.69 | -6.35 | -47.1 | -47.1 | -47.1 | -47.1 | -47.1 |
Tax Rate, % | -0.02444646 | -0.02444646 | -0.02444646 | -0.02444646 | -0.02444646 | -0.02444646 | -0.02444646 | -0.02444646 | -0.02444646 | -0.02444646 |
EBITAT | -47.4 | -57.8 | -58.1 | -66.1 | -57.1 | -4.0 | -4.9 | -6.1 | -7.5 | -9.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -43.7 | -55.7 | -56.4 | -63.2 | -55.7 | .0 | -1.8 | -2.2 | -2.8 | -3.4 |
WACC, % | 5.64 | 5.67 | 5.68 | 5.74 | 5.8 | 5.71 | 5.71 | 5.71 | 5.71 | 5.71 |
PV UFCF | ||||||||||
SUM PV UFCF | -8.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -3 | |||||||||
Terminal Value | -94 | |||||||||
Present Terminal Value | -71 | |||||||||
Enterprise Value | -79 | |||||||||
Net Debt | -7 | |||||||||
Equity Value | -73 | |||||||||
Diluted Shares Outstanding, MM | 7 | |||||||||
Equity Value Per Share | -11.15 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real SYBX financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the highlighted cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Synlogic’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive Data: Synlogic’s historical financial reports and pre-populated projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Instantly view Synlogic’s intrinsic value calculations as they update.
- Intuitive Visualizations: Dashboard graphs showcase valuation outcomes and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Synlogic, Inc. (SYBX) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Synlogic, Inc. (SYBX)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Synlogic's Calculator?
- Accuracy: Utilizes real Synlogic (SYBX) financial data for precise calculations.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexities of creating a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and precision expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for assessing Synlogic, Inc. (SYBX) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions for Synlogic, Inc. (SYBX).
- Consultants and Advisors: Equip clients with precise valuation insights regarding Synlogic, Inc. (SYBX) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling with Synlogic, Inc. (SYBX).
- Biotech Enthusiasts: Gain insights into how biotech firms like Synlogic, Inc. (SYBX) are valued in the financial market.
What the Template Contains
- Preloaded SYBX Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.