Primoris Services Corporation (PRIM) DCF Valuation

Primoris Services Corporation (PRIM) 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

Primoris Services Corporation (PRIM) 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:

Gain insight into your Primoris Services Corporation (PRIM) valuation analysis with our cutting-edge DCF Calculator! Preloaded with actual (PRIM) data, this Excel template enables you to adjust forecasts and assumptions to accurately determine Primoris Services Corporation's intrinsic value.


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 3,106.3 3,491.5 3,497.6 4,420.6 5,715.3 6,690.5 7,832.1 9,168.5 10,732.9 12,564.2
Revenue Growth, % 0 12.4 0.17571 26.39 29.29 17.06 17.06 17.06 17.06 17.06
EBITDA 218.8 242.2 276.8 301.7 357.5 468.0 547.9 641.3 750.8 878.9
EBITDA, % 7.04 6.94 7.91 6.83 6.26 7 7 7 7 7
Depreciation 85.4 82.5 105.6 99.2 107.0 163.9 191.8 224.6 262.9 307.7
Depreciation, % 2.75 2.36 3.02 2.24 1.87 2.45 2.45 2.45 2.45 2.45
EBIT 133.4 159.7 171.2 202.6 250.5 304.1 356.0 416.8 487.9 571.2
EBIT, % 4.29 4.57 4.89 4.58 4.38 4.55 4.55 4.55 4.55 4.55
Total Cash 120.3 326.7 200.5 248.7 217.8 380.0 444.9 520.8 609.6 713.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 404.9 432.5 471.7 1,257.8 1,531.6
Account Receivables, % 13.04 12.39 13.49 28.45 26.8
Inventories -344.8 -325.8 -423.7 21.6 .0 -429.0 -502.2 -587.8 -688.1 -805.6
Inventories, % -11.1 -9.33 -12.11 0.48781 0 -6.41 -6.41 -6.41 -6.41 -6.41
Accounts Payable 236.0 245.9 273.5 535.0 629.0 609.7 713.7 835.5 978.1 1,145.0
Accounts Payable, % 7.6 7.04 7.82 12.1 11 9.11 9.11 9.11 9.11 9.11
Capital Expenditure -94.5 -64.4 -133.8 -94.7 -103.0 -169.4 -198.2 -232.1 -271.7 -318.0
Capital Expenditure, % -3.04 -1.84 -3.83 -2.14 -1.8 -2.53 -2.53 -2.53 -2.53 -2.53
Tax Rate, % 29 29 29 29 29 29 29 29 29 29
EBITAT 93.1 115.1 130.5 169.2 177.9 226.7 265.3 310.6 363.6 425.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 259.9 96.7 188.4 -796.2 23.6 902.6 221.2 258.9 303.1 354.8
WACC, % 8.2 8.23 8.29 8.39 8.22 8.26 8.26 8.26 8.26 8.26
PV UFCF
SUM PV UFCF 1,685.5
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 365
Terminal Value 6,941
Present Terminal Value 4,667
Enterprise Value 6,352
Net Debt 1,100
Equity Value 5,252
Diluted Shares Outstanding, MM 54
Equity Value Per Share 96.85

What You Will Receive

  • Comprehensive Financial Model: Utilizing Primoris Services Corporation’s actual data for accurate DCF valuation.
  • Complete Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
  • Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
  • Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
  • Flexible and Reusable: Designed for adaptability, allowing for repeated use in detailed forecasting.

Key Features

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

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Primoris Services Corporation (PRIM) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Primoris Services Corporation (PRIM)’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for Primoris Services Corporation (PRIM)?

  • Accuracy: Utilizes real Primoris financial data to ensure precise calculations.
  • Flexibility: Tailored for users to easily adjust and experiment with inputs.
  • Time-Saving: Eliminate the need to construct 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 extensive financial modeling skills.

Who Should Use This Product?

  • Professional Investors: Develop comprehensive and accurate valuation models for assessing portfolios related to Primoris Services Corporation (PRIM).
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
  • Consultants and Advisors: Deliver precise valuation insights to clients focused on investing in Primoris Services Corporation (PRIM).
  • Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling related to the industry.
  • Industry Enthusiasts: Gain insights into how service companies like Primoris Services Corporation (PRIM) are valued in the marketplace.

What the Template Contains

  • Historical Data: Includes Primoris Services Corporation’s past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Primoris Services Corporation’s intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of Primoris Services Corporation’s financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.