Data matrix

Scenario manager

Manual scenarios



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 live online training, plus books, videos, and digital content from nearly 200 publishers.