These options configure the Summary DCF worksheets. See Working with Assumptions.
Sets the number of years to project the business's financial statements into the future.
Determines if the adjusted or historic financial statements are used as the basis for the forecasted financials.
Determines the economic base that is projected and discounted. Configures the Benefit Stream worksheet. EBT is earnings before taxes, EBIT is earnings before interest and taxes, and EBITDA is earnings before interest, taxes, depreciation and amortization.
Adds interest expense back to the benefit stream, applies weighted average cost of capital (WACC) to the discount rate, and deducts debt from the indicated value.
Determines how the discount rate is calculated. ValuSource Pro supports two calculation methods, the Buildup Method and the Capital Asset Pricing Model (CAPM).
Hides or shows the appropriate rows to match the equity risk premium data set. See SBBI and Duff and Phelps.
Enabled when the SBBI or D&P assumption (see above) is set to D&P Decile. Determines the rate type to apply from the Duff & Phelps data set: Excess of CAPM, or Arithmetic Mean.
Enabled when the SBBI or D&P assumption (see above) is set to D&P Decile. Determines the decile applied from the Duff & Phelps data set.
Applies a risk premium for the industry to the discount rate. You can download the risk premium from our SBBI Database.
Discounts the cash flows from the middle of the year. The mid-year cash flow is estimated by averaging the cash flows from the preceding year and the current year.
Applies a premium for control or a discount for lack of control in the indicated value calculation. The premium and discount are calculated in the Level of Control (Premium or Discount) worksheet. This assumption is enabled and disabled by the Application of Premiums, Discounts and Non-Operating/Excess Assets setting on the Project Assumptions sheet.
Applies a discount for lack of marketability in the indicated value calculation. The discount is calculated in the Marketability Discount worksheet. This assumption is enabled and disabled by the Application of Premiums, Discounts and Non-Operating/Excess Assets setting on the Project Assumptions sheet.
Includes excess and non-operating assets in the indicated value calculation. The value of the assets is calculated in the Excess and Non-Operating Assets worksheet. This assumption is enabled and disabled by the Application of Premiums, Discounts and Non-Operating/Excess Assets setting on the Project Assumptions sheet.
Applies the level of control premium or discount to the excess and non-operating assets in the indicated value calculation.
Disabled if the Level of Control assumption is set to No Premium or Discount.
Disabled if the Excess/Non-Operating Assets assumption is set to False.
Enabled and disabled by the Application of Premiums, Discounts and Non-Operating/Excess Assets setting on the Project Assumptions sheet.
Applies the marketability discount to the excess and non-operating assets in the indicated value calculation.
Disabled if the Marketability Discount assumption is set to False.
Disabled if the Excess/Non-Operating Assets assumption is set to False.
Enabled and disabled by the Application of Premiums, Discounts and Non-Operating/Excess Assets setting on the Project Assumptions sheet.
Determines if premiums and discounts are included in the values shown on the Rate Sensitivity worksheet.