A B E F G H 1 M D Inputs Outputs 1 2 Cost of Capita 5% 3 4 Year 0 5 Cash Flow 900 NPV IRR 2 4 1 450 3 600 5 100 750 200 Sensitivity Analysis Data Table Cost of Capital NPV 6 7 8 Analysis 9 Year 0 4.0% 4.5% 1 2 3 4 5 Individual PVS (optional) 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 5.0% 5.5% 6.0% 6.5% 7.0% 7.5% 8.0% 8.5% 9.0% 9.5% 10.0% 10.5% 11.0% 11.5% 12.0% 12.5% 13.0% 13.596 25 26 27 28 29