Sesitivity Analysis of Project A Base Ca Case Discount Factor @ 12%
Year 0
1
1
0.892857
2
0.797194
3
0.71178
4
0.635518
5
0.567427
NPV
Present Cash Flows value (4,600.00) (4,600.00) 1,600.44 1,428.96 1,760.48 1,403.44 1,936.53 1,378.38 2,130.19 1,353.77 2,343.20 1,329.59 2,294.16 Spread
Optimistic Ca Case(+8%)
Cash Flows (4,600.00) 1,728.48 1,901.32 2,091.45 2,300.61 2,530.66
Present Value (4,600.00) 1,543.28 1,515.72 1,488.65 1,462.08 1,435.96 2,845.69
Pessimistic Ca Case(-8%)
Cash Flows (4,600.00) 1,472.40 1,619.64 1,781.61 1,959.77 2,155.74
Present Value (4,600.00) 1,314.65 1,291.17 1,268.11 1,245.47 1,223.23 1,742.63
1,103.07
Sesitivity Analysis of Project B Base Ca Case Discount Factor @ 13%
Year 0
1
1
0.884956
2
0.783147
3
0.69305
4
0.613319
5
0.54276
NPV
Present Cash Flows value (6,090.00) (6,090.00) 2,000.85 1,770.66 2,200.94 1,723.66 2,421.03 1,677.90 2,663.13 1,633.35 2,929.44 1,589.98 2,305.55 Spread
Optimistic Ca Case(+8%)
Cash Flows (6,090.00) 2,160.92 2,377.02 2,614.71 2,876.18 3,163.80
Present Value (6,090.00) 1,912.32 1,861.55 1,812.13 1,764.02 1,717.18 2,977.19
Pessimistic Ca Case(-8%)
Cash Flows (6,090.00) 1,840.78 2,024.86 2,227.35 2,450.08 2,695.08
Present Value (6,090.00) 1,629.01 1,585.77 1,543.66 1,502.68 1,462.78 1,633.90
1,343.29
Sesitivity Analysis of Project C Base Ca Case Discount Factor @ 14%
Year 0
NPV
Present Cash Flows value 1
Optimistic Ca Case(+8%) Present Cash Flows Value
Pessimistic Ca Case(-8%) Present Cash Flows Value
(7,400.00) (7,400.00) (7,400.00) (7,400.00) (7,400.00)
(7,400.00)
1
0.877193 2,000.66
1,754.96
2,160.71
1,895.36
1,840.61
1,614.57
2
0.769468 2,200.73
1,693.39
2,376.79
1,828.86
2,024.67
1,557.92
3
0.674972 2,420.80
1,633.97
2,614.46
1,764.69
2,227.14
1,503.25
4
0.59208 2,662.88
1,576.64
2,875.91
1,702.77
2,449.85
1,450.51
5
0.519369 2,929.17
1,521.32
3,163.50
1,643.02
2,694.84
1,399.61
780.28 Spread
1,434.71
125.86 1,308.85
Strategic Evaluation Score
Questions Score (1-10) Is the project supportive to the organizational strategy? Does the project stay within the existing core competencies? Ability to build new knowledge for future Projects ability to build new global relations Degree of uniquenes of the project output Total Weighted Total Score Projected NPV Adjusted NPV Total Score (60% NPV, 40% Strategic)
Score Weight % A 25% 10% 15% 25% 25%
B 8
8
9
9
8
8
8
8
7
8
40 39.25 1742.63 174.26 120.26
41 40.5 1633.90 163.39 114.23
C 10 9 9 10 10
48 48.75 125.86 12.59 27.05
Supercom Project Evaluation Guideline for Project A Strategic Evaluation Score 39.25 NPV of Project 229.42 Sensitivity of NPV 284.57 229.42 174.26 Optimistic Pessimistic Case(+8%) Base Case Case(-8%) Spread 110.31 Per cent of spread over normal NPV 48.081447 Calculation of Final Score: Strategic Evaluation Score (40%)
15.7
Financial Evaluation Score (60%)
104.56
Total (A)
120.26
Less: Adjusted Spread (B)
Final Score (A-B)
48.081447
72.18
Supercom Project Evaluation Guideline for Project B Strategic Evaluation Score 40.5 NPV of Project 230.55 Sensitivity of NPV 297.72 230.55 163.39 Optimistic Pessimistic Case(+8%) Base Case Case(-8%) Spread 134.33 Per cent of spread over normal NPV 58.263271 Calculation of Final Score: Strategic Evaluation Score (40%) Financial Evaluation Score (60%) Total (A) Less: Adjusted Spread (B)
Final Score (A-B)
16.2 98.03 114.23 58.263271
55.97
Supercom Project Evaluation Guideline for Project C Strategic Evaluation Score 48.75 NPV of Project 78.03 Sensitivity of NPV 143.47 78.03 12.59 Optimistic Pessimistic Case(+8%) Base Case Case(-8%) Spread 130.88 Per cent of spread over normal NPV 167.73961 Calculation of Final Score: Strategic Evaluation Score (40%) Financial Evaluation Score (60%)
19.5 7.55
Total (A) Less: Adjusted Spread (B)
Final Score (A-B)
27.05 167.73961
(140.69)
