Investment Valuation

  • June 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Investment Valuation as PDF for free.

More details

  • Words: 1,959
  • Pages: 11
KEY ASSUMPTIONS Investment Details ● ●

New Investment

New Existing

Name of Investment

Status Quo

2007

First Year of Investment

Input Denomination

$000

Goodwill Amort (Yrs)

10

Taxation & Amortisation Rate Credits

33.00%

Company/Business Tax Rate

Carry forward tax credits (if any) on operational losses?



Capital and Cost of Capital Equity Ke Debt Kd Timing

10,000

Current level of Company Equity (in denomination above)

15.00%

Cost of Equity, or Calculate

9,000

Current level of Company Debt

7.00%

Cost of Debt

End

Discount cash flow evenly through the year (Mid) or at the end (End).

CE

Beg

Risk-Free Rate

7.00%

Market Risk Premium

8.00%

Equity Beta

Weighted Average Cost of Capital

WACC = 10.12%

Capital Employed calculated at the start

Include existing asset input data in

of the year (Beg) or averaged (Avg).

EVA capital charge?

Terminal Value Include Rate Capex

Include a terminal value after 5 years?



2.00% 0

Calculation Type ● Infinite Finite

Growth Rate after Yr 5 (or omit to use Yr 5 Growth Rate as per forecast). Ongoing annual capital expenditure requirement into perpetuity

Comparable Investment Score Optimal 10.00% 500 3.0

Weight 40% Return on Invested Capital (> WACC) 25% Net Present Value of cash flows 5% Cost/Benefit Ratio

5.0

15% Payback Period for cash invested

500

15% Free cash flow after 2 years 100%

1.00

Apply default weightings: Capital Constrained

0 2

TRUE

1

FALSE

0

TRUE

1

Mid End Beg Avg

1 1 1 Capital Constrained Capital Constrained Capital Constrained No Capital Constraint 40

40

20

25

25

40

5

5

20

15

15

10

15

15

10

100

100

100

INPUT ASSUMPTIONS FOR 0 (Before 0) $000

Description

Year 0

Year 1

Year 2

Year 3

Year 4

Year 5

2006

2007

2008

2009

2010

2011

Total

Assumptions

Taxable Revenue 0 0

Non-Taxable Revenue 0 0

Operating Expenses 0 0

Investment Expenses

Amort Yrs 1 1 1

Existing Assets

Existing Asset Life (yrs)

Age (Yrs)

Life (yrs)

Yr of Acq

Capital Expenditure

Accounting

Disposal

Rate

Method

Actg BV

Disposal

Rate

New Asset Acq Price

Taxation

Current BV

Current BV

Accounting Method

Rate

Unamort. Method

Taxation Rate

Method

Goodwill

Equity Funding 52.6% 52.6% 52.6% 52.6% 52.6%

Page 4 of 11

24891933.xlsBefore

11/14/2009

FINANCIAL ANALYSIS FOR 0 Accounting Impact

$000

2006

2007

2008

2009

2010

2011

Total

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

less Accounting

0

0

0

0

0

0

0

less Goodwill

0

0

0

0

0

0

0

0

0

0

0

0

0

0

less Interest

0

0

0

0

0

0

0

less Tax

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

2006

2007

2008

2009

2010

2011

Taxable Revenue Expenditure less Tax Payable less Interest Expense Operating Cash Flow

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

add Non

0

0

0

0

0

0

0

less Capital

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Total Revenue less Expenditure

EBITDA Depreciation Amortisation

EBIT Expense Payable Net Profit B4 Ab. Items

add Profit

on Asset disposal Net Profit

$000

Cash Flow Analysis

less Total

Taxable Income Expenditure add Asset Disposal Proceeds Net Cash Flow

Total PV of Capital Commitments after Year 5

5 Yr NPV

0

Total NPV of Cash Flow

0

Economic Value Added

2006

2007

2008

2009

2010

2011

Total Revenue Expenditure less Tax Payable less Interest Expense add Asset Disposal Proceeds add Economic Adjustments Economic Profit

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Capital Employed less Capital Charge Economic Value Added

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

$000

less Total

Page 55ofYr11PV of EVA Total PV of EVA

0 0

24891933.xlsBefore

Total PV of Capital Commitments after Year 5

11/14/2009

INPUT ASSUMPTIONS FOR 0 $000

Description

Year 0

Year 1

Year 2

Year 3

Year 4

Year 5

2006

2007

2008

2009

2010

2011

Total

Assumptions

Taxable Revenue 0 0

Non-Taxable Revenue 0 0

Operating Expenses 0 0

Investment Expenses

Amort Yrs 1 1 1

Existing Assets

Existing Asset Life (yrs)

Age (Yrs)

Life (yrs)

Yr of Acq

Capital Expenditure

Accounting

Disposal

Rate

Method

Actg BV

Disposal

Rate

New Asset Acq Price

Taxation

Current BV

Current BV

Accounting Method

Rate

Unamort. Method

Taxation Rate

Method

Goodwill

Equity Funding 52.6% 52.6% 52.6% 52.6% 52.6%

Page 6 of 11

24891933.xlsAfter

11/14/2009

FINANCIAL ANALYSIS FOR 0 Accounting Impact

$000

2006

2007

2008

2009

2010

2011

Total

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

less Accounting

0

0

0

0

0

0

0

less Goodwill

0

0

0

0

0

0

0

0

0

0

0

0

0

0

less Interest

0

0

0

0

0

0

0

less Tax

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

2006

2007

2008

2009

2010

2011

Taxable Revenue Expenditure less Tax Payable less Interest Expense Operating Cash Flow

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

add Non

0

0

0

0

0

0

0

less Capital

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Total Revenue less Expenditure

EBITDA Depreciation Amortisation

EBIT Expense Payable Net Profit B4 Ab. Items

add Profit

on Asset disposal Net Profit

$000

Cash Flow Analysis

less Total

Taxable Income Expenditure add Asset Disposal Proceeds Net Cash Flow

Total PV of Capital Commitments after Year 5

5 Yr NPV

0

Total NPV of Cash Flow

0

Economic Value Added

2006

2007

2008

2009

2010

2011

Total Revenue Expenditure less Tax Payable less Interest Expense add Asset Disposal Proceeds add Economic Adjustments Economic Profit

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Capital Employed less Capital Charge Economic Value Added

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

$000

less Total

Page 75ofYr11PV of EVA Total PV of EVA

0 0

24891933.xlsAfter

Total PV of Capital Commitments after Year 5

11/14/2009

FINANCIAL RESULTS FOR DIFFERENCE BETWEEN 0 AND 0 $000

Accounting Impact

2006

2007

2008

2009

2010

2011

Total

Total Revenue less Expenditure EBITDA

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

less Accounting

0

0

0

0

0

0

0

less Goodwill

0

0

0

0

0

0

0

0

0

0

0

0

0

0

less Interest

0

0

0

0

0

0

0

less Tax

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

2006

2007

2008

2009

2010

2011

Taxable Revenue Expenditure less Tax Payable less Interest Expense Operating Cash Flow

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

add Non

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Depreciation Amortisation

EBIT Expense Payable Net Profit B4 Ab. Items

add Profit

on Asset disposal Net Profit

$000

Cash Flow Analysis

less Total

Taxable Income Capital Expenditure less Asset Disposal Proceeds add Net Cash Flow 5-Yr NPV of Cash Flow

0

Infinite Terminal Value

0

Total NPV of Cash Flow

0

Page 8 of 11

24891933.xlsResults

Total PV of Capital Commitments after Year 5

11/14/2009

$000

Economic Value Added

2006

2007

2008

2009

2010

2011

Total Revenue less Total Expenditure less Tax Payable less Interest Expense add Asset Disposal Proceeds add Economic Adjustments Economic Profit

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Capital Employed Charge Economic Value Added

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Total PV of EVA

0

Infinite Terminal Value

0

Total PV of EVA

0

less Capital

COMPARABLE INVESTMENT SCORE Return on Invested Capital (> WACC) Net Present Value of Cash Flows Cost/Benefit Ratio Payback Period (Year) Free Cash Flow after 2 years

Result No Capital 0 No Upfront 5 0

Comparable Investment Score

Page 9 of 11

Total PV of Capital Commitments after Year 5

ADDITIONAL ANALYSIS Score 40.00% 0.00% 5.00% 0.00% 0.00%

45.00%

Implicit Annual Growth Rates Total Revenues Total Expenses Operating Cash Flow Net Cash Flow Economic Profit EVA

24891933.xlsResults

Change in Company Gearing Before (Year 0) 47.37% After (Year 5) 47.37% Change 0.00% Modified Internal Rate of Return No solution

11/14/2009

Cash Flow Chart Analysis Annual Cash Flow

Cumulative Cash Flow

1

1

1

1

1

1

1

1

1

1

0

0

0

0

0

0

0

0

0

0

0 2006

2007

2008

2009

2010

0 2006

2011

2007

2008

2009

2010

2011

Annual Cash Flow with Terminal Value

99

101

97

95

93

91

89

87

85

83

81

79

77

75

73

71

69

67

65

63

61

59

57

55

53

51

49

47

45

43

41

39

37

35

33

31

29

27

25

23

21

19

17

15

13

9

11

7

5

3

1

1 1 1 1 1 0 0 0 0 0 0 Year

Page 10 of 11

24891933.xlsResults

11/14/2009

Economic Value Added Chart Analysis Annual Economic Value Added

Cumulative Economic Value Added

1

1

1

1

1

1

1

1

1

1

0

0

0

0

0

0

0

0

0

0

0 2006

2007

2008

2009

2010

0 2006

2011

2007

2008

2009

2010

2011

Annual EVA with Terminal Value

99

101

97

95

93

91

89

87

85

83

81

79

77

75

73

71

69

67

65

63

61

59

57

55

53

51

49

47

45

43

41

39

37

35

33

31

29

27

25

23

21

19

17

15

13

9

11

7

5

3

1

1 1 1 1 1 0 0 0 0 0 0 Year

Page 11 of 11

24891933.xlsResults

11/14/2009

Related Documents

Investment Valuation
June 2020 15
Investment Valuation
June 2020 17
Investment
May 2020 62
Investment
June 2020 47
Investment
May 2020 51