JaxWorks
       Small Business Spreadsheet Factory
       Since 1996

 

 

     
     
 
 •  Home
 •  About
 •  Business Books

 •  Business Planning
 •  Charts
 •  Contact Us
 •  Downloads

 •  Excel Toys
 •  Functions
 •  Glossary
 •  Links
 •  Library
Product Catalog

 •  Tools
 •  Training
 •  Worksheets

 


Business Valuation (JAVA Required):
 

What is your business worth? This calculator creates a possible market valuation for your business. Enter your cash flow information for the next four years, your cost of capital and your expected growth rate. We will then determine how much your future cash flow is worth today. The result is the Net Present Value (NPV) of your company.

This Financial Calculator requires a Browser with Java Support

Definitions

Expected annual growth

This is the rate you expect your business to grow. This rate is only used on years 5 and above to estimate your future cash flow.

Weighted average cost of capital (WACC)

This is the cost of capital, or the interest rate, your investors require to put money into your business. Unless you are a fortune 500 company with an excellent credit rating, this rate should be at least 12% to 25%. For small businesses that rate can be much higher.

NPV Value of your business

This is the value of all of your future cash flows discounted in today's dollars at your Weighted Average Cost of Capital (WACC).

Operating profit

This is your total profit before interest and taxes. This is often called Earnings Before Interest and Taxes or EBIT.

Interest expense

Total interest expense for the year.

Interest income

Total interest income for the year.

Income taxes

Total income taxes paid for the year.

Depreciation and amortization

If you had any depreciation on equipment or land enter those amounts here. They are added back into your cash flow.

Change in notes payable

If you had a net change in your notes payable, enter the change here. If you have an increase in notes payable, your cash flow goes up. If you have had a decrease in your notes payable, your cash flow is reduced.

Change in inventory

If you had a net change in your inventory, enter that amount here. If you are holding more inventory your cash flow is decreased.

Change in accounts receivable

If you had net change in your accounts receivable, enter that amount here. Reducing your accounts receivable by collecting money owed more quickly can increase your cash flow and your valuation.

Changes in operating assets & liabilities

Enter any net change in operating assets and liabilities.

Other net change

Enter any other net change that impacted your cash flow for the period.

Capital expenditures

This is the amount you spent on capital equipment and land that you were not able to expense for the period. If you were able to expense the expenditure it is already accounted for in your EBIT.

Additional investment income

Enter any other investment that increased or (decreased) your cash flow for the period.



All compilation and content of this site, including its assembly, design, text, illustrations, photographs, logos, etc. are the intellectual property of Jaxworks. All worldwide rights, titles and interests are reserved.
Privacy Statement      ©Copyright, 2007, JaxWorks, All Rights Reserved.     Terms of Use