Sheet

Description

Value Drivers

Calculates value drivers  from historical and forecast financial information

ValueLine

Calculates value drivers  from information on a ValueLine Report

Peer Group Beta

Relevers Betas for use in  peer group cost of equity analysis

Shareholder Value

Calculates shareholder value  based on value drivers input from either the Value Drivers or ValueLine  worksheets or drivers that are entered directly

Sensitivities Analysis

Identifies which drivers  have the largest impact on shareholder value

Economic Profit

Calculates value created in  any year for which information is provided

Current Multiples

Calculates current prices  based on multiples

Transaction Multiples

Calculates acquisition  prices based on past transactions

Capital Structure

Assesses an appropriate  capital structure based on "downside" cash flows

Peer Group Cap. Struct.

Calculates debt to total  capital ratios for peers using book and market numbers