You need to complete this problem in a spreadsheet and show all your work. Creat

Question

You need to complete this problem in a spreadsheet and show all your work. Create an excel file that shows your calculations. Clearly indicate your final answer(s).

There are two mutually exclusive projects, Project A and Project B. Project A is a 7-year project and Project B is a 5-year project. The appropriate discount rate for both projects is 10%. The cash flows for the projects are listed below:

a) What is the IRR for each project? 2pts

b) What is the NPV for each project? 3pts

c) What is the Equivalent Annual Annuity for each project? 3pts

d) Which project would you pick - explain your reasoning? 2pts

I need this in an excel file that I can download and save OR provide the formuas so I can put them in excel.

Year Project A Project B 0 -70,000 -85,000 1 14,000 15,000 2 21,000 29,000 3 25,000 44,000 4 35,000 50,000 5 33,000 45,000 6 30,000 N/A 7 24,000 N/A

Explanation / Answer

Answer:a)

Formula: =IRR(year0 year 7)

Next (IRR Year 0 year 5)

Answer:b)

Formula: =NPV(10%, year 1 to year 7)+year 0

Answer:c) EAA

Project A=52511.40/4.868419=10786.13077

PRoject B=47753.29/ 3.790787=12597.19743

Answer:d) Project B because its EAA is higher than project A.

Year Project A Project B 0 -70,000 -85,000 1 14,000 15,000 2 21,000 29,000 3 25,000 44,000 4 35,000 50,000 5 33,000 45,000 6 30,000 N/A 7 24,000 N/A IRR 27.69% 26.56%

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

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