Answered step by step
Verified Expert Solution
Link Copied!

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!
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions