Setup |
Assumptions |
Business Profile |
Ownership |
Ownership Chart |
Report Writer Data |
Federal Tax Table |
Financial Statements |
Assumptions |
Historic |
Historic Balance Sheets |
Historic Income Statements |
Adjustments |
Balance Sheets |
Income Statements |
Sales Cycle |
Adjusted |
Adjusted Balance Sheets |
Adjusted Income Statements |
Working Trial Balance |
Balance Sheets |
Income Statements |
Summary |
Historic Summary Balance Sheets |
Adjusted Summary Balance Sheets |
Historic Summary Income Statements |
Adjusted Summary Income Statements |
Summary Cash Flow Statements |
Net Income to Adjusted Income Reconciliation |
Financial Analysis |
Assumptions |
Common Size Financial Statements |
Historic Balance Sheets |
Adjusted Balance Sheets |
Historic Income Statements |
Adjusted Income Statements |
Financial Statement Trends |
Compound Annual Growth |
Historic Balance Sheets |
Adjusted Balance Sheets |
Historic Income Statements |
Adjusted Income Statements |
Multi-Year Growth |
Historic Income Statements |
Adjusted Income Statements |
Margins and Return on Equity |
Historic Margin Analysis |
Adjusted Margin Analysis |
Return on Average Equity |
Benefit Stream |
Historic Benefit Stream Analysis |
Historic Benefit Stream Analysis |
Adjusted Benefit Stream Analysis |
Adjusted Benefit Stream Analysis |
RMA Comparison |
Common Size Balance Sheets |
Comparative Balance Sheets |
Subject Company Balance Sheets |
Subject Company Working Capital |
RMA Balance Sheets |
RMA Working Capital |
Common Size Income Statements |
Comparative Income Statements |
Subject Company Income Statements |
Subject Company Profit Margins |
RMA Income Statements |
RMA Profit Margins |
Liquidity Ratios |
Liquidity Ratios |
Current Ratio |
Quick Ratio |
Sales to Receivables |
Days’ Receivable |
Inventory Turnover |
Days’ Inventory |
COGS to Payables |
Days’ Payable |
Revenue to Working Capital |
Coverage Ratios |
Coverage Ratios |
Times Interest Earned |
Net Income and Non-Cash to Current LTD |
Fixed Assets to Tangible Worth |
Debt to Tangible Worth |
Debt to Equity |
Operating Ratios |
Operating Ratios |
Gross Profit Margin |
EBT to Tangible Worth |
EBT to Total Assets |
Fixed Asset Turnover |
Total Asset Turnover |
DDA to Revenue |
Officers’ Compensation as Percent of Revenue |
IRS Comparison |
Common Size Balance Sheets |
Comparative Balance Sheets |
Subject Company Balance Sheets |
Subject Working Capital |
IRS Balance Sheets |
IRS Working Capital |
Common Size Income Statements |
Comparative Income Statements |
Subject Company Income Statements |
Subject Company Profit Margins |
IRS Income Statements |
IRS Profit Margins |
Liquidity Ratios |
Liquidity Ratios |
Current Ratio |
Quick Ratio |
Revenue to Accounts Receivable |
Average Collection Period |
Inventory Turnover |
Days’ Inventory |
COGS to Payables |
Days’ Payable |
Revenue to Working Capital |
All Other Ratios |
All Other Ratios |
Times Interest Earned |
Net Income and Non-Cash to Current LTD |
Fixed Assets to Tangible Worth |
Debt to Tangible Worth |
EBT to Tangible Worth |
EBT to Total Assets |
Fixed Asset Turnover |
Total Asset Turnover |
DDA to Revenue |
Officers’ Compensation to Revenue |
Custom Comparison |
Data Source |
Common Size Balance Sheets |
Comparative Balance Sheets |
Subject Company Balance Sheets |
Subject Working Capital |
Balance Sheets |
Working Capital |
Common Size Income Statements |
Comparative Income Statements |
Subject Company Income Statements |
Subject Company Profit Margins |
Income Statements |
Profit Margins |
Liquidity Ratios |
Liquidity Ratios |
Current Ratio |
Quick Ratio |
Revenue to Accounts Receivable |
Average Collection Period |
Inventory Turnover |
Days Inventory |
COGS to Payables |
Days Payable |
Revenue to Working Capital |
Coverage, Leverage, Operating and Expense Ratios |
Coverage, Leverage, Operating and Expense Ratios |
Times Interest Earned |
Net Income and Non-Cash to Current LTD |
Fixed Assets to Tangible Worth |
Debt to Tangible Worth |
EBT to Tangible Worth |
EBT to Total Assets |
Fixed Asset Turnover |
Total Asset Turnover |
DDA to Revenue |
Officers’ Compensation to Revenue |
Appraisal |
Premiums and Discounts |
Assumptions |
Level of Control (Premium or Discount) |
Marketability Discount |
Pluris DLOM |
Pluris DLOM Data |
Pluris RSED |
Pluris PEDI and DLOM |
Assets and Liabilities Adjustments |
Assumptions |
Adjusted Non-Operating Assets and Liabilities |
Excess and Non-Operating Assets |
Built In Gains |
Asset Approach |
Assumptions |
Historic Book Value |
Indicated Value |
Adjusted Book Value |
Adjust to Market Value |
Indicated Value |
Liquidation Value |
Adjust to Liquidation Value |
Indicated Value |
Income Approach |
Adjusted Non-Cash Items |
Long Term Sustainable Company Growth |
Duff and Phelps |
Assumptions |
Duff and Phelps Risk Inputs for Cost of Capital |
Duff and Phelps Cost of Capital |
Duff and Phelps Industry Risk Premium |
Company Specific Risk |
Risk Rate Component Model |
Assumptions |
Competition Components |
Financial Performance Components |
Management Ability & Depth Components – Part I |
Management Ability & Depth Components – Part II |
Profitability & Stability of Earnings Components – Part I |
Profitability & Stability of Earnings Components – Part II |
RRCM Build Up |
Capitalization of Earnings |
Assumptions |
Benefit Stream |
Capitalization Rate |
Indicated Value |
Rate Sensitivity |
Multi-Stage Growth |
Assumptions |
Benefit Stream |
Projection Method |
Projected Benefit Stream |
Discount Rate |
Indicated Value |
Rate Sensitivity |
Summary DCF |
Assumptions |
Inputs |
Balance Sheets |
Income Statements |
Common Size Balance Sheets |
Common Size Income Statements |
Financial Performance |
Benefit Stream |
Projected Base |
Discount Rate |
Indicated Value |
Rate Sensitivity |
Detailed DCF |
Assumptions |
Projection Methods and Assumptions |
Balance Sheet Methods |
Income Statement Methods |
Capital Expenditures |
Long Term Debt |
Cash Flow |
Applied Projections |
Balance Sheets |
Common Size Balance Sheets |
Income Statements |
Common Size Income Statements |
Financial Performance |
Valuation |
Benefit Stream |
Discount Rate |
Indicated Value |
Rate Sensitivity |
Capitalization of Excess Earnings |
Assumptions |
Benefit Stream |
Normal Return |
Capitalization Rate |
Indicated Value |
Rate Sensitivity |
Market Approach |
Commercial Data Sources |
BIZCOMPS |
Assumptions |
Data |
Seller’s Discretionary Earnings Base |
Revenue Base |
Indicated Value |
IBA |
Assumptions |
Multiples |
Seller’s Discretionary Earnings Base |
Revenue Base |
Indicated Value |
Mergerstat Industry PE |
Assumptions |
Data |
Earnings Base |
Indicated Value |
DoneDeals Comps |
Assumptions |
Data |
Earnings Base |
Revenue Base |
Asset Base |
Book Value Base |
Indicated Value |
Pratt’s Stats™ |
Assumptions |
Multiples |
Net Sales Base |
Gross Profit Base |
EBITDA Base |
EBIT Base |
Discretionary Earnings Base |
Book Value Base |
Indicated Value |
Other Data Sources |
Guideline Public Company |
Assumptions |
Multiples |
Revenue Base |
Earnings Base |
Asset Base |
Book Value Base |
Cash Flow Base |
EBITDA Base |
Indicated Value |
Private Company |
Assumptions |
Multiples |
Revenue Base |
Earnings Base |
Asset Base |
Book Value Base |
Cash Flow Base |
Indicated Value |
Analyst Research Data |
Assumptions |
Multiples |
Fundamental Discount |
Revenue Base |
Earnings Base |
Asset Base |
Book Value Base |
Cash Flow Base |
EBIT Base |
EBITDA Base |
Indicated Value |
Subject Company Transactions |
Assumptions |
Transactions and Indicated Value |
Other Industry Multiples |
Assumptions |
Multiples |
Revenue Base |
Earnings Base |
Book Value Base |
Cash Flow Base |
Gross Profit Base |
Indicated Value |
Conclusion of Value |
Assumptions |
Conclusion of Value |
Indicated Values |
Value of Interest Appraised |
Sanity Checks |
Relative Value Analysis |
Justification of Purchase |
Assumptions |
Hypothetical Terms of Sale |
Projected Post Sale Cash Flow |
Pay Back Period |
Internal Rate of Return |
Custom Worksheets |
Custom Worksheet 1 |
Custom Worksheet 2 |
Custom Worksheet 3 |
Data |
Data – IBA |
Data – BIZCOMPS |
Data – DoneDeals Comps |
Business Profile – SIC |
Pluris DLOM Data |
Mergerstat |
Level of Control (Premium or Discount) |
Data – Mergerstat PE |
SBBI |
Capitalization Rate – Capitalization of Earnings |
Discount Rate – Multi-Stage Growth |
Discount Rate – Summary DCF |
Discount Rate – Detailed DCF |
Capitalization Rate – Capitalization of Excess Earnings |
Duff & Phelps |
Capitalization Rate – Capitalization of Earnings |
Discount Rate – Multi-Stage Growth |
Discount Rate – Summary DCF |
Discount Rate – Detailed DCF |
Capitalization Rate – Capitalization of Excess Earnings |
Duff and Phelps Industry Risk Premium |
RMA |
Comparative Balance Sheets |
RMA Balance Sheets |
Comparative Income Statements |
RMA Income Statements |
RMA Liquidity Ratios |
RMA Coverage and Leverage Ratios |
RMA Operating Ratios |
Excess and Non-Operating Assets |
IRS |
Comparative Balance Sheets |
IRS Balance Sheets |
Comparative Income Statements |
IRS Income Statements |
IRS Liquidity Ratios |
IRS Coverage, Leverage, Operating and Expense Ratios |
Excess and Non-Operating Assets |
Report Writer Links |
Report Writer Links |