SmartRent, Inc. (SMRT) 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
SmartRent, Inc. (SMRT) Bundle
Looking to assess SmartRent, Inc.'s intrinsic value? Our SMRT DCF Calculator integrates real-world data with comprehensive customization options, enabling you to refine your forecasts and enhance your investment strategies.
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 | 36.2 | 52.5 | 110.6 | 167.8 | 236.8 | 377.6 | 602.2 | 960.1 | 1,531.0 | 2,441.1 |
Revenue Growth, % | 0 | 44.99 | 110.6 | 51.69 | 41.13 | 59.45 | 59.45 | 59.45 | 59.45 | 59.45 |
EBITDA | -24.4 | -35.6 | -71.1 | -96.0 | -37.6 | -205.8 | -328.2 | -523.3 | -834.5 | -1,330.6 |
EBITDA, % | -67.27 | -67.85 | -64.29 | -57.23 | -15.89 | -54.51 | -54.51 | -54.51 | -54.51 | -54.51 |
Depreciation | .1 | .8 | 1.1 | 5.7 | 5.5 | 6.3 | 10.0 | 15.9 | 25.4 | 40.5 |
Depreciation, % | 0.16284 | 1.44 | 0.97978 | 3.38 | 2.34 | 1.66 | 1.66 | 1.66 | 1.66 | 1.66 |
EBIT | -24.4 | -36.4 | -72.2 | -101.7 | -43.2 | -212.1 | -338.2 | -539.3 | -859.9 | -1,371.1 |
EBIT, % | -67.44 | -69.29 | -65.27 | -60.61 | -18.22 | -56.17 | -56.17 | -56.17 | -56.17 | -56.17 |
Total Cash | 21.4 | 38.6 | 430.8 | 210.4 | 215.2 | 319.9 | 510.0 | 813.3 | 1,296.8 | 2,067.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 6.8 | 20.8 | 45.5 | 62.4 | 61.9 | 123.1 | 196.2 | 312.9 | 498.9 | 795.4 |
Account Receivables, % | 18.89 | 39.57 | 41.11 | 37.21 | 26.14 | 32.58 | 32.58 | 32.58 | 32.58 | 32.58 |
Inventories | 6.3 | 17.6 | 33.2 | 75.7 | 41.6 | 108.5 | 172.9 | 275.7 | 439.7 | 701.1 |
Inventories, % | 17.35 | 33.56 | 30.02 | 45.12 | 17.55 | 28.72 | 28.72 | 28.72 | 28.72 | 28.72 |
Accounts Payable | 1.7 | 2.3 | 6.1 | 18.4 | 15.1 | 24.0 | 38.3 | 61.1 | 97.4 | 155.4 |
Accounts Payable, % | 4.63 | 4.33 | 5.56 | 10.94 | 6.37 | 6.36 | 6.36 | 6.36 | 6.36 | 6.36 |
Capital Expenditure | -.8 | -.3 | -1.5 | -1.1 | -3.8 | -4.7 | -7.6 | -12.1 | -19.2 | -30.7 |
Capital Expenditure, % | -2.13 | -0.56725 | -1.33 | -0.66321 | -1.59 | -1.26 | -1.26 | -1.26 | -1.26 | -1.26 |
Tax Rate, % | 0.31128 | 0.31128 | 0.31128 | 0.31128 | 0.31128 | 0.31128 | 0.31128 | 0.31128 | 0.31128 | 0.31128 |
EBITAT | -27.0 | -36.5 | -72.3 | -96.3 | -43.0 | -209.7 | -334.4 | -533.2 | -850.2 | -1,355.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -39.2 | -60.8 | -109.1 | -139.0 | -9.9 | -327.3 | -455.3 | -726.0 | -1,157.7 | -1,845.9 |
WACC, % | 13.69 | 13.69 | 13.69 | 13.69 | 13.69 | 13.69 | 13.69 | 13.69 | 13.69 | 13.69 |
PV UFCF | ||||||||||
SUM PV UFCF | -2,798.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -1,883 | |||||||||
Terminal Value | -16,103 | |||||||||
Present Terminal Value | -8,477 | |||||||||
Enterprise Value | -11,276 | |||||||||
Net Debt | -215 | |||||||||
Equity Value | -11,061 | |||||||||
Diluted Shares Outstanding, MM | 201 | |||||||||
Equity Value Per Share | -55.11 |
What You Will Get
- Real SmartRent Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for SmartRent, Inc. (SMRT).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specifically for SmartRent.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on SmartRent’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for SmartRent, Inc. (SMRT).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for SmartRent.
Key Features
- Comprehensive SmartRent Data: Gain access to accurate historical performance metrics and future forecasts.
- Tailored Projection Parameters: Modify highlighted cells for key variables such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to effectively visualize your valuation outcomes.
- Designed for All Users: An intuitive layout suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review SmartRent, Inc.'s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions.
Why Choose This Calculator for SmartRent, Inc. (SMRT)?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your specific analysis needs.
- Real-Time Valuation: Watch SmartRent's valuation update instantly as you change inputs.
- Preloaded Data: Comes equipped with SmartRent's actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use SmartRent, Inc. (SMRT)?
- Property Managers: Streamline operations and enhance tenant experiences with our innovative smart home solutions.
- Real Estate Investors: Maximize property value and appeal by integrating cutting-edge technology into your investments.
- Developers: Easily incorporate smart home features into new projects to attract modern renters.
- Tech Enthusiasts: Explore the latest advancements in home automation and smart living with our comprehensive platform.
- Educators and Students: Utilize our tools to gain insights into the intersection of technology and real estate management.
What the Template Contains
- Pre-Filled Data: Includes SmartRent, Inc.’s historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze SmartRent, Inc.’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.