Indicated Value
The IBA Indicated Value worksheet calculates a value for the business from the Seller's Discretionary Earnings Base and the Revenue Base. The assumptions settings determine how the worksheet is configured.
Desktop Toolbar Links
You can use buttons in the Desktop Toolbar to jump to the following sheets:
Level of Control (Premium or Discount)
Excess and Non-Operating Assets
Weighted Average
Enter a weight for each of the multiple calculations (Revenue and SDE). The worksheet will update the weighted average calculated in the cell labeled "Ongoing Value".
Adjusting the Calculated Value
To adjust the calculated value:
Click on the Adjust button on the Desktop Toolbar. Two Adjustments rows will appear on the worksheet: one at the end of the Additions section, and one at the end of the Subtractions section.
Enter a label for each adjustments row in its white input cell in the labels column.
Enter adjustments to the calculated value.
To hide the adjustments and remove them from the calculations, click on the Adjust button again.
Selected Value
The rounded value in the cell labeled "SELECTED EQUITY VALUE" or "SELECTED ENTERPRISE VALUE" is used in the Conclusion of Value worksheet. You can edit this value by overwriting its blue text cell.