15

Sensitivity

Outline

Returns

Data matrix

Scenario manager

Manual scenarios

Summary

OUTLINE

The model now produces a single valuation that you can compare to the accounting value, market value or alternative methods such as adjusted present value or economic profit. On the other hand, the model considers the lenders’ position since it computes the debt service coverage ratios and gearing. If covenants or thresholds were introduced you would find that you could increase the value by increasing the gearing but possibly breach the specimen banking covenants. Alternatively, you could improve the lenders’ security by increasing the proportion of equity capital, although this would worsen returns to equity investors. The available cash flow to ...

Get Mastering Cash Flow and Valuation Modelling now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.