you need to edit, it's saler to stay in Protected View Enable Editing H6 X D N TWO: You MUST use the Excel Formulas do NOT simply put a number in the answer cell Three A feweils may have some guidance to help with the answers $ 28.000 400 $ 60 $ 42 8 $0 Straight line 37% 10.0% 10.04 0.074 Facts and Assumptions 4 Initial cost(1000 omitted 5 Unit sales 1000 Omitted) 6 Selling price per unit, this year 7 Variable cost per unit this year 8 Life expectanoy years) 9 Salvage value 10 Depreciation 11 Tarrate 12 Nominal discountate 13 Real discount rate 14 Inflation iste 15 15 Year 17 Initial cos 18 Annual sales funits) 19 Price per unit 20 Variable cost per unit 21 Revenue 22 Variable cost 23 Depreciation 24 Income before tax 25 Tan 26 Income aftertas 27 Depreciation 28 Free Cash Flow 29 2 4 5 ---Check Figure Cell J28 - 5,831 20 b) 31 IRR 32 NPV nominalrate -Check Figure Cell B32 = $3,108 34 c) 35 In "Facts and assumptions" above change the inflation rate to 8% 38 IBR 37 NPV nominalrate 38 Schenk Fine Cell 3781351 8.14 Givens and Answer Sheet