FirstService Corporation (FSV) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
FirstService Corporation (FSV) Bundle
Explore the financial prospects of FirstService Corporation (FSV) with our user-friendly DCF Calculator! Simply enter your assumptions for growth, margins, and costs to calculate the intrinsic value of FirstService Corporation (FSV) 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 | 2,407.4 | 2,772.4 | 3,249.1 | 3,745.8 | 4,334.5 | 5,021.1 | 5,816.5 | 6,737.8 | 7,805.1 | 9,041.5 |
| Revenue Growth, % | 0 | 15.16 | 17.19 | 15.29 | 15.72 | 15.84 | 15.84 | 15.84 | 15.84 | 15.84 |
| EBITDA | .0 | 272.1 | 312.6 | 333.7 | 394.3 | 376.0 | 435.6 | 504.6 | 584.5 | 677.1 |
| EBITDA, % | 0 | 9.81 | 9.62 | 8.91 | 9.1 | 7.49 | 7.49 | 7.49 | 7.49 | 7.49 |
| Depreciation | 2,634.1 | 2,736.0 | 3,008.7 | 3,382.7 | 127.9 | 3,861.7 | 4,473.4 | 5,182.0 | 6,002.8 | 6,953.7 |
| Depreciation, % | 109.42 | 98.69 | 92.6 | 90.31 | 2.95 | 76.91 | 76.91 | 76.91 | 76.91 | 76.91 |
| EBIT | -2,634.1 | -2,463.9 | -2,696.1 | -3,049.0 | 266.4 | -3,485.7 | -4,037.9 | -4,677.5 | -5,418.4 | -6,276.6 |
| EBIT, % | -109.42 | -88.87 | -82.98 | -81.4 | 6.15 | -69.42 | -69.42 | -69.42 | -69.42 | -69.42 |
| Total Cash | 121.2 | 184.3 | 165.7 | 136.2 | 187.6 | 248.5 | 287.9 | 333.5 | 386.3 | 447.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 393.7 | 418.9 | 551.6 | 635.9 | 842.2 | 852.1 | 987.0 | 1,143.4 | 1,324.5 | 1,534.3 |
| Account Receivables, % | 16.35 | 15.11 | 16.98 | 16.98 | 19.43 | 16.97 | 16.97 | 16.97 | 16.97 | 16.97 |
| Inventories | 94.5 | 142.0 | 161.4 | 242.3 | 246.2 | 262.7 | 304.4 | 352.6 | 408.4 | 473.1 |
| Inventories, % | 3.93 | 5.12 | 4.97 | 6.47 | 5.68 | 5.23 | 5.23 | 5.23 | 5.23 | 5.23 |
| Accounts Payable | 76.2 | 98.5 | 100.1 | 116.0 | 143.3 | 162.7 | 188.5 | 218.4 | 253.0 | 293.0 |
| Accounts Payable, % | 3.17 | 3.55 | 3.08 | 3.1 | 3.31 | 3.24 | 3.24 | 3.24 | 3.24 | 3.24 |
| Capital Expenditure | -46.6 | -39.4 | -58.2 | -77.6 | -92.7 | -94.0 | -108.9 | -126.1 | -146.1 | -169.3 |
| Capital Expenditure, % | -1.94 | -1.42 | -1.79 | -2.07 | -2.14 | -1.87 | -1.87 | -1.87 | -1.87 | -1.87 |
| Tax Rate, % | 50.63 | 50.63 | 50.63 | 50.63 | 50.63 | 50.63 | 50.63 | 50.63 | 50.63 | 50.63 |
| EBITAT | -2,990.8 | -1,478.1 | -1,744.2 | -1,903.1 | 131.5 | -2,345.7 | -2,717.2 | -3,147.6 | -3,646.2 | -4,223.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -815.3 | 1,168.1 | 1,055.9 | 1,252.6 | -16.1 | 1,415.0 | 1,496.5 | 1,733.5 | 2,008.1 | 2,326.2 |
| WACC, % | 8.25 | 7.99 | 8.02 | 8 | 7.92 | 8.03 | 8.03 | 8.03 | 8.03 | 8.03 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 7,021.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 2,373 | |||||||||
| Terminal Value | 39,326 | |||||||||
| Present Terminal Value | 26,723 | |||||||||
| Enterprise Value | 33,745 | |||||||||
| Net Debt | 1,229 | |||||||||
| Equity Value | 32,516 | |||||||||
| Diluted Shares Outstanding, MM | 45 | |||||||||
| Equity Value Per Share | 725.88 |
What You Will Get
- Real FSV Financials: Access to both historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are calculated in real-time.
- Scenario Analysis: Evaluate various scenarios to assess FirstService Corporation’s future performance.
- User-Friendly Interface: Designed for professionals while remaining accessible to newcomers.
Key Features
- Comprehensive Historical Data: FirstService Corporation's (FSV) past financial statements and pre-filled projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
- Real-Time Calculations: Instantly view the intrinsic value of FirstService Corporation (FSV) as it updates live.
- Intuitive Visualizations: Interactive dashboard charts illustrate valuation results and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- 1. Download the Template: Get the Excel file featuring FirstService Corporation's (FSV) preloaded financial data.
- 2. Adjust Key Inputs: Modify critical variables such as growth projections, discount rates, and capital investments.
- 3. Analyze Results in Real-Time: The DCF model automatically computes intrinsic value and net present value (NPV).
- 4. Explore Different Scenarios: Evaluate various forecasts to understand diverse valuation results.
- 5. Present with Assurance: Deliver expert valuation analysis to reinforce your strategic decisions.
Why Choose This Calculator for FirstService Corporation (FSV)?
- Accuracy: Utilizes real FirstService Corporation financials to ensure precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without advanced financial modeling skills.
Who Should Use This Product?
- Real Estate Investors: Develop comprehensive and accurate valuation models for property analysis.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Offer clients precise valuation insights for FirstService Corporation (FSV) shares.
- Students and Educators: Utilize real-world examples to practice and teach financial modeling techniques.
- Industry Analysts: Gain insights into how companies like FirstService Corporation (FSV) are assessed in the real estate market.
What the Template Contains
- Pre-Filled DCF Model: FirstService Corporation's (FSV) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate FirstService Corporation's (FSV) 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.