O'Reilly logo

Mastering Cash Flow and Valuation Modelling by Alastair Day

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required