Hello, I need help applying the correct cell formulas where the question marks a

Question

Hello,

I need help applying the correct cell formulas where the question marks are and answering the required responses

problem. Save it for later The Excel worksheet form that appears below is to be used to recreate Example E and Exhibit 13-7. Download the workbook containing this form from the Online Learning Center at www.mhhe.com/garrison15e. On the website you will also receive instructions about how to Chopter 13: Applying Excel Data Example E S60,000 100 000 $5,000 s Cost of equipment needed 7 8 9 Working capital needed Overhaul of equipment in four years Savage value of the equipment in five year $10,000 Annual revenues and costs S200,000 S125 000 S35 000 14% Sales revenues 1 Cost of goods sold 2 Out-of-pocket operating costs 13 Discount rate 25 Entera formula into eech of the ceils marked with ? below 6 Exhibit 13-7 27 Years Now 2 19 Purchase of equipment 20 Investment in working capital 21 Sales 22 Cost of goods sold 23 Out-of-pocket operating costs 24 Overhaul of equipment 25 Salvage vakue of the equipment 26 Working capital released 27 Total cash lows (a) 28 Discount factor (14%) (b) 29 Present value of cash flows (a)x(b) 30 Net present value 31 32 Use the formulas from Appendix 136 33 | Present value of $1 : 1/(1+r) 34 Present value of an annuity of $111N1+rn)) 5 where n is the number of years and r is the discount rate 36 4 Chapter 13 Form, Filed n Chapter 13 Chapter 13 Formulas

Explanation / Answer

1. The NPV at 10% discount rate

The NPV has increased due to a decrease in discount factor from 14% to 10% becuase higher the discount rate, lower is the present value of future cash flows. Hence with a low discount factor, the value of cash flows has increased, thus resulting in a higher NPV.

2. a.NPV

b) At 10% discount rate, the NPV becomes positive.

c) IRR is between 10% and 11%

d) The salvage value will have to be more than $54,000 for a positive NPV

0 1 2 3 4 5 Purchase of equipment -$60,000 Increase in working capital -$1,00,000 Sales $2,00,000 $2,00,000 $2,00,000 $2,00,000 $2,00,000 Cost of goods sold -$1,25,000 -$1,25,000 -$1,25,000 -$1,25,000 -$1,25,000 out of pocket operating costs -$35,000 -$35,000 -$35,000 -$35,000 -$35,000 Overhaul of equipment -$5,000 Salvage value of equipment $10,000 Working capital released $1,00,000 Total cash flows(a) -$1,60,000 $40,000 $40,000 $40,000 $35,000 $1,50,000 Discount factor (10%) (b) $1 $0.909 $0.826 $0.751 $0.683 $0.621 Present value of cash flows (a) * (b) -$1,60,000 $36,364 $33,058 $30,053 $23,905 $93,138 Net present value $56,518

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.