McGrath RentCorp (MGRC) DCF Valuation

McGrath RentCorp (MGRC) 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

McGrath RentCorp (MGRC) 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 evaluate the intrinsic value of McGrath RentCorp? Our (MGRC) DCF Calculator integrates real-world data with extensive customization features, allowing you to adjust 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 570.2 572.6 616.8 733.8 831.8 916.0 1,008.7 1,110.7 1,223.1 1,346.8
Revenue Growth, % 0 0.40755 7.73 18.97 13.36 10.12 10.12 10.12 10.12 10.12
EBITDA 230.8 235.4 239.1 276.9 299.4 355.6 391.5 431.1 474.8 522.8
EBITDA, % 40.48 41.11 38.77 37.74 35.99 38.82 38.82 38.82 38.82 38.82
Depreciation 89.5 94.6 106.7 111.3 109.4 142.6 157.0 172.9 190.4 209.7
Depreciation, % 15.69 16.53 17.3 15.17 13.15 15.57 15.57 15.57 15.57 15.57
EBIT 141.4 140.8 132.4 165.6 190.0 213.0 234.5 258.2 284.4 313.1
EBIT, % 24.79 24.58 21.47 22.56 22.84 23.25 23.25 23.25 23.25 23.25
Total Cash 2.3 1.2 1.5 1.0 .9 2.0 2.2 2.5 2.7 3.0
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 128.1 123.3 159.5 169.9 227.4
Account Receivables, % 22.46 21.54 25.86 23.16 27.33
Inventories .0 .0 .0 -59.8 .0 -14.9 -16.4 -18.1 -19.9 -22.0
Inventories, % 0.000000351 0.000000175 0.000000162 -8.15 0 -1.63 -1.63 -1.63 -1.63 -1.63
Accounts Payable 99.2 100.0 125.3 139.6 152.8 169.6 186.8 205.7 226.5 249.4
Accounts Payable, % 17.4 17.47 20.32 19.02 18.36 18.52 18.52 18.52 18.52 18.52
Capital Expenditure -179.8 -100.1 -116.8 -205.3 -273.7 -236.0 -259.9 -286.2 -315.1 -347.0
Capital Expenditure, % -31.53 -17.47 -18.94 -27.98 -32.9 -25.76 -25.76 -25.76 -25.76 -25.76
Tax Rate, % -16.83 -16.83 -16.83 -16.83 -16.83 -16.83 -16.83 -16.83 -16.83 -16.83
EBITAT 106.0 108.7 97.6 127.1 222.0 171.5 188.8 207.9 229.0 252.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -13.2 108.9 76.5 96.8 -46.4 116.8 82.4 90.7 99.9 110.0
WACC, % 7.04 7.07 7.03 7.06 7.33 7.11 7.11 7.11 7.11 7.11
PV UFCF
SUM PV UFCF 408.6
Long Term Growth Rate, % 3.50
Free cash flow (T + 1) 114
Terminal Value 3,156
Present Terminal Value 2,239
Enterprise Value 2,647
Net Debt 762
Equity Value 1,885
Diluted Shares Outstanding, MM 25
Equity Value Per Share 76.86

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real MGRC financials.
  • Real-World Data: Historical performance data and forward-looking estimates (highlighted in the yellow cells).
  • Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Instantly visualize the effect of your inputs on McGrath RentCorp’s valuation.
  • Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.

Key Features

  • Comprehensive Financial Data: McGrath RentCorp’s historical financial statements and pre-filled projections.
  • Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Real-Time Insights: Monitor McGrath RentCorp’s intrinsic value recalculating instantly.
  • Intuitive Visual Representations: Dashboard graphs illustrate valuation outcomes and essential metrics.
  • Designed for Precision: A reliable tool for analysts, investors, and finance professionals.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review McGrath RentCorp’s pre-filled financial data and forecasts.
  3. Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Watch the DCF model update instantly as you tweak assumptions.
  5. Step 5: Analyze the outputs and use the results for investment decisions.

Why Choose McGrath RentCorp (MGRC)?

  • Streamlined Process: Quickly access rental solutions without lengthy setups.
  • Enhanced Reliability: Dependable equipment and services minimize downtime and maximize efficiency.
  • Customizable Options: Flexible rental plans to suit your specific project needs.
  • User-Friendly Experience: Intuitive interface and support make it easy to find what you need.
  • Industry Leader: Trusted by businesses for quality and exceptional customer service.

Who Should Use This Product?

  • Professional Investors: Create comprehensive and dependable valuation models for analyzing McGrath RentCorp (MGRC).
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
  • Consultants and Advisors: Deliver precise valuation insights to clients regarding McGrath RentCorp (MGRC).
  • Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
  • Industry Analysts: Gain a deeper understanding of how rental service companies like McGrath RentCorp (MGRC) are valued in the market.

What the Template Contains

  • Comprehensive DCF Model: Editable template featuring thorough valuation calculations.
  • Real-World Data: McGrath RentCorp’s historical and projected financials preloaded for in-depth 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 to present clear, actionable results.

No products were found matching.