About the valuation utility

The valuation utility's goals are to:

• Implement and reconcile discounted cash flow, ratio and economic profit approaches
• Provide transparency of calculation and methodology
• Incorporate sophisticated analytics
• Perform comprehensive term structure modelling of capital costs and value evolution
• Allow user-defined additions and calculations
• Give feedback about error conditions / invalid / inconsistent assumptions
• Do the preceding whilst avoiding having to use macros or iteration

Content of the Valuation Utility

Following is a brief description of the utility. More information is in the user guide which can be downloaded by clicking on the link to the right.

Scenarios

Multiple scenarios can be defined and compared.

Interest rate model

A "coverage ratio" table can be used to add risk margins to the risk-free rate.

Three phase model

The utility supports three phases: An initial phase, a "fade" phase and a terminal phase. The duration of these are adjustable. Charts automatically re-scale to accomodate changed durations.

Time series analysis

The utility lets you choose any subset of parameters and displays how they evolve over time

Assumptions varys analysis

The utility shows the range of outcomes that would occur if a nominated assumption varies over a given range

Sensitivty analysis

The utility shows the sensitivity of a nominated value to all of its drivers

Other features

Information about additional features is in the user guide which can be downloaded by clicking on the link to the right.

Assessment

You can test your spreadsheet and financial modeling skills by downloading the following assessement spreadsheet. The spreadsheet contains topics ranging from easy to quite difficult.

Click here to download the assessment spreadsheet.

Register

You can register your interest for any of our courses by selecting the "Register" menu item at the top of this page.