Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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!
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started