Small Business: Summary Business Valuation - Low cost, How to Value Your Own Business - No cost course.
VALUE-A-BUSINESS.COM
The online business valuation center of C&S Associates
Helping business owners since 1979

Business Valuation Calculator - HELP

Frequently Asked Questions

Click on the question below to jump to explanation


Do I need the manual Data Worksheet with the online Calculator?
How do I save my work?
How do I print my work in color?
How do I print my work in black text?
What's a "Cannot Convert" error message?
What's a "Parameter 1 of function NumberFormat" error message?
The Allocated Values (Lower or Higher) of the Five methods look wrong. Why?
How do I immediately access the course Lessons?
Why is my password not working?
Where can I get Prime Rates?
My Business Name is longer than the space provided?
How do I get my free 15 minute telephone consult about the numbers I have calculated?
Other Help Suggestions or Questions from you.


DATA WORKSHEET

Even if you are using the Business Valuation Calculator, we suggest that you print out the manual Data Worksheet at http://www.value-a-business.com/dataform.shtml

There are worksheet spaces provided near the bottom of the form for you to manually work up a total for your "One Time Expenses / (Income)" and for your "Discretionary Expenses." We recommend using the worksheet to keep a good record of these items in case you need to go back and explain the totals that you input on the Business Valuation Calculator to your bankers, investors, or others.

Back to Top

SAVING

After you have made changes to the data, press the "Update Valuation" Button. The data is processed and a revised page appears with your new data incorporated into the results. Note, your work has NOT been saved anywhere yet. Update simply means to update your web page, not to save to any files.

Notice that the address of the web page in your browser now takes on a very, very long "tail" of your data. The address (or URL) begins "http://www.value-a-business.com/sam2new.cfm?busname=" and more data.

To save your work, simply add the page to your Bookmark or Favorites file. All of the variables are saved with the address of the page. Note, at the very top of your browser screen is the Title of the page. In that Title there is a date and time stamp.

When you go to your Bookmarks or Favorite files in the future, you can find the most recent copy of your work by selecting the Bookmark or Favorite with most recent date and time in the Title. We suggest that you delete old Bookmarks or Favorites when they are no longer pertinent. You may get confused with too many copies of the work in your Bookmarks or Favorites.

For your security and confidentiality, we do not keep a copy of your work on our web server. We only keep a record of usage by password. Therefore, we are unable to provide you additional copies of your input data if you lose the Bookmark or Favorite.

Back to Top

PRINTING IN COLOR

To print your work, first be sure you have pressed the "Update Valuation" button after entering your most recent data. Using the "Print" feature of your web browser, print the pages. Since browsers and printers all have different setting, it is impossible for us to provide you a page break at the end of the report area before the legend. For most printers, two pages will be sufficient to get all of the printed report area and perhaps some of the legend.

In Internet Explorer you can highlight the area you want printed and then chose on the print menu to print only the "Selected Area."

Back to Top

PRINTING WITH BLACK TEXT

For printers that don't work well with colors, click the Black Print option just above the "Update Valuation" button. Then click the "Update Valuation" button.

The next page will be the Printed Report section ONLY. You may then print that using your browser's print command. Again two pages is sufficient for most printers. To return to the colored text page with the data input boxes, scroll way, way down on the page until you find a "Return" button.

Back to Top

CANNOT CONVERT TO NUMBER - ERROR MESSAGE

If you get an error message that begins "Cannot convert to number", it is likely that you have left a blank in a box. You must have a number in every input box, even if that number is zero. Or, you have attempted to enter an alphabetic or special character into a numeric field.

Back to Top

PARAMETER 1 OF FUNCTION NUMBERFORMAT - ERROR MESSAGE

If you get an error message that begins "Parameter 1 of function NumberFormat", it is likely that you tried to enter a number with commas. Just the number should be entered, no commas. Round all financial data to the nearest dollar. Decimals are fine for the prime rate and other fractional data. Note, the prime rate percentage is entered as a proper decimal. 8.25% is entered as .0825, not as 8.25.

Back to Top

FUNNY LOOKING ALLOCATED WEIGHTED AVERAGE

If the Allocated Lower Value is lower than all of the Lower Values of the five valuation methods, (or if the Allocated Higher Value is higher than all of the Higher Values), then it is likely that the five Allocation Percentages do not add up to 100%. The five values must add to 100%, even if one or more of the values are 0%. (All input values must actually be expressed as proper decimals and must add up to 1.00.)

Back to Top

ONLINE LESSONS

Just below the "Update Valuation" button on the Business Valuation Calculator page is the link to all of the Lessons in the "How To Value Your Own Business" course. Click on the links and the Lessons will open a new Window in most newer browsers.

Back to Top

PASSWORDS

Passwords for the online BUSINESS VALUATION Calculator are good for a minimum of 30 days. In some cases they may go a couple of days longer before expiring. Passwords are not case sensitive.

Back to Top

PRIME RATES

A historical list of prime rates can be found at: http://www.stls.frb.org/fred/data/irates/prime

Note, the prime rate is entered as a proper decimal. 8.5% is entered as .0825, not as 8.25.

Back to Top

BUSINESS NAME

The maximum length of the Business Name field is 30 characters. We needed to do this to make the report consistent between printers. You should abbreviate as needed.

Back to Top

FREE TELEPHONE CONSULT

The $29.95 fee for the BVC includes 15 minutes of telephone consulting. Simply call 1-205-987-5315 during regular business hours, Central Time, whenever you are ready for your phone consult. Ask for Pete Smith.

We suggest that before you call, you have already filled out the data in the Business Valuation Calculator, updated the page, and saved the version that you want to talk about as a Bookmark or Favorite. We also suggest that you email a copy of the URL of that Bookmark or Favorite to petesmith@value-a-business.com before calling.

That Bookmark or Favorite may have over 500 characters. Simply copy the entire Bookmark or Favorite URL into the body of the email message and send it. We also suggest that when you call you have at hand copies of your tax returns or financial statements that were the source of the data and the Data Worksheet.

These suggestions will allow you to get the most value out of your time on the phone.

Additional telephone consultation is available at $25.00 per quarter hour.

Back to Top

OTHER HELP SUGGESTIONS OR QUESTIONS

If you have any suggestions for additions or changes to this HELP/FAQ file, please email Pete Smith. Thanks.

Back to Top

Website Management by ConWeb.com, Copyright C&S Associates 1996-2008, All rights reserved.

PRIVACY AND CONFIDENTIALITY
- THE REAL WORLD
by: Pete Smith

First, I will not disclose any information about your business or even the fact that you are a client without specific instructions from you about whom I may tell and what information I may present to that person or persons.

Second, I may ask you at the end of an assignment if I may use your name and company name as a reference. You may accept or decline.

Third, I will sign a standard confidentiality agreement if you have one, or I can provide one for you for a nominal charge.

Fourth, if you complete any information on the web site, I will not sell, give away, or otherwise distribute that data in any way.

Now that we have that understanding, let me share some real world experience about the un-likeliness of maintaining complete confidentiality.

You have a very good chance of completing the "How to Value Your Own Business" course, using the Business Valuation Calculator, or getting the Summary Business Valuation done without losing any confidentiality.

These comments apply mostly to a Business Valuation, Business Appraisal or the process of putting your business up for sale. Once you start taking any actions out of the ordinary, the rumor mill or grapevine (whichever you call it) in your office will start generating all kinds of rumors, some right, some wrong, some maybe outlandish.

These actions may include asking office people for past financial statements, having closed-door telephone conversations, or holding private meetings with outside professional advisors that are outside of the ordinary course of business. Any strangers on your premises that are not customers or vendors cause employees to talk and speculate, especially strangers wearing business suits.

While technically this talk is not a breach of any confidentiality, frequently the rumors are close to being accurate. Right or wrong, they can become very destructive to the morale of your employees if left unchecked.

Another source where confidentiality may be compromised is by the non-professional staff of outside advisors that are working with you. Your professional advisors should always respect your confidentiality and privacy. They will insist that their staffs also maintain complete confidentiality. However, a reality check is often needed here. I find the larger the outside institution is, the more apt there is to be some idle conversation, sometimes very innocent, but very revealing.

I recall a situation where a banker's administrative assistant told the first partner in a company that their loan package was ready and could be picked up at the bank at any time. That first partner knew nothing about the package. The second partner had applied for a loan to buy out the first partner and was waiting for the package before approaching the first partner. Sparks flew big time! Their partnership and their friendship were both dissolved with a big loss in the value of the company.

Your vendors' sales personnel may also spread rumors about potential changes in other businesses. Some sales people believe these rumors enhance the value of their presence and make calling on customers easier. As a word of caution, remember that sales persons who tell you rumors about other companies are probably telling their other customers about you.

As the owner, you may be the last person in your company to become aware of the rumors. For non-threatening scenarios such as estate planning, gifting, additional financing, stock buybacks, etc., I recommend that employees be told what is going on. They do not need a lot of detail, just a summary.

For example, you might say; "We have a visitor coming tomorrow. He is helping us prepare a business valuation for our key man life insurance policy. Please make him welcome." You need to only tell two or three people and let them know that the information is not confidential; they will spread the word.

Under situations where there is some kind of an adversarial relationship occurring such as a divorce or dissenting stockholder, the employees are probably very aware of the situation anyway, and again a brief explanation is all that is needed.

If the situation involves a possible sale of the company, it is best not to say anything until you sense that the rumor mill is in high gear, or you are approached directly. Your intentions will leak out in some manner before closing regardless of written confidentiality agreements and the like. In twenty-five years of doing deals, I have never seen or heard of a deal being completed without most of the employees already being aware of at least some of the details.

I recommend that owners try to dismiss early inquiries by nosy employees with some light reply such as, "Everything I own is for sale except my wife and my golf clubs - and I know I am going to keep my golf clubs." Notice, that the levity evaded answering the question directly and the owner did not deliberately lie to the employee.

However, this evasion cannot last too long. When it becomes obvious to the employees that something is afoot, my recommendation is to tell the employees that the company is considering additional investors and/or investment in the company in order to grow better and provide stability for the employees' jobs in the future. Again, there is not a lie, ever though the investor may end up owning all of the company.

Turn the possible events into a positive for the employees. Do not fabricate an out and out falsehood to the employees. After the sale of your business, you may see those people at church, in the local coffee shop, or on the golf course. If you have deliberately deceived them, you may jeopardize future relationships with them or their friends.

As a buyer, I would be very upset if I found out that during our negotiations a seller had told the employees that the company was not considering a sale or at least additional investment. When I, the buyer, come into the picture after the sale there will be immediate employee resentment and distrust towards me that is not my doing. For me as a buyer, that possible drop in morale reduces the value of the company today.

Certainly privacy and confidentiality are issues that should not be ignored. However, it is naive to believe that you can maintain complete confidentiality throughout a business valuation, business appraisal or the pre-business sale process.