Can someone show me how to do these in excel?
Project X has an initial cost of $19,800 and a cash inflow of$25,000 in Year 3. Project Y costs $40,700 and has cash flows of$12,000, $25,000, and $10,000 in Years 1 to 3, respectively. Thediscount rate is 6 percent and the projects are mutually exclusive.Based on the individual project's IRRs you should accept Project_____; based on NPV you should accept Project ____; the finaldecision should be to accept Project _
A- Y, Y, Y
B- X,X,X
C- X,Y,Y
D-Y,X,X
Luke proposed project has an initial cost of $120,000 and cashflows of $64,500, $98,300, and −$15,500 for Years 1 to 3respectively. If all negative cash flows are moved to Time 0 at adiscount rate of 10 percent, what is the modified internal rate ofreturn?
A- 10.00
B- 10.04
C- 9.69
D- 9.97
E- 14.32
Can someone show me how to do these in excel? Project X has an initial cost of $19,800 and a cash inflow of $25,000 in Y
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am