Inputs

Main Street Plumbing

Camp Hill, PA, 17011

[238220] Plumbing, Heating, and Air-Conditioning Contractors

Contact: Peter Jones

Phone: (717) 526-4935

Email: [email protected]

SWOT-XPRESS


P1: Financial-Value-Market Insights
P2: Strengths-Opportunities/Weaknesses-Challenges
P3: SWOT Scoring
P4: Glossary
P5: SWOT Scoring Explained
P6: Sources

SWOT XPRESS OVERALL SCORE: 3.1/5

Developed By

FOUNDATION FINANCIAL ADVISORS

Thomas Smart

Account Executive

561-856-4587

[email protected]

Industry Financial Insights - 2020q2

PEER GROUP OWNER EARNINGS (%)

16.85%

FIRM OWNER EARNINGS (%)

13.11%

Financial Metrics: Sales Class: $1m - $2.49m

(Peer industry and sales class average % basis)

Key PL&BS Benchmarks Industry Firm
Gross Margin 43.91% 42.00%
Officer/Owner's Compensation 7.95% 9.59%
Depreciation 1.60% 0.32%
Operating Expenses 36.48% 31.98%
Pre-Tax Net Profit 7.30% 3.20%
Owner Earnings 16.85% 13.11%
Accounts Receivable: Total Assets 29.08% 19.35%
Accounts Payable: TL & NW 13.92% 16.12%
Net Worth:Total Assets 51.28% 45.14%

Industry Standard Benchmarks Industry Firm
Current Ratio 2.04 1.92
Sales per Employee $212,090 $173,706
Efficiency Index 3.36 4.96
Days Payable 25.36 30.19
Days Receivable 29.72 21.01
Current Liabilities: NW 0.61 0.90
Long Term Liabilities: NW 0.34 0.31
Total Liabilities: NW 0.95 1.22
Modified Z‐Score 6.97 7.01
Accounts Payable: Revenue 3.90 4.80

Annual Firm Sales

Firm Sales

$1,563,352

Firm Sales Rank

54 of 151




Business Value Insights
Sept 2020

ASSET SALES VALUE: EARNINGS APPROACH

$327,324 - $331,952


Bizminer Vestimate®-Plus Value basis derived from input company sales and owner earnings; peer group earnings %; and industry valuation multiples.

Market Analysis Insights
Sept 2020

Plumbing, Heating, and Air-Conditioning Contractors
[238220]

Total Industry Sales

$339,442,812

Industry Market Overview
10.0 Mile Radius from 2601 Market Street, 17011
Industry Operations 151
Annual Market Sales Volume $339,442,812
Average Site Sales $2,247,966
Average Small Business Sales $1,126,054
Median Sales $852,336

Market Penetration
Market Sales per Person $890
US Sales per Person $798
Sales per Person Opportunity Index 0.90
Market Sales per Household $2,015
US Sales per Household $1,891
Sales per Household Opportunity Index 0.94
Location Quotient 0.08

Market Area Population and Income
Population 36,306
Households 13,586
Per Capita Income $35,022
Median HH Income $74,375

COVID IMPACT

Bizminer reports now adjust our raw data to better reflect the most recent changes in local and national industry markets. We accomplish this by integrating additional Census Bureau data with our proprietary content, allowing us to accelerate and refine month-to-month trends. Our content displays the new data in three ways:

These enhanced protocols will be most obvious in our Industry Market Trend series, including a new “Monthly Change” tab in each report. Similarly, snapshot reports like the SWOT-XPRESS, Competitive Market Narrative and Company Insight series will reflect our new update protocols and add content for Preliminary Update and Advance months.

Shorter projections are more detailed and accurate than longer-term projections. Preliminary Update data is calculated on a more accurate and detailed basis than the Advance Projection month, which will adjust as it moves to “update month” status the following month. Interpret and utilize this content accordingly.

Month-to-Month Employment-Sales
Dec-19 Sept-20 Oct-20 Advance
Employment 1,631 1,606 1,609
Monthly Industry Market Volume 28,331,258 28,236,101 28,289,877
Average Monthly Site Sales 177,070 186,994 187,350
% Change from Dec-19
Sept-20 Oct-20 Advance
Employment -1.53% -1.34%
Monthly Industry Market Volume -0.34% -0.15%
Average Monthly Site Sales 5.60% 5.81%
Monthly Change Index (Dec-19=1.00)


Strengths & Weaknesses


Profitability:

Variance from Owner Earnings: Performance at the average owner earnings level would add $58,425 onto your profit line.

Sales:

Variance from Average Sales: Sales below the industry average leaves $89,753 in owner earnings on the table.

Variance from Small Business Sales: Sales above the small business industry market net $57,330 in additional owner earnings

Variance from Median Sales: Sales above the industry market median accrue $93,214 in additional owner earnings

Sales Rank and Percentile: Your 54/151 sales rank and placement in percentile 64th puts your firm in the top end of the industry market

Efficiency:

Improve Sales per Employee metric to the industry market average by increasing efficiencies or adding product value and accrue $5,033 more owner earnings per employee.

Your firm's Efficiency Index indicates that the operation gets a 1.48x return over the industry productivity average.

Your firm's Days Receivable is 8.71 points below the industry average, indicating above average collection efficiency.

Opportunities and Threats


Market Opportunity and Saturation:

The Sales per person index in this industry market is 0.90, suggesting the possibility of service saturation or an export surplus of $3,340,152 sales

The Sales per household index in this industry market is 0.94, suggesting the possibility of service saturation or an export surplus of $1,684,664 sales

Industry employment is less concentrated in this market than US levels by a factor of 0.08x, suggesting a potentially under-served population and market opportunities

Cash Flow:

Your firm's current ratio is 0.12 points below the industry peer group average, indicating a relatively weak ability to cover short term liabilities.

Your Days Payable is 4.83 points higher than the industry peer group average, suggesting an inability or unwillingness to pay short term debt on a timely basis.

Debt:

Your firm's Current Liabilities:Net Worth ratio is 0.29 points above the industry peer group average, suggesting short term debts that may be difficult to cover in extreme situations.

Your firm's Long-Term Liabilities:Net Worth ratio is 0.03 points below the industry peer group average, suggesting that the current long term debt level is within bounds.

Your firm's Total Liabilities:Net Worth ratio is 0.27 points above the industry peer group average, indicating an over-reliance on debt and possible risk to operations.

Risk:

Your firm's Modified Z-Score is 0.04 points above the industry peer group average, indicating higher stability and lower-than-average susceptibility to bankruptcy conditions.

SWOT XPRESS SCORE: 3.1/5



SALES‐PROFITABILITY‐MARKET OPPORTUNITY:


Owner Earnings (%) 1
Sales Rank 5
Variance:
from Average Sales 1
from Small Business Sales 5
Sales per Household Market Opportunity Index 3
Location Quotient 5

OPERATING INDICATORS:


Sales per Employee Index 2
Efficiency Index 5
Days Receivable 5
Current Ratio 3
Current Liabilities:Net Worth 1
Long Term Liabilities: Net Worth 3
Total Liabilities:Net Worth 1
Days Payable 3
Modified Z‐Score 3

Industry Financial Insight Terms

Industry peer group percentage averages are applied to the company's estimated revenue.

Gross Margin: Business Revenue minus Cost of Sales
Officer/Owner's Compensation:
Total wage compensation for services of company officers
Depreciation: Current portion of non-cash depreciation-amortization-depletion
Operating Expenses: Discretionary Expenses (excludes Cost of Sales and Interest Paid)
Pre-Tax Net Profit: Net Profit before payment of income taxes
Owner Earnings: Officers Compensation+Net Profit+Depreciation
Net Worth/Assets: Net Worth as a percent of Total Assets
Sales per Employee: An efficiency or value-added indicator: Sales/FTE employees
Efficiency Index:
A more sophisticated efficiency indicator: Sales per Employee/Average Annual Wage
Accounts Receivable: Total Assets: Short-term receivables as a percent of Total Assets
Accounts Payable:Total Liabilities & Net Worth:
Short-term receivables as a percent of Total Liabilities+Net Worth
Days Payable: 365/(Cost of Sales/Accounts Payable ratio)
Days Receivable: 365/(Business Revenue/Receivables)
Current Ratio: Current Assets/Current Liabilities
Current Liabilities: Net Worth: Current Liabilities/Net Worth
Total Liabilities: Net Worth: Total liabilities/Net Worth
Modified Z-Score: A modified form of the Altman Z-Score which evaluates default risk
Accounts Payable:Revenue: Accounts Payable/Business Revenue
Loans-Notes Payable:Net Worth: Loans-Notes Payable/Net Worth

Business Value Insight Terms

Bizminer Vestimate® Value basis derived from input company sales and owner earnings; peer group average earnings %; and industry valuation multiples.

Owner Earnings (Cash Flow) Approach: Revenue/Owner Earnings market valuation approach
Sales Approach: Revenue/Annual Sales market value approach
Median and Quartiles: Median: the point at which 50% of a sample is above and 50% of the same below the value. Quartile 1 lies at the mid-point between the median and the lowest value; Quartile 3 between the median and the highest value.

MARKET INSIGHTS TERMS


Market Area: The selected market parameters for this industry.
Competitors: The number of same-industry operations within the market area.
Industry Market Sales Volume: Aggregate industry market sales
Average Site Sales: Average annual revenue of industry market operations in the market area.
Average Small Business Sales: Average annual sales of single site firms with <25 employees in the market
Firm Sales Rank: Sales rank based on this location's estimated revenue among all same industry market operations
US and Market Sales per Person and Household: Sales per person and sales per household using the US as a comparison basis for the local market or, if a national market, displaying that value.
Opportunity Index: A calculated index for both Sales per Person and Sales per Household indicating the level of market saturation where balance between Market and US levels where equilibrium=1.00. A higher index indicates more opportunity.
Projected Service Gap/Saturation-Plus: Projected dollar value of the Sales per Person/Household variance between the market area and the US average.
Location Quotient: Indicator of market saturation by employment; compares industry employment to total market employment at the local and national levels where equilibrium=1.00. A lower index indicates may indicate additional market opportunity.
Per Capita Income: Average area income per person
Median Household Income: Median (mid-point) area income per household

SWOT-XPRESS SCORING EXPLAINED






In most cases, the variance for each metric measures the percentage difference between input firm ratios and the industry average. The Sales per Household Market Opportunity Index and Location Quotient compare local and national market data to determine the variance between the two.

Each variance results in a Score of 1-5 (5 being best) for each year of each selected ratio. The application of the Variances to the Score depends on the specific metric; in most cases higher is better (Standard Scoring); in some, lower (Reverse Scoring) is better; in a few, closest to the industry average (Balanced Scoring) is best.

Approach to Scored SWOT Metrics:

  • Owner Earnings (%)-Standard
  • Sales Rank -Standard
  • Variance from Average Sales-Standard
  • Variance from Small Business Sales-Standard
  • Sales per Household Market Opportunity Index-Standard
  • Location Quotient-Reverse
  • Sales per Employee Index-Standard
  • Efficiency Index-Standard
  • Days Receivable-Reverse
  • Current Ratio-Standard
  • Current Liabilities:Net Worth-Reverse
  • Long Term Liabilities: Net Worth-Reverse
  • Total Liabilities:Net Worth-Reverse
  • Days Payable-Balanced
  • Modified Z‐Score-Standard

Scoring Calculations:

Standard (basically higher is better)

  • +/-10% from average= 3
  • +11% to +20% above average= 4
  • >20% above average= 5
  • +11% to +20% below average= 2
  • >20% below average= 1

Reverse (lower is better)

  • +/-10% from average= 3
  • +11% to +20% above average= 2
  • >20% above average= 1
  • +11% to +20% below average= 4
  • >20% below average= 5

Balanced (middle is good, too high or too low is not)

  • +/-10% from average= 5
  • 11% to 15% above or below average= 4
  • +16% to +25% above or below average= 3
  • 25%-30% above or below average= 2
  • 30% above or below average= 1

Data Sources and Limitations

BizMiner data is widely accepted for industry analytical work, benchmarking, valuations, forensics and litigation. Raw data analyzed for BizMiner reports is sourced from an array of the nation's government and private statistical sources. None of these raw data sources creates the final measures reflected in BizMiner industry profiles. In total, BizMiner accesses over a billion sourced data points from 15 million business operations for each of its twice annual updates covering a 3-5 year time series. Historical data and BizMiner algorithms are used to inform and test projections for non-reporting firms. Data elements are sourced specifically from:

No representation is made as to the accuracy of the databases utilized or the results of subsequent analyses. Neither the Bizminer® nor its resellers have undertaken independent primary research to confirm the accuracy of the data utilized in the Profile analyses. Neither the Bizminer® nor its resellers are responsible for conclusions drawn or decisions made based upon this data or analysis. In no event will Bizminer® or its resellers be liable for any damages, direct, indirect, incidental or consequential resulting from the use of the information contained in Bizminer® reports.

The Vestimate®is an informational tool, not a guide to action. Do not use the report in place of a certified valuation, or as the basis of any specific business-related or other financial transaction. For that we recommend obtaining an appraisal from a business broker, a valuation from a certified valuation professional, or both. You should not attempt to use Vestimate®-Pro to secure a business or personal loan. Be aware that the Vestimate® may not consider market or firm idiosyncrasies that can influence the actual value or selling price.