Management

Marsh-Berry's Online Value Estimator

An online number crunching tool that enables owners and managers to estimate what their agency is worth.

by Steven Brightbill

One industry trend that has emerged over the last several years is that of agency mergers and acquisitions. Regardless of the specific industry issues that have fueled this latest round of activity, mergers and acquisitions are part of agency life.

When an agency is involved in an acquisition, one of the key pieces of information that the various parties want to know is how much an agency is worth. The seller wants to know how much the agency should sell for. The buyer wants to know that the asking price is reasonable and not inflated. And in a merger, the parties want to know the comparative and relative values of the various pre-merger entities.

But even if an agency isn't involved in a merger or acquisition, knowledge of its value or worth can be an important indicator of financial performance. Owners and managers need the "cold hard facts" for review, benchmarking, and adjustment of business plans. Periodic financial valuations, regardless of the purpose, make good sense.

Enter Marsh-Berry

Marsh-Berry & Company, Inc. is a recognized name in the insurance industry. The Concord, OH firm was established in 1981 and is a leading provider of insurance consulting services. The company directs its services through four areas: 1) performance enhancement; 2) management consulting; 3) investment banking; and 4) information and technology.

Sounding Line readers may have noticed a short news item in our February issue about Marsh-Berry's new Online Value Estimator, an Internet-based tool that helps agents estimate their agency's value. For more information, we talked to Marsh-Berry's vice president of information services, Doug Terrill.

According to Terrill, the development of the Online Value Estimator was a natural outgrowth of existing services Marsh-Berry already provides. One such service is the subscription-based Perspectives on High Performance (PHP) agency assessment. The PHP assessment collects agency financial information that drives a series of calculations that leads to a performance analysis. Of course, another Marsh-Berry service is the traditional in-agency valuation that performs a detailed on-site analysis based on both tangible data and intangible assessments.

Terrill explained that the primary focus of Marsh-Berry's subscription-based services is to appeal to a broader market, especially smaller agencies (under $2 million in revenues) that haven't yet used their traditional services.

How the Online Value Estimator works

Conceptually, the Online Value Estimator is relatively simple. Essentially, the user enters data into a series of online data collection screens, and the computer performs the calculations and generates a valuation figure.

For existing subscribers who have already provided similar data for other Marsh-Berry services, the process is less time-consuming because existing data is automatically imported to populate the Estimator's data collection screens. For agencies that are not subscribers, data collection and entry is more time-consuming — two to four hours — and will likely require the involvement of the agency bookkeeper or accountant.

An online sample presentation at www.marshberry.com/Newsletter/ValueEstimatorTour.htm illustrates Marsh-Berry's five-step process.

  1. Pro Forma Earnings Potential: On this screen, the user enters financial data (revenue and expenses) from the agency's income statement. This screen includes clickable account names and "question marks" (?) that direct the user to online help, definitions and explanations, and guidelines that enable the user to refine and adjust requested data.
  2. Projected Earnings Potential: This screen forecasts earnings for the next five years based on the current year's actual and pro forma adjusted data and income tax and future commission growth assumptions.
  3. Balance Sheet Value: On this screen, the user enters actual balance sheet information using either a short form or a detailed version of the balance sheet to determine tangible net worth.
  4. Risk Assessment: In this step, the user completes a questionnaire that assesses risk. According to Terrill, this step was the most difficult to develop from a programming point of view. Whereas previous steps are essentially spreadsheet-like calculations, risk assessment is not quite as "cut and dried." Terrill said that while many valuation consultants use similar methodologies for assessing risk, there tends to be a measure of subjectivity in the process. Terrill explained that certain assumptions based on Marsh-Berry risk assessment criteria had to be factored into a more simplified process that could be handled via an online process. This is one of the main reasons only an estimate of value is available online.
  5. Estimation of Agency Value: Finally, with the previous four steps completed, an estimate of value is calculated. The estimate shows three important figures: 1) present value of future cash flows; 2) cash buyers retrospective EBITDA; and 3) estimate of full fair market value. The estimates are augmented by several caveats that could cause adjustments to the numbers presented.

Value and limitations

For agencies that already subscribe to Marsh-Berry services and have undergone a complete valuation process, the Online Value Estimator will likely be a more useful tool than for those who approach the process as a one-time event. Terrill said that an agency typically needs to be involved in the valuation process over a longer period of time to get an accurate picture of its value.

Existing Marsh-Berry subscribers can purchase a 30-day subscription to the Online Value Estimator for $295; non-customers, $395.

From the product's name — Online Value Estimator — users need to realize that the calculations provide only an estimate. Terrill cautions that the online tool should not be viewed as a substitute for a thorough on-site agency valuation and consultation, which can typically cost several thousand dollars.

From my limited understanding of agency accounting, the online sample presentation provides an informative and attractive option that I can imagine would be a useful tool for agents interested in obtaining a valuation. And, at $395, the price is hard to beat.

Sounding Line
March 2002

Interview: ChoicePoint

Editorial

Vendor: Marsh-Berry

Workflow Solutions

Get Rid of Pop-Ups

Vendor: PS4Plus

Contending With Broken Links

Industry Insight: Lessons from "Independent" Insurance Web Sites

Resources

Strategy: Don't Make Me Think (10 Tips)