Yield Range Analysis
Our clients (and our clients' clients) are
especially fond of this report. It is extremely
useful. The report automatically generates
calculations by bracketing the IRR that you
select for your analysis, both above and
below. Then it performs a DCF analysis, based
upon each IRR.
The Indicated Value and Required Equity are calculated
for each IRR. If a loan is used in the analysis, the new Debt Coverage Ratio is also shown.
When you try this with an HP 12c or your favorite spreadsheet template,
be sure to keep track of your time.