Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Copy of SBDC Valuation Spreadsheet - Excel

VIEWS: 668 PAGES: 8

									SBDC Valuation Analysis Program
This program uses various techniques to help small businesses look at various approaches to valuation for a potential purchase or sale of a small business. Each technique has a separate worksheet, and a final worksheet prepares a summary using all of the techniques. The Capitalized Adjusted Earnings approach and Discounted Future Earnings approach are standard valuation techniques employed in SBA lending, and utilize the methodology described in the SBA's Standard Operating Procedures (SOP) for lenders. The Business Valuation Model uses a fair market valuation of assets method, and is provided courtesy of John Nelson III, owner of the Capital Connection. The SBDC assists clients in putting their data into this format, and makes no guarantee or claim to the accuracy of the numbers. This information is typically "internal" in use by owners of a small business, and is not meant to be shared with others or used as the sole means of determining the value of a small business. The input process can begin by completing each sheet, left to right, by inputting data into BLUE fields only. The black fields are not protected, and the user is warned to input over them at the peril of destroying formulas and making the program unusable as originally intended.

Company Name Date Capitalized Adjusted Earnings (CAE)
Year Earnings Weight Adjusted Value Adjusted Value/Total Weight Indicated Value 1 $0.00 1 $0.00 2 $0.00 2 $0.00 3 $27,175.00 3 $81,525.00 4 $45,065.00 4 $180,260.00 5 $173,417.00 5 $867,085.00 Total $245,657.00 15 $1,128,870.00 $75,258.00 $376,290.00

Take five years of historic earnings. Year 5 is the most recent earnings year.

"All financial and business information contained herein was provided by the management of the business. The SBDC assisted in compiling the data and presenting in the format shown, and makes no claims regarding the accuracy of the presentation."

Company Name Date
Discounted Future Earnings (DFE) Year 1 2 3 4 5 6 7 8 9 10 Average earnings Growth rate Projected Growth Factor Net Present Value $0.00 150.00% $0.00 0.8333 $0.00 $0.00 150.00% $0.00 0.6944 $0.00 $0.00 150.00% $0.00 0.5787 $0.00 $0.00 112.00% $0.00 0.4822 $0.00 $0.00 112.00% $0.00 0.4018 $0.00 $0.00 112.00% $0.00 0.3349 $0.00 $0.00 112.00% $0.00 0.279 $0.00 $0.00 112.00% $0.00 0.2325 $0.00 $0.00 112.00% $0.00 0.1938 $0.00 $0.00 112.00% $0.00 0.1616 $0.00 Indicated Value $0.00

Average earnings year one, calculate the average earnings for the previous 5 years or justify number based on current operations A moderate growth rate of 5% is used for the projection Factors based on 20% risk typical for small business. Do not change the factor column.

"All financial and business information contained herein was provided by the management of the business. The SBDC assisted in compiling the data and presenting in the format shown, and makes no claims regarding the accuracy of the presentation."

Company Name Date
PROVIDED BY JOHN W. NELSON III, CAPITAL CONNECTION

BUSINESS VALUATION ANALYSIS
Based on the most recent tax return. 1 Sales 2 3 4 5 6 7 Sample $ 700,000 This Case $1,814,384 $980,791 $150,000 $50,000 $6,250 $ 739,843.00 $0 $0 $0 $0 $400,000 $0 $400,000 $50,000 $50,000 $500,000 $25,000 $525,000 0% $525,000 6% $31,500 $739,843 $31,500 $708,343 3 4 5 4 5 5 5 3 4 4 6 4 3 3

8 9

10

11

Operating Exp. (COGS) $ 414,400 Admin. Exp. $ 148,400 Owners Salary $ 49,000 Depreciation $ 21,000 Stabilized Earnings $ 109,200.00 Asset Value & Working Cap. A. Land $ 20,000 B. Buildings $ 120,000 Inventory $ 1. Raw $ 2. In Process $ 3. Finished $ 4. Resale $ C. Total Inventory $ 60,000 D. Equipment $ 60,000 F. Other Tangible Assets $ G. Total Tangible Assets $ 260,000 H. Working Capital Needed $ 40,000 I. Tangible Assets & W/C $ 300,000 Underlying Interest Rate $ 0.12 Cost Of Money A. Tangible Assets & W/C $ 300,000 B. Underlying Interest Rate $ 0.12 C. Total 9A + 9B $ 36,000 Excess Earnings A. Stabilized Earnings $ 109,200 B. Cost of Money $ 36,000 C. Excess Earnings $ 73,200 Calculate Multiple Rating (1 through 6 higher is better) A. Risk $ 4.0 B. Competitive $ 3.0 C. Industry $ 3.5 D. Company $ 5.0 E. Growth $ 4.0 F. Desirability $ 4.0 G. Owner's Reason for selling $ 6.0 H. Length of time current owner has owned $ 4.0 I. Length of time the firm has been in business $ 6.0 J. Profitability $ 5.0 K. Location $ 5.0 L. Entry barriers $ 5.0 M. Customer Base $ 5.0 N. Technology $ 3.0

$

611,800

"All financial and business information contained herein was provided by the management of the business. The SBDC assisted in compiling the data and presenting in the format shown, and makes no claims regarding the accuracy of the presentation."

G. Total H. Total divided by 14 12 Value of Excess Earnings A. Excess Earnings B. Multiple Rating C. Value of Excess Earnings 13 Total Business Value: A. Asset Value B. Multiple Rating C. TOTAL BUSINESS VALUE Value of turn key operation D. Final Business Value

$ $ $ $ $ $ $ $ $ $

62.5 4.5 73,200 4.5 326,786 260,000 326,786 586,786 25,000 611,786

58 4 $708,343 4 $2,909,266 $500,000 $2,909,266 $3,409,266 $50,000 $3,459,266

"All financial and business information contained herein was provided by the management of the business. The SBDC assisted in compiling the data and presenting in the format shown, and makes no claims regarding the accuracy of the presentation."

ATION ANALYSIS
Notes Last Annual COGS $1,130,791 include depreciation exp Yearly $56,250 Last years

at FMV at FMV at cost at cost at cost at cost book or FMV Furniture and Fixtures lowest cash should go highest rate allowed

rounded

minus

high risk, low # more competitors, lower # what's the future? more desirable, higher # higher growth, higher # to own the company better the reason, higher # over 10years a 6, down from there over 10 years a 6, down from there industry std a 3 or 4, adjust from there more desirable, higher # harder to start, higher the number more loyal provable base, higher # higher tech, higher # "All financial and business information contained herein was provided by the management of the business. The SBDC assisted in compiling the data and presenting in the format shown, and makes no claims regarding the accuracy of the presentation."

Average of the above numbers

the mulitplier

An estimate, usually $15 -$25K

"All financial and business information contained herein was provided by the management of the business. The SBDC assisted in compiling the data and presenting in the format shown, and makes no claims regarding the accuracy of the presentation."

SecurityBase.com Valuation August 15, 2005 Small Business Valuation Analysis Summary
Valuation Technique 1) Capitalized Adjusted Earnings Value 2) Discounted Future Earnings Value 3) Market Valuation Value Average of Above Techniques Comments $ $ $ $ 531,297 31,073,872 3,459,266 11,688,145

Discounted Future Earnings (DFE) Year Average earnings Growth rate Projected Growth 2005 -$931,000.00 -145.55% $1,355,070.50 2006 $1,355,070.50 519.50% $7,039,591.25 2007 $7,039,591.25 108.00% $7,602,758.55 2008 $7,602,758.55 108.00% $8,210,979.23 2009 $8,210,979.23 108.00% $8,867,857.57 2010 $8,867,857.57 108.00% $9,577,286.18 2011 $9,577,286.18 108.00% $10,343,469.07 2012 $10,343,469.07 108.00% $11,170,946.59 2013 $11,170,946.59 108.00% $12,064,622.32 2014 $12,064,622.32 108.00% $13,029,792.11 Indicated Value Factor Net Present Value 0.8333 $1,129,180.25 0.6944 $4,888,292.16 0.5787 $4,399,716.37 0.4822 $3,959,334.19 0.4018 $3,563,105.17 0.3349 $3,207,433.14 0.2790 $2,885,827.87 0.2325 $2,597,245.08 0.1938 $2,338,123.81 0.1616 $2,105,614.40 $31,073,872.44

Capitalized Adjusted Earnings (CAE)
Year 2002 2003 2004 Total Earnings $27,175.00 $45,065.00 $173,417.00 $245,657.00 Weight 1 2 3 6 Adjusted Value djusted Value/Total Wt.ndicated Value A I $27,175.00 $90,130.00 $520,251.00 $637,556.00 $106,259.33 $531,296.67

"All financial and business information contained herein was provided by the management of the business. The SBDC assisted in compiling the data and presenting in the format shown, and makes no claims regarding the accuracy of the presentation."


								
To top