Indicated Value
The Analyst Research Data Indicated Value worksheet calculates a value for the business from the bases and multiples. 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
Earnings Multiple
The Fundamental Discount assumption determines if the adjusted multiple from the Fundamental Discount worksheet is applied to the Earnings Multiple calculation.
Weighted Average
Enter a weight for each of the multiple calculations. 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. A an adjustment row will appear on the worksheet.
Enter a label for the adjustment row in the white input cell in the labels column.
Enter an adjustment to the calculated value.
To hide the adjustment and remove it 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.