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.2/5

Developed By

FOUNDATION FINANCIAL ADVISORS

Thomas Smart

Account Executive

561-856-4587

[email protected]

Industry Financial Insights - 2019q2

PEER GROUP OWNER EARNINGS (%)

13.95%

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.54% 42.00%
Officer/Owner's Compensation 7.78% 9.59%
Depreciation 1.31% 0.32%
Operating Expenses 38.56% 31.98%
Pre-Tax Net Profit 4.86% 3.20%
Owner Earnings 13.95% 13.11%
Accounts Receivable: Total Assets 28.96% 19.35%
Accounts Payable: TL & NW 14.50% 16.12%
Net Worth:Total Assets 49.20% 45.14%

Industry Standard Benchmarks Industry Firm
Current Ratio 1.92 1.92
Sales per Employee $203,497 $173,706
Efficiency Index 3.43 4.96
Days Payable 23.13 30.19
Days Receivable 26.08 21.01
Current Liabilities: NW 0.67 0.90
Long Term Liabilities: NW 0.36 0.31
Total Liabilities: NW 1.03 1.22
Modified Z‐Score 6.19 7.01
Accounts Payable: Revenue 3.58 4.80

Annual Firm Sales

Firm Sales

$1,563,352

Firm Sales Rank

57 of 160




Business Value Insights
Dec 2019

Asset Sales Value Earnings Approach

$353,616


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

Market Analysis Insights
Dec 2019

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

Total Industry Sales

$341,095,923

Industry Market Overview - 10.0 Mile Radius from 2601 Market Street, 17011
Industry Operations 160
Annual Market Sales Volume $341,095,923
Average Site Sales $2,131,850
Average Small Business Sales $1,079,710
Median Sales $836,532

Market Penetration
Market Sales per Person $894
US Sales per Person $789
Sales per Person Opportunity Index 0.88
Market Sales per Household $2,025
US Sales per Household $1,871
Sales per Household Opportunity Index 0.92
Location Quotient 0.09

Market Area Population and Income
Population 384,292
Households 156,596
Per Capita Income $33,733
Median HH Income $65,387


Strengths & Weaknesses


Profitability:

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

Sales:

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

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

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

Sales Rank and Percentile: Your 57/160 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 $3,907 more owner earnings per employee.

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

Your firm's Days Receivable is 5.07 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.88, suggesting the possibility of service saturation or an export surplus of $40,350,660 sales

The Sales per household index in this industry market is 0.92, suggesting the possibility of service saturation or an export surplus of $24,115,784 sales

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

Cash Flow:

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

Your Days Payable is 7.06 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.23 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.05 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.19 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.82 points above the industry peer group average, indicating higher stability and lower-than-average susceptibility to bankruptcy conditions.

SWOT XPRESS SCORE: 3.2/5



SALES‐PROFITABILITY‐MARKET OPPORTUNITY:


Owner Earnings (%) 3
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 4
Current Ratio 3
Current Liabilities:Net Worth 1
Long Term Liabilities: Net Worth 4
Total Liabilities:Net Worth 2
Days Payable 1
Modified Z‐Score 4

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 projected company sales; peer group average earnings %; and industry valuation multiples. Median ranges reflect a range of market conditions and business performance at this revenue scale.

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.