AutoSave On 2 9 Chapter_12_Applying_Excel_Student Form (1) - Compatibility Mode - Excel Search Reinhardt, Emilie RE - 7 Share 0 x Comments File Home Insert Page Layout Formulas Data Review View Help A1 - : x fc Chapter 12: Applying Excel A D E F G H I J K L M B $80,000 $100,000 S5,000 $10,000 5 Cost of equipment needed 6 Working capital needed 7 Overhaul of equipment in four years 8 Salvage value of the equipment in five years 9 Annual revenues and costs: 10 Sales revenues 11 Cost of goods sold 12 Out-of-pocket operating costs 13 Discount rate $200,000 $125,000 $35.000 14% 14 Years 15 Enter a formula into each of the cells marked with a ? below 16 Exhibit 12-8 17 Now 19 Purchase of equipment 20 Investment in working capital 21 Sales 22 Cost of goods sold 23 Out-of-pocket operating costs 24 Overhaul of equipment 25 Salvage value of the equipment 26 Working capital released 27 Total cash flows (a) 28 Discount factor (14%) (b) 29 Present value of cash flows (a) (b) 30 Net present value 31 32 *Use the formulas from Appendix 13B: 33 Present value of $1 = 1/(1+ry'n 34 Present value of an annuity of $1 = (1/r)*(1-(1/(1+r)^n)) Chapter 12 Form + 7 7 -_ + 100% 1 9:32 PM Type here to search te w * N e @ SA ue J A 4/21/2020