16

Optimisation

Outline

Goal Seek

Solver

Coding Solver

Summary

OUTLINE

The case model provides information about valuation and debt servicing using the sensitivity methods but does not illustrate how (or whether) the amounts are ‘enough’ to satisfy the competing demands of returns and debt covers. The model needs to have some targets and to include some degree of optimisation as a means of checking the outcomes. You should always be looking at the flexibility of the model and seeing if it is possible to gain more management information. The model currently uses:

  • inputs–calculations–outputs information flow as a basic model design;
  • data tables or matrices;
  • a built-in Scenario Manager.

Since the model has been developed using best practice ...

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.