Can you please answer showing how to use excel formulas? Can you please answer s

Question

Can you please answer showing how to use excel formulas? Can you please answer showing how to use excel formulas?
Wainright Co. has identified an investment project with the following cash flows. If the discount rate is 10 percent, what is the present value of these cash flows? What is the present value at 18 percent? At 24 percent? Discount rate Discount rate Discount rate 10% 18% 24% Year Cash flow 1 S 720 930 1.190 1:275 Complete the following analysis. Do not hard code values in your answers. Value today at 10%

Explanation / Answer

1. =720/1.1+930/1.1^2+1190/1.1^3+1275/1.1^4=3188.047

2. =720/1.18+930/1.18^2+1190/1.18^3+1275/1.18^4=2659.982

3. =720/1.24+930/1.24^2+1190/1.24^3+1275/1.24^4=2348.915

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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