Hello,

I need help applying the correct cell formulas where the question marks are and answering the required responses

problem. Save it for later The Excel worksheet form that appears below is to be used to recreate Example E and Exhibit 13-7. Download the workbook containing this form from the Online Learning Center at www.mhhe.com/garrison15e. On the website you will also receive instructions about how to Chopter 13: Applying Excel Data Example E S60,000 100 000 $5,000 s Cost of equipment needed 7 8 9 Working capital needed Overhaul of equipment in four years Savage value of the equipment in five year $10,000 Annual revenues and costs S200,000 S125 000 S35 000 14% Sales revenues 1 Cost of goods sold 2 Out-of-pocket operating costs 13 Discount rate 25 Entera formula into eech of the ceils marked with ? below 6 Exhibit 13-7 27 Years Now 2 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 vakue of the equipment 26 Working capital released 27 Total cash lows (a) 28 Discount factor (14%) (b) 29 Present value of cash flows (a)x(b) 30 Net present value 31 32 Use the formulas from Appendix 136 33 | Present value of $1 : 1/(1+r) 34 Present value of an annuity of $111N1+rn)) 5 where n is the number of years and r is the discount rate 36 4 Chapter 13 Form, Filed n Chapter 13 Chapter 13 Formulas