Hi!

I need the formulas (not the answers) that go to each cell with question mark. Please see below for the question and supplemental infromation.

Thank you.

Chapter 8: Applying Excel 2 3 Data 4 Example C 5 Cost of equipment needed 6 Working capital needed 7Overhaul of equipment in 8 Salvage value of the equipment in 9 Annual revenues and costs 101 Sales revenues 11 Cost of goods sold 12 Out-of-pocket operating costs 13 Discount rate 14 15 Enter a formula into each of the cells marked with a? below 16 Exhibit 8-4 17 18 Sales revenues 19 Less cost of goods sold 20 Less out-of-pocket costs 21 Annual net cash inflows 1 $60,000 $100,000 $5,000 $10,000 4 years years $200,000 $125,000 $35,000 14% Amount of? Present Value 23 24 25 Purchase of equipment 26 Working capital needed 27 Overhaul of equipment 28 Annual net cash inflows from sales of the product line Year(s) Cash Flow Factor of Cash Flows Now Now ?1.000 ?1.000 29 Salvage value of equipment 30 Working capital released 31 Net present value 32 33 "Use the formulas from Appendix 8B 341 Present value of $1 = 1/(1+rrn 35 Present value of an annuity of $1=(1/r)*(14141+rm) 36 where n is the number of vears and r is the discount rate 37 38