NPV Analysis Grid: NPV vs Discount Rate & Salvage Value Ranges SV -> SV-20% SV-1086 SV Base SV+1036 240 270 300 350 360 ATSV -> ATSV-2016 ATSV-1056 ATSV BASE ATSV-1016 ATSV+2036 #NPV in Cells: 224 24 260 270 Cost of Capit 687.90 5 702.12 $716.35 # 730.58 $ 744.90 125.42 538.11 $150.80 163.49 176.18 378.53 389.87 401.22 412.50 423.90 245.37 255.53 $265.69 275.36 236.02 124.36 138.48 $142.60 # 151.72 160.84 Check 101 22 NPV Analysis Grid: NPV vs Discount Rate & Year 1 Sales Ranges Sales Yr.1 Sales Yr.1 Sales Yc1 Sales Yr.1 Sales Yr.1 Sales Yr.1 -> -20P -1076 +101% +2076 #NFV in Cells: 800.00 # 900.00 # 1,000.00 $ 1,100.00 $ 1,200.00 Cost of Capital 49:] 349.38 532.86 $ 716.35 899.84 1,083.33 208.12 379.46 $350.20 722.14 893.49 20.48 240.83 401.22 161.58 721.93 (35.14) 115.28 $205.69 416.11 156.53 1238 (140.16) = 1.22 5 142.60 3 243.99 425.37