Ritchie Bros. Auctioneers Incorporated (RBA) DCF Valuation

Ritchie Bros. Auctioneers Incorporated (RBA) 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

Ritchie Bros. Auctioneers Incorporated (RBA) 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:

Streamline your analysis and improve precision with our RBA (Ritchie Bros. Auctioneers Incorporated) DCF Calculator! Equipped with real-time data and customizable assumptions, this tool empowers you to forecast, analyze, and value RBA 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 1,318.6 1,377.3 1,417.0 1,733.8 3,679.6 4,872.6 6,452.4 8,544.4 11,314.7 14,983.2
Revenue Growth, % 0 4.45 2.88 22.36 112.23 32.42 32.42 32.42 32.42 32.42
EBITDA 322.1 358.6 339.9 557.4 975.9 1,297.4 1,718.0 2,275.0 3,012.6 3,989.4
EBITDA, % 24.43 26.04 23.99 32.15 26.52 26.63 26.63 26.63 26.63 26.63
Depreciation 84.7 91.8 99.8 111.9 470.6 383.7 508.1 672.9 891.0 1,179.9
Depreciation, % 6.42 6.66 7.05 6.45 12.79 7.88 7.88 7.88 7.88 7.88
EBIT 237.4 266.9 240.1 445.5 505.3 913.6 1,209.9 1,602.1 2,121.6 2,809.4
EBIT, % 18.01 19.38 16.94 25.69 13.73 18.75 18.75 18.75 18.75 18.75
Total Cash 359.7 278.8 326.1 494.3 576.2 1,117.8 1,480.2 1,960.1 2,595.6 3,437.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 144.2 136.3 118.9 140.5 737.7
Account Receivables, % 10.94 9.9 8.39 8.1 20.05
Inventories 65.0 86.3 102.5 103.1 166.5 281.6 372.9 493.7 653.8 865.8
Inventories, % 4.93 6.26 7.23 5.94 4.52 5.78 5.78 5.78 5.78 5.78
Accounts Payable 72.9 289.8 378.5 503.3 638.1 971.1 1,286.0 1,703.0 2,255.1 2,986.3
Accounts Payable, % 5.53 21.04 26.71 29.03 17.34 19.93 19.93 19.93 19.93 19.93
Capital Expenditure -41.0 -43.1 -43.5 -71.9 -346.2 -222.9 -295.1 -390.8 -517.5 -685.3
Capital Expenditure, % -3.11 -3.13 -3.07 -4.15 -9.41 -4.57 -4.57 -4.57 -4.57 -4.57
Tax Rate, % 26.88 26.88 26.88 26.88 26.88 26.88 26.88 26.88 26.88 26.88
EBITAT 185.5 192.4 139.4 350.8 369.5 658.1 871.5 1,154.0 1,528.2 2,023.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 93.0 444.4 285.8 493.3 -32.0 1,215.5 1,126.8 1,492.1 1,975.9 2,616.5
WACC, % 7.59 7.52 7.37 7.59 7.53 7.52 7.52 7.52 7.52 7.52
PV UFCF
SUM PV UFCF 6,604.8
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 2,669
Terminal Value 48,342
Present Terminal Value 33,640
Enterprise Value 40,245
Net Debt 4,026
Equity Value 36,219
Diluted Shares Outstanding, MM 168
Equity Value Per Share 215.33

What You Will Get

  • Pre-Filled Financial Model: Ritchie Bros. Auctioneers' actual data allows for accurate DCF valuation.
  • Full Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
  • Instant Calculations: Automatic updates guarantee you see results in real-time as you make adjustments.
  • Investor-Ready Template: A polished Excel file crafted for professional-level valuation.
  • Customizable and Reusable: Designed for versatility, enabling repeated use for comprehensive forecasts.

Key Features

  • 🔍 Real-Life RBA Financials: Pre-filled historical and projected data for Ritchie Bros. Auctioneers Incorporated (RBA).
  • ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Built-in formulas calculate RBA’s intrinsic value using the Discounted Cash Flow method.
  • ⚡ Instant Results: Visualize RBA’s valuation instantly after making changes.
  • Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.

How It Works

  • Download: Get the pre-built Excel file containing Ritchie Bros. Auctioneers Incorporated's (RBA) financial data.
  • Customize: Modify projections, such as auction revenue growth, EBITDA margin, and discount rates.
  • Update Automatically: The intrinsic value and NPV metrics refresh in real-time as you make changes.
  • Test Scenarios: Develop various forecasts and evaluate results side by side effortlessly.
  • Make Decisions: Leverage the valuation insights to inform your investment approach.

Why Choose This Calculator for Ritchie Bros. Auctioneers (RBA)?

  • User-Friendly Interface: Tailored for both novices and seasoned professionals.
  • Customizable Inputs: Adjust parameters easily to suit your evaluation needs.
  • Real-Time Valuation: Monitor immediate updates to RBA’s valuation as you change inputs.
  • Preloaded Data: Comes equipped with RBA’s historical financial information for swift assessments.
  • Relied Upon by Experts: Favored by analysts and investors for making well-informed choices.

Who Should Use This Product?

  • Investors: Assess Ritchie Bros. Auctioneers’ (RBA) market position before making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation methodologies and evaluate financial forecasts.
  • Business Owners: Understand how auction companies like Ritchie Bros. are appraised.
  • Consultants: Provide comprehensive valuation analyses for your clients’ needs.
  • Students and Educators: Utilize practical examples to learn and teach valuation strategies.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Ritchie Bros. Auctioneers (RBA) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for Ritchie Bros. Auctioneers (RBA).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.