The worksheets in the Custom Comparison folder compare the subject business to data that you have compiled yourself or have obtained from an external source. To use these worksheets, set the Custom Comparison assumption on the Financial Analysis Assumptions Sheet to True.
To perform multi-year analysis, set the Custom Comparison Multi-Year assumption on the Financial Analysis Assumptions Sheet to True.
You use multi-year data to compare the subject business to its industry over time. For example, if the subject business is in decline, but the industry as a whole is faring worse, then the value of the company should reflect that its performance is superior to its industry. Conversely, if the subject business is improving, but the industry is improving more rapidly, then the value of the company should reflect that its performance is inferior to its industry. By analyzing the historical trends for the company and its industry, a keen appraiser will be able to draw conclusions about the company’s value relative to comparable businesses.