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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.