Republic Services, Inc. (RSG) DCF Valuation

Republic Services, Inc. (RSG) 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

Republic Services, Inc. (RSG) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Looking to assess the intrinsic value of Republic Services, Inc.? Our (RSG) DCF Calculator integrates real-world data with comprehensive customization features, enabling you to refine your forecasts and enhance your investment choices.


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 10,299.4 10,153.6 11,295.0 13,511.3 14,964.5 16,468.5 18,123.8 19,945.3 21,950.0 24,156.2
Revenue Growth, % 0 -1.42 11.24 19.62 10.76 10.05 10.05 10.05 10.05 10.05
EBITDA 2,909.1 3,000.1 3,384.8 3,659.5 4,320.5 4,733.6 5,209.4 5,732.9 6,309.1 6,943.3
EBITDA, % 28.25 29.55 29.97 27.08 28.87 28.74 28.74 28.74 28.74 28.74
Depreciation 1,122.4 1,158.8 1,268.2 1,441.2 1,599.3 1,808.0 1,989.7 2,189.7 2,409.8 2,652.0
Depreciation, % 10.9 11.41 11.23 10.67 10.69 10.98 10.98 10.98 10.98 10.98
EBIT 1,786.7 1,841.3 2,116.6 2,218.3 2,721.2 2,925.6 3,219.6 3,543.2 3,899.4 4,291.3
EBIT, % 17.35 18.13 18.74 16.42 18.18 17.76 17.76 17.76 17.76 17.76
Total Cash 47.1 38.2 29.0 143.4 140.0 101.7 111.9 123.1 135.5 149.1
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 1,125.9 1,091.3 1,271.4 1,677.2 1,993.3
Account Receivables, % 10.93 10.75 11.26 12.41 13.32
Inventories 56.8 59.1 72.2 96.6 97.3 103.4 113.7 125.2 137.8 151.6
Inventories, % 0.55149 0.58206 0.63922 0.71496 0.65021 0.62759 0.62759 0.62759 0.62759 0.62759
Accounts Payable 777.9 779.0 910.0 1,221.8 1,411.5 1,375.3 1,513.6 1,665.7 1,833.1 2,017.4
Accounts Payable, % 7.55 7.67 8.06 9.04 9.43 8.35 8.35 8.35 8.35 8.35
Capital Expenditure -1,207.1 -1,194.6 -1,316.3 -1,454.0 -1,631.1 -1,870.8 -2,058.9 -2,265.8 -2,493.5 -2,744.2
Capital Expenditure, % -11.72 -11.77 -11.65 -10.76 -10.9 -11.36 -11.36 -11.36 -11.36 -11.36
Tax Rate, % 21.01 21.01 21.01 21.01 21.01 21.01 21.01 21.01 21.01 21.01
EBITAT 1,479.9 1,558.5 1,734.0 1,801.8 2,149.4 2,396.7 2,637.6 2,902.7 3,194.4 3,515.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 990.4 1,556.1 1,623.7 1,670.6 1,990.5 2,352.5 2,502.0 2,753.5 3,030.3 3,334.8
WACC, % 7.09 7.11 7.09 7.08 7.06 7.09 7.09 7.09 7.09 7.09
PV UFCF
SUM PV UFCF 11,293.2
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 3,435
Terminal Value 84,044
Present Terminal Value 59,680
Enterprise Value 70,973
Net Debt 12,929
Equity Value 58,044
Diluted Shares Outstanding, MM 317
Equity Value Per Share 183.30

What You Will Receive

  • Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real RSG financials.
  • Authentic Data: Historical performance metrics and forward-looking projections (highlighted in the yellow cells).
  • Flexible Forecasting: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
  • Instant Calculations: Quickly observe how your inputs affect Republic Services, Inc.'s valuation.
  • Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Interface: Organized for clarity and ease of navigation, complete with step-by-step guidance.

Key Features

  • Comprehensive RSG Data: Pre-loaded with Republic Services’ historical performance metrics and future projections.
  • Customizable Assumptions: Modify revenue growth rates, profit margins, discount rates, tax assumptions, and capital investment plans.
  • Interactive Valuation Tool: Instantly refreshes Net Present Value (NPV) and intrinsic value calculations based on your customized inputs.
  • Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
  • Intuitive User Interface: Designed for ease of use, catering to both seasoned professionals and newcomers.

How It Works

  • Step 1: Download the prebuilt Excel template with Republic Services, Inc.'s (RSG) data included.
  • Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
  • Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Instantly view recalculated results, including Republic Services, Inc.'s (RSG) intrinsic value.
  • Step 5: Make informed investment decisions or generate reports using the outputs.

Why Choose This Calculator for Republic Services, Inc. (RSG)?

  • All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for Republic Services.
  • Flexible Inputs: Modify the highlighted cells to explore different financial scenarios.
  • In-Depth Analysis: Automatically computes the intrinsic value and Net Present Value for Republic Services.
  • Preloaded Information: Includes historical and projected data for accurate analysis.
  • High-Quality Standards: Perfect for financial analysts, investors, and business advisors focusing on Republic Services.

Who Should Use This Product?

  • Investors: Evaluate Republic Services, Inc. (RSG)'s market position before making investment decisions.
  • CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
  • Startup Founders: Understand the valuation strategies of established companies like Republic Services, Inc. (RSG).
  • Consultants: Provide detailed valuation analyses and reports for client engagements.
  • Students and Educators: Utilize current data to learn and teach valuation principles effectively.

What the Template Contains

  • Comprehensive DCF Model: Editable template featuring thorough valuation calculations.
  • Real-World Data: Republic Services, Inc.'s (RSG) historical and projected financials preloaded for analysis.
  • Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
  • Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
  • Dashboard with Visual Outputs: Charts and tables presenting clear, actionable results.

No products were found matching.