Question: Hello, I need some help figuring out how to compute the cells with a question (?) mark for accounting. All I ask is for all
Hello, I need some help figuring out how to compute the cells with a question (?) mark for accounting. All I ask is for all computations to be shown because I want to use it as a reference for future problems. Thank you!


Chapter 12: Applying Excel Data Example E \begin{tabular}{|l|r|} \hline Cost of equipment needed & $60,000 \\ \hline Working capital needed & $100,000 \\ \hline Overhaul of equipment in four years & $5,000 \\ \hline Salvage value of the equipment in five years & $10,000 \end{tabular} Annual revenues and costs: \begin{tabular}{|l|r|} \hline Sales revenues & $200,000 \\ \hline Cost of goods sold & $125,000 \\ \hline Out-of-pocket operating costs & $35,000 \\ \hline Discount rate & 14% \\ \hline \end{tabular} Enter a formula into each of the cells marked with a ? below Exhibit 12-8 Now 1 Years 5 Purchase of equipment Investment in working capital Sales Cost of goods sold Out-of-pocket operating costs Overhaul of equipment Salvage value of the equipment Working capital released Total cash flows (a) Discount factor (14\%) (b) Present value of cash flows (a) (b) \begin{tabular}{|r|r|r|r|r|} \hline$200,000 & $200,000 & $200,000 & $200,000 & $200,000 \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ & & & ? & \\ \hline & & & & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline? & ? & ? & ? & ? \\ \hline \end{tabular} Net present value *Use the formulas from Appendix 13B: Present value of $1=1/(1+r)n Present value of an annuity of $1=(1/r)(1(1/(1+r)n)) where n is the number of years and r is the discount rate
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
