Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please Show Excel formulas! A B C D E G H begin{tabular}{l|l} 3 & Data 4 & Example E hline end{tabular} begin{tabular}{|l|l|r|} hline
Please Show Excel formulas! A B C D E G H \begin{tabular}{l|l} 3 & Data \\ 4 & Example E \\ \hline \end{tabular} \begin{tabular}{|l|l|r|} \hline 5 & Cost of equipment needed & $60,000 \\ \hline 6 & Working captal neoded & $100,000 \\ \hline 7 & Overhaul of equipment in four years & $5,000 \\ \hline 8 & Salvage value of the equipnent in five years & $10,000 \\ \hline 9 & Annual revenves and costs: & \\ 10 & Sales revenues & $200,000 \\ \hline 11 & Cost of poods sold & $125,000 \\ \hline 12 & Out-of-pocket operating costs & $35,000 \\ \hline 13 & Discount rate & 14% \\ \hline \end{tabular} Entor a formute into each of the cells marked with a ? below Exhibit 14-8 \begin{tabular}{l|l} 17 & \\ 18 & \\ 19 & Purchase of equipmene \\ 20 & investment h working capital \\ 21 & Sales \\ 22 & Cost of goods soid \\ 23 & Out-ol-pocket operuing costs \\ 24 & Overhal of ecuipment \end{tabular} 24 Overhaul of equipment 25 Savage value of the equipment 26 Working capieal foleasod 27 Total cash flows (a) 28 Discount tactor (14\%) (b) 29 Present value of cash fows (a) (b) Net present value 'Use the formulas trom Appendix 138: Presentvalue of $1=14(1+1)2n Present value of an annuty of $1=(1/i)(1(1/(1+r))2)) Where n is the number of years and r is the discount rate
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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