Home Products Tour Support Contact Us Blog Resources Buy
 
Home > Resources > Business Valuation Guide > Financials Adjustment Worksheets
Business valuation video: State-of-the-art valuation tools. Old-fashioned customer service.

Worksheets for recasting financial statements

Your ValuAdder business valuation software contains integrated financial statement recasting worksheets you can use to prepare for your business valuation:

  • Start with the company's historic financial statements - the Income Statements and Balance Sheets.
  • Do important adjustments to determine the business earning power.
  • Assess the company's risk.
  • Prepare all the inputs you need for your business valuation calculations.

You will find the worksheets helpful when using the well-known business valuation methods available in ValuAdder that include the Capitalized Excess Earnings, the Discounted Cash Flow and the Multiple of Discretionary Earnings.

The Capitalized Excess Earnings worksheet provides you with the following business valuation inputs:

  • Business earnings and earnings growth rate.
  • Adjusted business assets.
  • Adjusted current liabilities
  • Fair rate of return on business net tangible assets.

The Discounted Cash Flow worksheet prepares these business valuation inputs for you:

The Multiple of Discretionary Earnings worksheet assembles the following business valuation inputs:

You can extract the worksheets directly from your ValuAdder product as follows:

  • Run ValuAdder.
  • Click on the Tools menu.
  • Select the Worksheets for Recasting Financials menu item.
  • In a window that opens, select the worksheets based on how many years of historic company financial statements you have available.
  • Click on the Save Worksheet button to save it on your computer hard drive.

You can now open each worksheet for editing in a Microsoft Excel® or compatible spreadsheet program.

Business Valuation using ValuAdder

<<previous<< >>next>>