Usio, Inc. (USIO) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Usio, Inc. (USIO) Bundle
Explore Usio, Inc.'s (USIO) financial outlook with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and costs to calculate Usio, Inc.'s (USIO) intrinsic value and refine your investment strategy.
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 | 28.2 | 32.3 | 61.9 | 69.4 | 82.6 | 111.0 | 149.1 | 200.4 | 269.2 | 361.7 |
Revenue Growth, % | 0 | 14.37 | 92.06 | 12.09 | 18.96 | 34.37 | 34.37 | 34.37 | 34.37 | 34.37 |
EBITDA | -3.0 | -2.2 | 2.5 | -2.5 | 1.9 | -3.3 | -4.5 | -6.0 | -8.0 | -10.8 |
EBITDA, % | -10.78 | -6.94 | 4.03 | -3.55 | 2.31 | -2.99 | -2.99 | -2.99 | -2.99 | -2.99 |
Depreciation | 2.0 | 1.5 | 2.6 | 2.7 | 2.1 | 5.0 | 6.7 | 9.1 | 12.2 | 16.4 |
Depreciation, % | 7.17 | 4.71 | 4.27 | 3.94 | 2.52 | 4.52 | 4.52 | 4.52 | 4.52 | 4.52 |
EBIT | -5.1 | -3.8 | -.1 | -5.2 | -.2 | -8.3 | -11.2 | -15.0 | -20.2 | -27.2 |
EBIT, % | -17.95 | -11.65 | -0.23806 | -7.49 | -0.21477 | -7.51 | -7.51 | -7.51 | -7.51 | -7.51 |
Total Cash | 2.1 | 5.0 | 7.3 | 5.7 | 7.2 | 11.5 | 15.4 | 20.7 | 27.8 | 37.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1.3 | 2.9 | 5.0 | 4.4 | 5.6 | 7.7 | 10.3 | 13.8 | 18.6 | 24.9 |
Account Receivables, % | 4.52 | 8.88 | 8.04 | 6.3 | 6.74 | 6.89 | 6.89 | 6.89 | 6.89 | 6.89 |
Inventories | 10.7 | .2 | .4 | .5 | .4 | 9.0 | 12.1 | 16.2 | 21.8 | 29.3 |
Inventories, % | 38.05 | 0.54715 | 0.70151 | 0.73076 | 0.51193 | 8.11 | 8.11 | 8.11 | 8.11 | 8.11 |
Accounts Payable | .4 | .9 | 1.4 | .9 | 1.0 | 2.0 | 2.6 | 3.6 | 4.8 | 6.4 |
Accounts Payable, % | 1.49 | 2.64 | 2.26 | 1.24 | 1.25 | 1.77 | 1.77 | 1.77 | 1.77 | 1.77 |
Capital Expenditure | -.6 | -.9 | -1.3 | -.8 | -.8 | -2.0 | -2.7 | -3.7 | -4.9 | -6.6 |
Capital Expenditure, % | -2.3 | -2.65 | -2.06 | -1.17 | -1.01 | -1.84 | -1.84 | -1.84 | -1.84 | -1.84 |
Tax Rate, % | -160.22 | -160.22 | -160.22 | -160.22 | -160.22 | -160.22 | -160.22 | -160.22 | -160.22 | -160.22 |
EBITAT | -5.2 | -3.8 | -.3 | -5.5 | -.5 | -8.3 | -11.2 | -15.0 | -20.2 | -27.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -15.4 | 6.3 | -.8 | -3.6 | -.2 | -15.1 | -12.2 | -16.4 | -22.1 | -29.7 |
WACC, % | 11.65 | 11.65 | 11.65 | 11.65 | 11.65 | 11.65 | 11.65 | 11.65 | 11.65 | 11.65 |
PV UFCF | ||||||||||
SUM PV UFCF | -66.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -30 | |||||||||
Terminal Value | -314 | |||||||||
Present Terminal Value | -181 | |||||||||
Enterprise Value | -247 | |||||||||
Net Debt | -4 | |||||||||
Equity Value | -244 | |||||||||
Diluted Shares Outstanding, MM | 20 | |||||||||
Equity Value Per Share | -12.11 |
What You Will Get
- Comprehensive USIO Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Instant calculations of intrinsic value and NPV.
- Scenario Analysis: Evaluate various scenarios to forecast Usio, Inc.'s future performance.
- User-Friendly Interface: Designed for industry professionals while remaining beginner-friendly.
Key Features
- 🔍 Real-Life USIO Financials: Pre-filled historical and projected data for Usio, Inc. (USIO).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Usio’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Usio’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based USIO DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Usio’s intrinsic value.
- Test Scenarios: Simulate various assumptions to assess potential valuation fluctuations.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Usio, Inc. (USIO)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: Usio’s historical and projected financials preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use Usio, Inc. (USIO)?
- Investors: Gain insights into payment processing solutions to make informed investment choices.
- Financial Analysts: Utilize comprehensive data to streamline analysis of Usio's financial performance.
- Consultants: Customize reports and presentations based on Usio's innovative offerings for client needs.
- Finance Enthusiasts: Explore the evolving landscape of fintech and payment solutions through Usio's practices.
- Educators and Students: Leverage Usio's case studies for hands-on learning in finance and technology courses.
What the Template Contains
- Pre-Filled DCF Model: Usio, Inc.'s (USIO) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Usio, Inc.'s (USIO) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.