Corporate (Group)
Shareholder Value Analysis

 

-	Revenue SBU 1	Revenue SBU 2	Other Revenue	Total Revenue	Total Expenses	Before-Tax Cash Flow
Yr	(Input)	(Input)	(Input)	(Computed)	(Input)	(Computed)
1	$	$	$	$	$	$
2	$	$	$	$	$	$
3	$	$	$	$	$	$
4	$	$	$	$	$	$
5	$	$	$	$	$	$
6	$	$	$	$	$	$
7	$	$	$	$	$	$
8	$	$	$	$	$	$
9	$	$	$	$	$	$
10	$	$	$	$	$	$

 

-	After-Tax Cash Flow	Discount Factor	Present Value of Cash Flow	Cumulative PV of Cash Flow
Yr	(Computed)	(Given)	(Computed)	(Computed)
1	$	.8696	$	$
2	$	.7561	$	$
3	$	.6575	$	$
4	$	.5718	$	$
5	$	.4972	$	$
6	$	.4323	$	$
7	$	.3759	$	$
8	$	.3269	$	$
9	$	.2843	$	$
10	$	.2472	$	$________ (1)

Residual Value (input): $_________________
Residual Value After Taxes (computed): $_____________
Present Value After-Tax Residual Value (computed): $_______ (2)

Present Value of Investment Portfolio (input): $______________(3)

Shareholder Value Based on: "Strategy XYZ" ______________ (1+2+3)

Notes relevant to this analysis include:

• Shareholder Value = (Cumulative PV of Net Cash Flow for 10 years)
   + (PV of of Investment Portfolio)
   + (PV of After-tax Residual Value)
• Tax Rate at 35%
• Discount Rate of 15%.
• Revenues include....
• Expenses include....
• Residual Value refers to how much the company will be worth at the end of the tenth year, based on projected comparable sales (liquidation value) and projected sales at the end of the forecast period. Sale price is estimated at....

Assumptions

• We will acquire.....
• We will divest....
• Our capital structure will....
• Our dividend policy will....
• Our environmental exposure will....
• Pending and future litigation against us (excluding environmental litigation) will....
• Our future facilities will....
• Pensions costs will....
• Health care costs will....
• Economic assumptions include....
• Other assumptions include....

[ Home ] [ Up ]

Send e- mail to webmaster@e-competitors.com with comments.     Or use Feedback.  
Legal notice.     Search.          Table of Contents 
Copyright 2008 Alan S. Michaels               Alan S. Michaels    All Rights Reserved.
Last modified:   Tuesday February 19, 2008