Question: please help me with the question marks by telling me the correct excel formulas. thank you! 1 Chapter 14: Applying Excel 3 Data 4 Example

please help me with the question marks by telling me the correct excel formulas. thank you!
please help me with the question marks by telling me the correct

1 Chapter 14: Applying Excel 3 Data 4 Example E 5 Cost of equipment needed 6 Working capital needed 7 Overtaul of equipment in four years 8 Salvage value of the equipment in five years 9 Annual rovenues and costs: 10 Sales rovenues 11 Cost of goods sold 12 Out-ot-pocket operating costs 13 Discount nate B \begin{tabular}{r|} \hline 560,000 \\ $100,000 \\ $5,000 \\ $10,000 \\ \hline$200,000 \\ $125,000 \\ $35,000 \\ \hline 14% \\ \hline \end{tabular} 15 Enter a formula into each of the cells marked with a ? bolow 16 Exhibit 148 17. \begin{tabular}{l|l} 18 & \\ 19 & Purchase of equipment \\ 20 & Investment in working capital \\ 21 & Sales \end{tabular} 21 Sales 22 Cost of goods sold 23 Out-of-pocket operating costs 24 Overhaul of equpment 25 Salvage value of the equipment 26 Working capital released 27 Total cash fown (a) 28. Discount factor (14%)(b)] 29 Present value of cash flos 5 (a) (b) 30 Net present value 31 Not prosent value: 32 .Use the formulas from Append 13B : 33 Present value of $1=1/(1+r2n Present value of an annuity of $1=(1/m)2(1(1)(1+r)rn)) 35 . Where n is the number of years and r is the decount rate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!