microsoft word - samplebizpresentationreportconstruction1a
TRANSCRIPT
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
1
BUSINESS ANALYSIS/VALUATION
For
Johnson Mechanical Contractors2754 Grand Avenue
Suite 100Madison WI, 53714
Valuation as of: December 31 2004
PREPARED BY
Robert Smith CVABusiness Valuation Services LLC
636 Maple Rd.Suite 100
Middleton, WI 53562608 555-1234
Report Date: September 1 2005
2
September 1 2005
Mr. Alexander Johnson, PresidentJohnson Mechanical Contractors3569 Pipefitter DriveMiddleton, WI 53562
Dear: Mr. Johnson:
Thank you for contacting us. The following is the information that you requested on JohnsonMechanical Contractors located at 2754 Grand Avenue Suite 100, Madison, WI. Enclosed hereinyou will find our complete market valuation for this business.
Our evaluation is based on the premise that any going business MUST meet the following threecriteria: 1) A business is worth that price at which it will support its structured debt service atcurrent market rates, terms and conditions. 2) It must pay a fair market salary to the owner(s),commensurate with other similar size and type of businesses located in the same market area asthe subject business. 3) It must also pay a fair market rate of return, commensurate with risk, onthe owner’s total investment. As you will see in the following analysis, by using the inputtedmarket variables listed herein, there is only ONE price at which this business can accomplishthese three criteria! This evaluation is a study that has determined that price.
Because of this fact, this analysis can be used by you as a powerful business tool and a completebusiness plan to help guarantee that the calculated profits can be maintained and possibly evenenhanced. This can be accomplished by regularly scheduled comparisons (and if necessary, themaking of adjustments) of the business’ expense to the sales ratios contained herein to those ofindustry standards. Your guiding point to this comparison will be the percentage columnscontained on each expense line-item of the adjusted income statement. Each of these criticalpercentages should be looked at by management as the specific performance goal objective foreach expense item to help assure a minimum performance level that is show here. This is acritical component of one element of your short term financial planning. By properly managingthe specific policies, procedures and systems that control each expense line-item to a performancestandard better than the standard shown here, you could expect that it would result in an evenbetter financial performance than is represented here.
We have determined the market value of this business on the basis of a personal inspection of thesubject business and the use of good, commonly accepted business and accounting practices. We
Johnson Mechanical Contractors 3ValuationDecember 31 2004
also used the information contained in the business tax forms and the business financialstatements and other readily available company financial information and industry standardinformation for similar companies of size, type and market location.
Additionally, we analyzed the current financial market variables affecting the business’ currentmarket value. We have determined that a 100% ownership interest of Johnson MechanicalContractors is $2,640,163.
An anticipated investment of $660,041 would be required as a down payment to purchase thisbusiness. An additional investment will be required to cover the cash cost of deferredmaintenance, and working capital, and other cash investments for a total other cash investment of$36,100. Therefore, the market value of the business plus the additional cash outlays would total$2,676,263.
This evaluation is an accurate mathematical analysis that has determined the value necessary forthis business to be properly structured in order to meet the three criteria previously explained.
This is a sample insert for the evaluator cover letter to show the location of the insert in thissample business analysis/valuation report.
Sincerely,
Robert Smith CVAPresident
Enclosures
Johnson Mechanical Contractors 4ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
TABLE OF CONTENTS
JOHNSON MECHANICAL CONTRACTORS VALUATION
BUSINESS VALUATION SUMMARY ........................................................................... 6FINAL DETERMINATION OF VALUE.......................................................................... 8TEST OF REASONABLENESS........................................................................................ 9SELLER PRETAX CASH POSITION ............................................................................ 11BUYER BALANCE SHEET POSITION ........................................................................ 12OWNER INFORMATION............................................................................................... 14EVALUATOR DATA...................................................................................................... 15BUSINESS PROFILE ...................................................................................................... 16MARKET VARIABLES USED IN ANALYSIS............................................................. 17INCOME STATEMENT WEIGHTED AVERAGE SUMMARY .................................. 19INCOME STATEMENT ADJUSTMENTS SUMMARY............................................... 20INCOME STATEMENT ADJUSTMENTS DETAIL ..................................................... 21COMMENTS – ADJUSTMENTS TO INCOME STATEMENT.................................... 22INCOME STATEMENT ADJUSTMENTS SUMMARY............................................... 23INCOME STATEMENT ADJUSTMENTS DETAIL ..................................................... 24COMMENTS – ADJUSTMENTS TO INCOME STATEMENT.................................... 25INCOME STATEMENT ADJUSTMENTS SUMMARY............................................... 26INCOME STATEMENT ADJUSTMENTS DETAIL ..................................................... 27COMMENTS – ADJUSTMENTS TO INCOME STATEMENT.................................... 28STRUCTURED FINANCING SUMMARY.................................................................... 29BALANCE SHEET ADJUSTMENTS SUMMARY ....................................................... 30BALANCE SHEET ADJUSTMENTS DETAIL ............................................................. 31COMMENTS – ADJUSTMENTS TO BALANCE SHEET............................................ 32BALANCE SHEET ADJUSTMENTS SUMMARY ....................................................... 33BALANCE SHEET ADJUSTMENTS DETAIL ............................................................. 34COMMENTS – ADJUSTMENTS TO BALANCE SHEET............................................ 35BALANCE SHEET ADJUSTMENTS SUMMARY ....................................................... 36BALANCE SHEET ADJUSTMENTS DETAIL ............................................................. 37COMMENTS – ADJUSTMENTS TO BALANCE SHEET............................................ 38PROFORMA FIRST YEAR FINANCIAL BUDGET SUMMARY ............................... 39PROFORMA FIRST YEAR FINANCIAL BUDGET DETAIL...................................... 40COMMENTS – ADJUSTMENTS TO BUDGET............................................................ 41PROFORMA FIRST YEAR FINANCIAL BUDGET DETAIL Q1................................ 42PROFORMA FIRST YEAR FINANCIAL BUDGET DETAIL Q2................................ 43PROFORMA FIRST YEAR FINANCIAL BUDGET DETAIL Q3................................ 44PROFORMA FIRST YEAR FINANCIAL BUDGET DETAIL Q4................................ 45DEFINITION OF MARKET VALUE ............................................................................. 46STATEMENT OF LIMITING CONDITIONS ................................................................ 47VALUATION TECHNIQUES (METHODOLOGIES) ................................................... 49EVALUATOR’S COMMENTS....................................................................................... 52APPENDICES .................................................................................................................. 54TAX FORMS.................................................................................................................... 55
Johnson Mechanical Contractors 5ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
FINANCIAL STATEMENTS......................................................................................... 56MISCELLANEOUS SUPPORTING DOCUMENTATION ........................................... 57
Johnson Mechanical Contractors 6ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
BUSINESS VALUATION SUMMARY
Robert Smith, CVA has been asked by Mr. Alexander Johnson, to render the business valuationdescribed below. The following information details our assignment:
Client Name: Alexander Johnson
Business Name: Johnson Mechanical Contractors
Business Address: 2754 Grand AvenueSuite 100Madison, WI53714
Type of Entity : S Corporation
State of Incorporation: WI
In Business Since: 1988
Valuation Prepared by: Robert Smith
Business Interest Valued: 100
Effective Date of Appraisal: December 31 2004
Date of Valuation: September 1 2005
Purpose of Evaluation: Valuation
Standard of Value: Fair Market Value
Business Value: $2,640,163
Down Payment Required: $660,041
Additional Investment Required: $36,100
Total Investment Anticipated: $696,141
Summary of Value:
We have determined that a 100% ownership interest of Johnson Mechanical Contractors is$2,640,163.
An anticipated investment of $660,041 would be required as a down payment to purchase thisbusiness. An additional investment will be required to cover the cash cost of deferredmaintenance, and working capital, and other cash investments for a total other cash investment of$36,100. Therefore, the market value of the business plus the additional cash outlays would total$2,676,263.
Johnson Mechanical Contractors 7ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
The opinion of value is rendered given the variables listed above for the period listed above only.The value is offered on the basis of a 100% marketable interest as noted above.
Scope and Limitations:
In the review of all data, we have relied upon all of the referenced information withoutindependent verification and therefore it is totally dependant upon the information provided byJohnson Mechanical Contractors. Any change in the critical information that was relied upon aspart of the process of this valuation would certainly justify a reassessment of the final conclusionof the fair market value.
Standard of Value:
The fair market value is defined as follows: The fair market value of a business is the value atwhich the business would change hands between a willing seller and a willing buyer when neitheris under a compulsion and when both have reasonable knowledge of the relevant facts.
A fair market transaction must be a “win-win” for all parties concerned. The fair market value ofa going business is that value at which the normalized spendable income stream of the businesscan accomplish three critical criteria: 1) It must be able to support the structured market debtservice that would be created from a hypothetical business sale in the business’ market area. 2) Itmust be able to pay the owner a market rate salary as determined by the size, type and location ofthe business to current industry standards of a similar business within the same market area. 3) Itmust be able to pay the owner a market rate of return on his/her investment as determined by thecurrent market standards.
Summary Comments:This is a sample insert for the evaluator summary comments to show the location of the insert inthis sample business analysis/valuation sample report.
Johnson Mechanical Contractors 8ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
FINAL DETERMINATION OF VALUEVS
BOOK VALUE AND ADJUSTED BOOK VALUE METHODS
Business Value: $2,640,163
Book Value Method: $2,032,669Less: Adjusted Book Value Method: $2,215,317
Intangibles (Good Will) Value: $424,846
Book Value Method:
The book value as of December 31 2004 was $2,032,669. Book value is an accountingvalue that is calculated by subtracting total liabilities from total assets. Book value wasselected because it will give us more of a well rounded look at the state of the companyand it will give us one more comparison to determine the reasonableness of the finaldetermination of value. It was rejected because balance sheets are prepared on ahistorical cost basis, in accordance with Generally Accepted Accounting Principals; thebook value of a business does not necessarily consider the fair market value of theunderlying assets. We are more concerned with the income producing ability of theassets than their book value.
Adjusted Book Value – Going Concern Method:
The adjusted book value as of December 31 2004 was $2,215,317. The adjusted bookvalue of this going concern method develops a valuation indicated by adjusting thereported book values of a subject company’s assets to its actual or estimated fair marketvalues and subtracting its liabilities (adjusted to fair market value, if appropriate). Thismethod was considered in the valuation of Johnson Mechanical Contractors because itwould be necessary to compare the estimated fair market value of the assets to the finaldetermination of value. If the fair market value of the assets is worth more than thedetermined value of the business, it would be better to sell the assets outright, not thebusiness as a going concern. This method was rejected because the estimated fair marketvalue of the assets individually is not an indicator of the income producing ability of theassemblage of all of the assets.
Johnson Mechanical Contractors 9ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
TEST OF REASONABLENESS
To test the reasonableness of our opinion as to the fair market value of Johnson Mechanical Contractors,we performed a proof of valuation analysis. This analysis includes assumptions regarding the cash downpayment, the terms of the purchase notes, and the Company’s projected cash flows. This analysis looks atthe final opinion of the fair market value and determines the functionality of the ensuing projected cashflows and anticipated financing conclusions. The assumptions regarding the terms of the hypotheticalpurchase are presented in the following schedule and represents the findings from our analysis.
Final determination of market value: $2,640,163
From normalized income statement:
Net operating income (NPBT): $675,127
Balance available to retire monthly debt service: $44,658
Buyer return on investment $ (ROI) : $139,228
Source of Purchase Funds Amount Terms (yrs) Interest Mo. Payment
Financial Institution Financing:
Auto / Truck $409,934 4 7.00 $9,816Inventory $237,000 3 7.50 $7,372Machinery/Equipment $528,060 5 7.00 $10,456Office Furniture/Fixtures $98,795 3 6.50 $3,028Seller Financing $706,333 5 7.00 $13,986
Total $1,980,122 $44,658
Based upon the hypothetical terms presented above, the Company’s projected cash flows were estimated toascertain whether or not they cover the hypothetical interest and principal payments. The buyer post-salecash flow was calculated in the following manner:
1. The projected before-tax income was reduced by interest payments on hypothetical purchasenotes.
2. The projected post-sale pre-tax income was reduced by an income tax factor of 0.0%.3. All non-cash expenses were added back.4. The principal portion of all debt instruments (re-sale and post-sale) was deducted.
Test #1:Opinion of business value: $2,640,163Total Down payment + Debt: $2,640,163
Variance (Should be “0”): $0
Test #2:Balance available to retire monthly debt plus ROI: $56,261Structured monthly debt service payments: - $44,658Monthly Cash Flow Before Taxes (ROI) - $11,602
Variance (Should be “0”): $0
Johnson Mechanical Contractors 10ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
TEST OF REASONABLENESS (CONTINUED)
Test #3:Net operating income (NPBT): $675,127Less: Balance available to retire debt service: $535,899
Amount available for buyer ROI: $139,228
Buyer required return on investment $ (ROI) : $139,228Amount available for buyer ROI: $139,228Variance (Should be “0”): $0
Test Conclusion:
The final opinion of value for Johnson Mechanical Contractors of $2,640,163 passes the “test ofreasonableness” because: 1) The total of all of the purchase funds created from the down payment andstructured financing, equals the final opinion of value. 2) The total monthly payments of all structuredfinancing at the hypothetical sale price, equals the total amount of the spendable cash flow available tomake such payments. 3) The total amount of cash flow needed to give the buyer a fair market return ontheir investment equals the balance of the spendable cash flow that is made available to make such apayment. 4) The integrity of the buyer’s ROI is maintained because a fair market salary was used in thenormalization of income streams process and therefore does not dilute the total cash flow stream structuredfor the buyer.
Therefore:
Based on the above analysis, the priced cash flows are sufficient to pay the assumed interest and principledue on the hypothetical purchase notes and existing notes.
Johnson Mechanical Contractors 11ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
SELLER PRETAX CASH POSITION
HYPOTHETICAL TERMS OF ASSET SALE AT CALCULATED MARKET VALUE
Cash received from sale:Down payment from Buyer: $660,041
Financial Institution Financing:Auto/truck $409,934Inventory $237,000Machinery/Equipment $528,060Other Financing $0Office Furniture/Fixtures $98,795Real Estate $0
Other Cash/Credit:Existing Cash from Business: $244,083Accounts Receivable Trade: $1,703,212Accounts Receivable Other: $236,850Costs in Excess of Billings: $113,955Prepaid Expenses: $46,250Deposits: $0Notes Receivable: $0
Total Cash Received: $4,278,180
Less cash/credit paid out from sale:Accounts Payable Trade: $380,810Accounts Payable Other: $0Notes Payable Other: $0Accrued Expenses: $46,465Notes Payable Current/Long Term: $462,465Billings in Excess of Costs: $347,600Other Current Liabilities: $18,000Deferred Liabilities: $36,000Other Long Term Liabilities: $0
Total Cash Paid Out: $1,291,340
Net Cash/Credit Received from Sale: $2,986,840
*The following unlisted balance sheet line-items are considered to be contributing assets and are assumedto stay in the business with the hypothetical buyer: Other Current Assets, Other Fixed Assets, Other Assets.Note: The actual seller proceeds received from a sale is totally dependent upon the final purchase terms.
Plus the seller will receive the following cash payments from the buyer:
Principal balance of seller loan: $706,333Monthly Payments: $13,986For a term period of: 5@ Interest Rate: 7.00
Johnson Mechanical Contractors 12ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
BUYER BALANCE SHEET POSITION
HYPOTHETICAL TERMS OF ASSET SALE AT CALCULATED MARKET VALUE
Period BeginningDate of Sale
CURRENT ASSETSCash $36,100Accounts Receivable – Trade $0Accounts Receivable – Other $0Costs in Excess of Billings $0Inventory $474,000Prepaid Expenses $0Other $0
Total Current Assets $510,100==============
FIXED ASSETSAutos & Trucks $753,223Machinery & Equipment $814,371Office Furniture & Equipment $187,727Real Estate $0
Leasehold Improvements $50,875Other Fixed Assets $0Total Depreciable Assets $1,806,196Less: Accumulated Depreciation $0Net Book Value $1,806,196Land $0Total Fixed Assets $1,806,196
==============OTHER ASSETSDeposits $0Notes Receivable $0Other $0
Total Other Assets $0==============
TOTAL ASSETS $2,316,296==============
Johnson Mechanical Contractors 13ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
CURRENT LIABILITIESAccounts Payable – Trade $0Accounts Payable – Other $0Notes payable $0Notes Payable – Current of LTD $409,672Billings in Excess of Costs $0Accrued Expenses $0Other Current Liabilities $0
Total Current Liabilities $409,672==============
LONG TERM LIABILITIESNotes Payable – LT of LTD $1,980,122Less: Notes Payable Current $409,672Deferred Liabilities $0Other Long Term Liabilities $0
Total Long Term Liabilities $1,570,450==============
TOTAL LIABILITIES $1,980,122==============
NETWORTHCapital stock $0Paid in Capital / Treasury Stock $660,041
Other Equities ($323,867)Retained Earnings $0Profit and Losses – YTD $0
Total Net worth $336,174==============
TOTAL LIABILITIES $2,316,296AND NETWORTH ==============
Johnson Mechanical Contractors 14ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
OWNER INFORMATION
Company Name: Johnson Mechanical Contractors
Located: Madison WI, 53714
Number of shares issued: 2500
Total number of shares outstanding: 2500
Owner Name # Shares Owned % OwnershipAlex Johnson 1250 50.00Nick Johnson 1250 50.00
Totals 2500 100
Johnson Mechanical Contractors 15ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
EVALUATOR DATA
APPRAISER’S INFORMATION
Name: Robert Smith
Title: President
Designation: (If entered) CVA
Company: Business Valuation Services LLC
Address: 636 Maple Rd.Suite 100Middleton, WI 53562
Phone: 608 555-1234
Email: [email protected]
Website: www.bvs.com
% of Business Being Valuated: 100
Date of Valuation: September 1 2005
Effective Date of Appraisal: December 31 2004
Purpose of Valuation: Valuation
Ownership Interest Being Valuated: 100
Type of Financial Statements Used: Reviewed
Type of Sale: Asset
LETTER INFORMATION
Report addressed to: Alexander JohnsonTitle: President
Company: Johnson Mechanical Contractors
Address: 3569 Pipefitter Drive
Middleton, WI 53562
Johnson Mechanical Contractors 16ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
BUSINESS PROFILE
Business Name: Johnson Mechanical Contractors
Business Address: 2754 Grand AvenueSuite 100Madison, WI53714
Website: www.johnsonmechanical.com
SIC/NAICS Code: 1711 / 238220
SIC/NAICS Description: Mechanical Construction Contractors
Business Owner: Alexander Johnson
Title: President
Business Owner’s Phone: 608 555-1234
Business Owner’s Email: [email protected]
Type of Entity : S Corporation
State of Incorporation: WI
In Business Since: 1988
Stock:Number of Shares Outstanding: 2500
Number of Share Holders: 2
Number of Shares Issued: 2500
Johnson Mechanical Contractors 17ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
MARKET VARIABLES USED IN ANALYSIS
INVESTMENT CRITERIA
Down Payment (as a % of S/P): 25
Investor Required Rate of Return: 20
Subject Business NPBT (as % of Sales):
Investor Other Cash Investments:Deferred Maintenance $12,600Working Capital $20,500Other $3,000
MARKET STANDARDS
Owner Market Salary in Dollars:Owner Market Salary as % of Sales 1.3
FINANCING
Number of Years to Analyze Income Statement 3Beginning Year to Analyze 2004Ending Month of Fiscal Year December
LOANS:
Auto/TruckMarket Value $683,223Loan to Value Ratio (%) 60Amount to Finance $409,934Term Length (Years) 4Interest Rate % 7
InventoryMarket Value $474,000Loan to Value Ratio (%) 50Amount to Finance $237,000Term Length (Years) 3Interest Rate % 7.5
Johnson Mechanical Contractors 18ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
MARKET VARIABLES USED IN ANALYSIS (CONTINUED)
Machinery and EquipmentMarket Value $754,371Loan to Value Ratio (%) 70Amount to Finance $528,060Term Length (Years) 5Interest Rate % 7
Office Furniture/FixturesMarket Value $131,727Loan to Value Ratio (%) 75Amount to Finance $98,795Term Length (Years) 3Interest Rate % 6.5
Seller FinancingAssets Used as Collateral GBSA - 2nd PositionTerm Length (Years) 5Interest Rate % 7
Johnson Mechanical Contractors 19ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
INCOME STATEMENT WEIGHTED AVERAGE SUMMARY
SALES WEIGHTED AVERAGE:
Annual AnnualWeighted Adjusted Weighted
Year % Sales Sales
2004 100 $9,216,687 $9,216,6872003 0 $8,921,753 $02002 0 $8,564,883 $0
Total Weighted Sales $9,216,687
NOTE: The “Total Weighted Sales Average” is calculated from the results of the average of the“Annual Weighted Sales” for the multi-years analyzed. Since the final results are the average ofmultiple years, it is possible that the amount of “Total Weighted Sales” will not be equal to the“Annual Adjusted Sales” for any one specific year of the different years weighted in the analysis.
NET OPERATING INCOME WEIGHTED AVERAGE:
Annual Weighted Weighted WeightedWeighted Adjusted NOI Annual Annual
Year % NOI Total $ Debt ROI
2004 100 $675,127 $675,127 $535,899 $139,2282003 0 $541,271 $0 $0 $02002 0 $426,780 $0 $0 $0
Total Weighted Average $675,127 $535,899 $139,228
NOTE: The “Weighted Annual Debt” and the “Weighted Annual ROI” are calculated from theresults of the average of the “Weighted Net Operating Incomes” for the multi-years analyzed.Since the final results are the average of multiple years, it is possible that the amount of “AnnualDebt” and the amount of “Annual ROI”, when totaled, will not be equal to the “Annual NetOperation Income” for any one specific year of the different years weighted in the analysis.
The weighting technique used for this analysis was determined to be the most appropriate methodto determine the subject business’ typical spendable income stream that takes the givencircumstances and the specific ranges of financial performance into account for the multiple yearsanalyzed.
Johnson Mechanical Contractors 20ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
Year 1
INCOME STATEMENT ADJUSTMENTS SUMMARYActual Adjustment AdjustedYear Year YearEnding Ending Ending
% 12-31-2004 12-31-2004 % 12-31-2004INCOME:Sales 100 $9,216,687 100 $9,216,687
Total Income 100 $9,216,687 $0 100 $9,216,687==== ========= ========= ==== =========
Cost of Goods Sold:Direct Costs - Labor 23.20 $2,138,590 $0 23.20 $2,138,590Direct Costs - Materials 23.84 $2,197,498 $0 23.84 $2,197,498Direct Costs - Equipment 0.20 $18,568 $0 0.20 $18,568Direct Costs - Subcontractor 2.70 $248,976 $0 2.70 $248,976Direct Costs - Other 1.13 $103,848 $0 1.13 $103,848
Total Cost of Goods Sold 51.08 $4,707,480 $0 51.08 $4,707,480==== ========= ========= ==== =========
GROSS PROFIT 48.92 $4,509,207 $0 48.92 $4,509,207==== ========= ========= ==== =========
LESS: OPERATING COSTS
Total Variable Costs 18.80 $1,732,522 ($70,549) 18.03 $1,661,973(See detail schedule on next page) ==== ========= ========= ==== =========
Fixed CostsTotal Fixed Costs 25.22 $2,324,035 ($95,977) 24.17 $2,228,058
(See detail schedule on next page) ==== ========= ========= ==== =========
Total Operating Expenses 44.01 $4,056,557 ($166,526) 42.21 $3,890,031(Fixed Costs plus Variable Costs) ==== ========= ========= ==== ========
Other Income (Expenses)Total Other Income (Expenses) 0.14 $13,078 $42,873 0.61 $55,951
==== ========= ========= ==== ========
NET OPERATING INCOME (NPBT) 5.05 $465,728 $209,399 7.33 $675,127(Before Debt Service) ==== ========= ========= ==== ========
NET OPERATING INCOME (NPBT) 5.05 $465,728 $209,399 7.33 $675,127(Multiple Year Weighted Average) ==== ========= ========= ==== ========
LESS: ANNUAL DEBT SERVICE $535,899========
CASH FLOW AFTER DEBT SERVICE 20.00 $139,228(Return on Investment ROI) ==== ========
Earnings Before Interest, Taxes, Depreciation, Amortization (EBITDA) 8.12 $748,334Multiple Year Weighted Average (EBITDA) 8.12 $748,334
==== ========
Debt Service Coverage Ratio (DSCR) 1.26Multiple Year Weighted Average (DSCR) 1.26
========
Johnson Mechanical Contractors 21ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
INCOME STATEMENT ADJUSTMENTS DETAIL
Actual Adjustment AdjustedYear Year YearEnding Ending Ending
% 12-31-2004 12-31-2004 % 2-31-2004
Variable CostsAdvertising & Promotion 0.77 $71,395 ($25,000) 0.50 $46,395Auto & Truck Gas, Oil, Repairs 2.05 $189,190 $0 2.05 $189,190Bad Debt 0.30 $27,710 $0 0.30 $27,710Bank Charges 0.10 $9,619 $0 0.10 $9,619Employee Benefits 2.26 $208,674 ($35,000) 1.88 $173,674Freight 0.21 $19,539 $0 0.21 $19,539Insurance - W. C. Direct Labor 0.91 $84,071 $0 0.91 $84,071Laundry, Cleaning 0.09 $8,646 $0 0.09 $8,646License & Permits 0.06 $5,735 $0 0.06 $5,735Miscellaneous 0.00 $418 $0 0.00 $418Office Supplies 0.63 $58,475 ($10,549) 0.52 $47,926Other 0.09 $8,014 $0 0.09 $8,014Payroll Taxes (Direct Labor) 2.16 $198,776 $0 2.16 $198,776Shop Supplies & Small tools 0.62 $57,051 $0 0.62 $57,051Travel & Lodging & Entertainme 0.02 $2,104 $0 0.02 $2,104U.P.S./FedEx 0.02 $1,861 $0 0.02 $1,861Union Benefits/Dues 7.71 $710,512 $0 7.71 $710,512Warranty Expense 0.77 $70,732 $0 0.77 $70,732
Total Variable Costs 18.80 $1,732,522 ($70,549) 18.03 $1,661,973==== ========= ======= ==== ========
Fixed Costs:Contributions 0.03 $2,434 $0 0.03 $2,434Depreciation 1.32 $121,985 ($48,778) 0.79 $73,207Dues & Subscriptions 0.23 $20,867 $0 0.23 $20,867Insurance - Auto & Liability 3.97 $366,043 $0 3.97 $366,043Insurance - Group Health 0.17 $15,248 $0 0.17 $15,248Insurance - Officer 0.10 $8,981 $0 0.10 $8,981Payroll Taxes - Office 1.58 $145,787 ($2,015) 1.56 $143,772Penison Plan 0.88 $81,028 $0 0.88 $81,028Professional Fees 0.70 $64,435 ($25,000) 0.43 $39,435Property Taxes 0.21 $19,584 $0 0.21 $19,584Rent 0.76 $69,665 $5,000 0.81 $74,665Repairs & Maintenance 0.05 $4,409 $0 0.05 $4,409Salaries - Owner 1.57 $145,000 ($25,184) 1.30 $119,816Salaries - Office/Shop 13.40 $1,234,609 $0 13.40 $1,234,609Telephone 0.11 $9,960 $0 0.11 $9,960Utilities 0.15 $14,000 $0 0.15 $14,000
Total Fixed Costs 25.22 $2,324,035 ($95,977) 24.17 $2,228,058==== ========= ======= ==== ========
Total Operating Costs 44.01 $4,056,557 ($166,526) 42.21 $3,890,031==== ========= ======= ==== ========
Johnson Mechanical Contractors 22ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
COMMENTS – ADJUSTMENTS TO INCOME STATEMENT
ADJUSTMENTS FOR YEAR: 2004
Line Item Adjusted CommentsAdvertising & Promotion Extra advertising for the 25th anniversary promotion was
adjusted to standard.
Employee Benefits Reduced by the amount of the employee's annual profitsharing. Next year's profit sharing will be included in nextyear's budget and paid from next year's performance.
Office Supplies Adjusted to market standard from trade association survey.
Depreciation Adjusted to economic life depreciation which is estimatedto be the same as straight line depreciation.
Payroll Taxes - Office Reduced to adjust for the reduction of owner's salary.
Professional Fees Unusual legal fees were deducted.
Rent The rent was determined to be under market rates asdetermined by a survey of commercial real estate brokers.
Salaries - Owner Owner's salary is set to industry standard that is based ontrade association surveys.
Other Expense - Interest Adjusted to bring the interest expense to zero as part of thenormaliztion process.
Johnson Mechanical Contractors 23ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
Year 2
INCOME STATEMENT ADJUSTMENTS SUMMARYActual Adjustment AdjustedYear Year YearEnding Ending Ending
% 12-31-2003 12-31-2003 % 12-31-2003INCOME:Sales 100 $8,921,753 $0 100 $8,921,753
Total Income 100 $8,921,753 $0 100 $8,921,753==== ========= ========= ==== =========
Cost of Goods Sold:Direct Costs - Labor 23.65 $2,110,096 $0 23.65 $2,110,096Direct Costs - Materials 24.37 $2,174,083 $0 24.37 $2,174,083Direct Costs - Equipment 0.22 $19,254 $0 0.22 $19,254Direct Costs - Subcontractor 2.65 $236,547 $0 2.65 $236,547Direct Costs - Other 1.06 $94,567 $0 1.06 $94,567
Total Cost of Goods Sold 51.95 $4,634,547 $0 51.95 $4,634,547==== ========= ========= ==== =========
GROSS PROFIT 48.05 $4,287,206 $0 48.05 $4,287,206==== ========= ========= ==== =========
LESS: OPERATING COSTS
Total Variable Costs 18.68 $1,666,444 ($45,305) 18.17 $1,621,139(See detail schedule on next page) ==== ========= ========= ==== =========
Fixed CostsTotal Fixed Costs 25.11 $2,240,087 ($62,593) 24.41 $2,177,494
(See detail schedule on next page) ==== ========= ========= ==== =========
Total Operating Expenses 43.79 $3,906,531 ($107,898) 42.58 $3,798,633(Fixed Costs plus Variable Costs) ==== ========= ========= ==== ========
Other Income (Expenses)Total Other Income (Expenses) 0.15 $13,240 $39,458 0.59 $52,698
==== ========= ========= ==== ========
NET OPERATING INCOME (NPBT) 4.42 $393,915 $147,356 6.07 $541,271(Before Debt Service) ==== ========= ========= ==== ========
NET OPERATING INCOME (NPBT) 5.05 $465,728 $209,399 7.33 $675,127(Multiple Year Weighted Average) ==== ========= ========= ==== ========
LESS: ANNUAL DEBT SERVICE $535,899========
CASH FLOW AFTER DEBT SERVICE 20.00 $139,228(Return on Investment ROI) ==== ========
Earnings Before Interest, Taxes, Depreciation, Amortization (EBITDA) 6.88 $614,002Multiple Year Weighted Average (EBITDA) 8.12 $748,334
==== ========
Debt Service Coverage Ratio (DSCR) 1.01Multiple Year Weighted Average (DSCR) 1.26
========
Johnson Mechanical Contractors 24ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
INCOME STATEMENT ADJUSTMENTS DETAIL
Actual Adjustment AdjustedYear Year YearEnding Ending Ending
% 12-31-2003 12-31-2003 % 2-31-2003
Variable CostsAdvertising & Promotion 0.45 $39,756 $0 0.45 $39,756Auto & Truck Gas, Oil, Repairs 2.08 $185,632 $0 2.08 $185,632Bad Debt 0.20 $17,456 $0 0.20 $17,456Bank Charges 0.11 $9,465 $0 0.11 $9,465Employee Benefits 2.23 $198,562 ($35,000) 1.83 $163,562Freight 0.23 $20,546 $0 0.23 $20,546Insurance - W. C. Direct Labor 0.93 $82,684 $0 0.93 $82,684Laundry, Cleaning 0.09 $8,356 $0 0.09 $8,356License & Permits 0.05 $4,895 $0 0.05 $4,895Miscellaneous 0.01 $758 $0 0.01 $758Office Supplies 0.64 $56,698 ($10,305) 0.52 $46,393Other 0.09 $7,589 $0 0.09 $7,589Payroll Taxes (Direct Labor) 2.24 $199,875 $0 2.24 $199,875Shop Supplies & Small tools 0.63 $55,852 $0 0.63 $55,852Travel & Lodging & Entertainment 0.02 $1,569 $0 0.02 $1,569U.P.S./FedEx 0.02 $1,648 $0 0.02 $1,648Union Benefits/Dues 7.96 $709,856 $0 7.96 $709,856Warranty Expense 0.73 $65,247 $0 0.73 $65,247
Total Variable Costs 18.68 $1,666,444 ($45,305) 18.17 $1,621,139==== ========= ======= ==== ========
Fixed Costs:Contributions 0.03 $2,275 $0 0.03 $2,275Depreciation 1.34 $119,584 ($46,853) 0.82 $72,731Dues & Subscriptions 0.23 $20,546 $0 0.23 $20,546Insurance - General & Auto 4.06 $362,479 $0 4.06 $362,479Insurance - Group Health 0.17 $15,251 $0 0.17 $15,251Insurance - Officer 0.10 $8,651 $0 0.10 $8,651Payroll Tax - Office 1.61 $143,699 ($1,622) 1.59 $142,077Penison Plan 0.90 $79,853 $0 0.90 $79,853Professional Fees 0.45 $40,568 $0 0.45 $40,568Property Taxes 0.21 $18,750 $0 0.21 $18,750Rent 0.76 $67,800 $4,900 0.81 $72,700Repairs & Maintenance 0.05 $4,895 $0 0.05 $4,895Salaries - Owner 1.51 $135,000 ($19,018) 1.30 $115,982Salaries - Office/Shop 13.42 $1,197,570 $0 13.42 $1,197,570Telephone 0.11 $9,586 $0 0.11 $9,586Utilities 0.15 $13,580 $0 0.15 $13,580
Total Fixed Costs 25.11 $2,240,087 ($62,593) 24.41 $2,177,494==== ========= ======= ==== ========
Total Operating Costs 43.79 $3,906,531 ($107,898) 42.58 $3,798,633==== ========= ======= ==== ========
Johnson Mechanical Contractors 25ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
COMMENTS – ADJUSTMENTS TO INCOME STATEMENT
ADJUSTMENTS FOR YEAR: 2003
Line Item Adjusted CommentsEmployee Benefits Adjusted for excesive bonuses to employees as was
determined by industry surveys.
Office Supplies Adjusted to market standard from trade association survey.
Depreciation Adjusted to economic life which is estimated to be thesame as straight line depreciation.
Payroll Tax - Office Reduced to adjust for the reduction of owner's salary.
Rent The rent is adjusted because it was determined to be undermarket rates as determined by a survey of commercial realestate brokers
Salaries - Owner Owner's salary is adjusted to industry standard.
Other Expense - Interest Adusted to bring the interest to "0" as part of thenormalization process.
Johnson Mechanical Contractors 26ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
Year 3
INCOME STATEMENT ADJUSTMENTS SUMMARYActual Adjustment AdjustedYear Year YearEnding Ending Ending
% 12-31-2002 12-31-2002 % 12-31-2002INCOME:Sales 100 $8,564,883 $0 100 $8,564,883
Total Income 100 $8,564,883 $0 100 $8,564,883==== ========= ========= ==== =========
Cost of Goods Sold:Direct Costs - Labor 23.55 $2,016,897 $0 23.55 $2,016,897Direct Costs - Materials 24.17 $2,070,004 $0 24.17 $2,070,004Direct Costs - Equipment 0.21 $17,785 $0 0.21 $17,785Direct Costs - Subcontractor 2.88 $246,789 $0 2.88 $246,789Direct Costs - Other 1.09 $93,654 $0 1.09 $93,654
Total Cost of Goods Sold 51.90 $4,445,129 $0 51.90 $4,445,129==== ========= ========= ==== =========
GROSS PROFIT 48.10 $4,119,754 $0 48.10 $4,119,754==== ========= ========= ==== =========
LESS: OPERATING COSTS
Total Variable Costs 19.35 $1,656,943 ($38,450) 18.90 $1,618,493(See detail schedule on next page) ==== ========= ========= ==== =========
Fixed CostsTotal Fixed Costs 25.47 $2,181,317 ($55,288) 24.82 $2,126,029
(See detail schedule on next page) ==== ========= ========= ==== =========
Total Operating Expenses 44.81 $3,838,260 ($93,738) 43.72 $3,744,522(Fixed Costs plus Variable Costs) ==== ========= ========= ==== ========
Other Income (Expenses)Total Other Income (Expenses) -0.16 ($13,352) $64,900 0.60 $51,548
==== ========= ========= ==== ========
NET OPERATING INCOME (NPBT) 3.13 $268,142 $158,638 4.98 $426,780(Before Debt Service) ==== ========= ========= ==== ========
NET OPERATING INCOME (NPBT) 5.05 $465,728 $209,399 7.33 $675,127(Multiple Year Weighted Average) ==== ========= ========= ==== ========
LESS: ANNUAL DEBT SERVICE $535,899========
CASH FLOW AFTER DEBT SERVICE 20.00 $139,228(Return on Investment ROI) ==== ========
Earnings Before Interest, Taxes, Depreciation, Amortization (EBITDA) 5.85 $500,976Multiple Year Weighted Average (EBITDA) 8.12 $748,334
==== ========
Debt Service Coverage Ratio (DSCR) 0.80Multiple Year Weighted Average (DSCR) 1.26
========
Johnson Mechanical Contractors 27ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
INCOME STATEMENT ADJUSTMENTS DETAIL
Actual Adjustment AdjustedYear Year YearEnding Ending Ending
% 12-31-2002 12-31-2002 % 2-31-2002
Variable CostsAdvertising & Promotion 0.44 $37,582 $0 0.44 $37,582Auto & Truck Gas, Oil, Repairs 2.18 $186,542 $0 2.18 $186,542Bad Debt 0.20 $16,854 $0 0.20 $16,854Bank Charges 0.11 $9,578 $0 0.11 $9,578Employee Benefits 2.31 $197,451 ($28,000) 1.98 $169,451Freight 0.20 $17,468 $0 0.20 $17,468Insurance - W. C. Direct Labor 0.96 $81,947 $0 0.96 $81,947Laundry, Cleaning 0.10 $8,256 $0 0.10 $8,256License & Permits 0.06 $4,798 $0 0.06 $4,798Miscellaneous 0.01 $459 $0 0.01 $459Office Supplies 0.64 $54,987 ($10,450) 0.52 $44,537Other 0.09 $7,459 $0 0.09 $7,459Payroll Taxes (Direct Labor) 2.32 $198,946 $0 2.32 $198,946Shop Supplies & Small tools 0.64 $54,891 $0 0.64 $54,891Travel & Lodging & Entertainment 0.02 $1,856 $0 0.02 $1,856U.P.S./FedEx 0.02 $1,459 $0 0.02 $1,459Union Benefits/Dues 8.28 $708,954 $0 8.28 $708,954Warranty Expense 0.79 $67,456 $0 0.79 $67,456
Total Variable Costs 19.35 $1,656,943 ($38,450) 18.90 $1,618,493==== ========= ======= ==== ========
Fixed Costs:Contributions 0.03 $2,150 $0 0.03 $2,150Depreciation 1.39 $118,952 ($44,756) 0.87 $74,196Dues & Subscriptions 0.23 $19,987 $0 0.23 $19,987Insurance - Auto & Liability 4.15 $355,468 $0 4.15 $355,468Insurance - Group Health 0.17 $14,987 $0 0.17 $14,987Insurance - Officer 0.10 $8,745 $0 0.10 $8,745Payroll Tax - Office 1.66 $142,568 ($1,875) 1.64 $140,693Penison Plan 0.92 $78,954 $0 0.92 $78,954Professional Fees 0.47 $39,872 $0 0.47 $39,872Property Taxes 0.22 $18,560 $0 0.22 $18,560Rent 0.77 $65,750 $5,000 0.83 $70,750Repairs & Maintenance 0.07 $5,841 $0 0.07 $5,841Salaries - Owner 1.46 $125,000 ($13,657) 1.30 $111,343Salaries - Office/Shop 13.56 $1,161,643 $0 13.56 $1,161,643Telephone 0.11 $9,651 $0 0.11 $9,651Utilities 0.15 $13,189 $0 0.15 $13,189
Total Fixed Costs 25.47 $2,181,317 ($55,288) 24.82 $2,126,029==== ========= ======= ==== ========
Total Operating Costs 44.81 $3,838,260 ($93,738) 43.72 $3,744,522==== ========= ======= ==== ========
Johnson Mechanical Contractors 28ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
COMMENTS – ADJUSTMENTS TO INCOME STATEMENT
ADJUSTMENTS FOR YEAR: 2002
Line Item Adjusted CommentsEmployee Benefits Adjusted for excesive bonuses to employees as determined
by industry standard.
Office Supplies Adjusted to market standard from trade association survey.
Depreciation Adjusted to economic life which is estimated to be thesame as straight line depreciation.
Payroll Tax - Office Reduced to adjust for the reduction of owner's salary.
Rent The rent is adjusted because it was determined to be undermarket rates as determined by a survey of commercial realestate brokers
Salaries - Owner Adjust to industry standard via trade association survey.
Other Expense - Interest Adusted to bring the interest to "0" as part of thenormalization process.
Johnson Mechanical Contractors 29ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
STRUCTURED FINANCING SUMMARY
Source of Purchase Funds Amount Terms (yrs) Interest Mo. Payment
Financial Institution Financing:
Auto / Truck $409,934 4 7.00 $9,816Inventory $237,000 3 7.50 $7,372Machinery/Equipment $528,060 5 7.00 $10,456Office Furniture/Fixtures $98,795 3 6.50 $3,028Seller Financing $706,333 5 7.00 $13,986
Total $1,980,122 $44,658
Johnson Mechanical Contractors 30ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
Year 1
BALANCE SHEET ADJUSTMENTS SUMMARY
Actual Adjustment AdjustedYear Year YearEnding Ending Ending12-31-2004 12-31-2004 2-31-2004
CURRENT ASSETSTotal Current Assets $2,821,702 ($3,352) $2,818,350
========= ========= =========FIXED ASSETSTotal Fixed Assets $467,157 $186,000 $653,157
========= ========= =========OTHER ASSETS
Total Other Assets $35,150 $0 $35,150========= ========= =========
TOTAL ASSETS $3,324,009 $182,648 $3,506,657========= ========= ========
CURRENT LIABILITIESTotal Current Liabilities $1,067,394 $0 $1,067,394
========= ========= =========LONG TERM LIABILITIES
Total Current Liabilities $223,946 $0 $223,946========= ========= =========
TOTAL LIABILITIES $1,291,340 $0 $1,291,340========= ========= ========
NETWORTHTotal Net worth $2,032,669 $182,648 $2,215,317
========= ========= =========TOTAL LIABILITIES $3,324,009 $182,648 $3,506,657AND NETWORTH ========= ========= =========
Johnson Mechanical Contractors 31ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
BALANCE SHEET ADJUSTMENTS DETAIL
Actual Adjustment AdjustedYear Year YearEnding Ending Ending12-31-2004 12-31-2004 2-31-2004
CURRENT ASSET ADJUSTMENTSAccounts Receivable – Trade $1,718,064 ($14,852) $1,703,212Inventory $462,500 $11,500 $474,000
Total Current Assets $2,821,702 ($3,352) $2,818,350========= ========= =========
FIXED ASSET ADJUSTMENTSTotal Depreciable Assets $1,806,196 $0 $1,806,196
========= ========= =========LESS Accumulated Depreciation $1,339,039 ($186,000) $1,153,039
Net Book Value $467,157 $186,000 $653,157Total Fixed Assets $467,157 $186,000 $653,157
========= ========= =========
OTHER ASSET ADJUSTMENTSTotal Other Assets $35,150 $0 $35,150
TOTAL ASSET ADJUSTMENTS $3,324,009 $182,648 $3,506,657========= ========= =========
CURRENT LIABILITIES ADJUSTMENTSTotal Current Liabilities $1,067,394 $0 $1,067,394
========= ========= =========
LONG TERM LIABILITIES ADJUSTMENTSTotal Long Term Liabilities $223,946 $0 $223,946
========= ========= =========
TOTAL LIABILITIES $1,291,340 $0 $1,291,340========= ========= =========
NETWORTH ADJUSTMENTSOther Equities ($113,307) $182,648 $69,341
Total Networth $2,032,669 $182,648 $2,215,317========= ========= =========
Johnson Mechanical Contractors 32ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
COMMENTS – ADJUSTMENTS TO BALANCE SHEET
ADJUSTMENTS FOR YEAR: 2004
Line Item Adjusted CommentsAccounts Receiveable Adjusted for known noncollectable accounts.
Inventory Adjusted for conversion of raw materials to finished goods.
Autos & Trucks Adjusted market value = $131,727.
Machinery & Equipment Adjusted market value = $754,371.
Office Furniture / Equipment Adjusted market value = $683,223.
Less Accumulated Depreciation Total of depreciation add back.
Other Equities Adjusted to balance from asset adjustments.
Johnson Mechanical Contractors 33ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
Year 2
BALANCE SHEET ADJUSTMENTS SUMMARY
Actual Adjustment AdjustedYear Year YearEnding Ending Ending12-31-2003 12-31-2003 2-31-2003
CURRENT ASSETSTotal Current Assets $2,745,482 ($8,278) $2,737,204
========= ========= =========FIXED ASSETSTotal Fixed Assets $469,558 $150,000 $619,558
========= ========= =========OTHER ASSETS
Total Other Assets $33,392 $0 $33,392========= ========= =========
TOTAL ASSETS $3,248,432 $141,722 $3,390,154========= ========= ========
CURRENT LIABILITIESTotal Current Liabilities $1,265,734 $0 $1,265,734
========= ========= =========LONG TERM LIABILITIES
Total Current Liabilities $475,353 $0 $475,353========= ========= =========
TOTAL LIABILITIES $1,741,087 $0 $1,741,087========= ========= ========
NETWORTHTotal Net worth $1,507,345 $66,722 $1,574,067
========= ========= =========TOTAL LIABILITIES $3,248,432 $66,722 $3,315,154AND NETWORTH ========= ========= =========
Johnson Mechanical Contractors 34ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
BALANCE SHEET ADJUSTMENTS DETAIL
Actual Adjustment AdjustedYear Year YearEnding Ending Ending12-31-2003 12-31-2003 2-31-2003
CURRENT ASSET ADJUSTMENTSAccounts Receivable – Trade $1,685,145 ($16,842) $1,668,303Inventory $478,956 $8,564 $487,520
Total Current Assets $2,745,482 ($8,278) $2,737,204========= ========= =========
FIXED ASSET ADJUSTMENTSTotal Depreciable Assets $1,686,612 $0 $1,686,612
========= ========= =========LESS Accumulated Depreciation $1,217,054 ($150,000) $1,067,054
Net Book Value $469,558 $150,000 $619,558Total Fixed Assets $469,558 $150,000 $619,558
========= ========= =========
OTHER ASSET ADJUSTMENTSTotal Other Assets $33,392 $0 $33,392
TOTAL ASSET ADJUSTMENTS $3,248,432 $141,722 $3,390,154========= ========= =========
CURRENT LIABILITIES ADJUSTMENTSTotal Current Liabilities $1,265,734 $0 $1,265,734
========= ========= =========
LONG TERM LIABILITIES ADJUSTMENTSTotal Long Term Liabilities $475,353 $0 $475,353
========= ========= =========
TOTAL LIABILITIES $1,741,087 $0 $1,741,087========= ========= =========
NETWORTH ADJUSTMENTSOther Equities ($75,000) $66,722 ($8,278)
Total Networth $1,507,345 $66,722 $1,574,067========= ========= =========
Johnson Mechanical Contractors 35ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
COMMENTS – ADJUSTMENTS TO BALANCE SHEET
ADJUSTMENTS FOR YEAR: 2003
Line Item Adjusted CommentsAccounts Receiveable Adjusted for known noncollectable accounts.
Inventory Adjusted for conversion of raw materials to finished goods.
Autos & Trucks Adjusted market value = $645,560
Machinery & Equipment Adjusted market value = $699,613
Office Furniture / Equipment Adjusted market value = $140,564.
Less Accumulated Depreciation Total of depreciation add back.
Other Equities Adjusted to balance from asset adjustments.
Johnson Mechanical Contractors 36ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
Year 3
BALANCE SHEET ADJUSTMENTS SUMMARY
Actual Adjustment AdjustedYear Year YearEnding Ending Ending12-31-2002 12-31-2002 2-31-2002
CURRENT ASSETSTotal Current Assets $2,630,000 ($4,739) $2,625,261
========= ========= =========FIXED ASSETSTotal Fixed Assets $470,190 $137,000 $607,190
========= ========= =========OTHER ASSETS
Total Other Assets $31,723 $0 $31,723========= ========= =========
TOTAL ASSETS $3,131,913 $132,261 $3,264,174========= ========= ========
CURRENT LIABILITIESTotal Current Liabilities $1,469,830 $0 $1,469,830
========= ========= =========LONG TERM LIABILITIES
Total Current Liabilities $607,246 $0 $607,246========= ========= =========
TOTAL LIABILITIES $2,077,076 $0 $2,077,076========= ========= ========
NETWORTHTotal Net worth $1,054,837 $63,811 $1,118,648
========= ========= =========TOTAL LIABILITIES $3,131,913 $63,811 $3,195,724AND NETWORTH ========= ========= =========
Johnson Mechanical Contractors 37ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
BALANCE SHEET ADJUSTMENTS DETAIL
Actual Adjustment AdjustedYear Year YearEnding Ending Ending12-31-2002 12-31-2002 2-31-2002
CURRENT ASSET ADJUSTMENTSAccounts Receivable – Trade $1,675,896 ($12,589) $1,663,307Inventory $435,666 $7,850 $443,516
Total Current Assets $2,630,000 ($4,739) $2,625,261========= ========= =========
FIXED ASSET ADJUSTMENTSTotal Depreciable Assets $1,567,660 $0 $1,567,660
========= ========= =========LESS Accumulated Depreciation $1,097,470 ($137,000) $960,470
Net Book Value $470,190 $137,000 $607,190Total Fixed Assets $470,190 $137,000 $607,190
========= ========= =========
OTHER ASSET ADJUSTMENTSTotal Other Assets $31,723 $0 $31,723
TOTAL ASSET ADJUSTMENTS $3,131,913 $132,261 $3,264,174========= ========= =========
CURRENT LIABILITIES ADJUSTMENTSTotal Current Liabilities $1,469,830 $0 $1,469,830
========= ========= =========
LONG TERM LIABILITIES ADJUSTMENTSTotal Long Term Liabilities $607,246 $0 $607,246
========= ========= =========
TOTAL LIABILITIES $2,077,076 $0 $2,077,076========= ========= =========
NETWORTH ADJUSTMENTSOther Equities ($60,000) $63,811 $3,811
Total Networth $1,054,837 $63,811 $1,118,648========= ========= =========
Johnson Mechanical Contractors 38ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
COMMENTS – ADJUSTMENTS TO BALANCE SHEET
ADJUSTMENTS FOR YEAR: 2002
Line Item Adjusted CommentsAccounts Receiveable Adjusted for known noncollectable accounts.
Inventory Adjusted for conversion of raw materials to finished goods.
Autos & Trucks Adjusted market value = $606,856.
Machinery & Equipment Adjusted market value = $639,740.
Office Furniture / Equipment Adjusted market value = $133,189.
Less Accumulated Depreciation Total of depreciation add back.
Other Equities Adjusted to balance from asset adjustments.
Johnson Mechanical Contractors 39ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
PROFORMA FIRST YEAR FINANCIAL BUDGET SUMMARY
HYPOTHETICAL TERMS OF ASSET SALE AT CALCULATED MARKET VALUE
Budget Assumptions:Sales Increase = 3%Price Increase = 1.5%
BudgetYear Ending
% 12/31/05INCOME:
Sales 100 $9,635,585Total Income 100 $9,635,585
===== =========Cost of Goods Sold:Direct Costs - Labor 22.86 $2,202,748Direct Costs - Materials 23.49 $2,263,423Direct Costs - Equipment 0.20 $19,125Direct Costs - Subcontractor 2.66 $256,445Direct Costs - Other 1.11 $106,963
—— ————
Total Cost of Goods Sold 50.32 $4,848,704===== =========
GROSS PROFIT 49.68 $4,786,881(Total Income less COS) ===== =========
LESS: OPERATING COSTSTotal Variable Costs 18.52 $1,784,498
(See detail schedule on next page) —— ————
Fixed CostsTotal Fixed Costs 24.92 $2,401,453
(See detail schedule on next page) —— ————
Total Operating Costs(Fixed Costs plus Variable Costs)
Total Operating Costs 43.44 $4,185,951==== =========
Other Income (Expenses)Total Other Income (Expenses) 1.06 $13,470
(See detail schedule on next page)
BUDGET- NET OPERATING INCOME 6.38 $614,401==== =========
Johnson Mechanical Contractors 40ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
PROFORMA FIRST YEAR FINANCIAL BUDGET DETAIL
HYPOTHETICAL TERMS OF ASSET SALE AT CALCULATED MARKET VALUE
BudgetYear Ending
% 12/31/05
Variable Costs:Advertising & Promotion 0.76 $73,537Auto & Truck Gas, Oil, Repairs 2.02 $194,866Bad Debt 0.30 $28,541Bank Charges 0.10 $9,908Employee Benefits 2.23 $214,934Freight 0.21 $20,125Insurance - W. C. Direct Labor 0.90 $86,593Laundry, Cleaning 0.09 $8,905License & Permits 0.06 $5,907Miscellaneous 0.00 $431Office Supplies 0.63 $60,229Other 0.09 $8,254Payroll Taxes (Direct Labor) 2.12 $204,739Shop Supplies & Small tools 0.61 $58,763Travel & Lodging & Entertainme 0.02 $2,167U.P.S./FedEx 0.02 $1,917Union Benefits/Dues 7.60 $731,827Warranty Expense 0.76 $72,854—— ————
Total Variable Costs 18.52 $1,784,498===== ========
Fixed Costs:Contributions 0.03 $2,434Depreciation 1.27 $121,985Dues & Subscriptions 0.22 $20,867Insurance - Auto & Liability 4.16 $400,543Insurance - Group Health 0.16 $15,248Insurance - Officer 0.09 $8,981Payroll Taxes - Office 1.56 $150,100Penison Plan 0.84 $81,028Professional Fees 0.67 $64,435Property Taxes 0.22 $21,151Rent 0.72 $69,665Repairs & Maintenance 0.05 $4,409Salaries - Owner 1.50 $145,000Salaries - Office/Shop 13.20 $1,271,647Telephone 0.10 $9,960Utilities 0.15 $14,000—— ————
Total Fixed Costs 24.92 $2,401,453===== ========
Total Operating Costs 43.44 $4,185,951===== ========
Other Income (Expenses):Other Income 0.60 $57,630Other Expense - Interest 0.46 $44,159
Total Other Income (Expenses) 1.06 $13,470===== ========
Johnson Mechanical Contractors 41ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
COMMENTS – ADJUSTMENTS TO BUDGET
ADJUSTMENTS FOR YEAR: 2004
Line Item Adjusted Comments ________Insurance - Auto & Liability Received insurance quotes to show actual amount to expect
for the year.
Payroll Taxes - Office Adjusted to compensate for increase in payroll.
Property Taxes Notifications were received advising of property taxincreases.
Salaries - Office/Shop Salary increase due to the need to add an individual tocompensate for increased sales volumes.
Johnson Mechanical Contractors 42ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
PROFORMA FIRST YEAR FINANCIAL BUDGET DETAIL Q1
M1 % Amount M2 % Amount M3 % AmountIncome:
7.59 $731,341 9.39 $904,781 6.65 $640,766==== ===== ==== ===== ==== =====
Cost of Goods Sold:Direct Costs - Labor 22.86 $167,189 22.86 $206,838 22.86 $146,483Direct Costs - Materials 23.49 $171,794 23.49 $212,535 23.49 $150,518Direct Costs - Equipment 0.20 $1,452 0.20 $1,796 0.20 $1,272Direct Costs - Subcontractor 2.66 $19,464 2.66 $24,080 2.66 $17,054Direct Costs - Other 1.11 $8,118 1.11 $10,044 1.11 $7,113
—— ——— —— ——— —— ———Total Cost of Goods Sold 50.32 $368,017 50.32 $455,293 50.32 $322,440
==== ===== ==== ===== ==== =====Gross Profit 49.68 $363,324 49.68 $449,488 49.68 $318,326
==== ===== ==== ===== ==== =====Variable Costs:Advertising & Promotion 0.76 $5,581 0.76 $6,905 0.76 $4,890Auto & Truck Gas, Oil, Repairs 2.02 $14,790 2.02 $18,298 2.02 $12,959Bad Debt 0.30 $2,166 0.30 $2,680 0.30 $1,898Bank Charges 0.10 $752 0.10 $930 0.10 $659EmployeeBenefits 2.23 $16,313 2.23 $20,182 2.23 $14,293Freight 0.21 $1,527 0.21 $1,890 0.21 $1,338Insurance - W. C. Direct Labor 0.90 $6,572 0.90 $8,131 0.90 $5,758Laundry, Cleaning 0.09 $676 0.09 $836 0.09 $592License & Permits 0.06 $448 0.06 $555 0.06 $393Miscellaneous 0.00 $33 0.00 $40 0.00 $29Office Supplies 0.63 $4,571 0.63 $5,656 0.63 $4,005Other 0.09 $626 0.09 $775 0.09 $549Payroll Taxes (Direct Labor) 2.12 $15,540 2.12 $19,225 2.12 $13,615Rentals 0.00 $0 0.00 $0 0.00 $0Sales Commissions 0.00 $0 0.00 $0 0.00 $0Sales Tax Expense 0.00 $0 0.00 $0 0.00 $0Shop Supplies & Small tools 0.61 $4,460 0.61 $5,518 0.61 $3,908Travel & Lodging & Entertainme 0.02 $164 0.02 $203 0.02 $144U.P.S./FedEx 0.02 $146 0.02 $180 0.02 $127Union Benefits/Dues 7.60 $55,546 7.60 $68,719 7.60 $48,666Warranty Expense 0.76 $5,530 0.76 $6,841 0.76 $4,845
—— ——— —— ——— —— ———Total Variable Costs 18.52 $135,441 18.52 $167,564 18.52 $118,668
==== ===== ==== ===== ==== =====Fixed Costs:Contributions 0.03 $203 0.02 $203 0.03 $203Depreciation 1.39 $10,165 1.12 $10,165 1.59 $10,165Dues & Subscriptions 0.24 $1,739 0.19 $1,739 0.27 $1,739Insurance - Auto & Liability 4.56 $33,379 3.69 $33,379 5.21 $33,379Insurance - Group Health 0.17 $1,271 0.14 $1,271 0.20 $1,271Insurance - Officer 0.10 $748 0.08 $748 0.12 $748Insurance - WC Office 0.00 $0 0.00 $0 0.00 $0Payroll Taxes - Office 1.71 $12,508 1.38 $12,508 1.95 $12,508Penison Plan 0.92 $6,752 0.75 $6,752 1.05 $6,752Postage, Mailings 0.00 $0 0.00 $0 0.00 $0Professional Fees 0.73 $5,370 0.59 $5,370 0.84 $5,370Property Taxes 0.24 $1,763 0.19 $1,763 0.28 $1,763Rent 0.79 $5,805 0.64 $5,805 0.91 $5,805Repairs & Maintenance 0.05 $367 0.04 $367 0.06 $367Salaries - Owner 1.65 $12,083 1.34 $12,083 1.89 $12,083Salaries - Office/Shop 14.49 $105,971 11.71 $105,971 16.54 $105,971Telephone 0.11 $830 0.09 $830 0.13 $830Utilities 0.16 $1,167 0.13 $1,167 0.18 $1,167
—— ——— —— ——— —— ———Total Fixed Costs 27.34 $200,121 22.1 $200,121 31.25 $200,121
==== ===== ==== ===== ==== =====Total Operating Costs 45.88 $335,562 40.64 $367,685 49.75 $318,789
==== ===== ==== ===== ==== =====Other Income (Expenses):Other Income 0.60 $4,374 0.60 $5,411 0.60 $3,832Other Expense– Interest 0.46 $3,352 0.46 $4,147 0.46
$2,937Other Expense 0.00 $0 0.00 $0 0.00 $0
Total Other Income (Expenses) 0.14 $1,022 0.14 $1,264 0.14 $895==== ===== ==== ===== ==== =====
BUDGET– NET OPERATING INCOME 3.94 $28,784 9.18 $83,067 0.07 $432==== ===== ==== ===== ==== =====
Johnson Mechanical Contractors 43ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
PROFORMA FIRST YEAR FINANCIAL BUDGET DETAIL Q2
M4 % Amount M5 % Amount M6 % AmountIncome:
8.11 $781,446 8.30 $799,754 10.31 $993,429==== ===== ==== ===== ==== =====
Cost of Goods Sold:Direct Costs - Labor 22.86 $178,643 22.86 $182,828 22.86 $227,103Direct Costs - Materials 23.49 $183,564 23.49 $187,864 23.49 $233,359Direct Costs - Equipment 0.20 $1,551 0.20 $1,587 0.20 $1,972Direct Costs - Subcontractor 2.66 $20,798 2.66 $21,285 2.66 $26,439Direct Costs - Other 1.11 $8,675 1.11 $8,878 1.11 $11,028
—— ——— —— ——— —— ———Total Cost of Goods Sold 50.32 $393,231 50.32 $402,442 50.32 $499,901
==== ===== ==== ===== ==== =====Gross Profit 49.68 $388,215 49.68 $397,312 49.68 $493,528
==== ===== ==== ===== ==== =====Variable Costs:Advertising & Promotion 0.76 $5,964 0.76 $6,104 0.76 $7,582Auto & Truck Gas, Oil, Repairs 2.02 $15,804 2.02 $16,174 2.02 $20,091Bad Debt 0.30 $2,315 0.30 $2,369 0.30 $2,943Bank Charges 0.10 $804 0.10 $822 0.10 $1,022Employee Benefits 2.23 $17,431 2.23 $17,840 2.23 $22,160Freight 0.21 $1,632 0.21 $1,670 0.21 $2,075Insurance - W. C. Direct Labor 0.90 $7,023 0.90 $7,187 0.90 $8,928Laundry, Cleaning 0.09 $722 0.09 $739 0.09 $918License & Permits 0.06 $479 0.06 $490 0.06 $609Miscellaneous 0.00 $35 0.00 $36 0.00 $44Office Supplies 0.63 $4,885 0.63 $4,999 0.63 $6,210Other 0.09 $669 0.09 $685 0.09 $851Payroll Taxes (Direct Labor) 2.12 $16,604 2.12 $16,993 2.12 $21,109Rentals 0.00 $0 0.00 $0 0.00 $0Sales Commissions 0.00 $0 0.00 $0 0.00 $0Sales Tax Expense 0.00 $0 0.00 $0 0.00 $0Shop Supplies & Small tools 0.61 $4,766 0.61 $4,877 0.61 $6,058Travel & Lodging & Entertainme 0.02 $176 0.02 $180 0.02 $223U.P.S./FedEx 0.02 $155 0.02 $159 0.02 $198Union Benefits/Dues 7.60 $59,351 7.60 $60,742 7.60 $75,451Warranty Expense 0.76 $5,908 0.76 $6,047 0.76 $7,511
—— ——— —— ——— —— ———Total Variable Costs 18.52 $144,723 18.52 $148,113 18.52 $183,983
==== ===== ==== ===== ==== =====Fixed Costs:Contributions 0.03 $203 0.03 $203 0.02 $203Depreciation 1.30 $10,165 1.27 $10,165 1.02 $10,165Dues &Subscriptions 0.22 $1,739 0.22 $1,739 0.18 $1,739Insurance - Auto & Liability 4.27 $33,379 4.17 $33,379 3.36 $33,379Insurance - Group Health 0.16 $1,271 0.16 $1,271 0.13 $1,271Insurance - Officer 0.10 $748 0.09 $748 0.08 $748Insurance - WC Office 0.00 $0 0.00 $0 0.00 $0Payroll Taxes - Office 1.60 $12,508 1.56 $12,508 1.26 $12,508Penison Plan 0.86 $6,752 0.84 $6,752 0.68 $6,752Postage, Mailings 0.00 $0 0.00 $0 0.00 $0Professional Fees 0.69 $5,370 0.67 $5,370 0.54 $5,370Property Taxes 0.23 $1,763 0.22 $1,763 0.18 $1,763Rent 0.74 $5,805 0.73 $5,805 0.58 $5,805Repairs & Maintenance 0.05 $367 0.05 $367 0.04 $367Salaries - Owner 1.55 $12,083 1.51 $12,083 1.22 $12,083Salaries - Office/Shop 13.56 $105,971 13.25 $105,971 10.67 $105,971Telephone 0.11 $830 0.10 $830 0.08 $830Utilities 0.15 $1,167 0.15 $1,167 0.12 $1,167
—— ——— —— ——— —— ———Total Fixed Costs 25.62 $200,121 25.02 $200,121 20.16 $200,121
==== ===== ==== ===== ==== =====Total Operating Costs 44.13 $344,844 43.54 $348,234 38.66 $384,104
==== ===== ==== ===== ==== =====Other Income (Expenses):Other Income 0.60 $4,674 0.60 $4,783 0.60 $5,942Other Expense– Interest 0.46 $3,581 0.46 $3,665 0.46
$4,553Other Expense 0.00 $0 0.00 $0 0.00 $0
Total Other Income (Expenses) 0.14 $1,093 0.14 $1,118 0.14 $1,389==== ===== ==== ===== ==== =====
BUDGET– NET OPERATING INCOME 5.69 $44,464 6.28 $50,196 11.15 $110,813==== ===== ==== ===== ==== =====
Johnson Mechanical Contractors 44ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
PROFORMA FIRST YEAR FINANCIAL BUDGET DETAIL Q3
M7 % Amount M8% Amount M9 % AmountIncome:
8.27 $796,863 8.95 $862,385 6.11 $588,734==== ===== ==== ===== ==== =====
Cost of Goods Sold:Direct Costs - Labor 22.86 $182,167 22.86 $197,146 22.86 $134,588Direct Costs - Materials 23.49 $187,185 23.49 $202,576 23.49 $138,295Direct Costs - Equipment 0.20 $1,582 0.20 $1,712 0.20 $1,169Direct Costs - Subcontractor 2.66 $21,208 2.66 $22,952 2.66 $15,669Direct Costs - Other 1.11 $8,846 1.11 $9,573 1.11 $6,535
—— ——— —— ——— —— ———Total Cost of Goods Sold 50.32 $400,988 50.32 $433,959 50.32 $296,256
==== ===== ==== ===== ==== =====Gross Profit 49.68 $395,875 49.68 $428,426 49.68 $292,478
==== ===== ==== ===== ==== =====Variable Costs:Advertising & Promotion 0.76 $6,082 0.76 $6,582 0.76 $4,493Auto & Truck Gas, Oil, Repairs 2.02 $16,115 2.02 $17,441 2.02 $11,906Bad Debt 0.30 $2,360 0.30 $2,554 0.30 $1,744Bank Charges 0.10 $819 0.10 $887 0.10 $605Employee Benefits 2.23 $17,775 2.23 $19,237 2.23 $13,132Freight 0.21 $1,664 0.21 $1,801 0.21 $1,230Insurance - W. C. Direct Labor 0.90 $7,161 0.90 $7,750 0.90 $5,291Laundry, Cleaning 0.09 $736 0.09 $797 0.09 $544License & Permits 0.06 $489 0.06 $529 0.06 $361Miscellaneous 0.00 $36 0.00 $39 0.00 $26Office Supplies 0.63 $4,981 0.63 $5,390 0.63 $3,680Other 0.09 $683 0.09 $739 0.09 $504Payroll Taxes (Direct Labor) 2.12 $16,932 2.12 $18,324 2.12 $12,510Rentals 0.00 $0 0.00 $0 0.00 $0Sales Commissions 0.00 $0 0.00 $0 0.00 $0Sales Tax Expense 0.00 $0 0.00 $0 0.00 $0Shop Supplies & Small tools 0.61 $4,860 0.61 $5,259 0.61 $3,590Travel & Lodging & Entertainme 0.02 $179 0.02 $194 0.02 $132U.P.S./FedEx 0.02 $159 0.02 $172 0.02 $117Union Benefits/Dues 7.60 $60,522 7.60 $65,499 7.60 $44,715Warranty Expense 0.76 $6,025 0.76 $6,520 0.76 $4,451
—— ——— —— ——— —— ———Total Variable Costs 18.52 $147,578 18.52 $159,714 18.52 $109,031
==== ===== ==== ===== ==== =====Fixed Costs:Contributions 0.03 $203 0.02 $203 0.03 $203Depreciation 1.28 $10,165 1.18 $10,165 1.73 $10,165Dues & Subscriptions 0.22 $1,739 0.20 $1,739 0.30 $1,739Insurance - Auto & Liability 4.19 $33,379 3.87 $33,379 5.67 $33,379Insurance - Group Health 0.16 $1,271 0.15 $1,271 0.22 $1,271Insurance - Officer 0.09 $748 0.09 $748 0.13 $748Insurance - WC Office 0.00 $0 0.00 $0 0.00 $0Payroll Taxes - Office 1.57 $12,508 1.45 $12,508 2.12 $12,508Penison Plan 0.85 $6,752 0.78 $6,752 1.15 $6,752Postage, Mailings 0.00 $0 0.00 $0 0.00 $0Professional Fees 0.67 $5,370 0.62 $5,370 0.91 $5,370Property Taxes 0.22 $1,763 0.20 $1,763 0.30 $1,763Rent 0.73 $5,805 0.67 $5,805 0.99 $5,805Repairs & Maintenance 0.05 $367 0.04 $367 0.06 $367Salaries - Owner 1.52 $12,083 1.40 $12,083 2.05 $12,083Salaries - Office/Shop 13.30 $105,971 12.29 $105,971 18.00 $105,971Telephone 0.10 $830 0.10 $830 0.14 $830Utilities 0.15 $1,167 0.14 $1,167 0.20 $1,167
—— ——— —— ——— —— ———Total Fixed Costs 25.13 $200,121 23.2 $200,121 34 $200,121
==== ===== ==== ===== ==== =====Total Operating Costs 43.63 $347,699 41.73 $359,835 52.51 $309,152
==== ===== ==== ===== ==== =====Other Income (Expenses):Other Income 0.60 $4,766 0.60 $5,158 0.60 $3,521Other Expense– Interest 0.46 $3,652 0.46 $3,952 0.46
$2,698Other Expense 0.00 $0 0.00 $0 0.00 $0
Total Other Income (Expenses) 0.14 $1,114 0.14 $1,206 0.14 $823==== ===== ==== ===== ==== =====
BUDGET– NET OPERATING INCOME 6.19 $49,290 8.09 $69,797 -2.69 ($15,851)==== ===== ==== ===== ==== =====
Johnson Mechanical Contractors 45ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
PROFORMA FIRST YEAR FINANCIAL BUDGET DETAIL Q4
M10 % Amount M11 % Amount M12% AmountIncome:
9.81 $945,251 7.59 $713,997 9.1 $876,838==== ===== ==== ===== ==== =====
Cost of Goods Sold:Direct Costs - Labor 22.86 $216,090 22.86 $163,224 22.86 $200,450Direct Costs - Materials 23.49 $222,042 23.49 $167,720 23.49 $205,971Direct Costs - Equipment 0.20 $1,876 0.20 $1,417 0.20 $1,740Direct Costs - Subcontractor 2.66 $25,157 2.66 $19,003 2.66 $23,336Direct Costs - Other 1.11 $10,493 1.11 $7,926 1.11 $9,734
—— ——— —— ——— —— ———Total Cost of Goods Sold 50.32 $475,658 50.32 $359,290 50.32 $441,231
==== ===== ==== ===== ==== =====Gross Profit 49.68 $469,593 49.68 $354,707 49.68 $435,607
==== ===== ==== ===== ==== =====Variable Costs:Advertising & Promotion 0.76 $7,214 0.76 $5,449 0.76 $6,692Auto & Truck Gas, Oil, Repairs 2.02 $19,116 2.02 $14,440 2.02 $17,733Bad Debt 0.30 $2,800 0.30 $2,115 0.30 $2,597Bank Charges 0.10 $972 0.10 $734 0.10 $902Employee Benefits 2.23 $21,085 2.23 $15,927 2.23 $19,559Freight 0.21 $1,974 0.21 $1,491 0.21 $1,831Insurance - W. C. Direct Labor 0.90 $8,495 0.90 $6,417 0.90 $7,880Laundry, Cleaning 0.09 $874 0.09 $660 0.09 $810License & Permits 0.06 $579 0.06 $438 0.06 $538Miscellaneous 0.00 $42 0.00 $32 0.00 $39Office Supplies 0.63 $5,908 0.63 $4,463 0.63 $5,481Other 0.09 $810 0.09 $612 0.09 $751Payroll Taxes (Direct Labor) 2.12 $20,085 2.12 $15,171 2.12 $18,631Rentals 0.00 $0 0.00 $0 0.00 $0Sales Commissions 0.00 $0 0.00 $0 0.00 $0Sales Tax Expense 0.00 $0 0.00 $0 0.00 $0Shop Supplies & Small tools 0.61 $5,765 0.61 $4,354 0.61 $5,347Travel & Lodging & Entertainme 0.02 $213 0.02 $161 0.02 $197U.P.S./FedEx 0.02 $188 0.02 $142 0.02 $174Union Benefits/Dues 7.60 $71,792 7.60 $54,228 7.60 $66,596Warranty Expense 0.76 $7,147 0.76 $5,398 0.76 $6,630
—— ——— —— ——— —— ———Total Variable Costs 18.52 $175,059 18.52 $132,232 18.52 $162,388
==== ===== ==== ===== ==== =====Fixed Costs:Contributions 0.02 $203 0.03 $203 0.02 $203Depreciation 1.08 $10,165 1.42 $10,165 1.16 $10,165Dues & Subscriptions 0.18 $1,739 0.24 $1,739 0.20 $1,739Insurance - Auto & Liability 3.53 $33,379 4.67 $33,379 3.81 $33,379Insurance - Group Health 0.13 $1,271 0.18 $1,271 0.14 $1,271Insurance - Officer 0.08 $748 0.10 $748 0.09 $748Insurance - WC Office 0.00 $0 0.00 $0 0.00 $0Payroll Taxes - Office 1.32 $12,508 1.75 $12,508 1.43 $12,508Penison Plan 0.71 $6,752 0.95 $6,752 0.77 $6,752Postage, Mailings 0.00 $0 0.00 $0 0.00 $0Professional Fees 0.57 $5,370 0.75 $5,370 0.61 $5,370Property Taxes 0.19 $1,763 0.25 $1,763 0.20 $1,763Rent 0.61 $5,805 0.81 $5,805 0.66 $5,805Repairs & Maintenance 0.04 $367 0.05 $367 0.04 $367Salaries - Owner 1.28 $12,083 1.69 $12,083 1.38 $12,083Salaries - Office/Shop 11.21 $105,971 14.84 $105,971 12.09 $105,971Telephone 0.09 $830 0.12 $830 0.09 $830Utilities 0.12 $1,167 0.16 $1,167 0.13 $1,167
—— ——— —— ——— —— ———Total Fixed Costs 21.16 $200,121 28.01 $200,121 22.82 $200,121
==== ===== ==== ===== ==== =====Total Operating Costs 39.69 $375,180 46.55 $332,353 41.34 $362,509
==== ===== ==== ===== ==== =====Other Income (Expenses):Other Income 0.60 $5,654 0.60 $4,270 0.60 $5,244Other Expense – Interest 0.46 $4,332 0.46 $3,272 0.46
$4,018Other Expense 0.00 $0 0.00 $0 0.00 $0
Total Other Income (Expenses) 0.14 $1,322 0.14 $998 0.14 $1,226==== ===== ==== ===== ==== =====
BUDGET– NET OPERATING INCOME 10.13 $95,735 3.27 $23,352 8.48 $74,324==== ===== ==== ===== ==== =====
Johnson Mechanical Contractors 46ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
DEFINITION OF MARKET VALUE
The market value is the most probable price that a business should bring in a competitive
and open market under all conditions necessary for a fair sale presuming the buyer and
seller each act prudently, knowledgeably, and assuming the price is not affected by undue
stimuli. Implicit in this definition the consummation of a sale as of a specified date and
the title from seller to buyer under condition by:
1. Buyer and seller are typically motivated.
2. Both parties are well informed or well advised and each of them is acting in what
one considers one’s own best interests.
3. A reasonable time is allowed for exposure in the open market.
4. Payment is made in terms of cash of the same currency which the business has
adopted as their accounting standard or in terms of financial arrangements
comparable thereto.
5. The price represents the normal consideration for the business sold unaffected by
special or creative financing or sales concessions granted by anyone associated
with the sale.
A fair market transaction must be a “win-win” for all parties concerned. The fair market
value of a going business, in its specific market, is that value where the normalized
spendable income stream of the business can accomplish three criteria.
1. It must be able to support the structured debt service that is created from the
business sale.
2. It must be able to pay the owner a fair salary as determined by the size, type and
location of the business to current market standards.
3. It must be able to pay the owner a fair return on their investment as determined by
current market standards.
Johnson Mechanical Contractors 47ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
47
STATEMENT OF LIMITING CONDITIONS
1. The establishing of the fair market value of this business is not based in whole or
in part upon: the race, color, sex or national origin of the prospective owners or
occupants of the business evaluated; or upon the race, color, sex or national origin
of the present owners or occupants of the businesses in the vicinity of the business
evaluated.
2. The evaluator has personally inspected the business, both inside and out.
3. To the best of the evaluator’s knowledge and belief, all statements and
information in this report are true and correct and the evaluator has not knowingly
withheld any significant information.
4. This evaluation has been made in conformity with the use of good, common
accepted business and accounting practices.
5. The evaluator has relied upon the representations made to him/her by the owners
and/or management of the subject business. All information, where possible, has
been verified by the evaluator. The information, although not guaranteed by the
evaluator, has been compiled from sources we believe reliable.
6. The evaluator has used financial sources such as the business’ tax forms to assure
the accuracy of this report. These forms are signed by the owner and/or
management of the business certifying to the government that it is a true and
accurate representation of the financial condition of the business.
Johnson Mechanical Contractors 48ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
48
7. The evaluator has mathematically compiled the final opinion of value through the
use of commonly accepted accounting practices. The evaluator assumes no
liability in the determining of this value.
8. This analysis cannot be duplicated or otherwise copied in whole or in part without
the permission of the evaluator.
9. It is understood that the evaluator is not required to give testimony or appear in
court because of having made this evaluation with reference to the business in
question, unless arrangements have been previously make.
10. This is a sample insert for the evaluator limiting conditions to show the location of the
insert in this sample business analysis/valuation sample report.
Johnson Mechanical Contractors 49ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
49
VALUATION TECHNIQUES (METHODOLOGIES)
This evaluation has not used some of the industries’ typical valuation techniques because
of their commonly known inaccuracy. One of the major problems with using the different
techniques listed below is that the price they establish gives no guarantee or even a
probable chance that the evaluated business will be able to support the debt service which
the sale has created. If the debt service payments cannot be made, there is certainly no
chance of profit, even in companies that were profitable before the sale. Some evaluators
believe that if you use more than one of these techniques you can then average them for a
more accurate answer. This is just not true. A list of these valuation techniques and the
reasons for their inherent inaccuracy are provided below.
CAPITALIZATION OF EARNINGS
This approach is an income approach where the earnings of the business are capitalized
into the total value. The accuracy of this technique is dependent upon the evaluator being
able to accurately select at rate of return that reflects both the tangible and the intangible
assets of the business. The more stable the business’ income stream, the lower he
capitalization rate. If the income stream is more speculative, the capitalization rate is
higher. The technique also applies a weighted average and a division factor to the
earnings of those years analyzed. Since a small discrepancy in the arbitrary selection of
the factor of the rate of return can adversely affect the business’ value by many thousands
of dollars, it was not used for this evaluation.
PRICE TO EARNING (P/E) RATIO APPROACH
The users of this approach believe that the value of a business is determined according to
a relationship that the selling price of common stocks in publicly-owned and traded
companies has to the annual earnings of these companies. One of the shortcomings here
is that this ratio is determined from the sale of smaller “blocks” of stock, a much different
situation than purchasing 100% of a company or even a controlling share. Many times,
the P/E ratio within an industry increases or decreases for reasons not associated with the
Johnson Mechanical Contractors 50ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
50
industry but rather due to other market conditions (such as political circumstances of the
time). These factors could seriously distort the value of the business. For these reasons,
this technique cannot be considered accurate.
DISCOUNTED FUTURE EARNINGS APPROACH
This valuation approach establishes the market value of a business by projecting the
value of its future cash flows and then discounting them back to their present value. This
approach relies on the evaluator’s ability to perform two almost impossible tasks. First,
the evaluator must be able to accurately project future cash flows for periods as distant as
ten years. Second, the evaluator must establish a realistic discount value to apply to these
future cash flows. These can only be considered as “educated guesses”, not an acceptable
accurate valuation technique.
COST TO CREATE APPROACH
With this approach, an examination of the subject business’ records will show us what
was the actual cost to create (start) the business. This cost includes organizational costs,
assemblage of personal costs, acquisition of lease or real estate costs, assemblage of fixed
assets costs, development of intangible (goodwill) costs and the costs of the net tangible
assets. This method requires the summation of all of these costs. There are many
problems with this approach with the biggest being the reality of having an accurate way
to figure the intangible costs; it is simply impossible to accurately calculate and therefore
makes this technique inaccurate.
ECONOMIC MULTIPLES OF VALUE APPROACH
The economic multiples approach is simply the use of “market” originated multiples that
are multiplied to different areas of a business’ financial statement. An example of this
would be that hotels and motels “should” sell for between 3 and 4 times their gross sales.
There is no accuracy when using multiples. No one knows from where they came or how
they were created. A range of multiples such as the example given above can show a
difference in the market value (selling price) of tens and even hundreds of thousands of
Johnson Mechanical Contractors 51ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
51
dollars. Therefore, this valuation technique cannot be considered accurate enough for this
analysis.
THE RULES OF THUMB APPROACH
This approach closely resembles the “Multiples” approach. Over a period of time,
different industry shortcuts for valuation are created. One example of this would be that
taverns are “supposed” to sell for $10,000 per bar stool. If the seller wants to increase the
value, why not just add some more bar stools? From this example one can see how even
the slightest difference in the number will affect the final valuation by many thousands of
dollars.
BALANCE SHEET (SUMMATION OF ASSETS) APPROACH
In this approach the value of a business is established by the summation of the market
value of its assets. In it, the current market value of all of the business’ assets, including
the intangibles, are totaled to arrive at the total market value for the business. Upon
inspection of the balance sheet, the intangibles (also known as goodwill) may or may not
be found. If an established value for goodwill was carried over from the allocation of the
selling price from a prior sale, the goodwill can not be depreciated and remains on the
balance sheet without change. If there was not a prior sale, none is listed. How can you
verify the value of goodwill if it is listed? How do you establish the value of goodwill if it
is not listed? Since the fair market of “goodwill” cannot be substantiated, the total value
arrived at by this approach is distorted to an unacceptable level.
Johnson Mechanical Contractors 52ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
52
EVALUATOR’S COMMENTS
The business valuation in this study is an evaluation of the subject business as a going
business only. This valuation is not an appraisal of the individual parts making up this
business, but rather an evaluation of how the individual parts work together to create
the spendable cash flows that form it into a going business.
In this evaluation it is not the evaluator’s intention to determine if the integral parts
that make up this business are being used for their best or highest income producing
value. It is an evaluation of the income that they are creating. The market values of
those individual assets that can be used as collateral to support the structured business
loans are only considered. If the business’ value as an existing business is less than
the current market value of its parts, the parts should then be sold separately for their
higher value.
A business is worth that price at which it will support its structured debt service and
pay a fair salary to the owner along with a fair return on the owner’s investment. This
evaluation considers all of these criteria using the listed existing market variables of
interest rates, loan terms, rent factors, wage rates and other factors as listed under the
attached schedule entitled “Market Variables Used in Analysis”. Mathematically,
under these existing variables, there is only ONE business value that will allow the
business to meet these three criteria. This evaluation is a study that calculates that
value.
Once the business’ value is determined, the breakdown of its price is not a function of
determining the market value of its individual parts (assets) but rather is a function of
tax allocations that must be properly determined by accountants and tax attorneys. An
example of items that would be allocated and included in a business’ value would be:
real estate and land (if any), furniture, fixtures, equipment, goodwill, covenants not-
Johnson Mechanical Contractors 53ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
53
to-compete, management consulting agreements, customer lists, telephone numbers,
signage, trade names, business records, leases, licenses, franchise rights and so on.
This is a sample insert for the evaluator comments to show the location of the insert in this
sample business analysis/valuation sample report.
Johnson Mechanical Contractors 54ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
54
APPENDICES
Johnson Mechanical Contractors 55ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
55
TAX FORMS
Johnson Mechanical Contractors 56ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
56
FINANCIALSTATEMENTS
Johnson Mechanical Contractors 57ValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
57
MISCELLANEOUSSUPPORTING
DOCUMENTATION
Johnson Mechanical ContractorsValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
OFFERED AT: $2,640,163
Type of Business: Mechanical Construction Contractors
Business Profile:
This is a sample insert for the evaluator business/income listing profile to show thelocation of the insert in this sample business/analysis sample report.
Johnson Mechanical ContractorsValuationDecember 31 2004
TheBusinessAnalyst.comPowered by The TASCON™Business Analyst
Business Valuation, Financial Analysis, Profit Enhancement, Cash Management Software
Johnson Mechanical Contractors2754 Grand Avenue
Suite 100Madison, WI 53714
www.johnsonmechanical.com